HW 1 Data Analytics.docx - Business 322 Homework 1 Due October 3 1 Personal Record your Blood Pressure 3 times(you can go to any supermarket pharmacy

# HW 1 Data Analytics.docx - Business 322 Homework 1 Due...

• No School
• AA 1
• 7

This preview shows page 1 - 3 out of 7 pages.

Business 322 Homework 1 Due: October 3 1. Personal : Record your Blood Pressure 3 times (you can go to any supermarket pharmacy area) and compute the mean and standard deviation for the systolic number (highest number). What does the variation you observe tell you? 121, 118, 120 Blood Pressure Mean 119.666666 7 Standard Error 0.88191710 4 Median 120 Mode #N/A Standard Deviation 1.52752523 2 Sample Variance 2.33333333 3 Kurtosis #DIV/0! Skewness - 0.93521953 Range 3 Minimum 118 Maximum 121 Sum 359 Count 3 The mean for my blood pressure was 119.67 and the standard deviation was 1.53. The variation means that my blood pressure, on average, was 1.53 points away from the mean. 2. CREATE an Excel worksheet in which you track every day from August 29 to September 19 (Wednesday class) your mood. You should measure your mood for the day. Please keep track for Do this in the late evening and use a 1-10 scale with a 10 indicating the very highest mood. 8/29 8/30 8/31 9/1 9/2 9/3 9/4 9/5 9/6 9/7 9/8 8 5 8 8 6 8 6 7 5 6 8 9/9 9/10 9/11 9/12 9/13 9/14 9/15 9/16 9/17 9/18 9/19 8 7 7 6 7 8 6 5 6 4 7 Chapter 2 : 7, 19 (a, b, e), 26

Subscribe to view the full document.

7a. I used the COUNT.IF Function to determine the frequency which is listed below. After I determined the frequency, I divided each frequency by the total number in the data set (200) to determine the percentage. Industry Frequency % Frequency Cable 44 22% Car 42 21% Collection 28 14% Cell 60 30% Bank 26 13% 7b. The cell phone industry had the highest number of complaints.

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes