Create a PivotTable for the data provided to analyze the average wedding cost by type of payor and value rating. What conclusions do you reach? Complete the PivotTable below for the average of the wedding cost.
Couple's Income Bride's Age
Payor Wedding cost Attendance
Value Rating
98000 27 Bride & Groom
47000 150 3
40000 26 Bride's Parents
7000 50 3
53000 31 Bride & Groom
14000 100 1
90000 28 Bride & Groom
30500 150 3
67000 30 Bride's Parents
20000 200 5
64000 25 Bride's Parents
24000 200 1
130000 22 Bride's Parents
60700 300 3
52000 23 Bride's Parents
19000 200 1
75000 27 Bride & Groom
24000 200 5
75000 25 Bride's Parents
20000 200 5
73000 25 Bride's Parents
25000 150 5
78000 35 Bride & Groom
26000 200 5
67000 27 Groom's Parents
22000 200 5
43000 19 Bride & Groom
30000 250 3
62000 21 Groom's Parents
20000 100 1
Please fill this out . Thanks !
1 |
3 |
5 |
Grand Total |
|
---|---|---|---|---|
Bride & Groom |
||||
Bride's Parents |
||||
Groom's Parents |
||||
Grand Total |
|
PivotTable
1 |
3 |
5 |
Grand Total |
|
Bride & Groom |
14000 |
35833.33333 |
25000 |
74833.33333 |
Bride's Parents |
21500 |
33850 |
21666.66667 |
77016.66667 |
Groom's Parents |
20000 |
- |
22000 |
42000 |
Grand Total |
55500 |
69683.33333 |
68666.66667 |
193850 |
Conclusions:
1) The average of the wedding cost of Payor Bride & Groom more for Value Rating 3 and less for Value Rating 1.
2) The average of the wedding cost of Payor Bride's Parents more for Value Rating 3 and less for Value Rating 1.
3) The average of the wedding cost of Payor Groom's Parents more for Value Rating 5 and less for Value Rating 1.
4) The Grant total of average of the wedding cost is more for Payor Bride's Parents and less for Payor Groom's Parents.
5) The Grant total of average of the wedding cost is more for Value Rating 3 and less for Value Rating 1
Get Answers For Free
Most questions answered within 1 hours.