Apply the following to Excel Filming what you done on Excel

Technology Step by Step MINITAB Determining Normality Step by Step There are several ways in which statisticians test a data set for normality. Four are shown here. Construct a Histogram Summary for Inventory Inspect the histogram for shape. pearos-y Data 0.12 5 29 34 44 45 1. Enter the data in the first column of a new 68 74 74 81 0.23 worksheet. Name the 88 91 97 98 113 column Inventory. 118 151 158 2. Use Stat> Basic 120 77.50 and Quartle Statistics>Graphical 15 40 Summary presented in 59.62 Section 3-3 to create 96% Confidence Intervals 15% Confidence Interval for Stoma the histogram. Is it 3559 60.45 */ Confidence Interval for Madin symmetric? Is there a single peak? Check for Outliers Inspect the boxplot for outliers. There are no outliers in this graph. Furthermore, the box is in the middle of the range, and the median is in the middle of the box. Most likely this is not a skewed distribution either. Calculate Pearson's Index of Skewness The measure of skewness in the graphical summary is not the same as Pearson's index. Use the calculator and the formula. PI = 34 - median) 3. Select Calo Calculator, then type PI in the text box for Store result in:. 4. Enter the expression: 3*(MEAN(CI)-MEDI(CD))/(STDEV(C1)). Make sure you get all the parentheses in the right place! 5. Click [OK]. The result, 0.148318, will be stored in the first row of C2 named PI. Since it is smaller than + 1, the distribution is not skewed. Construct a Normal Probability Plot 6. Select Graph>Probability Plot, then Single and click [OK]. 7. Double-click C1 Inventory to select the data to be graphed. 8. Click [Distribution] and make sure that Normal is selected. Click [OK]. 9. Click [Labels] and enter the title for the graph: Quantile Plot for Inventory. You may also put Your Name in the subtitle. 10. Click [OK] twice. Inspect the graph to see if the graph of the points is linear