In: Statistics and Probability
x | 1 | 2 | 3 | 4 | 5 | 6 |
---|---|---|---|---|---|---|
y | 1057 | 1510 | 2151 | 3499 | 5146 | 7261 |
Use linear regression to find the equation for the linear
function that best fits this data. Round to two decimal
places.
Y=
X | Y | XY | X^2 | Y^2 |
1 | 1057 | 1057 | 1 | 1117249 |
2 | 1510 | 3020 | 4 | 2280100 |
3 | 2115 | 6345 | 9 | 4473225 |
4 | 3499 | 13996 | 16 | 12243001 |
5 | 5146 | 25730 | 25 | 26481316 |
6 | 7261 | 43566 | 36 | 52722121 |
n | 6 |
sum(XY) | 93822.00 |
sum(X) | 21.00 |
sum(Y) | 20624.00 |
sum(X^2) | 91.00 |
sum(Y^2) | 99470588.00 |
Numerator | 129828.00 |
Denominator | 134181.91 |
r | 0.9676 |
r square | 0.9362 |
Xbar(mean) | 3.5000 |
Ybar(mean) | 3437.3333 |
SD(X) | 1.7078 |
SD(Y) | 2182.4690 |
b | 1236.4571 |
a | -890.2667 |
y = -890.27 + 1236.46x