Question
Historic cost data at a popular wedding location is shown in the accompanying file Cp2 wedding datasel x s x ). Run a simple regression
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started