SPSS DATA INTERPRETATION 1

profilejaybird
spss_project_av.docx

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