![]() 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 Trendline chart and equation Moving average Excel TREND function The Excel TREND function is used to calculate a linear trend line through a given set of dependent y-values and, optionally, a set of independent x-values and return values along the trend line. ![]() ![]() However, when I tried to use the original x data to calculate y using the trendline equation, it doesn't appear right. The "known_x" values are in green in A3:C22 Excel trendline looks fine but the equation is completely wrong I used excel to fit a curve to some data points (x,y). If you change the values in E3:E22, the trend() function will update Cell E24 for your new input at Cell A24.Įdit = Note: You cannot display trendline equations for a moving average. 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 To display the trendline equation on the chart, select the Display Equation on chart check box. Column C is X^3 (two cells to the left cubed). Column B is X^2 (the cell to the left squared). The discrepancy is due to the rounding precision of the coefficients and only comes about when one tries to calculate future values manually using the equation. ![]() Try trend(known_y's, known_x's, new_x's, const).Ĭolumn A below is X. 1 Answer Sorted by: 2 This is due to the way Excel calculates the coefficients for an nth order Polynomial Trendline and the precision used in coming up with the coefficients.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |