I notice that the R squared statistical value is different in Excel than in Grapher with a fit curve that goes through the origin. Can this be explained?
According to a variety of statistical sources, R squared cannot be calculated in the same manner when a through origin fit is selected. Excel uses the same equation regardless of whether the fit curve is forced through the origin. This results in a different R squared value in Excel. This value can occasionally be negative, so using the same equation is not a good idea when forcing a curve through the origin. Grapher uses an equation specifically designed for a through origin fit that takes into account the issues of how the line is centered. Refer to Grapher’s online help for the exact equation used in both cases.
Related Questions
- When I received my "Change of Assessment" notice, it had the Fair Market Value, the Taxable Value, and the Gross Assessed Value. What do these different values mean?
- I notice that the R squared statistical value is different in Excel than in Grapher with a fit curve that goes through the origin. Can this be explained?
- Where can I see a list of all the Data Curve Fit Creator functions in Excel?
