Statistics Homework

profileLewisHendrix

Need HELP ASAP due in a few hours!

 

Thi is my assignemtn must get 100% I HAVE ATTACHED THE CAKE MIX DATA as an attachment

 

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. Create a manual pivot table in a new worksheet (i.e., Sheet 2) using the entire cake mix dataset. (HINT: follow the procedures in the textbook Chapter 1.3, Pivot Tables.) Click anywhere in your pivot table you create to view the PivotTable Builder window. Select variables to display by checking them in the "Field name" box. Move variables by dragging them from box to box in this window in order to format your table properly.

  3. Display Packaging (i.e., 1=box and 2=bag) as row labels.

  4. Display values as Averages of Calories, Ounces, Price, and Sodium as column labels.

  5. Adjust cell format to display two decimal places. (HINT: highlight cells to be formatted and use the Excel menu format > Cells > Number procedure by highlighting Category: Number, selecting 2 decimal places, and clicking the OK button.)

6. SEND ME THE FINAL EXCEL product

  • 11 years ago
  • 30
Answer(1)

Purchase the answer to view it

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