dunlop407703
New Member
- Joined
- Oct 8, 2014
- Messages
- 24
I have a data set of x and y values, my aim is to come up with a formula which I can use to input an x value to give me the expected y value.
When I plot my data on a scatter chart, using a 3rd order polynomial trend line I get an r-squared value of 0.8402. When I use LINEST to get an r-squared value for the exact same data set I get an r-squared value of 0.7207.
Also, when I use the same x value in both the equation generated from the chart, and from LINEST I get different results. On this comparison using x=1.4, my chart formula returns y=12.1912, but my LINEST returns y=11.76757.
I'm curious to know why I am getting different results, and ultimately which is more accurate. In the past I would just have used the chart equation but I am working with a dynamic data set and I'm not aware of a way to have the chart update as I enter new data, and also to pull the regression equation out of the chart without manually typing it.
I'd really appreciate any insight or help.
When I plot my data on a scatter chart, using a 3rd order polynomial trend line I get an r-squared value of 0.8402. When I use LINEST to get an r-squared value for the exact same data set I get an r-squared value of 0.7207.
Also, when I use the same x value in both the equation generated from the chart, and from LINEST I get different results. On this comparison using x=1.4, my chart formula returns y=12.1912, but my LINEST returns y=11.76757.
I'm curious to know why I am getting different results, and ultimately which is more accurate. In the past I would just have used the chart equation but I am working with a dynamic data set and I'm not aware of a way to have the chart update as I enter new data, and also to pull the regression equation out of the chart without manually typing it.
I'd really appreciate any insight or help.