Access over 20 million homework & study documents

20191110133021kassandra Willis Word Document

Content type
User Generated
Subject
Statistics
School
Bethel University
Type
Homework
Rating
Showing Page:
1/14
Running head: WEEK TWO 1
Kassandra Willis
Bethel University
Dr. Dorothy Black
11/10/2019

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/14
2
Week Two
COMPLETE PROBLEM 1
Helpful Tip: problem number one has three parts. Part 1 is using the provided Excel table. Part
2 is using manual calculations that you would have used prior to taking a statistics course. Part 3
is comparing what you got from the provided Excel Table and your own manual calculations.
Special Note: the numbers will not be the exact same.
COMPLETE PROBLEM 1 Part 1: Let’s assume (for this problem only) that the
Student_Data.xls file was the entire population. We know the mean and standard deviation of
student ages to be 42.3 and 8.9, respectively. Using the Normal_ Probability.xls file:
a) compute the percentage of students that are older than 50,
b) compute the percentage of students that are younger than 40,
c) compute the percentage of students that are between 41 and 46, inclusive.
d) compute the age range of the oldest 10% of the students.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/14

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 14 pages?
Access Now
Unformatted Attachment Preview
Running head: WEEK TWO 1 Kassandra Willis Bethel University Dr. Dorothy Black 11/10/2019 2 Week Two COMPLETE PROBLEM 1 Helpful Tip: problem number one has three parts. Part 1 is using the provided Excel table. Part 2 is using manual calculations that you would have used prior to taking a statistics course. Part 3 is comparing what you got from the provided Excel Table and your own manual calculations. Special Note: the numbers will not be the exact same. COMPLETE PROBLEM 1 Part 1: Let’s assume (for this problem only) that the Student_Data.xls file was the entire population. We know the mean and standard deviation of student ages to be 42.3 and 8.9, respectively. Using the Normal_ Probability.xls file: a) compute the percentage of students that are older than 50, b) compute the percentage of students that are younger than 40, c) compute the percentage of students that are between 41 and 46, inclusive. d) compute the age range of the oldest 10% of the students. 3 Table 1: Normal Probability Table a) compute the percentage of students that are older than 50, Answer: From the above table we see that 19.35% of the students are older than 50. b) compute the percentage of students that are younger than 40, Answer: From the table we see that 39.8% of the students are younger than 40. 4 c) compute the percentage of students that are between 41 and 46, inclusive. Answer: From the table we see that 21.93% of students are between 41 and 46, inclusive. d) compute the age ran ...
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.

Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4