marketing research excel homework about crosstabs

profiledaoeveysgao9
friendlymarket_ver_3.5.xlsm
Home>Business & Finance homework help>Marketing homework help>marketing research excel homework about crosstabs

Working

Category townsize 998
1 1
5 5
2 2
1 1
5 5
4 4
2 2
1 1
3 3
1 1
5 5
2 2
1 1
1 1
4 4
1 1
3 3
1 1
1 1
1 1
2 2
5 5
2 2
1 1
2 2
1 1
1 1
1 1
1 1
3 3
2 2
2 2
4 4
3 3
5 5
3 3
4 4
5 5
3 3
4 4
1 1
3 3
3 3
5 5
3 3
3 3
5 5
1 1
1 1
4 4
4 4
1 1
1 1
2 2
5 5
5 5
3 3
1 1
2 2
1 1
2 2
4 4
2 2
2 2
1 1
3 3
5 5
4 4
3 3
1 1
3 3
5 5
2 2
2 2
4 4
2 2
3 3
3 3
2 2
4 4
1 1
2 2
3 3
1 1
4 4
5 5
3 3
1 1
5 5
2 2
1 1
3 3
2 2
4 4
2 2
2 2
3 3
2 2
4 4
3 3
2 2
5 5
3 3
3 3
4 4
3 3
4 4
4 4
3 3
2 2
3 3
1 1
4 4
5 5
3 3
5 5
1 1
2 2
1 1
2 2
1 1
2 2
2 2
2 2
2 2
3 3
3 3
4 4
1 1
4 4
4 4
2 2
1 1
2 2
4 4
1 1
1 1
3 3
1 1
4 4
2 2
1 1
5 5
4 4
1 1
1 1
3 3
2 2
3 3
2 2
3 3
1 1
4 4
2 2
5 5
5 5
2 2
5 5
1 1
4 4
3 3
1 1
1 1
5 5
2 2
3 3
5 5
3 3
4 4
1 1
5 5
2 2
5 5
5 5
2 2
3 3
5 5
5 5
2 2
5 5
1 1
3 3
3 3
3 3
4 4
4 4
5 5
3 3
1 1
4 4
4 4
3 3
1 1
4 4
4 4
1 1
5 5
2 2
5 5
2 2
2 2
4 4
2 2
4 4
2 2
4 4
4 4
5 5
4 4
5 5
1 1
1 1
5 5
1 1
1 1
5 5
2 2
3 3
5 5
3 3
3 3
4 4
5 5
4 4
5 5
1 1
1 1
5 5
1 1
1 1
2 2
5 5
1 1
1 1
1 1
5 5
4 4
2 2
3 3
2 2
1 1
1 1
2 2
4 4
1 1
4 4
2 2
1 1
2 2
4 4
2 2
2 2
1 1
5 5
3 3
3 3
1 1
4 4
3 3
4 4
1 1
1 1
2 2
4 4
1 1
1 1
4 4
1 1
4 4
4 4
3 3
2 2
2 2
2 2
2 2
2 2
1 1
1 1
2 2
1 1
5 5
5 5
2 2
2 2
1 1
2 2
5 5
1 1
5 5
4 4
2 2
1 1
2 2
1 1
3 3
2 2
2 2
1 1
2 2
3 3
2 2
1 1
1 1
2 2
5 5
5 5
2 2
1 1
4 4
2 2
1 1
2 2
2 2
5 5
1 1
1 1
5 5
3 3
4 4
4 4
3 3
5 5
1 1
2 2
4 4
4 4
3 3
1 1
1 1
1 1
3 3
4 4
5 5
1 1
2 2
1 1
2 2
1 1
3 3
4 4
2 2
5 5
5 5
1 1
3 3
3 3
5 5
2 2
2 2
2 2
3 3
2 2
5 5
5 5
5 5
2 2
2 2
2 2
2 2
3 3
2 2
4 4
2 2
1 1
2 2
1 1
2 2
4 4
4 4
2 2
4 4
5 5
5 5
3 3
5 5
2 2
5 5
5 5
3 3
4 4
3 3
5 5
5 5
2 2
5 5
3 3
1 1
3 3
2 2
3 3
5 5
3 3
5 5
2 2
2 2
4 4
5 5
1 1
1 1
5 5
2 2
1 1
5 5
1 1
3 3
4 4
5 5
1 1
1 1
2 2
2 2
5 5
3 3
1 1
3 3
1 1
5 5
2 2
1 1
1 1
2 2
4 4
1 1
4 4
2 2
1 1
3 3
2 2
1 1
1 1
2 2
3 3
4 4
4 4
4 4
4 4
5 5
3 3
3 3
4 4
5 5
4 4
3 3
4 4
3 3
3 3
1 1
4 4
2 2
4 4
4 4
4 4
3 3
5 5
3 3
1 1
2 2
1 1
2 2
1 1
2 2
5 5
5 5
4 4
2 2
1 1
5 5
3 3
4 4
4 4
5 5
2 2
5 5
1 1
1 1
4 4
2 2
2 2
5 5
3 3
1 1
3 3
1 1
5 5
4 4
1 1
3 3
4 4
4 4
3 3
2 2
4 4
2 2
4 4
4 4
2 2
4 4
3 3
2 2
4 4
5 5
2 2
1 1
1 1
3 3
5 5
1 1
1 1
4 4
3 3
1 1
1 1
1 1
3 3
1 1
2 2
1 1
3 3
2 2
2 2
5 5
4 4
4 4
3 3
2 2
2 2
3 3
3 3
4 4
2 2
1 1
2 2
4 4
5 5
1 1
2 2
1 1
1 1
2 2
1 1
1 1
4 4
2 2
3 3
5 5
4 4
4 4
3 3
2 2
1 1
2 2
1 1
3 3
4 4
4 4
1 1
2 2
4 4
3 3
5 5
1 1
3 3
2 2
3 3
2 2
5 5
3 3
1 1
1 1
5 5
1 1
1 1
5 5
5 5
1 1
5 5
3 3
4 4
2 2
4 4
5 5
1 1
2 2
5 5
3 3
1 1
3 3
1 1
5 5
4 4
2 2
1 1
2 2
3 3
5 5
1 1
3 3
4 4
2 2
3 3
5 5
5 5
4 4
3 3
5 5
3 3
1 1
4 4
4 4
5 5
1 1
5 5
1 1
4 4
1 1
1 1
1 1
1 1
2 2
3 3
3 3
3 3
1 1
3 3
2 2
4 4
5 5
3 3
3 3
2 2
1 1
1 1
2 2
4 4
5 5
4 4
1 1
2 2
2 2
1 1
5 5
2 2
4 4
5 5
5 5
4 4
3 3
1 1
2 2
5 5
2 2
5 5
3 3
4 4
1 1
1 1
5 5
2 2
1 1
5 5
4 4
1 1
2 2
1 1
3 3
4 4
3 3
4 4
5 5
2 2
2 2
1 1
3 3
1 1
3 3
5 5
1 1
3 3
2 2
3 3
2 2
2 2
2 2
5 5
3 3
5 5
2 2
3 3
1 1
4 4
1 1
4 4
5 5
3 3
5 5
1 1
2 2
3 3
4 4
3 3
2 2
1 1
4 4
4 4
4 4
2 2
5 5
3 3
5 5
1 1
1 1
3 3
3 3
1 1
3 3
1 1
1 1
1 1
3 3
2 2
3 3
2 2
2 2
2 2
3 3
2 2
2 2
4 4
1 1
1 1
1 1
4 4
4 4
1 1
2 2
5 5
2 2
2 2
2 2
5 5
3 3
1 1
4 4
1 1
1 1
3 3
2 2
2 2
4 4
5 5
1 1
1 1
3 3
4 4
1 1
4 4
1 1
4 4
1 1
4 4
2 2
5 5
1 1
1 1
3 3
1 1
2 2
2 2
1 1
3 3
5 5
3 3
4 4
1 1
4 4
1 1
4 4
4 4
5 5
5 5
1 1
3 3
5 5
4 4
5 5
1 1
5 5
5 5
1 1
3 3
5 5
4 4
3 3
4 4
1 1
1 1
4 4
5 5
3 3
1 1
2 2
2 2
4 4
1 1
4 4
1 1
4 4
3 3
3 3
1 1
4 4
4 4
1 1
2 2
2 2
3 3
1 1
5 5
1 1
1 1
1 1
1 1
4 4
5 5
5 5
3 3
1 1
2 2
1 1
1 1
1 1
1 1
2 2
3 3
1 1
1 1
1 1
2 2
2 2
1 1
1 1
4 4
2 2
1 1
4 4
4 4
2 2
4 4
4 4
5 5
2 2
4 4
2 2
3 3
4 4
1 1
4 4
1 1
3 3
2 2
1 1
4 4
5 5
1 1
1 1
4 4
4 4
1 1
2 2
2 2
4 4
4 4
1 1
5 5
1 1
1 1
2 2
1 1
2 2
4 4
1 1
2 2
2 2
3 3
5 5
2 2
1 1
3 3
3 3
2 2
1 1
4 4
5 5
2 2
5 5
5 5
5 5
5 5
3 3
4 4
4 4
1 1
2 2
1 1
2 2
1 1
1 1
2 2
1 1
4 4
3 3
4 4
5 5
1 1
1 1
3 3
3 3
2 2
2 2
1 1
2 2
1 1
2 2
1 1
3 3
1 1
3 3
1 1
4 4
4 4
1 1
5 5
4 4
4 4
1 1
4 4
2 2
3 3
2 2
3 3
3 3
4 4
1 1
1 1
3 3
3 3
2 2
3 3
4 4
2 2
1 1
1 1
3 3
2 2
2 2
4 4
1 1
2 2
1 1
3 3
1 1
2 2
1 1
4 4
2 2
1 1
2 2
2 2
1 1
2 2
5 5
5 5
2 2
2 2
3 3
1 1
4 4
2 2
3 3
1 1
2 2
3 3
2 2
2 2
3 3
3 3
1 1
2 2
3 3
1 1
3 3
5 5
2 2
5 5
2 2
4 4
3 3
1 1

