Forum Discussion

tewksbam's avatar
tewksbam
Copper Contributor
Apr 21, 2022
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 any issue, so it is something on my end. I've tried redownloading Excel, using a different version, and contacting support and no one has answers. I know I am running it correctly because when I try on another computer, I am able to. The data is also not corrupted because I have retyped it. Does anyone know why this is happening? I do use a Mac but other Mac users have not had this issue. If I need to reinstall ToolPack, how would I do so?

  • 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).

6 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Can you provide us with an example workbook and indicate what results you think are wrong please?
    • tewksbam's avatar
      tewksbam
      Copper Contributor

      see highlighted on RESIDUAL OUTCOME and equation next to line

      • tewksbam's avatar
        tewksbam
        Copper Contributor
        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

Resources