Question

Create a PivotTable for the data provided to analyze the average wedding cost by type of...

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

  

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions