10. Using the Excel file Weddings, apply the Excel Re- gression tool using the wedding cost as the dependent variable and the couple's income as the independent variable, only for those weddings paid for by the bride and groom. oggu2 ua qua. Interpret all key regression results, hypothesis tests, and confidence intervals in the output. b. Analyze the residuals to determine if the assump- tions underlying the regression analysis are valid. c. Use the standard residuals to determine if any possible outliers exist. d. If a couple makes $70,000 together, how much last would they probably budget for the wedding? Couple's Income Bride's age Payor Wedding cost Attendance Value Rating $130,000 22 Bride's Parents $60,700.00 300 3 $157,000 23 Bride's Parents $52,000.00 350 1 $98,000 27 Bride & Groom $47,000.00 150 3 $72,000 29 Bride & Groom $42,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 $43,000 19 Bride & Groom $30,000.00 250 3 $100,000 30 Bride & Groom $30,000.00 300 3 $65,000 24 Bride's Parents $28,000.00 250 3 $78,000 35 Bride & Groom $26,000.00 200 5 $73,000 25 Bride's Parents $25,000.00 150 5 5 $75,000 27 5 $64,000 25 7 $67,000 27 B $75,000 25 $67,000 $62,000 21 1 $75,000 2 $52,000 3 $64,000 4 $55,000 5 $53,000 6 $62,000 7 $40,000 8 $45,000 22222222222222 Bride & Groom $24,000.00 200 5 Bride's Parents $24,000.00 200 1 Groom's Parents $22,000.00 200 5 Bride's Parents $20,000.00 200 5 30 Bride's Parents $20,000.00 200 5 Groom's Parents $20,000.00 100 1 19 Bride's Parents $19,000.00 150 3 23 Bride's Parents $19,000.00 200 1 Bride's Parents $18,000.00 150 1 28 Bride's Parents $16,000.00 100 5 31 Bride & Groom $14,000.00 100 24 Bride's Parents $13,000.00 150 26 Bride's Parents $7,000.00 50 32 Bride & Groom $5,000.00 50 1135 1