Generate equations form data set for two variable like f=ax+bx=c

[anuragrktiwari]

x1 y1 z1
305930.5277 1.042 1.01
307752.4281 1.054 1.059
314433.7659 1.083 1.086
320779.5539 1.091 1.105
322111.451 1.099 1.109
325592.4762 1.118 1.141
343023.2121 1.128 1.167
348432.1307 1.162 1.171
356907.7669 1.227 1.2
360997.0616 1.241 1.226
366205.8684 1.248 1.231
376188.3244 1.297 1.248
384753.5623 1.313 1.262
390744.1395 1.331 1.333
405751.4367 1.335 1.346
406114.6969 1.353 1.361
414299.319 1.356 1.37
428231.7688 1.411 1.383
433510.2943 1.416 1.398
434712.0162 1.421 1.418
435090.244 1.436 1.426
441591.8314 1.501 1.431
446286.2965 1.64 1.438
452680.6533 1.641 1.446
455561.1927 1.651 1.447
455602.4442 1.668 1.448
458048.9452 1.678 1.45
462611.0012 1.729 1.454
463042.0614 1.787 1.458
467767.2267 1.807 1.468
478583.5054 1.812 1.479
479639.8179 1.841 1.499
485151.2277 1.87 1.529
487387.3839 1.942 1.537
494127.8909 1.945 1.551
507340.3781 1.982 1.633
508465.8925 1.99 1.633
523512.8412 1.999 1.674
527394.7255 2.008 1.712
529403.5954 2.03 1.717
530867.0889 2.043 1.863
531154.3225 2.055 1.877
534961.5034 2.088 1.899
560857.2533 2.091 1.899
563777.4193 2.124 1.932
564985.6 2.134 1.957
570775.8308 2.146 2.083
571645.7551 2.188 2.117
575869.6243 2.219 2.149
578252.3742 2.224 2.16
582631.8297 2.261 2.19
583657.8831 2.262 2.207
584055.8247 2.298 2.217
603007.2815 2.3 2.234
603026.2674 2.337 2.256
607121.6581 2.347 2.295
610085.2114 2.371 2.351
611172.2775 2.38 2.453
632766.6019 2.409 2.456
633558.5038 2.439 2.497
646460.8033 2.524 2.511
668014.6807 2.635 2.516
683345.9215 2.694 2.568
698142.4718 2.725 2.598
698806.7402 2.788 2.603
699514.5279 2.819 2.623
700872.4662 2.872 2.761
704868.5736 2.917 2.807
713229.2851 2.925 2.828
714718.4703 2.95 2.829
716525.7249 2.958 2.835
719328.6739 2.976 2.87
721289.1148 2.983 2.945
723701.3122 2.99 2.947
723944.2381 3.1 2.952
731144.3783 3.116 2.955
738095.9339 3.154 2.958
743331.9149 3.154 2.971
745078.0278 3.167 2.976
748460.494 3.17 2.985
753191.1817 3.175 2.992
767860.5581 3.195 3.037
769465.6644 3.224 3.046
770952.3928 3.231 3.048
778578.108 3.29 3.065
784982.0558 3.306 3.086
786980.0825 3.327 3.089
818258.0897 3.346 3.121
821880.6329 3.359 3.151
836112.9668 3.384 3.153
839144.9705 3.396 3.216
845684.8197 3.435 3.226
846018.6275 3.44 3.255
854025.416 3.447 3.313
855933.4273 3.465 3.395
856097.1093 3.519 3.398
873636.0191 3.584 3.411
878616.3808 3.632 3.457
889226.7786 3.645 3.457
893978.116 3.659 3.503
895451.8087 3.67 3.507
899187.6754 3.692 3.516
899766.5826 3.757 3.53
900493.0896 3.781 3.566
901874.6098 3.782 3.566
904198.7491 3.817 3.62
904536.2652 3.869 3.628
904590.138 3.917 3.778
906506.4099 3.95 3.806
910189.0736 3.95 3.818
914242.9798 4.039 3.825
919745.0078 4.109 3.856
921021.125 4.122 4.026
923064.8504 4.143 4.04
931907.0311 4.144 4.084
938273.0673 4.16 4.122
941084.2575 4.212 4.124
950419.1704 4.229 4.159
958489.1668 4.229 4.18
965121.3922 4.241 4.288
967707.839 4.246 4.293
968483.8914 4.286 4.318
969683.6814 4.319 4.32
972416.0305 4.343 4.346
973367.984 4.345 4.347
973368.5442 4.397 4.377
982760.5496 4.5 4.41
985500.1314 4.506 4.425
985904.6634 4.506 4.443
988708.4365 4.517 4.444
1001924.872 4.519 4.445
1003135.932 4.533 4.463
1003592.633 4.544 4.47
1016403.086 4.649 4.483
1017449.832 4.742 4.505
1029896.049 4.836 4.614
1037491.509 4.841 4.618
1039157.492 4.973 4.664
1040205.98 4.983 4.688
1040846.183 5.033 4.694
1042267.074 5.078 4.696
1048662.466 5.125 4.712
1049994.998 5.163 4.72
1052462.457 5.182 4.739
1056945.838 5.182 4.783
1058425.011 5.183 4.796
1063067.291 5.231 4.815
1066993.031 5.245 4.824
1067642.882 5.259 4.915
1067795.888 5.299 4.966
1075386.064 5.313 5.001
1082007.303 5.334 5.021
1083104.424 5.353 5.105
1084824.342 5.404 5.109
1091089.696 5.429 5.162
1091768.039 5.432 5.222
1092920.851 5.457 5.242
1101964.889 5.484 5.252
1105085.967 5.507 5.278
1117107.711 5.537 5.319
1118833.273 5.571 5.339
1119402.405 5.576 5.362
1119407.914 5.577 5.405
1119767.688 5.59 5.416
1120220.728 5.597 5.444
1122742.789 5.635 5.512
1127205.561 5.661 5.514
1128135.061 5.67 5.523
1130677.433 5.696 5.621
1133491.465 5.765 5.623
1134580.058 5.803 5.638
1139828.798 5.825 5.644
1141697.439 5.847 5.682
1141910.803 5.865 5.689
1142778.187 5.914 5.69
1151775.341 5.927 5.769
1152311.673 5.939 5.783
1154175.231 5.97 5.786
1165285.465 5.985 5.811
1175226.249 6.037 5.814
1180166.998 6.04 5.822
1182774.205 6.052 5.866
1188116.934 6.054 5.883
1198190.259 6.066 5.898
1200179.35 6.072 5.9
1203279.681 6.105 5.908
1204083.097 6.12 5.935
1205536.309 6.153 6.013
1206821.65 6.165 6.024
1209476.561 6.166 6.039
1212592.727 6.222 6.046
1212751.248 6.313 6.05
1225102.355 6.338 6.056
1225858.115 6.364 6.072
1233368.855 6.414 6.095
1235289.311 6.494 6.124
1243161.673 6.495 6.131
1243941.06 6.506 6.161
1248324.781 6.54 6.163
1270479.839 6.548 6.198
1275884.368 6.56 6.245
1284516.482 6.586 6.402
1287644.798 6.596 6.414
1293778.834 6.653 6.509
1296027.163 6.686 6.555
1307738.851 6.747 6.566
1308588.008 6.759 6.571
1309167.06 6.773 6.595
1312953.009 6.779 6.613
1313258.228 6.8 6.621
1315365.39 6.834 6.631
1316393.233 6.837 6.71
1319059.938 6.847 6.718
1319591.005 6.85 6.733
1320851.302 6.892 6.748
1335183.476 6.895 6.764
1341411.823 6.957 6.774
1348631.604 6.959 6.819
1359285.663 6.985 6.85
1369342.166 6.987 6.891
1375252.439 7.018 6.901
1381393.096 7.042 6.948
1386244.851 7.057 7.032
1391594.987 7.114 7.073
1395785.213 7.126 7.079
1396330.297 7.179 7.106
1399087.743 7.194 7.131
1399428.244 7.24 7.201
1401996.028 7.249 7.243
1410014.423 7.31 7.261
1416253.329 7.312 7.307
1417752.767 7.437 7.383
1418039.767 7.472 7.403
1426668.551 7.484 7.44
1431177.849 7.486 7.481
1432276.126 7.507 7.495
1434694.008 7.51 7.498
1439968.071 7.524 7.578
1445351.296 7.542 7.588
1446702.261 7.547 7.598
1447038.419 7.584 7.696
1447475.088 7.593 7.708
1449325.557 7.62 7.708
1453371.76 7.635 7.711
1455461.243 7.638 7.715
1461524.717 7.646 7.731
1468354.095 7.782 7.793
1469582.458 7.817 7.796
1471100.106 7.827 7.801
1475462.555 7.85 7.864
1481195.039 7.864 7.866
1483621.268 7.885 7.882
1483646.253 7.918 7.902
1489800.227 7.943 7.962
1492676.664 7.945 7.964
1494499.464 7.954 7.97
1496447.698 7.986 7.973
1496589.28 8.005 8.02
1502603.214 8.084 8.029
1523460.092 8.094 8.032
1529615.411 8.128 8.054
1531638.336 8.137 8.125
1544337.72 8.145 8.128
1559779.337 8.237 8.191
1561717.928 8.237 8.212
1583109.743 8.315 8.224
1583352.146 8.317 8.243

[jeffreybrown]

Hello & Welcome to the Forum,

Not sure you are going to generate a lot of traction on this question.

1) You should probably elaborate on what you are trying to achieve
2) Don't post a list of data as it doesn't copy all that well.
3) Post a workbook instead with a clear before and after

We are here to help, but you have to help us also.

[anuragrktiwari]

Want to get liner equation two variable by using abave data to know the nature of data through equation just line trendline in excel but it only generate function with one variable,But i need two variable for that.

[MrShorty]

Are you familiar with the LINEST() function? https://support.office.com/en-us/art...a-fa7abf772b6d That is how I do almost all of my regressions (as long as the modeling equation is "linear").

[shg]

	A	B	C	D	E	F	G	H	I
1	x1	y1	z1	Fit
2	305,930.5277	1.042	1.010	388,504.6870					D2: =$G$6*B2 + $F$6 * C2 + $H$6
3	307,752.4281	1.054	1.059	390,820.9101
4	314,433.7659	1.083	1.086	395,526.1426
5	320,779.5539	1.091	1.105	396,936.8927		mz1	my1	b
6	322,111.4510	1.099	1.109	398,201.2297		9760.876386	153161.6838	219051.7	F6:H10: {=LINEST(A2:A268, B2:C268, , TRUE)}
7	325,592.4762	1.118	1.141	401,423.6498		16814.1657	16933.67589	5563.209
8	343,023.2121	1.128	1.167	403,209.0494		0.99131019	32945.39933	#N/A
9	348,432.1307	1.162	1.171	408,455.5901		15058.20605	264	#N/A
10	356,907.7669	1.227	1.200	418,694.1650		3.26883E+13	2.86545E+11	#N/A
11	360,997.0616	1.241	1.226	421,092.2114

The highlighted value is R2 for the fit.