Bookmarked With the growth of internet service providers, a researcher decides t

Question

Bookmarked With the growth of internet service providers, a researcher decides to examine whether there is a correlation between the cost of internet service per month (rounded to the nearest dollar) and the degree of customer satisfaction (on a scale of 110, 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.

Dollars 11 18 17 15 9 5 12 19 22 25

Satisfaction 6 8 10 4 9 6 3 5 2 10

A) calculate the ANOVA table for the data. Use the ANOVA Table to conduct an F-Test to see if the model is significant (use = 0.05).

Explanation / Answer

Here Dollars variable is independent variable and Statisfaction is dependent variable.

We can solve this question using excel.

First enter data into excel.

Click on Data -------> Data Analysis --------> Regression ------->

Input

Input Y Range : select satisfaction values

Input X Range :select values of dollars.

Output Range : select any empty cell

-------------> Ok

We get ANOVA

F statistic = 0.047027

Ftable = 0.833749

F statistic < Ftable so model is not significant.

ANOVA df SS MS F Significance F Regression 1 0.433038 0.433038 0.047027 0.833749 Residual 8 73.66696 9.20837 Total 9 74.1

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.