Now put the formula in the spreadsheet to solve for Y with any value of X Or perhaps this is clearer: y = -0.0013X^3 + 0.3459X^2 - 30.891X + 953.82Īnd the R-squared value is equal to 1 (My understanding is R squared of 1 means the data matches the trendline perfectly with the formula shown) The trendline is added and the equation for the trendline appears: TrendlineType - select Polynomial, Order value is 3.Ĭlick on the "Options" tab & check "Display equation on chart" & "Display R-squared value on chart" Right click a data point in the chart & Select "Add Trendline" Highlight cells A2:B5, select Insert>Chart (or use toolbar Chart button)Ĭhart Type: XY (Scatter), click Finish (or Next, Next, Next) Open the attachment and/or replicate the problem: I am using Excel 2003 but the same thing happened under a newer version (my son's Excel 2010, and apparently 2012) He also showed it to his professor (not sure what one) and (quote from email) "she was able to replicate the exact same problem we were having, and had no idea what was happening." This problem has stumped me (no surprise) & stumped my son (surprise, he is finishing his last year as a business major & has good experience with Excel). Excel calculated Polynomial formula does not match data, why?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |