statistics question

copy_of_data_set_2.xlsx

Price

Price willing to be paid for shoes endorsed by professional female athlete: Current median price $50
New York					Los Angeles
107	57	70	84		81	113	139	55	144	71
77	70	133	66		119	54	139	112	148	125
89	65	93	62		79	79	81	130	85	72
105	74	51	71		57	104	108	122	128	55
102	102	105	99		106	67	50	107	54	88
99	146	150	145		82	150	53	74	75
116	118	69	84		106	136	147	135	68
72	110	92	137		111	80	60	122	138
142	66	112	117		149	144	54	61	100
122	88	125	62		142	141	66	118	126
Sample Mean
98.5684210526			Test Statistic:					98.6-80		18.6
Standard Deviation			0.062				˭	30.6 95	˭	298.25	˭	0.062
30.6204119904
#7 What is the age of the person the shoes are being purchased for?
New York	18	19	20	18	34	22	51	29	42		18	19	36
	47	24	25	26	25	24	27	21	18		19	23	31
	32	24	28	16	46	51	26	35	14		19	21	36
	28
LA	21	22	21	16	18	19	23	24	26		31	32	15
	33	35	26	27	24	31	32	25	26		41	39	22
	32	19	18	17	21	32	23	26	25		24	24	25
	34	25	26	29	24	32	35	31	19		17
	Mean		Standard Deviation			Test Statistic				26.5-25		1.5
	26.4939759036		8.0491985573			0.019			˭	8.05 95	˭	78.46	˭	0.019

Age of person for which shoes are being purchased
New York				Los Angeles
18	18	18	16	21	25	24	35	22	44
19	19	17	46	15	21	21	24	24	27
20	47	19	51	33	26	24	25	18	33
18	24	23	26	22	18	19	26	31	52
34	25	31	35	32	26	31	31	41	54
22	26	32	15	25	16	32	26	24
51	25	36	18	34	27	32	26	17
29	24	38	19	22	17	23	25	32
42	27	24	21	35	29	32	19	39
38	21	28	62	19	18	23	27	24