Question

Use linear regression to find the equation for the linear function that best fits this data. Round both numbers to two decimal places. Write your final answer in a form of an equation y=mx+by=mx+b

x	1	2	3	4	5	6
y	93	110	138	170	191	212

Answer 1

Solution:

X	Y	XY	X^2	Y^2
1	93	93	1	8649
2	110	220	4	12100
3	138	414	9	19044
4	170	680	16	28900
5	191	955	25	36481
6	212	1272	36	44944

n	6
sum(XY)	3634.00
sum(X)	21.00
sum(Y)	914.00
sum(X^2)	91.00
sum(Y^2)	150118.00
Numerator	2610.00
Denominator	2618.73
r	0.9967
r square	0.9933
Xbar(mean)	3.5000
Ybar(mean)	152.3333
SD(X)	1.7078
SD(Y)	42.5937
b = m	24.8571
a = b	65.3333

y = 24.86 X + 65.33