EVERYTHING MUST BE DONE AND DONE CORRECTLY My Professor grades HARD.
NO SKIPPING STEPS PLEASE, due in a few hours, need done ASAP
– I posted the Cake Mix Assignment Data workbook as an attachment
(ASSIGNMENT)
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.)
