SFU What Is the Coefficient of Determination for The Regression Questions

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)