Question

What is the value of R2 statistics? What does this statistics tell? Customers (in 1000s), X...

What is the value of R2 statistics? What does this statistics tell?

Customers (in 1000s), X

Line Maintenance Expense (in $1000s), Y

X^2

Y^2

XY

25.3

484.6

640.09

234837.16

12260.38

36.4

672.3

1324.96

451987.29

24471.72

37.9

839.4

1436.41

704592.36

31813.26

45.9

694.9

2106.81

482886.01

31895.91

53.4

836.4

2851.56

699564.96

44663.76

66.8

681.9

4462.24

464987.61

45550.92

78.4

1037

6146.56

1075369

81300.8

82.6

1095.6

6822.76

1200339.36

90496.56

93.8

1563.1

8798.44

2443281.61

146618.78

97.5

1377.9

9506.25

1898608.41

134345.25

105.7

1711.7

11172.49

2929916.89

180926.69

124.3

2138.6

15450.49

4573609.96

265827.98

Total

848

13133.4

70719.06

17159980.62

1090172.01

Homework Answers

Answer #1

The coefficient of determination (r2) is determined as follows:

Sxx = ?x2 – (1/n)(?x)2 = 70719.06 – (1/12)(848)2 = 10793.73

Syy = ?y2 – (1/n)(?y)2 = 17159980.62 – (1/12)(13133.4)2 = 2786130.99

Sxy = ?xy – (1/n)(?x)(?y) = 1090172.01 – (1/12)(848)(13133.4) = 162078.41

R2 = (Sxy)2/( Sxx * Syy) = (162078.41)2/(10793.73*2786130.99) = 0.8735

R2 = 0.8735

Coefficient of determination, R2 explains likelihood of future data points or expenses that fall within the results of predicted outcomes. Thus, for given data 87.35 of added sample data points will fall within the results predicted outcome from the regression line.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 6. In your spreadsheet, calculate the estimated line maintenance expense that would be predicted by...
Question 6. In your spreadsheet, calculate the estimated line maintenance expense that would be predicted by the regression function for each company in the sample. Plot the predicted values you calculate on your graph. Does is appear linear regression model is appropriate. The Following table shows the calculations for regression line: Customers (in 1000s), X Line Maintenance Expense (in $1000s), Y X^2 Y^2 XY 25.3 484.6 640.09 234837.16 12260.38 36.4 672.3 1324.96 451987.29 24471.72 37.9 839.4 1436.41 704592.36 31813.26 45.9...
Nolan Banks is an auditor for the Public Service Commission for the state of Georgia. The...
Nolan Banks is an auditor for the Public Service Commission for the state of Georgia. The PublicService Commission is a government agency responsible for ensuring that utility companies throughout the state manage their operations efficiently so that they can provide quality services to the public at fair prices. Georgia is the largest state east of the Mississippi River, and various communities and regions throughout the state have different companies that provide water, power, and phone service. These companies have a...
n for the state of Georgia. The PublicService Commission is a government agency responsible for ensuring...
n for the state of Georgia. The PublicService Commission is a government agency responsible for ensuring that utility companies throughout the state manage their operations efficiently so that they can provide quality services to the public at fair prices. Georgia is the largest state east of the Mississippi River, and various communities and regions throughout the state have different companies that provide water, power, and phone service. These companies have a monopoly in the areas they serve and, therefore, could...