Data

FRIENDLY CIRCLEK COMMUTE BARGAIN CASH QUICK KNOWME HURRY DWELL GENDER WORK
1 1 1 3 2 2 3 2 1 2 2
0 1 3 2 2 1 1 1 2 3
1 0 1 3 2 2 3 2 1 1 1
1 0 0 3 3 2 3 1 2 1 2
1 1 1 3 3 3 3 2 2 2 1
1 1 1 2 2 3 2 1 2 2 1
0 0 1 2 2 2 2 1 1 1 1
1 0 3 2 2 3 3 1 2 3
0 1 1 3 3 1 1 1 2 2 2
1 0 0 3 2 2 3 1 2 1 1
1 1 1 3 1 2 3 1 2 2 2
1 0 0 3 2 2 2 3 1 2 1
1 1 1 3 3 2 3 1 2 1 1
1 1 1 3 2 3 3 2 2 2 1
0 1 3 2 2 2 1 2 1 3
0 1 1 3 2 2 2 2 1 2 1
1 1 3 3 2 3 1 2 1 3
0 1 1 3 1 1 1 1 2 2 2
0 0 0 3 2 2 1 3 2 1 2
1 1 1 3 1 2 3 2 2 2 1
0 1 1 3 3 1 2 1 1 2 1
1 0 1 3 1 2 3 1 2 2 2
0 1 1 3 2 3 1 2 1 1 1
1 1 1 3 3 2 3 1 2 1 1
1 1 1 2 1 3 2 3 2 2 1
1 0 3 3 3 3 2 2 2 3
1 0 0 3 1 2 3 1 2 2 1
1 1 1 2 2 2 3 2 2 2 2
1 0 0 3 1 2 3 1 2 2 2
1 0 3 3 2 3 2 2 2 3
1 1 1 3 1 2 3 3 2 2 2
0 0 0 3 1 2 2 2 1 2 1
1 0 1 3 2 3 3 2 2 2 1
1 1 1 3 2 3 3 1 2 1 2
1 1 1 3 2 2 3 3 2 2 1
0 1 1 3 2 2 1 2 2 1 2
0 1 2 2 2 2 1 1 2 3
1 0 1 3 1 3 3 1 2 2 1
0 1 1 3 2 2 1 1 2 2 1
1 1 1 3 1 2 3 1 2 1 1
0 1 1 3 3 2 3 2 2 1 2
1 1 1 3 1 3 2 2 2 2 1
1 1 1 3 1 2 3 2 2 2 1
1 1 1 2 2 2 2 1 2 2 1
1 1 1 3 2 2 3 3 2 2 1
1 1 3 2 2 3 2 2 2 3
0 1 1 3 2 2 2 1 1 1 1
1 1 1 3 2 3 3 3 2 1 2
1 0 0 1 3 2 2 2 2 2 1
1 0 1 1 1 2 3 1 2 2 1
1 0 1 3 2 2 3 2 1 1 1
0 0 0 2 1 3 2 1 2 2 2
1 1 1 3 2 2 3 2 2 2 1
0 1 1 3 1 3 1 2 1 1 1
0 1 3 1 3 3 1 2 1 3
1 1 1 2 1 2 2 2 2 2 2
1 0 0 2 2 2 3 2 2 2 1
1 1 1 3 2 1 3 2 2 2 1
1 1 1 3 1 2 3 1 2 2 1
1 1 1 3 3 2 2 3 2 1 2
1 0 3 2 2 3 1 2 1 3
1 1 1 3 2 2 3 1 2 2 1
1 1 3 2 2 3 2 2 2 3
0 1 1 2 2 2 2 2 1 2 1
0 1 1 3 2 2 1 2 2 1 1
0 0 0 3 1 2 3 1 1 2 2
0 1 1 2 2 2 1 1 1 1 1
1 1 1 3 2 3 3 1 2 1 1
0 1 3 2 1 3 1 2 2 3
0 1 1 3 2 2 3 1 2 2 2
0 1 1 3 2 2 1 1 1 1 1
0 1 3 3 1 2 2 1 1 3
0 1 1 3 2 3 3 2 2 1 1
0 1 1 3 2 1 2 2 2 2 1
0 1 1 3 2 2 2 2 1 1 2
0 0 1 2 2 2 1 2 2 1 1
0 1 1 3 2 1 3 1 2 2 1
0 0 3 2 2 1 2 1 1 3
0 1 1 2 2 2 1 2 2 1 2
0 1 1 3 3 1 1 2 1 1 2
0 1 1 2 2 2 3 2 2 1 2
0 1 1 3 1 2 1 2 2 1 1
0 1 3 2 2 2 2 2 2 3
0 1 1 3 2 3 3 1 1 1 1
0 1 1 3 3 1 1 3 2 1 1
1 0 0 3 2 2 3 1 2 2 1
1 0 3 2 2 3 2 2 1 3
0 1 1 2 3 2 1 2 1 2 1
0 1 1 3 3 3 2 1 2 2 1
0 1 1 3 2 3 2 2 2 2 2
1 1 0 3 2 2 3 2 2 1 2
0 0 0 3 2 3 1 1 2 2 2
0 1 0 3 2 2 2 1 2 1 1
0 1 1 3 2 3 2 2 2 1 1
0 1 1 3 2 3 1 1 2 2 1
0 0 3 2 2 2 1 2 1 3
0 1 1 3 2 2 1 1 2 1 1
1 1 1 3 2 2 3 1 2 2 1
0 1 1 3 2 2 1 2 2 1 2
0 1 1 3 3 1 2 2 2 2 2
0 1 1 3 2 2 1 2 2 2 1
0 0 3 2 2 1 2 2 1 3
0 1 3 3 2 2 1 2 2 3
0 1 1 3 2 2 1 1 2 1 1
1 1 0 2 3 1 3 2 2 2 1
0 1 1 3 2 2 3 1 2 1 1
0 1 1 2 1 2 2 2 2 2 1
0 1 0 2 2 3 1 3 2 2 1
0 1 1 3 2 2 1 2 2 2 1
0 1 1 3 2 2 3 1 1 1 2
1 1 0 3 3 3 3 2 2 1 1
1 0 0 2 3 1 2 1 2 2 1
0 1 0 3 2 2 3 1 2 1 2
1 1 1 2 1 1 3 2 2 2 1
0 1 1 3 2 2 3 1 2 1 1
1 1 1 2 2 2 3 2 2 1 1
1 1 2 2 2 2 1 2 1 3
1 0 0 2 3 1 2 2 2 1 1
1 1 1 2 2 2 3 1 2 1 1
1 1 2 3 2 1 2 2 1 3
0 1 1 1 2 3 2 3 2 1 2
1 0 1 3 3 2 3 1 2 2 2
1 1 1 2 2 3 2 3 2 1 2
1 1 3 2 2 3 1 2 2 3
1 0 0 3 2 3 3 2 2 2 1
0 1 1 3 2 2 2 1 2 2 1
0 0 1 3 2 1 2 2 2 2 2
1 0 3 2 3 3 2 2 2 3
0 1 1 3 2 3 2 2 2 2 2
0 1 1 3 2 3 1 2 2 2 1
0 1 3 2 2 3 2 1 1 3
0 1 1 3 2 3 1 2 2 1 1
0 0 3 2 2 1 2 2 2 3
1 1 1 2 1 2 2 2 2 1 1
0 1 1 3 2 2 1 1 2 2 2
0 1 1 3 2 2 3 1 2 2 2
0 1 1 2 3 2 1 2 2 2 1
1 1 1 3 2 3 3 2 2 1 1
0 1 1 3 3 1 2 1 2 1 1
1 1 1 3 2 2 3 2 2 2 2
0 1 1 3 2 2 1 2 2 1 2
0 1 1 3 2 3 1 1 2 1 1
1 1 1 3 2 3 3 2 2 2 1
0 0 1 2 2 3 1 2 2 1 2
1 1 2 3 3 3 2 2 2 3
1 0 0 1 2 3 2 2 2 2 2
1 1 1 2 2 2 2 2 2 2 2
0 1 1 3 2 2 2 2 2 1 1
0 1 1 2 1 2 2 2 2 2 1
0 1 1 3 2 3 1 1 2 2 1
0 1 1 3 2 3 3 1 2 2 1
0 1 1 3 3 3 1 1 1 1 1
0 1 3 3 2 1 2 1 1 3
0 1 1 3 2 3 3 1 2 1 1
0 1 1 3 3 2 1 2 2 1 2
0 1 2 2 2 3 1 2 1 3
0 1 0 3 3 1 1 1 1 2 1
0 1 1 2 3 1 1 2 2 1 2
0 1 3 3 1 1 3 2 1 3
0 1 1 2 2 2 1 2 2 1 2
1 0 0 3 3 2 1 1 2 1 1
0 1 1 3 3 3 2 2 2 1 1

