AutoSave On . F - .= Linear Regression in Excel - Saved . Chart Tools Donnelly, Vincent DV X File Home Insert Page Layout Formulas Data Review View Help Design Format Search Share Comments AutoSum A" A = E ab Wrap Text General AP O Fill - Idea Paste BIU - - SA. E Merge & Center Conditional Format as Cell Insert Delete Format Sort & Find & BEE * % " Formatting Table Styles Clear Filter ~ Select Font Alignment Number Styles Cells Editing Ideas Clipboard Chart 7 X V A B C D E F G H I J K L M N O P Format Trendline X 1 hgt wgt 140 174 65.6 Trendline Options 175.3 71.8 193.5 80.7 120 186.5 72.6 187.2 78.8 . O Polynomial Order 181.5 74.8 100 = 1.0176x - 105.01 .. RZ =0.5145....... 184 86.4 O Power CO 9 184.5 78.4 30 Moving 2 10 175 62 Period Average 11 184 81.6 Weight Trendline Name 12 180 76.6 13 177.8 83.6 O Automatic Linear (wgt) 14 192 90 Custom 15 176 74.6 40 Forecast 16 174 71 Forward 6.0 period 17 184 79.6 0.0 192.7 93.8 Backward period 18 20 19 171.5 70 Set Inter 0.0 20 173 72.4 Display Equation on chart 21 176 85.9 190 200 Display R-squared value on chart 22 176 78.8 140 150 160 170 180 22 190 5 770 Height ... 4-Hgt + Wgt 5-Hgt + Wgt Regression 6-Exercise 1 7-Exercise 2 + Tableau 2020.2 100% 3:12 PM Type here to search O R w X O A 7/5/2020 LJ