SPSS DATA INTERPRETATION 1
SPSS Data Interpretation Alcohol Volume
A between-group one-way analysis of variance (ANOVA) compares the mean values of more than two groups. In this assignment, you will review the SPSS output for an ANOVA and use it to answer questions about the means of the groups.
Directions:
Review the SPSS output file, which reports the results of the between-group (independent group) one-way ANOVA to see if the mean alcohol by volume (%) of the beer differs as a function of quality of the brand as rated by a beer expert (in 2012). Answer the following questions based on your observations of the SPSS output file:
1. Looking at the descriptives (first information), do you see differences in the mean alcohol contents for the three levels of quality? Explain.
1. Looking at the Test for Homogeneity of Variances (Levene Statistic), is it reasonable to proceed with the ANOVA? Is the assumption met, or violated? How do you know?
1. Looking at the results of the ANOVA, is there a significant difference in the mean alcohol content for beers in the three quality groups? How do you know? Write the results in the following format: F(df value) = ___, p value = ______.
1. The pairwise post hoc tests indicate which quality groups' means are statistically significantly different for the others. Using the results of the Tukey HSD post hoc test, what two quality rating groups had significantly different mean alcohol by volume levels? How do you know?
SPSS Data Set Legend (Attachment “A”)
Information has been gathered on 35 brands of wheat beer. Qualitative (categorical) information has been given codes. Information that is in numerical form (e.g., $ amount) does not need to be coded.
Here are all the types of information gathered on these beers:
1. Product name (abbreviation of product’s brand name)
2. Product ID code
a. Codes: Each brand is given a numerical ID, with 1 being the first one to 35 for the last one
3. Rating assigned to the product by a taste expert for each brand
a. Codes: 1 = Very good
2 = Good
3 = Fair
4. Recommended by leading beer connoisseur magazine?
a. Codes: 0 = no
1 = yes
5. Country of origin for each brand:
a. Codes: 1 = USA
2 = Canada
3 = France
4 = Holland
5 = Mexico
6 = Germany
7 = Japan
6. Availability in the USA for each brand
a. Codes: 1 = National
2 = Regional
7. Price per 6-pack for each brand (values are in US Dollars)
8. Cost per 12 fluid ounces for each brand (values are in US Dollars)
9. Calories per 12 fluid ounces
10. Sodium per 12 fluid ounces for each brand (values are in milligrams, mg)
11. Alcohol by volume for each brand (values are percents, %)
12. Price class for each brand
a. Codes: 0 = Not classified
1 = Super premium
2 = Premium
3 = Popular
13. Regular or reduced calorie for each brand
a. Codes: 0 = Regular
1 = Reduced calorie
14. Number of US states in which brand was sold in 2008.
15. Number of US states in which brand was sold in 2012.
Data Interpretation (Attachment “B”)
ONEWAY alcohol BY rating
/STATISTICS DESCRIPTIVES HOMOGENEITY
/PLOT MEANS
/MISSING ANALYSIS
/POSTHOC=TUKEY ALPHA(0.05).
One-way
|
Notes |
||
|
Output Created |
07-JUN-2013 12:39:57 |
|
|
Comments |
|
|
|
Input |
Data |
C:\Users\donn\Documents\GCU Lead fac\Project with Judy for modifying PSY845 to introduce SPSS\drinks database -revised for course applications DH.sav |
|
|
Active Dataset |
DataSet1 |
|
|
File Label |
SPSS/PC+ |
|
|
Filter |
<none> |
|
|
Weight |
<none> |
|
|
Split File |
<none> |
|
|
N of Rows in Working Data File |
35 |
|
Missing Value Handling |
Definition of Missing |
User-defined missing values are treated as missing. |
|
|
Cases Used |
Statistics for each analysis are based on cases with no missing data for any variable in the analysis. |
|
Syntax |
ONEWAY alcohol BY rating /STATISTICS DESCRIPTIVES HOMOGENEITY /PLOT MEANS /MISSING ANALYSIS /POSTHOC=TUKEY ALPHA(0.05). |
|
|
Resources |
Processor Time |
00:00:00.33 |
|
|
Elapsed Time |
00:00:00.42 |
[DataSet1] C:\Users\donn\Documents\GCU Lead fac\Project -revised for course applications DH.sav
|
Descriptives |
||||||
|
Alcohol by Volume (in %) for brand |
||||||
|
|
N |
Mean |
Std. Deviation |
Std. Error |
95% Confidence Interval for Mean |
|
|
|
|
|
|
|
Lower Bound |
Upper Bound |
|
VeryGood |
11 |
4.9000 |
.17889 |
.05394 |
4.7798 |
5.0202 |
|
Good |
14 |
4.6000 |
.38829 |
.10377 |
4.3758 |
4.8242 |
|
Fair |
10 |
4.5100 |
.34140 |
.10796 |
4.2658 |
4.7542 |
|
Total |
35 |
4.6686 |
.35295 |
.05966 |
4.5473 |
4.7898 |
|
Descriptives |
||
|
Alcohol by Volume (in %) for brand |
||
|
|
Minimum |
Maximum |
|
|
|
|
|
VeryGood |
4.70 |
5.20 |
|
Good |
4.00 |
5.50 |
|
Fair |
3.90 |
5.00 |
|
Total |
3.90 |
5.50 |
|
Test of Homogeneity of Variances |
|||
|
Alcohol by Volume (in %) for brand |
|||
|
Levene Statistic |
df1 |
df2 |
Sig. |
|
1.420 |
2 |
32 |
.256 |
|
ANOVA |
|||||
|
Alcohol by Volume (in %) for brand |
|||||
|
|
Sum of Squares |
df |
Mean Square |
F |
Sig. |
|
Between Groups |
.906 |
2 |
.453 |
4.357 |
.021 |
|
Within Groups |
3.329 |
32 |
.104 |
|
|
|
Total |
4.235 |
34 |
|
|
|
Post Hoc Tests
|
Multiple Comparisons |
||||
|
Dependent Variable: Alcohol by Volume (in %) for brand |
||||
|
Tukey HSD |
||||
|
(I) Rated Quality of Brand |
(J) Rated Quality of Brand |
Mean Difference (I-J) |
Std. Error |
Sig. |
|
|
|
|
|
|
|
VeryGood |
Good |
.30000 |
.12995 |
.069 |
|
|
Fair |
.39000* |
.14093 |
.025 |
|
Good |
VeryGood |
-.30000 |
.12995 |
.069 |
|
|
Fair |
.09000 |
.13354 |
.780 |
|
Fair |
VeryGood |
-.39000* |
.14093 |
.025 |
|
|
Good |
-.09000 |
.13354 |
.780 |
|
Multiple Comparisons |
|||
|
Dependent Variable: Alcohol by Volume (in %) for brand |
|||
|
Tukey HSD |
|||
|
(I) Rated Quality of Brand |
(J) Rated Quality of Brand |
95% Confidence Interval |
|
|
|
|
Lower Bound |
Upper Bound |
|
VeryGood |
Good |
-.0193 |
.6193 |
|
|
Fair |
.0437* |
.7363 |
|
Good |
VeryGood |
-.6193 |
.0193 |
|
|
Fair |
-.2382 |
.4182 |
|
Fair |
VeryGood |
-.7363* |
-.0437 |
|
|
Good |
-.4182 |
.2382 |
|
*. The mean difference is significant at the 0.05 level. |
Homogeneous Subsets
|
Alcohol by Volume (in %) for brand |
|||
|
Tukey HSDa,b |
|||
|
Rated Quality of Brand |
N |
Subset for alpha = 0.05 |
|
|
|
|
1 |
2 |
|
Fair |
10 |
4.5100 |
|
|
Good |
14 |
4.6000 |
4.6000 |
|
VeryGood |
11 |
|
4.9000 |
|
Sig. |
|
.784 |
.082 |
|
Means for groups in homogeneous subsets are displayed. |
|
a. Uses Harmonic Mean Sample Size = 11.436. |
|
b. The group sizes are unequal. The harmonic mean of the group sizes is used. Type I error levels are not guaranteed. |
MEANS PLOT