The 'new_x' values are in cells A24:C24, where B24 and C24 are the formulas as shown. The 'known_y' values are in green in E3:E22 To display the trendline equation on the chart, select the. The 'known_x' values are in green in A3:C22 On the Layout tab, in the Analysis group, click Trendline, and then click More Trendline Options. If you change the values in E3:E22, the trend() function will update Cell E24 for your new input at Cell A24.Įdit = The trend() formula is in Cell E24 where the cell references are shown in red.Ĭell A24 contains the new X, and is the cell to change to update the formula in E24Ĭell B24 contains the X^2 formula (A24*A24) for the new XĬell C24 contains the X^3 formula (A24*A24*A24) for the new X You can go from raw data to having the slope and intercept of a best-fit line in 6 clicks (in Excel. Add the equation to the trendline and you have everything you need. Column C is X^3 (two cells to the left cubed). When you need to get a quick and dirty linear equation fit to a set of data, the best way is to simply create an XY-chart (or Scatter Chart) and throw in a quick trendline. Column B is X^2 (the cell to the left squared). The TREND function returns values along a linear trend. Try trend(known_y's, known_x's, new_x's, const).Ĭolumn A below is X. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 More.

Excel how to get equation of trendline