Obtain data from other groups and record the data in additional trial number columns. Calculate the mean value for each color category within the experiment. Select the cell that corresponds with the category Yellow Mean. Select Insert. Select Function. Select Average from the Insert Function dialog box. Select OK. Select the cells that contain the Yellow category data. Select OK. Select the bottom right corner of cell Yellow, Mean and drag to cell , Mean. The mean should now be calculated for all color categories. Calculate the median, mode, and standard deviation for all color categories. Follow procedure steps 13a 13i. Modify step 13d to select the required – function. Calculate the package total using the SUM function. Calculate the package volume by multiplying the package total by the volume of one candy. Create a ± 3ϭ histogram for each candy color. Create a frequency distribution table for each candy color as illustrated below. Bin Frequency (how often the value Yellow Candy = 1.155 ϭ occurs within the data array) 9.7983 3 Mean + (3 ) Ϭ ϭ 8.6433 2 Mean + (2 ) Ϭ ϭ 7.4883 1 Mean + (1 ) Ϭ ϭ Mean 6.3333 5.1783 -1 Mean (1 ) – Ϭ ϭ 4.0233 -2 Mean (2 ) – Ϭ ϭ
Obtain data from other groups and record the data in additional trial number columns. Calculate the mean value for each color category within the experiment. Select the cell that corresponds with the category Yellow Mean. Select Insert. Select Function. Select Average from the Insert Function dialog box. Select OK. Select the cells that contain the Yellow category data. Select OK. Select the bottom right corner of cell Yellow, Mean and drag to cell , Mean. The mean should now be calculated for all color categories. Calculate the median, mode, and standard deviation for all color categories. Follow procedure steps 13a – 13i. Modify step 13d to select the required function. Calculate the package total using the SUM function. Calculate the package volume by multiplying the package total by the volume of one candy. Create a ± 3ϭ histogram for each candy color. Create a frequency distribution table for each candy color as illustrated below. Yellow Candy ϭ = 1.155 Bin Frequency (how often the value occurs within the data array) 3 Ϭ Mean + (3 ϭ ) 9.7983 2 Ϭ Mean + (2 ϭ ) 8.6433 1 Ϭ Mean + (1 ϭ ) 7.4883 Mean 6.3333 -1 Ϭ Mean – (1 ϭ ) 5.1783 -2 Ϭ Mean – (2 ϭ ) 4.0233
4.1.2.A%20CandyStatistics.docx