I need help with this today please!!!
wguindiContinue using the Cake Mix Assignment Data workbook.
Use a new Excel workbook file for this assignment.
Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of the new Excel file.
Enter the following label in cell Q2: "Sugar grams - z-scores".
Enter appropriate formulas in cells Q3:Q32 to display z-scores of variable "Sugar grams".
Use cells R3 and R7 to interpret the adjacent z-score in terms of the score's relationship to the mean of the "Sugar grams" variable. (HINT: enter a short sentence in cells R3 and R7 to interpret the adjacent z-score in terms of distance and direction of the z-score from the mean of sugar grams.)
Enter the following label in cell P34: "Mean". Enter the appropriate formula in cell Q34 to display the mean of the z-scores for variable "Sugar grams".
Save and submit the Excel file with your last name and week number, e.g., Smith3.xlsx
- 8 years ago
- 5
Purchase the answer to view it
- lastnameweeknumber.xlsx