Data Set WORK.GRAPE1
Obs | store | sales1 | sales2 | sales3 |
---|---|---|---|---|
1 | 1 | 62.1 | 61.3 | 60.8 |
2 | 2 | 58.2 | 57.9 | 55.1 |
3 | 3 | 51.6 | 49.2 | 46.2 |
4 | 4 | 53.7 | 51.5 | 48.3 |
5 | 5 | 61.4 | 58.7 | 56.6 |
6 | 6 | 58.5 | 57.2 | 54.3 |
7 | 7 | 46.8 | 43.2 | 41.5 |
8 | 8 | 51.2 | 49.8 | 47.9 |
Obs | store | sales1 | sales2 | sales3 |
---|---|---|---|---|
1 | 1 | 62.1 | 61.3 | 60.8 |
2 | 2 | 58.2 | 57.9 | 55.1 |
3 | 3 | 51.6 | 49.2 | 46.2 |
4 | 4 | 53.7 | 51.5 | 48.3 |
5 | 5 | 61.4 | 58.7 | 56.6 |
6 | 6 | 58.5 | 57.2 | 54.3 |
7 | 7 | 46.8 | 43.2 | 41.5 |
8 | 8 | 51.2 | 49.8 | 47.9 |
Obs | store | sales1 | sales2 | sales3 | price | sales |
---|---|---|---|---|---|---|
1 | 1 | 62.1 | 61.3 | 60.8 | 1 | 62.1 |
2 | 1 | 62.1 | 61.3 | 60.8 | 2 | 61.3 |
3 | 1 | 62.1 | 61.3 | 60.8 | 3 | 60.8 |
4 | 2 | 58.2 | 57.9 | 55.1 | 1 | 58.2 |
5 | 2 | 58.2 | 57.9 | 55.1 | 2 | 57.9 |
6 | 2 | 58.2 | 57.9 | 55.1 | 3 | 55.1 |
7 | 3 | 51.6 | 49.2 | 46.2 | 1 | 51.6 |
8 | 3 | 51.6 | 49.2 | 46.2 | 2 | 49.2 |
9 | 3 | 51.6 | 49.2 | 46.2 | 3 | 46.2 |
10 | 4 | 53.7 | 51.5 | 48.3 | 1 | 53.7 |
11 | 4 | 53.7 | 51.5 | 48.3 | 2 | 51.5 |
12 | 4 | 53.7 | 51.5 | 48.3 | 3 | 48.3 |
13 | 5 | 61.4 | 58.7 | 56.6 | 1 | 61.4 |
14 | 5 | 61.4 | 58.7 | 56.6 | 2 | 58.7 |
15 | 5 | 61.4 | 58.7 | 56.6 | 3 | 56.6 |
16 | 6 | 58.5 | 57.2 | 54.3 | 1 | 58.5 |
17 | 6 | 58.5 | 57.2 | 54.3 | 2 | 57.2 |
18 | 6 | 58.5 | 57.2 | 54.3 | 3 | 54.3 |
19 | 7 | 46.8 | 43.2 | 41.5 | 1 | 46.8 |
20 | 7 | 46.8 | 43.2 | 41.5 | 2 | 43.2 |
21 | 7 | 46.8 | 43.2 | 41.5 | 3 | 41.5 |
22 | 8 | 51.2 | 49.8 | 47.9 | 1 | 51.2 |
23 | 8 | 51.2 | 49.8 | 47.9 | 2 | 49.8 |
24 | 8 | 51.2 | 49.8 | 47.9 | 3 | 47.9 |
Obs | store | price | sales |
---|---|---|---|
1 | 1 | 1 | 62.1 |
2 | 1 | 2 | 61.3 |
3 | 1 | 3 | 60.8 |
4 | 2 | 1 | 58.2 |
5 | 2 | 2 | 57.9 |
6 | 2 | 3 | 55.1 |
7 | 3 | 1 | 51.6 |
8 | 3 | 2 | 49.2 |
9 | 3 | 3 | 46.2 |
10 | 4 | 1 | 53.7 |
11 | 4 | 2 | 51.5 |
12 | 4 | 3 | 48.3 |
13 | 5 | 1 | 61.4 |
14 | 5 | 2 | 58.7 |
15 | 5 | 3 | 56.6 |
16 | 6 | 1 | 58.5 |
17 | 6 | 2 | 57.2 |
18 | 6 | 3 | 54.3 |
19 | 7 | 1 | 46.8 |
20 | 7 | 2 | 43.2 |
21 | 7 | 3 | 41.5 |
22 | 8 | 1 | 51.2 |
23 | 8 | 2 | 49.8 |
24 | 8 | 3 | 47.9 |
The GLM Procedure
Class Level Information | ||
---|---|---|
Class | Levels | Values |
price | 3 | 1 2 3 |
Number of Observations Read | 24 |
---|---|
Number of Observations Used | 24 |
The GLM Procedure
Dependent Variable: sales
Source | DF | Sum of Squares | Mean Square | F Value | Pr > F |
---|---|---|---|---|---|
Model | 2 | 67.4808333 | 33.7404167 | 0.94 | 0.4069 |
Error | 21 | 754.7575000 | 35.9408333 | ||
Corrected Total | 23 | 822.2383333 |
R-Square | Coeff Var | Root MSE | sales Mean |
---|---|---|---|
0.082070 | 11.21447 | 5.995067 | 53.45833 |
Source | DF | Type I SS | Mean Square | F Value | Pr > F |
---|---|---|---|---|---|
price | 2 | 67.48083333 | 33.74041667 | 0.94 | 0.4069 |
Source | DF | Type III SS | Mean Square | F Value | Pr > F |
---|---|---|---|---|---|
price | 2 | 67.48083333 | 33.74041667 | 0.94 | 0.4069 |
The GLM Procedure
Least Squares Means
Adjustment for Multiple Comparisons: Bonferroni
price | sales LSMEAN | LSMEAN Number |
---|---|---|
1 | 55.4375000 | 1 |
2 | 53.6000000 | 2 |
3 | 51.3375000 | 3 |
Least Squares Means for Effect price t for H0: LSMean(i)=LSMean(j) / Pr > |t| Dependent Variable: sales |
|||
---|---|---|---|
i/j | 1 | 2 | 3 |
1 |
|
0.613004
1.0000
|
1.367791
0.5575
|
2 |
-0.613
1.0000
|
|
0.754787
1.0000
|
3 |
-1.36779
0.5575
|
-0.75479
1.0000
|
|
The Mixed Procedure
Model Information | |
---|---|
Data Set | WORK.GRAPE3 |
Dependent Variable | sales |
Covariance Structure | Unstructured |
Subject Effect | store |
Estimation Method | REML |
Residual Variance Method | None |
Fixed Effects SE Method | Model-Based |
Degrees of Freedom Method | Between-Within |
Class Level Information | ||
---|---|---|
Class | Levels | Values |
price | 3 | 1 2 3 |
Dimensions | |
---|---|
Covariance Parameters | 6 |
Columns in X | 4 |
Columns in Z | 0 |
Subjects | 8 |
Max Obs per Subject | 3 |
Number of Observations | |
---|---|
Number of Observations Read | 24 |
Number of Observations Used | 24 |
Number of Observations Not Used | 0 |
Iteration History | |||
---|---|---|---|
Iteration | Evaluations | -2 Res Log Like | Criterion |
0 | 1 | 141.05309845 | |
1 | 1 | 86.03317486 | 0.00000000 |
Convergence criteria met. |
Estimated R Matrix for Subject 1 | |||
---|---|---|---|
Row | Col1 | Col2 | Col3 |
1 | 29.6084 | 33.0114 | 34.0598 |
2 | 33.0114 | 37.5886 | 38.7000 |
3 | 34.0598 | 38.7000 | 40.6255 |
Covariance Parameter Estimates | ||
---|---|---|
Cov Parm | Subject | Estimate |
UN(1,1) | store | 29.6084 |
UN(2,1) | store | 33.0114 |
UN(2,2) | store | 37.5886 |
UN(3,1) | store | 34.0598 |
UN(3,2) | store | 38.7000 |
UN(3,3) | store | 40.6255 |
Fit Statistics | |
---|---|
-2 Res Log Likelihood | 86.0 |
AIC (Smaller is Better) | 98.0 |
AICC (Smaller is Better) | 104.0 |
BIC (Smaller is Better) | 98.5 |
Null Model Likelihood Ratio Test | ||
---|---|---|
DF | Chi-Square | Pr > ChiSq |
5 | 55.02 | <.0001 |
Type 3 Tests of Fixed Effects | ||||
---|---|---|---|---|
Effect | Num DF | Den DF | F Value | Pr > F |
price | 2 | 7 | 34.60 | 0.0002 |
Least Squares Means | ||||||
---|---|---|---|---|---|---|
Effect | price | Estimate | Standard Error |
DF | t Value | Pr > |t| |
price | 1 | 55.4375 | 1.9238 | 7 | 28.82 | <.0001 |
price | 2 | 53.6000 | 2.1676 | 7 | 24.73 | <.0001 |
price | 3 | 51.3375 | 2.2535 | 7 | 22.78 | <.0001 |
Differences of Least Squares Means | |||||||||
---|---|---|---|---|---|---|---|---|---|
Effect | price | _price | Estimate | Standard Error |
DF | t Value | Pr > |t| | Adjustment | Adj P |
price | 1 | 2 | 1.8375 | 0.3831 | 7 | 4.80 | 0.0020 | Bonferroni | 0.0059 |
price | 1 | 3 | 4.1000 | 0.5141 | 7 | 7.98 | <.0001 | Bonferroni | 0.0003 |
price | 2 | 3 | 2.2625 | 0.3190 | 7 | 7.09 | 0.0002 | Bonferroni | 0.0006 |
The Mixed Procedure
Model Information | |
---|---|
Data Set | WORK.GRAPE3 |
Dependent Variable | sales |
Covariance Structure | Compound Symmetry |
Subject Effect | store |
Estimation Method | REML |
Residual Variance Method | Profile |
Fixed Effects SE Method | Model-Based |
Degrees of Freedom Method | Between-Within |
Class Level Information | ||
---|---|---|
Class | Levels | Values |
price | 3 | 1 2 3 |
Dimensions | |
---|---|
Covariance Parameters | 2 |
Columns in X | 4 |
Columns in Z | 0 |
Subjects | 8 |
Max Obs per Subject | 3 |
Number of Observations | |
---|---|
Number of Observations Read | 24 |
Number of Observations Used | 24 |
Number of Observations Not Used | 0 |
Iteration History | |||
---|---|---|---|
Iteration | Evaluations | -2 Res Log Like | Criterion |
0 | 1 | 141.05309845 | |
1 | 1 | 93.18551859 | 0.00000000 |
Convergence criteria met. |
Estimated R Matrix for Subject 1 | |||
---|---|---|---|
Row | Col1 | Col2 | Col3 |
1 | 35.9408 | 35.2571 | 35.2571 |
2 | 35.2571 | 35.9408 | 35.2571 |
3 | 35.2571 | 35.2571 | 35.9408 |
Covariance Parameter Estimates | ||
---|---|---|
Cov Parm | Subject | Estimate |
CS | store | 35.2571 |
Residual | 0.6838 |
Fit Statistics | |
---|---|
-2 Res Log Likelihood | 93.2 |
AIC (Smaller is Better) | 97.2 |
AICC (Smaller is Better) | 97.9 |
BIC (Smaller is Better) | 97.3 |
Null Model Likelihood Ratio Test | ||
---|---|---|
DF | Chi-Square | Pr > ChiSq |
1 | 47.87 | <.0001 |
Type 3 Tests of Fixed Effects | ||||
---|---|---|---|---|
Effect | Num DF | Den DF | F Value | Pr > F |
price | 2 | 14 | 49.35 | <.0001 |
Contrasts | ||||
---|---|---|---|---|
Label | Num DF | Den DF | F Value | Pr > F |
1vs2 | 1 | 14 | 19.75 | 0.0006 |
1vs3 | 1 | 14 | 98.34 | <.0001 |
2vs3 | 1 | 14 | 29.95 | <.0001 |