I need help with this today please!!!

profilewguindi

Continue 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
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    lastnameweeknumber.xlsx
Bids(1)