Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of a new Excel workbook.
Select the most appropriate hypothesis test described in Sections 4.7 and 4.8 to evaluate the following null hypothesis:
"Sugar grams" cannot predict "Calories from Fat" in packaged cake mixes. Assume normality and linearity.
Create a marked scatterplot to compare pairs of values for "Sugar grams" and "Calories from Fat" on Sheet 1 adjacent to the Sugar grams data. Make sure the x- and y-axes are properly labeled.
Change the marker style to circles and reduce marker size from 9 (default) to 2.
Also, delete the legend and use "Scatterplot" as the title of the chart. (HINT: You can facilitate creation of the scatterplot by deleting the following variables: Potassium grams, Cholesterol grams, and Protein grams from your new Excel Workbook. This action will place the variables "Calories from Fat" and "Sugar grams" adjacent to each other.)
Cell R1: Evaluate the scatterplot in terms of the strength of relationship, direction of relationship, and form of relationship between the two variables. Also, use adjacent cells, if required.
Enter the following labels: In cell A34 enter Hypothesis Test;
In cells A37:A38 enter Calories from Fat and Sugar Grams;
In cells B36:C36: enter Mean and Standard Deviation;
in cells A40:A47: enter (constant), b(slope), Standard Error of the Estimate (SEE), Coefficient of Multiple Determination (R-squared), Correlation Coefficient (R), Degrees of Freedom (df), F, and p-value; in cell A51 enter Statistical Decision; and in cell A53 enter Prediction Equation.
Cell B34: Enter the name of the hypothesis test used to evaluate the null hypothesis contained in step #2 above.
Cells B37:C38: Enter the formulas that display the sample means and standard deviations for variables "Calories from Fat" and "Sugar grams," as appropriate. Format cells to round to two decimal places.
Cells B40:B47: Enter the appropriate formulas that display the required statistics based on adjacent labels. Format cells to round to two decimal places.
Cell B51: Enter the statistical decision (i.e., reject or fail to reject the null hypothesis).
Cell B53: Enter the prediction equation. (HINT: the prediction equation is the formula for the unstandardized regression line)
Cell B55: Quote a relevant passage from Scripture that provides a good ethical foundation for statisticians to follow. Briefly describe how it is relevant for statisticians.
An Excel file with formulas and summary output is provided. All questions have been answered.