3_2 Excel Homework_Springer.xlsx

Step 6 transfer the mean median and standard devi

Info icon This preview shows pages 3–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Step 6: Transfer the Mean, Median, and Standard Devi 44.00 22.27 Step 7: An alternative method is using functions. Use 45.00 21.12 MEAN = 23.49 46.00 14.35 47.00 15.87 MEDIAN = 22.70 48.00 44.29 49.00 17.83 STD DEV = 9.97 50.00 21.68 Question 1: Based on the information from Tasks 1A and 1B, describe whether or not Question 2: Based on the information from Task 2, provide a brief statistical descript Answer: No they are not meeting their customers' needs. There are a number of customer requirement. Answer: The mean and and median delivery times of 23.49 and 22.70 (respectively) woud different story. Since this is a large number relative to the the number of deliveries days re out, which suggests a problem. When we delve further into the numbers, there is a minim investigating.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
he order was received Door - Date Order was Received the DATA ANAYSIS on the far right. ighlight the data under the DURATION column (cells B6 to B55) and do not highlight the determine this for you). click into the white area of that section, and type $E$19:$N$30 t starts in cell E19 and contain a count of each data point per Bin. s F20-F27) and do not hightlight the header. tion. vided section below. Histogram 0 5 10 15 Histogram Frequency Bin Frequency 1 2 3 0 2 4 6 8 10 12 14
Image of page 4
the DATA ANAYSIS on the far right. nput Range, highlight the data under the DURATION column (cells B6 to B55) and do not click into the white area of that section, and type $S$46:$T$60 en OK. S46 and contains the Mean, Median, and Standard Deviation.
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern