1.

A wedding planner has gathered data from her last 25 wedding and would like to be able to easily predict for a couple how much their wedding might cost. Use the data in the attached file to develop a simple linear regression model to predict the Wedding Cost as the dependent variable (y) using the Couple's Income as the independent variable (x).

What is the regression equation?

y = 1905.69 + 130.12 x

y = 17408.22 - 765.56 x

y = 58259.68 - 1229.58 x

y = -5024.51 + 0.42 x

2. 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.)

3. A wedding coordinator was curious as to whether the cost differed among the value ratings given for a wedding. She collected 25 data points from recent weddings that she had worked. Create a pivot table that has the Value Rating 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 with a Value Rating of 1? (Round your answer to 2 decimal places. Do not include any $ or commas in your answer.)

Couple's Bride's 1 Income age 2 $40,000 36 3 $43,000 19 4 $45,000 32 5 $52,000 23 6 $53,000 31 7 $55,000 28 8 $62,000 21 9 $62,000 34 10 $64,000 25 11 $64,000 22 12 $65,000 24 13 $67,000 27 14 $67,000 30 15 $72,000 21 16 $73,000 25 17 $75,000 27 18 $75,000 25 $75,000 19 $78,000 35 $86,000 25 $90,000 28 ; $98,000 27 4 $100,000 30 5 $130,000 22 6 $157,000 23 wwwwwwwwwwwwwwwww Wedding value cost Attendance Rating $7,000.00 50 3 $30,000.00 250 3 $5,000.00 50 5 $19,000.00 200 1 $14,000.00 100 1 $16,000.00 100 $20,000.00 100 1 $13,000.00 150 1 $24,000.00 200 1 $18,000.00 150 1 $28,000.00 250 $22,000.00 200 5 $20,000.00 200 $42,000.00 200 5 $25,000.00 150 $24,000.00 200 5 $20,000.00 200 $19,000.00 150 3 $26,000.00 200 $34,000.00 250 3 $30,500.00 150 3 $47,000.00 150 3 $30,000.00 300 3 $60,700.00 300 $52,000.00 350 1 Payor Bride's Parents Bride & Groom Bride & Groom Bride's Parents Bride & Groom Bride's Parents Groom's Parents Bride's Parents Bride's Parents Bride's Parents Bride's Parents Groom's Parents Bride's Parents Bride & Groom Bride's Parents Bride & Groom Bride's Parents Bride's Parents Bride & Groom Bride's Parents Bride & Groom Bride & Groom Bride & Groom Bride's Parents Bride's Parents U1 01 w 01 01 3 3