Answer to Question #203405 in Statistics and Probability for alyssa

Question

Sales, in millions of pesos, of a certain company are shown here.

 

YEAR(X)

1

2

3

4

5

6

7

8

9

10

SALES(Y)

P12

P15

P17

P18

P16

P19

P21

P20

P22

P24

Determine the regression equation. Solve for the sum of squares for error, standard error, coefficient of determination. Find the 90% confidence interval for all year for the 12^th year. Determine a 95% prediction interval for the 12^th year.

 

 

Step 1: Complete the table

 

Step 2: solve for the following:

 

 

Slope(b1):

 

Intercept(bo):

 

Simple linear regression equation:

 

Standard error of estimate(SE):

 

Coefficient of Determination(r²):

 

Confidence interval:

 

Prediction interval: