Assignment #1: Open the Friendly Market File. How many survey respondents

(data files) are in this data set? Determine the number of people who shop at Circle K regularly? In your answer include the formula you used to determine the answer to this question

Variable Label

townsize

gender

marital

reside

agecat

edcat

jobcat

inccat

hometype

vehiclevalue

vehicletype

commutecat

global1

global2

global3

gasoline1

gasoline2

gasoline3

prices1

prices2

prices3

verysmall1

verysmall2

verysmall3

small1

small2

small3

hybrid1

hybrid2

hybrid3

verysmallprob

smallprob

hybridprob

syntheticprob

electricprob

cyclepref

commuterpref

commuter2pref

economypref

standardpref

lifestyle1

lifestyle2

lifestyle3

lifestyle4

lifestyle5

lifestyle6

television

radio

magazines

newspaper

Description

Size of home town or city

Gender

Marital status

Number of people in household

Age category

Level of education

Job category

Income category

Dwelling type

Primary vehicle price type

Primary vehicle type

Type of commuting

I am worried about global warming.

Global warming is a real threat.

We need to do something to slow global warming.

Gasoline emissions contribute to global warming.

Americans use too much gasoline.

We should be looking for gasoline substitutes.

Gasoline prices will remain high in the future.

Gasoline prices are too high now.

High gasoline prices will impact what type of autos are purchased.

Very small autos with very high mpg's will reduce fuel emissions.

Very small autos with very high mpg's will keep gas prices stable.

Very small autos with very high mpg's will slow down global warming.

Small autos with high mpg's will reduce fuel emissions.

Small autos with high mpg's will keep gas prices stable.

Small autos with high mpg's will slow down global warming.

Hybrid autos that use alternative fuels will reduce fuel emissions.

Hybrid autos that use alternative fuels will keep gas prices down.

Hybrid autos that use alternative fuels will slow down global warming.

Probability of buying a very small (1 seat) hybrid auto within 3 years

Probability of buying a small (2 seat) hybrid auto within 3 years

Probability of buying a standard size hybrid auto within 3 years

Probability of buying a standard size synthetic fuel auto within 3 years

Probability of buying a standard size electric auto within 3 years

Preference: Super Cycle 1 seat hybrid

Preference: Runabout Sport 2 seat hybrid

Preference: Runabout with Luggage 2 seat hybrid

Preference: Economy 4 seat hybrid

Preference: Standard 4 seat hybrid

Life Style: Novelist

Life Style: Innovator

Life Style: Trendsetter

Life Style: Forerunner

Life Style: Mainstreamer

Life Style: Classic

Favorite television show type

Favorite radio genre

Favorite magazine type

Favorite local newspaper section

Value Codes

1,2,3,4,5

0,1

0,1

1,2,3,4,5,6,9

1,2,3,4,5

1,2,3,4,5,6,9

1,2,3,4,5

1,2,3,4

0,1,2,3

0,1,2,3

1,2,3,4,5

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,10

1,10

1,10

1,10

1,10

1,10

1,2,3,4,5,6,7

1,2,3,4,5,6

1,2,3,4,5,6,7,8

1,2,3,4,5,6

Value Labels

Under 10K,10K to 100K,100K to 500K,500K to 1 million,1 million and more

Male,Female

Unmarried,Married

Less than 18,18 to 24,25 to 34,35 to 49,50 to 64,65 and older,No response

Less than High School,High School diploma,Some college,College Degree,Post graduate degee

Management,Sales,Service,Agriculture,Craft,General labor,Retired

Under $25K,$25K to 49K,$50K to 74K,75K to 125K,$125K and more

Single family,Multiple family,Condominium/Townhouse,Mobile home

No vehicle,Economy,Standard,Luxury

No vehicle,Car,Pick-up truck,SUV or van

Single occupancy,Multiple occupancy,Public transportation,Non-motorized,Telecommute

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Comedy,Drama,Movies/Mini-Series,News/Documentary,Reality,Science-Fiction,Sports

Classic Pop & Rock,Country,Easy listening,Jazz & Blues,Pop & Chart,Talk

Business & Money,Music & Entertainment,Family & Parenting,Sports & Outdoors,Home & Garden,Cooking-Food & Wine,Trucks-Cars & Motorcycles,News-Politics & Current Events

Editorial,Business,Local news,National news,Sports,Entertainment

To set up your data... (Note: if you have a csv file, 1-3 is accomplished with Utilities-Import Data)

1. Copy Labels from Row 1 of your Data worksheet.

2. Place your cursor in cell B1 of the Define Variables worksheet.

3. Paste Special-Paste Link to link your Variables information to the Data worksheet

Then,

4. Type in Descriptions. They can be as long as you wish.

5. Type in Value Codes separated by commas

