Hello,

I have real data from 2000-2016 for variables W, X, Y, and Z of the following equation:

W = a + b*X + c*Y + d*Z

I am using Solver to fit the real data to the equation and estimate the constants a, b, c, and d.

Since the Changing Variable Cells in the Solver are constants a, b, c, and d, every time that the Solver gives me new values for the constants I want to see some statistics for the new values like standard error, p-values, and t-statistics (like the results brought by Regression). I checked its Report option, but none of them gives me the statistics for the new values. How can I calculate and have access to the changing statistics, or ask Solver to bring me automatically?

Regards,