onth (rounded to the nearest dollar) and degree of customer satisfaction a scale of 1 - 10 with a 1 being not at all satisfied and a 10 being remely satisfied). The researcher only includes programs with mparable types of services. A sample of the data is provided below. dollar satisfactio 11 6 18

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 11PPS
icon
Related questions
Question

Please show the step by step on excel output.

2. With the growth of internet service providers, a researcher decides to
examine whether there is a correlation between cost of internet service per
month (rounded to the nearest dollar) and degree of customer satisfaction
(on a scale of 1- 10 with a 1 being not at all satisfied and a 10 being
extremely satisfied). The researcher only includes programs with
comparable types of services. A sample of the data is provided below.
dollar satisfactio
n
11
6
18
17
10
15
4
5
6
12
3
19
5
22
2
25
10
a. Compute the correlation coefficient.
b. Determine the equation of regression if the level of satisfaction is
being predicted.
c. What satisfaction level would the customers achieved if they are
paying $20? $8? $16?
d. Determine the equation of regression if the cost is being predicted.
e. How much would it cost to have a satisfaction level of 7?
f. Explain the predicting capability of the equation.
Transcribed Image Text:2. With the growth of internet service providers, a researcher decides to examine whether there is a correlation between cost of internet service per month (rounded to the nearest dollar) and degree of customer satisfaction (on a scale of 1- 10 with a 1 being not at all satisfied and a 10 being extremely satisfied). The researcher only includes programs with comparable types of services. A sample of the data is provided below. dollar satisfactio n 11 6 18 17 10 15 4 5 6 12 3 19 5 22 2 25 10 a. Compute the correlation coefficient. b. Determine the equation of regression if the level of satisfaction is being predicted. c. What satisfaction level would the customers achieved if they are paying $20? $8? $16? d. Determine the equation of regression if the cost is being predicted. e. How much would it cost to have a satisfaction level of 7? f. Explain the predicting capability of the equation.
Expert Solution
steps

Step by step

Solved in 7 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL