| Duplicating Excel NORMDIST Results in PROC MIXED |
| Model Information | |
|---|---|
| Data Set | WORK.NORMAL_DATA |
| Dependent Variable | Normal_Y |
| Covariance Structure | Diagonal |
| Estimation Method | ML |
| Residual Variance Method | Profile |
| Fixed Effects SE Method | Model-Based |
| Degrees of Freedom Method | Residual |
| Dimensions | |
|---|---|
| Covariance Parameters | 1 |
| Columns in X | 1 |
| Columns in Z | 0 |
| Subjects | 1 |
| Max Obs Per Subject | 10 |
| Number of Observations | |
|---|---|
| Number of Observations Read | 10 |
| Number of Observations Used | 10 |
| Number of Observations Not Used | 0 |
| Covariance Parameter Estimates | ||||
|---|---|---|---|---|
| Cov Parm | Estimate | Standard Error | Z Value | Pr > Z |
| Residual | 6.2064 | 2.7756 | 2.24 | 0.0127 |
| Fit Statistics | |
|---|---|
| -2 Log Likelihood | 46.6 |
| AIC (smaller is better) | 50.6 |
| AICC (smaller is better) | 52.3 |
| BIC (smaller is better) | 51.2 |
| Solution for Fixed Effects | |||||
|---|---|---|---|---|---|
| Effect | Estimate | Standard Error | DF | t Value | Pr > |t| |
| Intercept | 5.2400 | 0.7878 | 9 | 6.65 | <.0001 |