An exponential curve fit from Microsoft Excel might not match the exponential curve fit from Spotfire's Lines & Curves feature.
Article ID: KB0079653
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All supported versions |
| Spotfire Web Player | All supported versions |
Description
An exponential curve fit from Microsoft Excel might not match the exponential curve fit from Spotfire's Lines & Curves feature.
Issue/Introduction
An exponential curve fit from Microsoft Excel might not match the exponential curve fit from Spotfire's Lines & Curves feature.
Environment
All supported environments
Resolution
The reason for the difference, when it happens, is that the exponential curve fit in Spotfire's Lines & Curves feature uses nonlinear least squares regression on the original data, and the exponential curve fit in Excel uses linear regression on log-transformed data.
Spotfire is using the direct approach that produces the best fit, and Excel is using an acceptable alternative that produces a "good enough" fit in most cases.
Spotfire is using the direct approach that produces the best fit, and Excel is using an acceptable alternative that produces a "good enough" fit in most cases.
Feedback
Yes
No
Powered by
