Access over 35 million academic & study documents

Finalexam Final

Content type
User Generated
Subject
Excel
School
Minnesota State University - Mankato
Type
Homework
Showing Page:
1/20

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/20

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/20

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 20 pages?
Access Now
Unformatted Attachment Preview
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: May 7th by 10: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 Be sure to complete all 4 problems. 50 points total. Name: m left of the page to find the sheets. Problem 1 (12 points total) A new automatic door system was installed at the Mankato Justice Center. The manufacturer of th average 4 door faults per week. A door fault is when a door sensor opens or closes a door unexpec Can we say with 95% confidence that the new automatic door system is triggered more door faults Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Door faults 7 6 5 8 4 0 4 1 8 5 7 2 8 5 2 1 H0: H1: mu: N: Sample average: Sample standard deviation: t: Level of confidence: Alpha level: t-alpha: Reject H0? (Yes or No): Interpretation: When finished, go on to problem 2 in the sheet tab bel ce Center. The manufacturer of the new door system says that it can be expected that the system will or opens or closes a door unexpectedly. The Justice Center staff has collected 16 weeks of door fault data. stem is triggered more door faults than it should? Type Answers in the Spaces Below u = 4 door fault per week u > 4 door fault per week 4 16 4.5725 2.7072 0.8311 95% 5% 0.209475 yes yes the new automatic door system is triggered more door faults than it should to problem 2 in the sheet tab below ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4