SPSS DATA INTERPRETATION

· Review the SPSS output file that reports the results of the related samples t-test to compare the number of U.S. states where each brand was sold in 2008 with the number of U.S. states where those same brands were sold in 2012. For each brand, there is one value for the number of states in 2008 and another value for the number of states in 2012, making this a repeated measure. Answer the following questions based on your observations of the SPSS output file:

· What was the mean number of U.S. states in which all of the beer brands were sold in 2008?

· What was the mean number of U.S. states in which all of the beer brands were sold in 2012?

· Was there a significant difference in the number of states in which these beer brands were sold in 2008 versus 2012? Report the results of the t-test as follows: t(df value) = ___, and p-value.

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”)

DATASET ACTIVATE DataSet1.

SAVE OUTFILE='C:\Users\donn\Documents\Project'+

'introduce SPSS\drinks database -revised for course applications DH.sav'

/COMPRESSED.

T-TEST PAIRS=States2008 WITH States2012 (PAIRED)

/CRITERIA=CI(.9500)

/MISSING=ANALYSIS.

T-Test

[DataSet1] C:\Users\donn\Documents\Project to introduce SPSS\drinks database -revised for course applications DH.sav