Question: Use the 'BakeryData' excel file and include pivot tables for the following: 1) Promotional effect on sales for each product (Use Average rather than Sum)
Use the 'BakeryData' excel file and include pivot tables for the following:
1) Promotional effect on sales for each product (Use Average rather than Sum)
2) Daily Breakdown of sales for each product (Monday, Tuesday, etc.)
3) Monthly breakdown of sales for each product (January, February, March, etc.)
Please upload your homework assignment in Excel format.
Pies 79 46 91 47 50 60 64 89 1 Monday 2 Tuesday 3 Wednesday 4 Thursday 5 Friday 6 Saturday 7 Sunday 73 57 NP 112 89 70 70 59 71 74 119 50 48 37 36 50 71 51 48 56 daywk weekday Date Cakes Tuesday 2 1/1/13 Wednesday 3 1/2/13 Thursday 4 1/3/13 Friday 5 1/4/13 Saturday 6 1/5/13 Sunday 7 1/6/13 Monday 1 1/7/13 Tuesday 2 1/8/13 Wednesday 3 1/9/13 Thursday 4 1/10/13 Friday 5 1/11/13 Saturday 6 1/12/13 Sunday 7 1/13/13 Monday 1 1/14/13 Tuesday 2 1/15/13 Wednesday 3 1/16/13 Thursday 4 1/17/13 Friday 5 1/18/13 Saturday 6 1/19/13 Sunday 7 1/20/13 Monday 1 1/21/13 Tuesday 2 1/22/13 Wednesday 3 1/23/13 Thursday 4 1/24/13 Friday 5 1/25/13 Saturday 6 1/26/13 Sunday 7 1/27/13 Monday 1 1/28/13 Tuesday 2 1/29/13 Wednesday 3 1/30/13 Thursday 4 1/31/13 Friday 5 2/1/13 Saturday 6 2/2/13 Sunday 7 2/3/13 Monday 1 2/4/13 Tuesday 2 2/5/13 Wednesday 3 2/6/13 Thursday 4 2/7/13 Friday 5 2/8/13 Saturday 6 2/9/13 Sunday 7 2/10/13 Monday 1 2/11/13 Tuesday 2. 2/12/13 Wednesday 3 2/13/13 90 96 62 48 58 74 94 97 79 67 81 71 95 33 67 74 45 95 93 60 79 54 36 39 43 42 58 16 66 46 38 40 45 59 62 59 80 77 71 89 90 81 49 93 54 65 61 112 103 113 63 34 50 70 58 60 43 72 93 49 61Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
