Question

In: Operations Management

Y^ = b0 + b1X1 The following table shows the calculations for regression line: The following...

Y^ = b0 + b1X1

The following table shows the calculations for regression line:

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

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

Sample size: n = 12

Question. According to equation Y^ = b0 + b1X1 what level of line maintenance expense would be expected for a phone company with 75,000 customers show how you arrive at this value.

Solutions

Expert Solution


Related Solutions

Suppose you perform the following multiple regression: Y = B0 + B1X1 + B2X2 + B3X3....
Suppose you perform the following multiple regression: Y = B0 + B1X1 + B2X2 + B3X3. You find that X1 and X3 have a near perfect correlation. How would you conclude on the utility of your regression result? This is a problem of multicollinearity which renders the entire regression invalid. This is a problem of multicollinearity which nevertheless does not invalidate the utility of the model as a whole This is NOT a regression problem and inferences made using the...
estimate the following linear regression equation using the data below: y=B0+B1X In this exercise, you need...
estimate the following linear regression equation using the data below: y=B0+B1X In this exercise, you need to estimate ŷ values for given y and x values using Excel. What are the estimated values of B0 and B1 ? x = 2, 4, 6, 8, 10 y = 10, 12, 20, 25, 40 ŷ =
Find the linear regression line for the following table of values. You will need to use...
Find the linear regression line for the following table of values. You will need to use a calculator, spreadsheet, or statistical software. Enter your answer in the form y=mx+b, with m and b both rounded to two decimal places. x y 3 6.03 4 9.65 5 11.49 6 11.57 7 12.96 8 14.97 9 16.31 10 17.43 11 18.55
Simple Linear Regression: Suppose a simple linear regression analysis provides the following results: b0 = 6.000,    b1...
Simple Linear Regression: Suppose a simple linear regression analysis provides the following results: b0 = 6.000,    b1 = 3.000,    sb0 = 0.750, sb1 = 0.500,  se = 1.364 and n = 24. Use this information to answer the following questions. (a) State the model equation. ŷ = β0 + β1x ŷ = β0 + β1x + β2sb1    ŷ = β0 + β1x1 + β2x2 ŷ = β0 + β1sb1 ŷ = β0 + β1sb1 x̂ = β0 + β1sb1 x̂ = β0 +...
There is a regression line Y = 10 + 11X. The SEE for the slope is...
There is a regression line Y = 10 + 11X. The SEE for the slope is 60. The sample size is 10. The standard deviation of Y is 100 and the standard deviation of X is 5. Do a hypothesis test. Calculate the t-statistic, state the critical value, and state what this means with regards to the relation between X and Y.
A hospital administrator developed a regression line, y = 30 + 2x, to predict y =...
A hospital administrator developed a regression line, y = 30 + 2x, to predict y = the number of full-time employees (FTE) needed using x = the number of beds. The slope of this regression line suggests this: __________. for a unit increase in the number of beds, the number of FTEs is predicted to increase by 32 for a unit increase in the number of beds, the number of FTEs is predicted to decrease by 32 for a unit...
Please answer all questions, fill in table and show calculations. The table below shows the hypothetical...
Please answer all questions, fill in table and show calculations. The table below shows the hypothetical prices and quantities demanded of a software product. Assume that the fixed cost of setting up the production of software is $200 and the marginal cost is $5. Fill out the table by calculating the revenue, the marginal revenue, total cost, the marginal cost, and the profit. Give a general definition of price elasticity of demand. Explain the factors that make the demand of...
Find the linear regression line for the following table of values, where x represents the number...
Find the linear regression line for the following table of values, where x represents the number of employees a manager supervises and y represents average percentage of incomplete tasks. You will need to use a calculator, spreadsheet, or statistical software. Round your final answers to two decimal places.
The following table shows the yields (y) obtained in an agricultural experiment in tonnes per hectare...
The following table shows the yields (y) obtained in an agricultural experiment in tonnes per hectare after using (x) tonnes of fertilizer per hectare. Fertilizer (x, ton/hectare) 0 0.2 0.4 0.6 Yield (y, ton/hectare) 1.35 1.55 1.95 2.75 (a) Calculate the regression line of y on x (ie. y= a + bx) (b) Calculate regression coefficient, rx,y (c) Estimate the total yields in tonnes from a 2.2 hectare field if 0.5 tonne of fertilizer is used
Regression Equation: Y' 1.15X+ -5.688 Display the data with a scatterplot inserting a regression line. Make...
Regression Equation: Y' 1.15X+ -5.688 Display the data with a scatterplot inserting a regression line. Make comments on the arrangements of the points Predicted values of Y: 0.062, 1.212, 2.362, 2.362, 2.362, 3.512, 3.512, 3.512, 3.512, 4.662 Residual: 0.938, -0.212, -0.362, -0.362, -0.362, -1.512, -0.512, -0.512, 1.488, 1,338
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT