Statistics Homework

Continue using the Cake Mix Assignment Data workbook.

Use a new Excel workbook file for this assignment.

1. Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of the new Excel workbook.
   
   
2. Enter the following labels in cells A34:A47 (that is, in cells A34 through A47 inclusive): Mean, Median, Mode, Standard Deviation, Range, Mean Standard Error, Skewness Coefficient, Standard Error of Skewness, Standard Coefficient of Skewness, 1st Quartile, 2nd Quartile, 3rd Quartile, IQR, and 90th Percentile. Adjust the width of column A, as needed, to accommodate labels without truncation.
   
   
3. Enter appropriate formulas in cells B34:B47 that calculate the statistic identified by the adjacent label for variable "Sugar grams" (see column P). For example, in cell B34 enter the Excel formula that displays the mean of the variable sugar grams, in cell B35 enter the Excel formula that displays the median for variable sugar grams, etc.
   
   
4. Cells C34:C47: Interpret (i.e. explain the meaning of) the adjacent statistic in terms of the dataset. For example, in cell C34 enter a short sentence that interprets the mean you report in cell B34, in cell C35 enter a short sentence that interprets the median you report in cell B35, etc.
   
   
5. Cell A48: Relate the statistics calculated in this assignment with appropriate biblical concepts. For example, "I will pray with my spirit, but I will also sing with my mind." -- 1 Cor. 14:15 (Note: select a different verse that applies.)