+1 (208) 254-6996 [email protected]
  

There are 4 questions in the attachment. Needs to solve within 7 hours. 

There are 4 questions in the attachment. Needs to solve within 7 hours. 

Don't use plagiarized sources. Get Your Custom Essay on
Excel Spreadsheet
Just from $13/Page
Order Essay

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

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?
WeekDoor faultsType Answers in the Spaces Below
15H0:
23H1:
35mu:
48N:
55Sample average:
62Sample standard deviation:
79t:
81Level of confidence:
91Alpha level:
100t-alpha:
117Reject H0? (Yes or No):
126Interpretation:
138
148
1510
164
When finished, go on to problem 2 in the sheet tab below that says “Problem 2”

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?
SalespersonSales before seminarSales after seminard = x1 – x2Type Answers in the Spaces Below
Joey Tribbiani4947H0:
Monica Geller6180H1:
Ross Geller5256N:
Pheobe Buffay4848Mu of d:
Rachel Green5755Sample Average of d:
Chandler Bing5553Sample Standard Deviation of d:
“Gunther”4148Level of Confidence:
Mr. Heckles2729Alpha Level:
“Fun” Bobby3842t:
Richard Burke4755t-Alpha:
Ursula Buffay4848Reject H0? (Yes or no):
Eddie Menuek4044Interpretation:
Janice Hosenstein4146
Jack Geller3741
Frank Buffay Jr.2936
When finished, go on to problem 3 in the sheet tab below that says “Problem 3”

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 DensitySingle FamilyType Answers in the Spaces Below
34.7Question Hypothesis H0
3.15Question Hypothesis H1
5.84Intermediate Hypothesis H0
4.96.8Intermediate Hypothesis H1
4.14.2Level of Confidence
2.63.4Alpha Level
3.73.8Variance for x1
4.53.7Variance for x2
3.13Did you reject H0 in your Intermediate Hypothesis?
2.97.1Did you reject H0 in your Question Hypothesis?
3.84.5Interpretation
43.7
3.93.5
3.64
55.6
3.1
When finished, go on to problem 4 in the sheet tab below that says “Problem 4”

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.
CityNumber of officersNumber of parking ticketsWrite your answers here:
Redwood Falls1069Name:
Austin22107Correlation coefficient:
Rochester42182Correlation interpretation:
Fairmont1371b0:
Waseca957Interpretation of b0:
Bemidji1491b1:
Cass Lake650pvalue for x1:
Cloquet674Interpretation of b1 and p-value:
Hibbing867Significance of F-test:
Walker1198Interpretation of Significance of F-test:
Detroit Lakes1795R-squared:
Hinckley887Interpretation of R-squared:
Black Duck545
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.

Order your essay today and save 10% with the discount code ESSAYHELP