Math 113 - SPSS Projects

The following projects are designed to familiarize you with gathering data and then describing and analyzing it using SPSS.

Project I - Descriptive Statistics (30 points)

Retrieve some information from the Internet. I suggest using the special topics data available at the Inter-University Consortium for Political and Social Research (ICPSR) located at the University of Michigan. The URL for this site is http://www.icpsr.umich.edu/topical.html

There are five special topic areas available

Browse or do a search for areas of interest to your group.

There are many other surveys available on the ICPSR site, but many of them require a membership in the consortium to get access to the data and Richland is not a member.

Some of the data areas allow you to perform an analysis of the data. If possible, choose this because it allows you to select subsets of the data rather than downloading the entire file. There are often tens of thousands of cases with several hundred variables each in some of these surveys, so narrowing the data down makes it more handleable. At least one of your variables must be quantitative.

Make a subdirectory on the server named for your group as "\\acad1\stats\01\xxxx" where "xxxx" is the name you choose for your group. Save all of your files into this directory so that they can be accessed from different machines.

Once you have located the information that you wish to use and saved it to the file server, the instructor will help you get the information into SPSS.

Be sure to copy down the citation for the data you're using and include it with your output.

Descriptive Statistics

Produce the following output with SPSS. Annotate the output to include the bibliographic citation and any interesting information you found. Sample output is available.

Project II - Inferential Statistics (50 points)

Collect data on the price to get from one city to another. In each case, select the cheapest fare that meets the given conditions. You may depart at anytime on the indicated dates.

A blank template for you to enter your information into is on the file server as \\acad1\stats\01\blanktravel.sav. After you have entered your information into the template, save it under the name "travel#" where # is the number of your internet site. The instructor will go through and compile all the data into one master file called "travel" for you to use.

Airplane

1 Expedia - http://www.expedia.com/

2 Travelocity - http://www.travelocity.com/

3 Uniglobe - http://www.uniglobe.com/

Train

4 Amtrak - http://www.amtrak.com/

Bus

5 Greyhound - http://www.greyhound.com/

The following variables will be defined

site Internet site used to obtain information (numbered as above)

fare Cost of round trip (including taxes)

time Total time of round trip in hours

city1 Departure city (*=Multiple airport search)

1=Decatur (DEC), 2=Bloomington (BMI), 3=Champaign (CMI),
4=Springfield (SPI), 5=St. Louis (STL), 6=Chicago(CHI*)

city2 Destination city (*=Multiple airport search)

1=Houston (IAH), 2=Las Vegas (LAS), 3=Orlando (MCO),
4=Washington DC (WAS*), 5=Honolulu (HNL), 6=San Juan, Puerto Rico (SJU)

weekend Weekend travel (Fri, Sat, or Sun)?

1=Yes, 2=No

sat Stay over a Saturday?

1=Yes, 2=No

advance Time before departure

1=less than 14 days, 2=at least 14 days

mode Mode of transportation (calculated - you don't need to enter)

1=airplane, 2=train, 3=bus

Answer the following questions.

Q1 - Is the mean cost from Decatur different from the overall mean price? (7.4)

Select cases so that only air transport is selected (mode=1). Then find the mean fare of all flights. Then select cases so that only Decatur is chosen (mode=1 and city1=1). Compare the mean to the overall value using a one-sample t test. Be sure to select all cases when done.

Q2 - Is there a difference in the airline fares when a Saturday stay is included? (8.5)

Select cases so that only air transport is selected (mode=1). Then compare the fares using the independent samples t-test with sat as the grouping variable. Be sure to select all cases when done.

Q3 - Does booking your trip early save you money? (8.5)

Select all cases. Then compare the fares using the independent samples t-test with advance as the grouping variable.

Q4 - Is it cheaper to fly during the week than on the weekend? (8.5)

Select cases so that only air transport is selected (mode=1). Then compare the fares using the independent samples t-test with weekend as the grouping variable. Be sure to select all cases when done.

Q5 - Is there a linear relationship between the time of a trip and its fare? (9.3)

Select all cases. Perform linear regression with time as the independent variable and fare as the dependent variable.

Q6 - Is there a difference in the fares within the continental US by transportation type? (11.2)

Select cases so only those destinations in the continental US are selected (city2<=4). Compare the fares using a One-Way Analysis of Variance with mode as the factor variable. Be sure to select all cases when done.

Q7 - Is there a difference in the fares returned by the flight search engines? (11.2)

Select cases so that only air transport is selected (mode=1). Then compare the fares using a one-way ANOVA with site as the factor. Be sure to select all cases when done.

Evaluation

Project Evaluation (10 points)

As a group, comment on the entire project. Address questions like

This should be typed and only one document per group submitted.

Group Evaluation (10 points)

As an individual, evaluate each member of your group including yourself. Comment on how much they contributed to the group. Did they show up for all the meetings, did they participate when they showed up, did they pull their weight or did they not do anything.

In addition to a paragraph describing each person, assign them a score between 0 and 10 points for their effort in the group. Remember you are evaluating yourself, also.

* The score that you receive for this part of the project will be the mean scores given to you by each person in your group.

This may be handwritten and there should be one document per person.

Due Dates:

Jun 26 Descriptive Statistics (30 pts)

Jun 28 Data collected for Inferential Statistics (10 pts)

Jul 24 Inferential Statistics (40 pts)

Jul 24 Evaluations (20 pts)

Travel Worksheet

Internet Site : ______________________________

Depart: July 26

Return August 9

Weekend: no

Saturday: yes

Advance: > 14 days

Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago            

Depart: July 27

Return August 3

Weekend: yes

Saturday: yes

Advance: > 14 days

  Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago            

Depart: August 6

Return August 9

Weekend: no

Saturday: no

Advance: > 14 days

  Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago            

Depart: August 6

Return August 10

Weekend: yes

Saturday: no

Advance: > 14 days

  Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago            

Travel Worksheet

Internet Site : ______________________________

Depart: _____________ (this Thursday)

Return _____________ (two weeks later)

Weekend: no

Saturday: yes

Advance: < 14 days

  Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago            

Depart: _____________ (this Friday)

Return _____________ (next Friday)

Weekend: yes

Saturday: yes

Advance: < 14 days

  Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago            

Depart: _____________ (this Monday)

Return _____________ (this Thursday)

Weekend: no

Saturday: no

Advance: < 14 days

  Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago            

Depart: _____________ (this Monday)

Return _____________ (this Friday)

Weekend: yes

Saturday: no

Advance: < 14 days

  Houston Las Vegas Orlando Washington Honolulu San Juan
Decatur            
Bloomington            
Champaign            
Springfield            
St. Louis            
Chicago