Question
Couple's Income Bride's age Payor Wedding cost Attendance Value Rating $40,000 36 Bride's Parents $7,000.00 50 3 $43,000 19 Bride & Groom $30,000.00 250 3
| Couple's Income | Bride's age | Payor | Wedding cost | Attendance | Value Rating |
| $40,000 | 36 | Bride's Parents | $7,000.00 | 50 | 3 |
| $43,000 | 19 | Bride & Groom | $30,000.00 | 250 | 3 |
| $45,000 | 32 | Bride & Groom | $5,000.00 | 50 | 5 |
| $52,000 | 23 | Bride's Parents | $19,000.00 | 200 | 1 |
| $53,000 | 31 | Bride & Groom | $14,000.00 | 100 | 1 |
| $55,000 | 28 | Bride's Parents | $16,000.00 | 100 | 5 |
| $62,000 | 21 | Groom's Parents | $20,000.00 | 100 | 1 |
| $62,000 | 34 | Bride's Parents | $13,000.00 | 150 | 1 |
| $64,000 | 25 | Bride's Parents | $24,000.00 | 200 | 1 |
| $64,000 | 22 | Bride's Parents | $18,000.00 | 150 | 1 |
| $65,000 | 24 | Bride's Parents | $28,000.00 | 250 | 3 |
| $67,000 | 27 | Groom's Parents | $22,000.00 | 200 | 5 |
| $67,000 | 30 | Bride's Parents | $20,000.00 | 200 | 5 |
| $72,000 | 21 | Bride & Groom | $42,000.00 | 200 | 5 |
| $73,000 | 25 | Bride's Parents | $25,000.00 | 150 | 5 |
| $75,000 | 27 | Bride & Groom | $24,000.00 | 200 | 5 |
| $75,000 | 25 | Bride's Parents | $20,000.00 | 200 | 5 |
| $75,000 | 19 | Bride's Parents | $19,000.00 | 150 | 3 |
| $78,000 | 35 | Bride & Groom | $26,000.00 | 200 | 5 |
| $86,000 | 25 | Bride's Parents | $34,000.00 | 250 | 3 |
| $90,000 | 28 | Bride & Groom | $30,500.00 | 150 | 3 |
| $98,000 | 27 | Bride & Groom | $47,000.00 | 150 | 3 |
| $100,000 | 30 | Bride & Groom | $30,000.00 | 300 | 3 |
| $130,000 | 22 | Bride's Parents | $60,700.00 | 300 | 3 |
| $157,000 | 23 | Bride's Parents | $52,000.00 | 350 | 1 |
A wedding coordinator was curious as to which payor was likely to spend the most on a wedding. She collected 25 data points from recent weddings that she had worked. Create a pivot table that has the Payor as the row value and computes the average Wedding Cost using the data in the attached file. What is the average cost of a wedding paid for by the Groom's Parents? (Round your answer to 2 decimal places. Do not include any $ or commas in your answer.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Personal Finance Turning Money Into Wealth
Authors: Arthur J. Keown
6th Edition
0132719169, 978-0132719162
