Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent variable and attendance as the dependent variable.

a Interpret all key regression results, hypothesis tests, and confidence intervals in the output.

b. Analyze the residuals to determine if the assumptions underlying the regression analysis are valid.

c. Use the standard residuals to determine if any possible outliers exist.

d. If a couple is planning a wedding for 175 guests, how much should they budget?

From the excel file:

Wedding cost	Attendance
$60,700.00	300
$52,000.00	350
$47,000.00	150
$42,000.00	200
$34,000.00	250
$30,500.00	150
$30,000.00	250
$30,000.00	300
$28,000.00	250
$26,000.00	200
$25,000.00	150
$24,000.00	200
$24,000.00	200
$22,000.00	200
$20,000.00	200
$20,000.00	200
$20,000.00	100
$19,000.00	150
$19,000.00	200
$18,000.00	150
$16,000.00	100
$14,000.00	100
$13,000.00	150
$7,000.00	50
$5,000.00	50