A7

Assignment7.xlsx

Sheet1

Please type your answers in the yellow boxes.					2.	(7 points) The percentage of the public with diabetes is about μ=11.5%. 30 counties in Minnesota reported their diabetes findings.
						Construct a two-tailed test to determine whether or not diabetes is more or less prevalent in Minnesota than it is throughout the rest of the country.
1.	(8 points) The following data is a compilation of assaults rates (per 100,000 people) in the Mankato area over the past 30 years.					Don’t forget to choose an appropriate α level.
	ERROR:#NAME?
	over the past 30 years are significantly lower than the national average for that time frame. Don’t forget to choose an appropriate α level.
						County #	Diabetes rate %		Type Answers in the Spaces Below
			NAME:			1	13.2	H0:
						2	13.3	H1:
	Year	Assault rate		Type Answers in the Spaces Below		3	15.8	N:
	1990	91	H0:			4	10.1	Mu:
	1991	84	H1:			5	15.2	Sample Average:
	1992	90	N:			6	14.4	Sample Variance:
	1993	82	Mu:			7	12.6	Sample Standard Deviation:
	1994	91	Sample Average:			8	11	Level of Confidence:
	1995	88	Sample Variance:			9	12.8	Alpha Level:
	1996	99	Sample Standard Deviation:			10	12.8	Z:
	1997	83	Level of Confidence:			11	15.1	Z-Alpha:
	1998	108	Alpha Level:			12	12.7	Reject H0? (Yes or no):
	1999	91	Z:			13	14	Interpretation:
	2000	104	Z-Alpha:			14	11.9
	2001	90	Reject H0? (Yes or no):			15	11.6		Save your file with the answers and upload it
	2002	96	Interpretation:			16	13.8
	2003	88				17	14.5
	2004	90		Scroll to the right for Question 2 ---->		18	13.5
	2005	92				19	15.6		to the "Assignment 7" D2L Assignment Dropbox.
	2006	80				20	14.2
	2007	82				21	15.6
	2008	91				22	13
	2009	90				23	13.6
	2010	102				24	12.9
	2011	78				25	14.8
	2012	91				26	14.8
	2013	97				27	15
	2014	92				28	12.5
	2015	88				29	12
	2016	85				30	11.1
	2017	95
	2018	88
	2019	90