Case study stats

TwosamplepopulationtestbetweenLAandSD_a290bebcf0d013761a0aaff7b1a9ba61.xlsx

Sheet1

Two cities - San Diego and Los Angeles are bidding for the National Health Institute
to come to the respective cities to build a new hospital equip to handle the most
current health issues on the plannet.
San Diego is claiming the following advantages				Los Angeles is claiming the following advantages
	Mean	Standard Deviation	Sample Size	Mean	Standard Deviation	Sample Size
Cost of constructing the facility:	750	20	36	800	15	49
Cost of living	500 / wk	25/week	49	650	15/week	36
Educational Achievements of children	85	15	25	80	20	16
Potential cost of building a house for employees	425 (in thousands)	25	64	460	30	49
Crime rate	25 per week	5	49	35 per week	10	36
Pick a line item to compare San Diego vs Los Angeles. (just one eight step hypothesis test)
Conduct a two sample population Hypothesis test between the two cities for the respective item
to determine which city is better than the other.
Use level of significanc alfa = 0.01
Use the appropriate z or t test respectively
Provide your conclusion and your recommendations.