The following data represent the Statistics grades for a random sample of 12 freshmen at a
certain college along with their scores on an intelligence test administered while they were still
seniors in high school and the number of class periods missed by the students taking the
Statistics course. The complete data are shown.
Final Test
Student Grade Score Missed
y x1 x2
1 85 65 1
2 74 50 7
3 76 55 5
4 90 65 2
5 85 55 6
6 87 70 3
7 94 65 2
8 98 70 5
9 81 55 4
10 91 70 3
11 76 50 1
12 74 55 4
a) Estimate the simple linear regression equation to predict Final Grade from Test score.
̂ = 𝒂 + 𝒃𝒙𝟏
𝒚
b) Estimate the Final grade of a student who scored 75 in test.
c) Calculate coefficient of correlation ‘r’ and coefficient of determination ‘R2’ and comments.
d) The estimated multiple linear regression equation is defined as:
̂ = 𝟐𝟕. 𝟓𝟒𝟔𝟕 + 𝟎. 𝟗𝟐𝟏𝟕𝒙𝟏 + 𝟎. 𝟐𝟖𝟒𝟐𝒙𝟐 .
𝒚
Use this equation and calculate multiple R2 and compare with R2 of simple linear regression equation and
comments
Solution:
For Linear Regression:
Use calculator option
ModeStatsA + BX or Menu6A + BX (If you have latest version calculator)
Then input data in column x and y
Press AC (to clear screen of calculator)
Shift 1 REG or Optn.Regression calculation (If you have latest version calculator)
Now find values of a, b and r 1 by 1
a 30.043
b 0.897
r 0.862
Regression equation:
̂ = 𝒂 + 𝒃𝒙
𝒚
̂ = 𝟑𝟎. 𝟎𝟒𝟑 + 𝟎. 𝟖𝟗𝟕 𝒙
𝒚
Coefficient of correlation ’ r’ 0.862
R Square =r2 0.743 = 74.3%
n 12
Now for Finding R2 for
Multiple Linear regression
S.# y x1 x2 ̂ = 𝟐𝟕. 𝟓𝟒𝟔𝟕 + 𝟎. 𝟗𝟐𝟏𝟕𝒙𝟏 + 𝟎. 𝟐𝟖𝟒𝟐𝒙𝟐 .
𝒚 𝒆𝟐 = (𝒚 − 𝒚
̂)𝟐
1 85 65 1 87.7414 7.515274
2 74 50 7 75.6211 2.627965
3 76 55 5 79.6612 13.40439
4 90 65 2 88.0256 3.898255
5 85 55 6 79.9454 25.54898
6 87 70 3 92.9183 35.02627
7 94 65 2 88.0256 35.69346
8 98 70 5 93.4867 20.36988
9 81 55 4 79.377 2.634129
10 91 70 3 92.9183 3.679875
11 76 50 1 73.9159 4.343473
12 74 55 4 79.377 28.91213
Total SSE=183.6541
𝑺𝑺 𝑻𝒐𝒕𝒂𝒍 = 𝒏 × 𝒗𝒂𝒓𝒊𝒂𝒏𝒄𝒆(𝒚) = 𝟏𝟐×𝟔𝟎. 𝟔𝟖𝟕𝟓 = 𝟕𝟐𝟖. 𝟐𝟓
𝑆𝑆𝐸 183.6541
𝑹𝟐 = 1 − =1− = 1 − 0.2522 = 0.7478 = 𝟕𝟒. 𝟕𝟖%
𝑆𝑆𝑇𝑜𝑡𝑎𝑙 728.25