Using the Excel file weddings, use the excel regression tool using the wedding cost as the dependent variable and attendance as the independent variable.

a. interpret all key regression results.

b. if a couple is planning a wedding for 175 guests, how much they they budget?

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