Project for Midzuno the Whiz

graphs_for_paper.xlsx

Intro Data to discuss Gender

PLEASE MAKE PIE CHART

Statistics

PLEASE MAKE A TABLE TO SHOW DATA FOR NIGHTLIFE AND SHOPPING BETWEEN FOR THE TWO DIFFERENT AGE GROUPS-
DO you Feel that France has shopping opportunities? *agecat Crosstabulation					DO you Feel that France has nightlife opportunities? *agecat Crosstabulation
			agecat					agecat
			18-21 years old					18-21 years old
				22-30					22-30
	Agree	Count % within agecat	45	27		Agree	Count % within agecat	53	19
			28.5%	30.0%				33.5%	21.1%
	Strongly Agree	Count % within agecat	100	56		Strongly Agree	Count % within agecat	89	58
			63.3%	62.2%				56.3%	64.4%
Total		Count % within agecat	145	83	Total		Count % within agecat	142	77
			91.8%	92.2%				89.8%	85.5%
DO you Feel that Spain has shopping opportunities? *agecat Crosstabulation					DO you Feel that Spain has nightlife opportunities? *agecat Crosstabulation
			agecat					agecat
			18-21 years old					18-21 years old
				22-30					22-30
	Agree	Count % within agecat	66	38		Agree	Count % within agecat	43	16
			41.8%	42.2%				27.2%	17.8%
	Strongly Agree	Count % within agecat	64	34		Strongly Agree	Count % within agecat	93	64
			40.5%	37.8%				58.9%	71.1%
Total		Count % within agecat	130	72	Total		Count % within agecat	136	80
			82.3%	80.0%				86.1%	88.9%
DO you Feel that UK has shopping opportunities? *agecat Crosstabulation					DO you Feel that UK has nightlife opportunities? *agecat Crosstabulation
			agecat					agecat
			18-21 years old					18-21 years old
				22-30					22-30
	Agree	Count % within agecat	58	35		Agree	Count % within agecat	39	21
			36.7%	38.9%				24.7%	23.3%
	Strongly Agree	Count % within agecat	68	41		Strongly Agree	Count % within agecat	89	55
			43.0%	45.6%				56.3%	61.1%
Total		Count % within agecat	126	76	Total		Count % within agecat	128	76
			79.7%	84.5%				81.0%	91.1%

PLEASE MAKE A TABLE TO SHOW COMBINED DATA COMPARING DIFFERENT AGE GROUPS
DO you Feel that France is Luxury? *agecat Crosstabulation
			agecat
			18-21 years old
				22-30
	Agree	Count % within agecat	41	26
			25.9%	28.9%
	Strongly Agree	Count % within agecat	100	49
			63.3%	54.4%
Total		Count % within agecat	141	75
			89.2%	83.3%
DO you Feel that Spain is Luxury? *agecat Crosstabulation
			agecat
			18-21 years old
				22-30
	Agree	Count % within agecat	50	36
			31.6%	40.0%
	Strongly Agree	Count % within agecat	63	32
			39.9%	35.6%
Total		Count % within agecat	113	68
			71.5%	75.6%
DO you Feel that UK is Luxury? *agecat Crosstabulation
			agecat
			18-21 years old
				22-30
	Agree	Count % within agecat	58	33
			36.7%	36.7%
	Strongly Agree	Count % within agecat	55	28
			34.8%	31.1%
Total		Count % within agecat	113	61
			71.5%	67.8%

How likely are you going to visit France this or next year? *agecat Crosstabulation
			agecat
			18-21 years old
				22-30	Total
How likely to	Unlikely	Count % within agecat	104	51	155
are you going			65.8%	56.7%	62.5%
visit France this	Little Likely	Count % within agecat	16	17	33
or next year?			10.1%	18.9%	13.3%
	Neurtal	Count % within agecat	17	13	30
			10.8%	14.4%	12.1%
	Likely	Count % within agecat	8	2	10
			5.1%	2.2%	4.0%
	Very Likely	Count % within agecat	13	7	20
			8.2%	7.8%	8.1%
Total		Count % within agecat	158	90	248
			100.0%	100.0%	100.0%
ONLY FOCUS ON THE NUMBERS FOR LIKELY AND VERY LIKELY					PLEASE MAKE GRAPH
How likely are you going to visit Spain this or next year? *agecat Crosstabulation
			agecat
			18-21 years old
				22-30	Total
How likely to	Unlikely	Count % within agecat	102	54	156
are you going			64.6%	60.0%	62.9%
visit Spain this	Little Likely	Count % within agecat	18	13	31
or next year?			11.4%	14.4%	12.5%
	Neurtal	Count % within agecat	17	14	31
			10.8%	15.6%	12.5%
	Likely	Count % within agecat	8	2	10
			5.1%	2.2%	4.0%
	Very Likely	Count % within agecat	13	7	20
			8.2%	7.8%	8.1%
Total		Count % within agecat	158	90	248
			100.0%	100.0%	100.0%
How likely are you going to visit the UK this or next year? *agecat Crosstabulation
			agecat
			18-21 years old
				22-30	Total
How likely to	Unlikely	Count % within agecat	100	52	152
are you going			63.3%	57.8%	61.3%
visit the UK this	Little Likely	Count % within agecat	15	17	32
or next year?			9.5%	18.9%	12.9%
	Neurtal	Count % within agecat	13	8	21
			8.2%	8.9%	8.5%
	Likely	Count % within agecat	16	4	20
			10.1%	4.4%	8.1%
	Very Likely	Count % within agecat	14	9	23
			8.9%	10.0%	9.3%
Total		Count % within agecat	158	90	248
			100.0%	100.0%	100.0%