Please help me with calculating the crossing point of the regression lines of tw part of one graph, the X axis is column B and Y axis is column D, and please formta the axis to logaritm, I want to crossing point of the regression lines for the early flat part and non linear dropping part of the graph

 A B C D E F G
1|1 0.1 -0.00392 -25.53 25.69 12.79 10.4
1|2 0.1272 -0.00124 -102.4 25.69 23.53 21.14
1|3 0.1619 -0.00038 -422.1 25.69 34.27 31.88
1|4 0.206 1.29E-13 1.6E+12 25.7 42.6 40.21
1|5 0.262 1.82E-06 144200 25.69 53.28 50.89
1|6 0.3334 0.000133 2503 25.7 64.04 61.65
1|7 0.4242 0.000221 1922 25.7 74.79 72.4
1|8 0.5397 0.000356 1517 25.7 85.5 83.11
1|9 0.6867 0.000468 1469 25.7 96.26 93.87
1|10 0.8736 0.000495 1763 25.71 107 104.6
1|11 1.112 0.000675 1646 25.71 117.7 115.3
1|12 1.414 0.000727 1947 25.7 128.4 126
1|13 1.799 0.000924 1948 25.7 139 136.6
1|14 2.289 0.001156 1980 25.7 149.7 147.3
1|15 2.913 0.001551 1878 25.7 160.4 158
1|16 3.706 0.001782 2080 25.71 171.1 168.7
1|17 4.715 0.002135 2208 25.7 181.8 179.5
1|18 5.999 0.002473 2425 25.71 192.6 190.2
1|19 7.632 0.002972 2568 25.71 203.4 201
1|20 9.711 0.003609 2691 25.71 214 211.6
1|21 12.36 0.004376 2823 25.71 224.7 222.3
1|22 15.72 0.005235 3003 25.71 235.4 233
1|23 20 0.006341 3154 25.71 246.1 243.8
1|24 25.45 0.007816 3255 25.71 256.8 254.4
1|25 32.38 0.01129 2868 25.71 267.5 265.1
1|26 41.19 0.01682 2448 25.71 278.3 275.9
1|27 52.41 0.0289 1813 25.71 289 286.6
1|28 66.68 0.06034 1105 25.7 299.7 297.3
1|29 84.84 0.1434 591.8 25.71 310.4 308
1|30 107.9 0.35 308.4 25.71 321.1 318.7
1|31 137.3 0.7867 174.6 25.7 331.7 329.4
1|32 174.7 1.55 112.7 25.7 342.5 340.1
1|33 222.3 2.702 82.26 25.71 353.2 350.8
1|34 282.8 4.282 66.06 25.7 363.9 361.5
1|35 359.9 6.427 55.99 25.71 374.6 372.2
1|36 457.9 9.306 49.2 25.7 385.3 383
1|37 582.5 13.19 44.15 25.71 396 393.7
1|38 741.2 18.4 40.28 25.7 406.8 404.4
1|39 943 25.31 37.26 25.71 417.5 415.1
1|40 1200 34.64 34.64 25.71 428.1 425.8
1|41 1526 47.11 32.4 25.71 438.8 436.5
1|42 1942 64.02 30.34 25.71 449.5 447.2
1|43 2471 86.23 28.66 25.7 460.3 457.9
1|44 3144 114.7 27.4 25.71 471 468.6

 

By: mahsa

Leave a Reply

Your email address will not be published. Required fields are marked *