X | Y | X^2 | Y^2 | XY | |||
20 | 0.24 | 400 | 0.0576 | 4.8 | |||
40 | 1.2 | 1600 | 1.44 | 48 | |||
60 | 1.71 | 3600 | 2.9241 | 102.6 | |||
80 | 2.22 | 6400 | 4.9284 | 177.6 | |||
SUM | 200 | 5.37 | 12000 | 9.3501 | 333 | ||
n | 4 | ||||||
Mean | 50 | 1.3425 | |||||
SSxx | 2000 | Sum(x^2) - ((Sum(x))^2 /n) | SSR | 2.080125 | slope * Ssxy | MSR | 2.080125 |
Ssyy | 2.140875 | Sum(y^2) - ((Sum(y))^2 /n) | SSE | 0.06075 | SST-SSR | MSE | 0.030375 |
Ssxy | 64.5 | Sum(xy) - (Sum(x)*Sum(y)/n) | SST | 2.140875 | Ssyy | F | 68.48148 |
slope | 0.03225 | Ssxy/SSxx | |||||
intercept | -0.27 | Mean Y - Mean X * Slope | |||||
Se | 0.174284 | SQRT(SSE/(n-2)) | |||||
Sb1 | 0.003897 | Se/SQRT(SSxx) | |||||
r | 0.98571 | ||||||
r^2 | 0.971624 |
a)
Y intercept(b0) = -0.27
Slope(b1) = 0.03225
Y = -0.27 + 0.03225 * X
b)
If X = -10
Y = -0.27 + 0.03225 * (-10)
Y = -0.5925
c)
Hypothesis :
H0 : β1 = 0
Ha : β1 not = 0
Test :
t = b1 / Sb1
t = 0.03225/0.003897 = 8.2756
P value = 0.0143 ( Use t table or calculator), df = 2
P value > 0.01, It is not statistically significant
d)
Part 2. In the following computational Problem 2.1 The accompanying datan (m/min) appeared in a recent...