USA: +1(669)289-8683 
Sign in
| 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: DataLengthWidthThickness10.677.510.55110.747.570.54610.687.550.54610.727.530.55410.667.530.54610.697.560.54210.707.520.54510.727.580.53810.697.550.55210.687.530.54710.727.560.54610.707.580.54510.707.550.54610.737.550.54810.757.540.54610.737.570.54310.697.540.54810.687.550.54510.707.550.55310.777.560.53910.727.540.54910.697.560.54110.667.560.54310.697.550.54510.637.540.54910.687.550.54610.737.560.54510.747.570.54010.657.540.54110.697.550.54510.707.540.54710.727.550.54310.757.530.54510.717.540.54610.727.550.547Upper Spec117.660.56Lower Spec10.57.450.54Target10.757.550.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? |
