Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent
Question:
Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent variable and attendance as the independent 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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Question Posted: