Spreadsheet: 159082d1338490110-finding-the-best-equation-to-predict-relationship-between-three-variables-book1
Sheet: Sheet1

X | Y | Z | Z predicted
3.784118936742862 | 1.477925784188953 | 34.28387345679012
3.740406128189289 | 1.487632469847468 | 34.34891975308641
3.738093661824519 | 1.48894077280213 | 34.29904243764883
3.703035042646239 | 1.498143137468921 | 34.30555555555556
3.77617521039316 | 1.526432613962334 | 34.43330675172781
3.672342488437508 | 1.534489146364314 | 34.30102039865004
3.581953537762614 | 1.535156987414549 | 34.26746913580247
3.606598247926039 | 1.537977354620425 | 33.88971193415638
3.599277565971574 | 1.545310623019736 | 33.99576861378458
3.720124935232998 | 1.549544123169901 | 34.27032407407407
3.687724206314442 | 1.557328375729047 | 34.28703703703705
3.626960093903434 | 1.557925094566162 | 33.89274086650227
3.641018374169738 | 1.575526368899869 | 34.25409828714913
3.614752797092866 | 1.57788844985841 | 34.00783807062877
3.54219648625965 | 1.600771322504124 | 34.01868191721132
3.534449818721356 | 1.60276151371175 | 33.8650759734093
3.466823006907444 | 1.622350211177787 | 34.25411522633745
3.556943518921645 | 1.661925766126681 | 34.34288302138181
4.029963201355661 | 1.795110912989692 | 35.47356627208322
3.583954863359445 | 1.901616660634978 | 34.75688888888889
3.355387910560847 | 1.949675901709384 | 34.64716386142499
3.038528896672505 | 2 | 33.4
2.5569176882662 | 2 | 31.3
2.311733800350263 | 2 | 30.5
3.3438171952395 | 2.010565388869797 | 34.87418300653594
3.283966695286434 | 2.029317537389747 | 34.64208333333333
3.253065725210839 | 2.041986047748281 | 34.32800925925927
3.234209667219697 | 2.048472748254089 | 34.53773148148148
2.355516637478109 | 2.36 | 31.9
3.54946319202726 | 2.362917650802304 | 35.54413580246914
3.353147096274859 | 2.38650681703969 | 35.26966328381112
3.458844133099825 | 2.4 | 36.1
3.48089514671228 | 2.400898185839044 | 35.31984702093397
3.4406745213106 | 2.410077468621773 | 35.31782407407407
3.052279741810084 | 2.410408383889403 | 35.31462390911025
3.308912791402702 | 2.449737346654063 | 35.37543438500229
3.03247435019393 | 2.461828973382755 | 35.20564756148657
3.698380020155114 | 2.602434411796553 | 35.5400205761317
3.248686514886165 | 2.64 | 34.6
3.534364924877767 | 2.682556523237837 | 35.59248605337029
3.210905854510743 | 2.717209146473472 | 35.56789507293137
3.298152321368961 | 2.747489990558298 | 35.49456700861039
2.953720513546015 | 2.75485081365771 | 36.15326323031566
2.541092940550203 | 2.764057893022648 | 29.17390929064658
2.432175274777878 | 2.768568716273012 | 29.67958937198068
2.89055082556902 | 2.779010693384117 | 30.32652777777778
3.151944075135216 | 2.876939940701139 | 35.56242998213337
2.892764467205277 | 2.97501302701878 | 35.58763339610798
3.060946731753855 | 2.992965417029365 | 35.60328274833863
2.893173920816297 | 3.010411550973365 | 32.73101484420929
3.074180653876174 | 3.024562773874686 | 33.79570913816529
2.82516309221165 | 3.038482047200689 | 32.7600361856109
3.011816381741515 | 3.049352384987187 | 33.27632275132275
3.143615194739479 | 3.058011044681753 | 32.74050925925926
2.784183833041028 | 3.058147494508415 | 32.74893019586002
2.727675328642824 | 3.078441469852128 | 32.74457707043914
2.866148250470232 | 3.085392230956427 | 31.66583820662768
3.09120272517186 | 3.089978548010003 | 31.15460204114511
2.85433671520912 | 3.118993542668687 | 31.75210321124448
2.929624690322946 | 3.123843255291432 | 32.22166925150474
2.547196425563399 | 3.147928017965123 | 30.6204248366013
2.549857900665145 | 3.155512222648175 | 32.74603980417199
2.602047754571554 | 3.204960619474915 | 30.26920875420875
3.415613116495609 | 3.255058377981379 | 35.88318713450292
2.810291945119741 | 3.259637787490128 | 30.2076566951567
3.10446903499027 | 3.295375365572847 | 32.68722454856849
2.550048869560352 | 3.325773202059717 | 32.73229166666667
3.284688588896424 | 3.373972202758643 | 35.36296296296296
3.307732719453424 | 3.443266097277695 | 34.82289562289562
3.139840316855642 | 3.470329569450842 | 34.822962402005
2.977343435108147 | 3.479663101632087 | 36.35094765560866
3.194511080207152 | 3.5275508868763 | 34.57993827160494
3.208554813741164 | 3.530848373058596 | 34.83998921388449
2.305772426272576 | 3.534655503383187 | 29.12033195788278
3.141238861429136 | 3.549984396853104 | 34.31072530864198
3.137859224544832 | 3.560789810311664 | 33.78082788671024
2.727348622364969 | 3.642861097648035 | 34.33744212962963
3.434685241846597 | 3.721144889667406 | 36.49851851851852
2.932366117611363 | 3.74317532103698 | 33.16400000000001
3.228320390512206 | 3.746265550787471 | 33.71233458264142
2.876239738575046 | 3.750845697544802 | 33.2241512345679
2.701967542565118 | 3.769520197757848 | 33.25754576415495
2.939945862180397 | 3.772366290502578 | 32.714218550447
2.544068267656656 | 3.787894378851471 | 30.0392484270941
2.558371959577828 | 3.802412011616132 | 34.43493827160494
2.521562698111355 | 3.810277571118018 | 30.0852366255144
2.630886539962852 | 3.83700512729065 | 30.07721009700177
2.891489414331494 | 3.838551888946667 | 32.16339781076623
2.939729451676019 | 3.844684389420256 | 34.02633307998359
3.162341331418101 | 3.846770352662357 | 34.9140412211411
3.138687622551529 | 3.862489212266127 | 33.81712962962963
2.848656516410195 | 3.871685665777368 | 31.64891067538126
3.32400639139499 | 3.872773786398213 | 34.3618639826267
2.43949885700885 | 3.872875992306114 | 30.11343106184022
2.417518367194268 | 3.889211074733629 | 30.66182280033286
2.45114176362412 | 3.889224701468649 | 30.14305555555556
3.07078438077516 | 3.890180362627659 | 33.90307112849486
3.01301486448079 | 3.90289233284508 | 34.11999050332383
3.04382886766175 | 3.907490966220017 | 34.3644880174292
2.528937362532438 | 3.911121556528661 | 30.15391737891738
2.797861892649806 | 3.912159955737063 | 32.16453672316384
2.427496575105589 | 3.912693326544658 | 33.22978966620941
2.476353410032296 | 3.91648992580959 | 30.14345679012346
3.251068693400556 | 3.917657408019912 | 33.78736614467699
2.621851603971018 | 3.925351734057222 | 31.1193378279455
2.471339221389803 | 3.929835952883506 | 30.12430555555556
2.585786960264159 | 3.932318423116462 | 30.27340067340068
3.110126110819692 | 3.935593510134248 | 33.71191825048734
2.48829932556784 | 3.939129407301126 | 30.11476034858388
3.194866048702099 | 3.939996755107588 | 33.84440035273369
3.157371301073167 | 3.943996641406686 | 33.72567664956183
2.735764451726755 | 3.955400752940869 | 30.09246582892415
2.711399050456777 | 3.957565803856588 | 31.63706453744421
2.447108821191909 | 3.961395165828661 | 30.15775760118159
2.740105631485962 | 3.983354784734995 | 30.15597643097643
2.726928644335998 | 4.003017918326643 | 31.64385326061794
2.419081751223291 | 4.004743696601642 | 30.11213713713714
2.741966212422423 | 4.027788696030522 | 31.64401008407832
2.57975019904129 | 4.054323216527186 | 32.16993308794157
2.675626624635399 | 4.055414331710461 | 31.87716061649025
2.571909750475704 | 4.063328923476751 | 30.9034345922277
2.573994895274636 | 4.063536657427877 | 30.39082279503985
2.737209339813085 | 4.071852380031012 | 31.22906605067681
2.380315405554192 | 4.088442034445472 | 30.11864535768645
2.651795923539912 | 4.088815378576712 | 31.11092075624977
2.865207554054367 | 4.095379157451509 | 31.54583946955933
2.326705413726426 | 4.103632118094632 | 31.17226589153634
2.664018995295685 | 4.112374436094795 | 30.78446518895419
2.327743079642887 | 4.117736864092723 | 31.69719416386083
2.571150477889193 | 4.131586506587979 | 29.12234993614303
2.32916272183891 | 4.137783167044147 | 31.7230452674897
2.764177101911744 | 4.13878488305257 | 31.61671868497712
2.290368559730839 | 4.13958493548659 | 29.0227102718482
2.93749553136947 | 4.145171365669659 | 31.80944256120528
2.422476789695814 | 4.16005043370569 | 30.57922150270004
2.56002762569931 | 4.201354097514168 | 30.38062110653574
2.244193179012459 | 4.203762501966639 | 30.64008524634681
2.50662174024447 | 4.257460212072959 | 30.84403935185185
2.661261728209266 | 4.343621100367043 | 31.61466049382717
2.580526961330339 | 4.344601385880553 | 30.16347222222222
2.508569950556337 | 4.36508070735076 | 30.15189127372446
2.810306885747274 | 4.36652544161476 | 30.06732804232804
2.377794698257054 | 4.429985391011416 | 29.41939876886752
2.531374359334357 | 4.612205568369407 | 30.86244681593082
2.960625146090806 | 4.96783633932682 | 36.29447877432518
2.590312295073349 | 5.262545698132305 | 30.13539886039886
2.419045622384734 | 5.341018793503689 | 30.08757716049383
2.536230113323995 | 5.368361809377404 | 30.053952991453
2.309250679298398 | 5.501419425698144 | 29.07025898078529