Define Variables

Variable Label
alburns: Variable Labels - Copy labels from Row 1 of your Data Worksheet. Place your cursor in cell B1 of this worksheet and Paste Special-Paste Link to link Define Variables information to the Data set. 		FRIENDLY CIRCLEK COMMUTE BARGAIN CASH QUICK KNOWME HURRY DWELL GENDER WORK
Description
alburns: Description - Type or Paste in a long Description under each Variable Label. 		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
alburns: Value Codes - Type in your value code numbers, separated by commas in the cells under the Variable Descriptions. 		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
alburns: Value Labels - Type in the labels associated with your value codes, in order and separated by commas in the cells under the value codes. 		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
FRIENDLY CIRCLEK COMMUTE BARGAIN CASH QUICK KNOWME HURRY DWELL GENDER WORK

PieTemp

Percentages Analysis Results
title of graph
Category Frequency Percent
Category 1 100 10.0%
Category 2 432 43.2%
Category 3 210 21.0%
Category 4 258 25.8%
Total 1000 100.0%
Category 1 Category 2 Category 3 Category 4 0.1 0.432 0.21 0.25800000000000001

CylinderTemp

Percentages Analysis Results
Title of graph
Category Frequency Percent
Category 1 100 10.0%
Category 2 432 43.2%
Category 3 210 21.0%
Category 4 258 25.8%
Total 1000 100.0%
Category 1 Category 2 Category 3 Category 4 0.1 0.432 0.21 0.25800000000000001