Excel spreadsheet

FinalExam.xlsx

Instructions

Final Exam for POL 221

Please type in the answers to all of the questions in the highlighted cells.

Let me know if you have any questions.

Due: Wednesday, May 5th, by 9:00 pm in the D2L Assignment Dropbox.

Each problem is on a separate Excel sheet. Look down at the bottom left of the page to find the sheets.

Be sure to complete all 4 problems. 40 points total.

Name:

Problem 1 (10 points total)
A new automatic door system was installed at the Mankato Justice Center. The manufacturer of the new door system says that it can be expected that the system will
average 4 door faults per week. A door fault is when a door sensor opens or closes a door unexpectedly. The Justice Center staff has collected 16 weeks of door fault data.
Can we say with 95% confidence that the new automatic door system is triggered more door faults than it should?
Week	Door faults		Type Answers in the Spaces Below
1	5	H0:
2	3	H1:
3	5	mu:
4	8	N:
5	5	Sample average:
6	2	Sample standard deviation:
7	9	t:
8	1	Level of confidence:
9	1	Alpha level:
10	0	t-alpha:
11	7	Reject H0? (Yes or No):
12	6	Interpretation:
13	8
14	8
15	10
16	4
When finished, go on to problem 2 in the sheet tab below that says "Problem 2"

Problem 2 (10 points)
Management hires a motivational consultant to help a struggling sales team improve their sales. The motivational consultant holds a seminar with the
sales team to try to motivate them to improve their sales techniques. Below are the number of sales for each salesperson. Can we say with
95% confidence that the consultant's seminar helped improve sales?
Salesperson	Sales before seminar	Sales after seminar	d = x1 - x2		Type Answers in the Spaces Below
Joey Tribbiani	49	47		H0:
Monica Geller	61	80		H1:
Ross Geller	52	56		N:
Pheobe Buffay	48	48		Mu of d:
Rachel Green	57	55		Sample Average of d:
Chandler Bing	55	53		Sample Standard Deviation of d:
"Gunther"	41	48		Level of Confidence:
Mr. Heckles	27	29		Alpha Level:
"Fun" Bobby	38	42		t:
Richard Burke	47	55		t-Alpha:
Ursula Buffay	48	48		Reject H0? (Yes or no):
Eddie Menuek	40	44		Interpretation:
Janice Hosenstein	41	46
Jack Geller	37	41
Frank Buffay Jr.	29	36
When finished, go on to problem 3 in the sheet tab below that says "Problem 3"

Problem 3 (10 points)
The city administrator is curious whether or not residents in high density residential units produce less trash than residents in single family dwellings. A random sample of
individuals from each type of residential dwelling (high density or single family) were selected and the pounds of trash per day for each of these individuals was approximated.
Can we say with 95% confidence that high density residential units produce less trash than residents in single family dwellings? (All data below is in pounds of trash per day)
High Density	Single Family		Type Answers in the Spaces Below
3	4.7	Question Hypothesis H0
3.1	5	Question Hypothesis H1
5.8	4	Intermediate Hypothesis H0
4.9	6.8	Intermediate Hypothesis H1
4.1	4.2	Level of Confidence
2.6	3.4	Alpha Level
3.7	3.8	Variance for x1
4.5	3.7	Variance for x2
3.1	3	Did you reject H0 in your Intermediate Hypothesis?
2.9	7.1	Did you reject H0 in your Question Hypothesis?
3.8	4.5	Interpretation
4	3.7
3.9	3.5
3.6	4
5	5.6
3.1
When finished, go on to problem 4 in the sheet tab below that says "Problem 4"

Problem 4 (10 points)
Do more officers out on patrol lead to more parking tickets are given out?
Do a scatter plot, correlation, and regression analysis to analyze the following data.
City	Number of officers	Number of parking tickets		Write your answers here:
Redwood Falls	10	69	Name:
Austin	22	107	Correlation coefficient:
Rochester	42	182	Correlation interpretation:
Fairmont	13	71	b0:
Waseca	9	57	Interpretation of b0:
Bemidji	14	91	b1:
Cass Lake	6	50	pvalue for x1:
Cloquet	6	74	Interpretation of b1 and p-value:
Hibbing	8	67	Significance of F-test:
Walker	11	98	Interpretation of Significance of F-test:
Detroit Lakes	17	95	R-squared:
Hinckley	8	87	Interpretation of R-squared:
Black Duck	5	45
			Place scatterplot below ↓↓↓↓↓
When finished with all four problems, please save this file and upload it
into the Final Exam Assignment Dropbox on the D2L/BrightSpace site.