3_2 Excel Homework_Springer.xlsx

# Step 6 transfer the mean median and standard devi

• Homework Help
• 7
• 100% (1) 1 out of 1 people found this document helpful

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

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.

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

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
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.

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

This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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