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).
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.
- If you check that box, the first row of the data you selected in the boxes above is ignored. So if you select B2:B9 and check the box the regression tool ignores cell B2, but that is OK since it is the label. On the other hand, if you select B3:B9, checking the box makes the tool use cells B4:B9 to calculate the regression because the checked box tells it to ignore row 3.