398 Statistical Methods
The unstacked data are shown in Figure 10-5.Figure 10-5
The unstacked
dataSTATPLUS TIPS
You can use the StatPlus’ Stack Columns to stack a series of
columns. The resulting data set will contain two columns: a
column of data values and a column containing the category
labels.Now you can perform the analysis of variance on the price data.To perform the analysis of variance:1 Click Data Analysis from the Analysis group on the Data tab, then
click Anova: Single Factor in the Analysis Tools list box, and then
click OK.
2 Type A1:D9 in the Input Range text box, and verify that the Grouped
By Columns option button is selected.
3 Click the Labels in First Row checkbox to select it.
4 Click the New Worksheet Ply option button and type Price ANOVA
in the corresponding text box. Your dialog box should look like
Figure 10-6.