Department of Building and Real Estate
First Year Statistics


LINEAR REGRESSION

Queries can be sent to me

  1. Introduction

  2. Assumptions

  3. Process

  4. Method of Least Squares

  5. Calculating a and b

  6. Correlation

  7. Coefficient of Determination

  8. Standard Error of Estimate (SEE)

  9. Confidence interval for the regression line (estimating the expected value)

  10. Confidence interval for individual prediction

An Example

Accounting
X
Statistics
Y
X2 Y2 XY
1 74.00 81.00 5476.00 6561.00 5994.00
2 93.00 86.00 8649.00 7396.00 7998.00
3 55.00 67.00 3025.00 4489.00 3685.00
4 41.00 35.00 1681.00 1225.00 1435.00
5 23.00 30.00 529.00 900.00 690.00
6 92.00 100.00 8464.00 10000.00 9200.00
7 64.00 55.00 4096.00 3025.00 3520.00
8 40.00 52.00 1600.00 2704.00 2080.00
9 71.00 76.00 5041.00 5776.00 5396.00
10 33.00 24.00 1089.00 576.00 792.00
11 30.00 48.00 900.00 2304.00 1440.00
12 71.00 87.00 5041.00 7569.00 6177.00
Sum 687.00 741.00 45591.00 52525.00 48407.00
Mean 57.25 61.75 3799.25 4377.08 4033.92

 

Figure 1: Scatter Diagram of Raw Data

 

 

 

 

Figure 2: Scatter Diagram and Regression Line



Interpretation/Conclusion

There is a linear relation between the results of Accounting and Statistics as shown from the scatter diagram in Figure 1. A linear regression analysis was done using the least-square method. The resultant regression line is represented by in which X represents the results of Accounting and Y that of Statistics. Figure 2 shows the regression line. In this example, the choice of dependent and indeendent variables is arbitrary. It can be said that the results of Statistics are correlated to that of Accounting or vice versa.

The Coefficient of Determination is 0.9194. This shows that the two variables are correlated. Nearly 92% of the variation in Y is explained by the regression line.

The Coefficient of Correlation (r) has a value of 0.8453. This indicates that the two variables are positively correlated (Y increases as X increases).

Queries can be sent to me


Previous Page
Home Page

SM 18Oct95