the limits of expected variation

Objective:

Your boss wants to know the limits of expected variation. You know there is another shipment

coming in next week and based upon this week's run, you can calculate/predict the limits

of expected variation by calculating the mean and standard deviation.

need to use excell

The Mean and StDev in Excel

Expected variation

Instructions for you:

1. Calculate the average for length, width and thickness.

2. Calculate the standard deviation for each.

3. From these calculations, determine the expected variation. ( Use + or - 3 sigma)

You may complete this assignment by hand, as taught in the lecture. You may use Excel, or you

may use a calculator or other software. We explain the fundamentals of the calculations, so that

you learn the mechanics and the meaning of standard deviation. This basic approach gives you an

understanding of standard deviation, which then allows you to be flexible in the tools that you use.

Project:			Manufacturing
Deliverable:			Expected variation
Student last name:			Your last name here
REPORT ALL OF THE RESULTS TO AT LEAST 4 DECIMAL PLACES!
Mean for LENGTH:::
Standard deviation for LENGTH:::
What is the lowest point of expected variation?
What is the upper point of expected variation?

Mean for WIDTH:::
Standard deviation for WIDTH:::
What is the lowest point of expected variation?
What is the upper point of expected variation?

Mean for THICKNESS:::
Standard deviation for THICKNESS:::
What is the lowest point of expected variation?
What is the upper point of expected variation?

expected_variation

NOT RATED

Purchase the answer to view it