Total Access Statistics is the most powerful data analysis program for Microsoft Access. It runs as an Access add-in and offers a wide range of statistical functions to analyze your data.
Regression results can be output to a regression table and residual table. There is also an option to to store the estimated value in a field in the data table. However, there may be no fields listed in the combo box for Estimated Y Value. Why?
The data type for number hasa Field Size, so it’s not sufficient to just be a Number. The Output has to be a Double under field size. This is in the manual under “Assign Estimated Y to Field”:
"Simply specify the field where you'd like the result to be placed. The field should be a double and the data source must of course be updateable."
A double allows numbers with decimals. There are other field sizes like Integer and Long Integer which would not make sense for a regressions (these numbers won’t be integers).
See this example from the sample database that ships with the product. The Field Size is set in the pane at the bottom.
This should work with the sample scenario 7 called “Simple Regression with Assignment of Estimated Cholesterol”. The EstimatedValue field gets updated when the scenario is run.
Please sign in to leave a comment.