Book1

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

x y

1.25 44 180
2.25 60
160 f(x) = 21.1785714285714 x + 9.84821428571429
3.25 75 R² = 0.968986288384807
4.25 90 140
5.25 110
120
6.25 150
7.25 170 100

80

60

40

20

0
0 1 2 3 4 5 6 7 8

x y
200
2 21
3 41 180
4 71 160 f(x) = 25.9642857142857 x − 34.6785714285714
R² = 0.993430747485076
5 91 140
6 121 120
7 141
100
8 180
80
60
40
20
0
1 2 3 4 5 6 7 8 9

eq
matrix
y=21.179x+9.8482 a 21.179 -1 b -9.8482
y=25.964x-34.679 25.964 -1 34.679

rearrange

21.179x-y=-9.8482 a2 -0.208986 0.208986


-5.426123 4.426123
25.964x-y=34.679
answer
x= #NAME?
#NAME?
y
Chart Title
250

200
Chart Title 1
250 2
3
200 4
5
150 6
7
100 8
9
10
50
11

0
0 2 4 6 8 10 12 graph

-50

Column J Column K
29

6 7 8

7 8 9

x1 x2
9.8482 -34.679
31.0272 -8.715
52.2062 17.249
73.3852 43.213
94.5642 69.177
115.7432 95.141
136.9222 121.105
158.1012 147.069
179.2802 173.033
200.4592 198.997
221.6382 224.961

11,210

You might also like