Forum Discussion
Solved
Data Regression Analysis Using ToolPack
Hello, I keep trying to run data regression, but the ToolPack produces incorrect results. This also occurs when I use Analytic Solver. When I send others the file, they are able to run it without an...
- If you uncheck that "Labels" box, you should get the exact same results as I do. With that box checked, you are excluding the first data point (14, 95).
Can you provide us with an example workbook and indicate what results you think are wrong please?
see highlighted on RESIDUAL OUTCOME and equation next to line
- If you were to run the same test, you would get different answers. The equation to the line should be something similar to y=16.6351+5.7098x
- If you uncheck that "Labels" box, you should get the exact same results as I do. With that box checked, you are excluding the first data point (14, 95).
- OH MY GOSH THAT WORKED!!! Do you know why that is? On other computers it doesn't seem to matter whether the box is checked or not.