Statistics Homework
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.
- Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of the new Excel workbook.
- 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.
- Display Packaging (i.e., 1=box and 2=bag) as row labels.
- Display values as Averages of Calories, Ounces, Price, and Sodium as column labels.
- 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)![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- book1_1.xlsx
Bids(1)
other Questions(10)
- Discussions
- Financial Management Impressions
- Policy making-Tutor Gabriel Only
- FOR NYANYA (ONLY) - HSAD221 Week 7 DQ
- ABC expenses stock options as required by GAAP. On January 1, 2015, ABC granted 50 key executives 100 options each....
- CIS 106 Week 3 discussion question
- research 5 pages + sources' page !
- BSHS 406 Family Learning Team A
- Healthwise Medical Supplies Company Chapter 9
- finance