SFU What Is the Coefficient of Determination for The Regression Questions
Description
Using SPSS and the data from the Customer Service and Travel Preferences Survey, complete the following problems.
You should cut and paste SPSS tables into your assignment and write out the answers in your own words. Hand in your
work by uploading it into Moodle in a single Word file. (35 points)
1) Run a correlation analysis for PRICE by ROOMSERV. (10 points)
a) Is the correlation significant or not? Explain why or why not. (1 point)
b) What is the correlation? What is its strength (magnitude)? (2 points)
c) What is the directionality of the correlation? Explain how the variables react to each other (do they travel
together or go in opposite directions)? (2 point)
d) In your own words, write up the results of this correlation analysis. Be sure to include the test statistic and p?value in your write-up. (5 points)
2) Run a regression analysis for PRICE (Independent) by FIVESTAR (Dependent). (25 points)
a) What is the Coefficient of Determination (R2) for the regression? How much of the variation in the Importance
Rating for Five-Star Service is explained by Price Importance? (1 point)
b) List the test statistic, df and p-value. Is the test statistically significant? (5 points)
c) What is the Y-intercept? (2 points)
d) What is the regression coefficient? (2 points)
e) Using Excel, create a model using the linear regression equation provided by the regression analysis. What is the
value of the five-star importance rating when price importance is rated 1, 3 or 5? (5 points)
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."