Historic cost data at a popular wedding location is shown in the accompanying file Cp2 wedding datasel
Question:
Historic cost data at a popular wedding location is shown in the accompanying file Cp2 wedding dataselxsx). Run a simple regression model using the wedding cost as the dependent variable and attendance as the independent variable. Answer the following questions (all in the same Excel file and highlight in red):
Develop a simple linear regression model between attendance(Xvariable) and wedding cost(Yvariable).
Create the Line Fit Plot when running the regression. As shown in the tutorial, add a trendline to the data, show the Regression equation and the coefficent of determination on the plot.
Describe and clearty interpret the coefficient of determination for the model (as shown in the tutorial video) - Check for significance of the model and clearly state your interpretation - Check for significance of the explanatory variable(x)and clearly state your interpretation.
What is the slope (coefficient) value of the regression equation? interpret it clearty as shown in the tutorial?
Business Statistics Communicating With Numbers
ISBN: 9780078020551
2nd Edition
Authors: Sanjiv Jaggia, Alison Kelly