![]() ![]() I chose the high polynomial just because the trendline was smoother. I've got inputs from 1 to 220ish, and the output should be from 2 to ~45. ![]() I'm just trying to smooth the data perhaps there is a better way. I'm interpolating - and no, the data does not extend to those values. ![]() I have no clue what could be causing this problem. It starts going negative at 70, even though none of my outputs are ever negative (the smallest is 1.9). The formula actually works for the first 30 or so numbers, but then it gets WAY off. I used this formula to get the specific coefficients:Īnd hit CTRL+SHIFT+ENTER to get the array, and the coefficients match what the formula says when I check the "show formula" box in Excel. So far, so good.īut the equation that the formula spits out doesn't work when I try to get the actual numbers (I need to know what the best fit output is for 24 and 45 and 78, etc.). It turns out the R^2 was higher using the polynomial trendline rather than the logarithmic one, and upping the exponent to 6 made for the tightest line/smoothest data. So I graphed the data using the scatter plot and added a trendline. The dropoff should not be linear, and should be either logarithmic or polynomial. 1 should yield a higher output than 2, 2 than 3, and so on. I'd like to smooth the data, as there should be a general decline. In column A, I have 220 rows of data going 1, 2, 3, 4, etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |