Question 1 You will use Excel to simulate rolling five 6-sided dice and calculating the average and standard deviation of the five numbers. You will also calculate the mean and standard deviation when rolling one dice. You will demonstrate the effect of the sample size on the shape, mean, and standard deviation of the sampling distribution of the mean. Finally, you will verify Central Limit Theorem. . . O . . Open a new Excel document. Double click sheet 1 and change the sheet name to size 2. Click on cell A1, then click on the function icon fx and select Math&Trig, then select RANDBETWEEN. In the dialog box, enter 1 for bottom and enter 6 for top. Use the fill handle (solid cross sign on the bottom right corner of A1) to copy the formula in A1 into B1. In cell C1, type "=AVERAGE(A1:B1)". Select range A1 to C1 and put your mouse on the bottom right corner of C1 until you see the fill handle, click and drag down the fill handle to row 1000. In Cell L1, calculate the mean of C1 to C1000. In Cell L2, calculate the standard deviation of C1 to C1000. Create a histogram based on C1: C1000. Change the chart title to size 2. Reposition the chart so that its top left corner is in Cell L3. Open a new worksheet and change its name to size 5. Use RANBETWEEN to fill in A1 to E1. In cell F1, type "=AVERAGE(A1:E1)". . . c 1 . . Select range A1 to F1 and put your mouse on the bottom right corner of F1 until you see the fill handle, click and drag down the fill handle to row 1000. In Cell L1, calculate the mean of F1 to F1000. In Cell L2, calculate the standard deviation of F1 to F1000. Create a histogram based on F1: F1000. Change the chart title to size 5. Reposition the chart so that its top left corner is in Cell L3. Open a new worksheet and change its name to size 10. Use RANBETWEEN to fill in A1 to J1. In cell K1, type "=AVERAGE(A1:J1)". Select range A1 to K1 and put your mouse on the bottom right corner of K1 until you see the fill handle, click and drag down the fill handle to row 1000. In Cell L1, calculate the mean of K1 to K1000. In Cell L2, calculate the standard deviation of K1 to K1000. Create a histogram based on K1: K1000. Change the chart title to size 10. Reposition the chart so that its top left corner is in Cell L3. . a) Submit a screenshot of Excel for sheet size 2 including at least A1 to L30 (average, standard deviation, and histogram). b) Submit a screenshot of Excel for sheet size 5 including at least A1 to L30 (average, standard deviation, and histogram). c) Submit a screenshot of Excel for sheet size 10 including at least A1 to L30 (average, standard deviation, and histogram). d) (Submit a screenshot of your written or typed answer.) Create a discrete probability distribution table for rolling a 6-sided dice. Calculate the mean and standard deviation of this distribution. e) (Submit a screenshot of your written or typed answer.) Use result from a), b), c) and d) to verify Central Limit Theorem. f) Fill out the table below and submit this table. Sample Size Observed Values Theoretical Values Mean Standard deviation Mx OX n=2 n= 5 n= 10 Question 1 You will use Excel to simulate rolling five 6-sided dice and calculating the average and standard deviation of the five numbers. You will also calculate the mean and standard deviation when rolling one dice. You will demonstrate the effect of the sample size on the shape, mean, and standard deviation of the sampling distribution of the mean. Finally, you will verify Central Limit Theorem. . . O . . Open a new Excel document. Double click sheet 1 and change the sheet name to size 2. Click on cell A1, then click on the function icon fx and select Math&Trig, then select RANDBETWEEN. In the dialog box, enter 1 for bottom and enter 6 for top. Use the fill handle (solid cross sign on the bottom right corner of A1) to copy the formula in A1 into B1. In cell C1, type "=AVERAGE(A1:B1)". Select range A1 to C1 and put your mouse on the bottom right corner of C1 until you see the fill handle, click and drag down the fill handle to row 1000. In Cell L1, calculate the mean of C1 to C1000. In Cell L2, calculate the standard deviation of C1 to C1000. Create a histogram based on C1: C1000. Change the chart title to size 2. Reposition the chart so that its top left corner is in Cell L3. Open a new worksheet and change its name to size 5. Use RANBETWEEN to fill in A1 to E1. In cell F1, type "=AVERAGE(A1:E1)". . . c 1 . . Select range A1 to F1 and put your mouse on the bottom right corner of F1 until you see the fill handle, click and drag down the fill handle to row 1000. In Cell L1, calculate the mean of F1 to F1000. In Cell L2, calculate the standard deviation of F1 to F1000. Create a histogram based on F1: F1000. Change the chart title to size 5. Reposition the chart so that its top left corner is in Cell L3. Open a new worksheet and change its name to size 10. Use RANBETWEEN to fill in A1 to J1. In cell K1, type "=AVERAGE(A1:J1)". Select range A1 to K1 and put your mouse on the bottom right corner of K1 until you see the fill handle, click and drag down the fill handle to row 1000. In Cell L1, calculate the mean of K1 to K1000. In Cell L2, calculate the standard deviation of K1 to K1000. Create a histogram based on K1: K1000. Change the chart title to size 10. Reposition the chart so that its top left corner is in Cell L3. . a) Submit a screenshot of Excel for sheet size 2 including at least A1 to L30 (average, standard deviation, and histogram). b) Submit a screenshot of Excel for sheet size 5 including at least A1 to L30 (average, standard deviation, and histogram). c) Submit a screenshot of Excel for sheet size 10 including at least A1 to L30 (average, standard deviation, and histogram). d) (Submit a screenshot of your written or typed answer.) Create a discrete probability distribution table for rolling a 6-sided dice. Calculate the mean and standard deviation of this distribution. e) (Submit a screenshot of your written or typed answer.) Use result from a), b), c) and d) to verify Central Limit Theorem. f) Fill out the table below and submit this table. Sample Size Observed Values Theoretical Values Mean Standard deviation Mx OX n=2 n= 5 n= 10
