Statistics Homework case study

due in a few hours!

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

Use a file for this assignment.

1. Copy the Assignment Data (i.e., ) 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. 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