After the Wizard completes its work, you should see the freshly imported and formatted workbook below.
Most of the new formatting is common to all models. You can review this by clicking here. On this page we will introduce formatting explicitly for factor models and walk through an interpretation of model results.
Notice that in column H all of the values have been turned boldface and colored blue. All R2 values above the arbitrary cutoff value of 0.2 are formatted in this way.
Although no examples exist here, any p-value greater than the cutoff 0.05 is displayed in boldface red. You can see this as an exercise if you over-type one of the entries in column G with a value larger than 0.05.
With color-coding in columns B and E, the interpretation of the two classes is straightforward. DFactor1 loads principally on joint pain, swelling and stiffness, whereas DFactor2 loads mostly on back and neck pain. Clicking on the Model9 ProbMeans sheet and examining it reveals this pattern.
A look at the charts on the Model 9 Profile sheet confirms this observation.
The charts give a visually richer interpretation of the data, allowing you to examine level detail.
By default, cluster models include a table of bivariate residuals, which the Format Wizard imports into its own sheet, like the one in the following image.
The Wizard adds conditional formatting to all the numerical cells in the sheet. If any bivariate residual exceeds the cutoff value in cell I1, the residual value will turn boldface red. In this example no bivariate residual exceeds 3.84, so no red cells appear. Just to illustrate the capability, we arbitrarily change the cutoff value to 1. The worksheet reveals one bivariate residual that exceeds this amount.
That concludes our tutorial on formatting D-factor model output. Click on one of these links to see tutorials on cluster models, regression models and choice models.