Variable Label	FRIENDLY	CIRCLEK	COMMUTE	BARGAIN	CASH	QUICK	KNOWME	HURRY	DWELL	GENDER	WORK
Description	Do you use Friendly Market regularly	Do you use Circle K regularly?	Do you pass by Friendly Market/Circle K corner to/from work?	I often shop for bargains.	I always pay cash.	I like quick, easy shopping.	I shop where they know my name.	I am always in a hurry.	Where do you live?	What is your gender?	What is your work status?
Value Codes	0,1	0,1	0,1	1,2,3	1,2,3	1,2,3	1,2,3	1,2,3	1,2	1,2	1,2,3
Value Labels	No,Yes	No,Yes	No,Yes	Disagree,Neutral,Agree	Disagree,Neutral,Agree	Disagree,Neutral,Agree	Disagree,Neutral,Agree	Disagree,Neutral,Agree	Own home,Rent	Male,Female	Full-time,Part-time,Retired/Do Not Work
	To set up your data... (Note: if you have a csv file, 1-3 is accomplished with Utilities-Import Data)
	1. Copy Labels from Row 1 of your Data worksheet.
	2. Place your cursor in cell B1 of the Define Variables worksheet.
	3. Paste Special-Paste Link to link your Variables information to the Data worksheet
	Then,
	4. Type in Descriptions. They can be as long as you wish.
	5. Type in Value Codes separated by commas
	6. Type in Value Labels separated by commas
	7. Use Utilities-Clean-up to check your Value Code-Value Labels work

Variable Label

townsize

gender

marital

reside

agecat

edcat

jobcat

inccat

hometype

vehiclevalue

vehicletype

commutecat

global1

global2

global3

gasoline1

gasoline2

gasoline3

prices1

prices2

prices3

verysmall1

verysmall2

verysmall3

small1

small2

small3

hybrid1

hybrid2

hybrid3

verysmallprob

smallprob

hybridprob

syntheticprob

electricprob

cyclepref

commuterpref

commuter2pref

economypref

standardpref

lifestyle1

lifestyle2

lifestyle3

lifestyle4

lifestyle5

lifestyle6

television

radio

magazines

newspaper

Description

Size of home town or city

Gender

Marital status

Number of people in household

Age category

Level of education

Job category

Income category

Dwelling type

Primary vehicle price type

Primary vehicle type

Type of commuting

I am worried about global warming.

Global warming is a real threat.

We need to do something to slow global warming.

Gasoline emissions contribute to global warming.

Americans use too much gasoline.

We should be looking for gasoline substitutes.

Gasoline prices will remain high in the future.

Gasoline prices are too high now.

High gasoline prices will impact what type of autos are purchased.

Very small autos with very high mpg's will reduce fuel emissions.

Very small autos with very high mpg's will keep gas prices stable.

Very small autos with very high mpg's will slow down global warming.

Small autos with high mpg's will reduce fuel emissions.

Small autos with high mpg's will keep gas prices stable.

Small autos with high mpg's will slow down global warming.

Hybrid autos that use alternative fuels will reduce fuel emissions.

Hybrid autos that use alternative fuels will keep gas prices down.

Hybrid autos that use alternative fuels will slow down global warming.

Probability of buying a very small (1 seat) hybrid auto within 3 years

Probability of buying a small (2 seat) hybrid auto within 3 years

Probability of buying a standard size hybrid auto within 3 years

Probability of buying a standard size synthetic fuel auto within 3 years

Probability of buying a standard size electric auto within 3 years

Preference: Super Cycle 1 seat hybrid

Preference: Runabout Sport 2 seat hybrid

Preference: Runabout with Luggage 2 seat hybrid

Preference: Economy 4 seat hybrid

Preference: Standard 4 seat hybrid

Life Style: Novelist

Life Style: Innovator

Life Style: Trendsetter

Life Style: Forerunner

Life Style: Mainstreamer

Life Style: Classic

Favorite television show type

Favorite radio genre

Favorite magazine type

Favorite local newspaper section

Value Codes

1,2,3,4,5

0,1

0,1

1,2,3,4,5,6,9

1,2,3,4,5

1,2,3,4,5,6,9

1,2,3,4,5

1,2,3,4

0,1,2,3

0,1,2,3

1,2,3,4,5

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,10

1,10

1,10

1,10

1,10

1,10

1,2,3,4,5,6,7

1,2,3,4,5,6

1,2,3,4,5,6,7,8

1,2,3,4,5,6

Value Labels

Under 10K,10K to 100K,100K to 500K,500K to 1 million,1 million and more

Male,Female

Unmarried,Married

Less than 18,18 to 24,25 to 34,35 to 49,50 to 64,65 and older,No response

Less than High School,High School diploma,Some college,College Degree,Post graduate degee

Management,Sales,Service,Agriculture,Craft,General labor,Retired

Under $25K,$25K to 49K,$50K to 74K,75K to 125K,$125K and more

Single family,Multiple family,Condominium/Townhouse,Mobile home

No vehicle,Economy,Standard,Luxury

No vehicle,Car,Pick-up truck,SUV or van

Single occupancy,Multiple occupancy,Public transportation,Non-motorized,Telecommute

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very strongly disagree,Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree,Very strongly agree

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Very undesirable,Undesirable,Somewhat desirable,Neutral,Somewhat desirable,Desirable,Very desirable

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Does not describe me at all,Describes me perfectly

Comedy,Drama,Movies/Mini-Series,News/Documentary,Reality,Science-Fiction,Sports

Classic Pop & Rock,Country,Easy listening,Jazz & Blues,Pop & Chart,Talk

Business & Money,Music & Entertainment,Family & Parenting,Sports & Outdoors,Home & Garden,Cooking-Food & Wine,Trucks-Cars & Motorcycles,News-Politics & Current Events

Editorial,Business,Local news,National news,Sports,Entertainment

To set up your data... (Note: if you have a csv file, 1-3 is accomplished with Utilities-Import Data)

1. Copy Labels from Row 1 of your Data worksheet.

2. Place your cursor in cell B1 of the Define Variables worksheet.

3. Paste Special-Paste Link to link your Variables information to the Data worksheet

Then,