Question: A regression run on Excel using the data shown gave the output shown below data. a) What the value of the Correlation Coefficient between price

A regression run on Excel using the data shown gave the output shown below data. a) What the value of the Correlation Coefficient between price and customer satisfaction? Round your answer to two decimal points. b) What is the Mean Squared Error (MSE) for this regression? Round your answer to two decimal points.

Styles Price Customer Satisfaction 20 87 25 86 27 92 42 97 44 89 87 96 SUMMARY OUTPUT Regression Statistics Multiple R 0.669423689 R Square 0.448128076 Adjusted R Square 0.310160095 Standard Error 3.839215976 Observations 6 ANOVA of 55 MS F Significance F Regression 47.8750161 47.87502 3.248059 0. 145858241 Residual 58.95831723 14.73958 Total 106.8333333 Coefficients Standard Error t Stat P-value Intercept 86.02445757 3.255388844 26.42525 1.226-05 Price 0.125931651 0.069875186 1.802237 0.145858

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Question 3 0/20 pts A toaster company wanted to see if they could predict customer satistaction levels based on the price of the toaster. They collected a random sarrple of 8 toasters and compared...

A toaster company wanted to see it they could predict customer satisfaction levels based on the price of the toastes. They collected a mondom sample of 6 toasters and comcared the price and the...

1. Using the data in Chapter 12, problem 12.11, page 488, do a correlation and regression analysis. 1a. Identify the dependent and independent variables if the data to be used to develop the equation...

Model Score Pixel DensitBattery ScoFingerprintAndroid Samsung Galaxy S7 90 577 80 1 Samsung Galaxy S6 85 577 61 1 HTC 10 79 564 66 1 Samsung Galaxy S7 Edge 100 534 98 1 LG G4 80 534 42 0 Samsung...

Worldwide sales of mobile phones are a multi-billion dollar business.There is severe competition among the major manufacturers to attract higher sales and greater market shares.To achieve this,...

Cover sheet for submission of work for assessment School: Economics, Finance and Marketing Program Name Course/unit name Business Statistics 1 Due Date 16 October 2016 Program Code Course/unit code...

6) In question #4 you calculated the optimal combination of AIG stock and CITI stock using a Markowitz optimization. How much different would your answer be if, instead, you used an index model?...

You are a small business owner considering two alternatives for your phone system. The discount rate is 8%. Which alternative would you pick? Plan A Plan B Initial cost (S) 50,000 120,000 Annual...

K- Equlibrium constant is maximum for (A)-Me (B)-Et (C) (D)

To help ensure an acceptable return rate in a questionnaire study, the researcher shouldGroup of answer choicesmake liberal use of open - ended questionsuse follow - up letters or e - mailsenclose or...

The following is an audit working paper prepared by an assistant on the Williams audit: f Column footed. ? Amount agrees to amount recorded as a deposit on the bank statement and description agrees...