Hi
x y (x-2.5) (y-1.125)Product(x-2.5)^2
1 0.45 -1.5 -0.675 1.0125 2.25
2 0.9 -0.5 -0.225 0.1125 0.25
3 1.35 0.5 0.225 0.1125 0.25
4 1.8 1.5 0.675 1.0125 2.25
10 4.5 0 0 2.25 5
2.5 1.125
y = ax + b
a = 2.25/5 = .45
b = 1.125 - .45*2.5 = 0
y = .45x , when x = 9, y = $3.60
Or use Excel Scatter Plot capbilities
.