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.

Data:
Data	Length	Width	Thickness
10.67	7.51	0.551
10.74	7.57	0.546
10.68	7.55	0.546
10.72	7.53	0.554
10.66	7.53	0.546
10.69	7.56	0.542
10.70	7.52	0.545
10.72	7.58	0.538
10.69	7.55	0.552
10.68	7.53	0.547
10.72	7.56	0.546
10.70	7.58	0.545
10.70	7.55	0.546
10.73	7.55	0.548
10.75	7.54	0.546
10.73	7.57	0.543
10.69	7.54	0.548
10.68	7.55	0.545
10.70	7.55	0.553
10.77	7.56	0.539
10.72	7.54	0.549
10.69	7.56	0.541
10.66	7.56	0.543
10.69	7.55	0.545
10.63	7.54	0.549
10.68	7.55	0.546
10.73	7.56	0.545
10.74	7.57	0.540
10.65	7.54	0.541
10.69	7.55	0.545
10.70	7.54	0.547
10.72	7.55	0.543
10.75	7.53	0.545
10.71	7.54	0.546
10.72	7.55	0.547
Upper Spec		11	7.66	0.56
Lower Spec		10.5	7.45	0.54
Target		10.75	7.55	0.55

 

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?