Generate the "data" Copy & paste "data" as values
slope = m= 0.777 Guess:
intercept = b = 8.5
X Y data:Y+rand X data:Y+rand expected
0 8.5 9.27 0 7.56 8.58185
1 9.277 9.05 1 30 8.61 9.338418
2 10.054 9.96 2 8.07 10.09499
3 10.831 13.10 3 25 10.95 10.85155
40 4 11.608 11.21 4 20 9.86 11.60812
5 12.385 15.28 5 14.19 12.36469
30 15
6 13.162 10.18 6 14.43 13.12126
20 7 13.939 15.41 7 10 11.88 13.87783
8 14.716 15.82 8 5 14.72 14.6344
10 9 15.493 17.79 9 17.25 15.39096
0
10 16.27 16.85 10 0 18.19 16.14753
10
0
0 11 5 17.04710 16.05 20
15 25 30 11 17.84 16.9041
12 17.824 15.32 12 18.79 data:Y+rand
17.66067
13 15.61
18.601 Y data:Y+rand 13 16.15 18.41724
14 19.378 19.53 14 21.54 19.1738
15 20.155 17.44 15 19.65 19.93037
16 20.932 20.76 16 21.74 20.68694
17 21.709 21.46 17 22.41 21.44351
18 22.486 21.01 18 22.48 22.20008
19 23.263 25.85 19 21.85 22.95665
20 24.04 22.01 20 22.20 23.71321
21 24.817 26.11 21 22.81 24.46978
22 25.594 24.15 22 26.61 25.22635
23 26.371 28.58 23 26.36 25.98292
24 27.148 28.93 24 27.12 26.73949
25 27.925 30.36 25 28.74 27.49605
26 28.702 30.75 26 29.37 28.25262
27 29.479 31.72 27 26.90 29.00919
28 30.256 28.84 28 27.75 29.76576
slope = 0.76
Intercept = 8.58
difference^2 Objective Function: 7.763409
1.04855598
0.53399627
4.09142338
0.01062657
3.05034897
3.32044914
1.72276374
3.9732625
0.00721199
3.4746301
4.17223865
20 30
0.87661604
1.27763321fit
data:Y+rand
5.12065752
5.58262552
0.07688163
1.11573076
0.93689789
0.07751361
1.22373474
2.27892457
2.76750027
1.92151111
0.13931937
0.14390502
1.55072944
1.25192911
4.46443384
4.05846229