Question

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

Answer 1

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