Week 5 Assignment: Lab
Submit Assignment
·
Points 50
·
Submitting a file upload
Required Resources
Read/review the following resources for this activity:
·
OpenStax Textbook:
Chapter 2, 6, and 7
·
Lesson
·
Weeks 3 and 5 Excel
Spreadsheets
Scenario/Summary
This week’s lab highlights the use of probability and normal
distribution.
Follow the directions below to gather data, calculate using
Excel spreadsheets, and interpret the results.
Deliverables
The deliverable is a Word document with your answers to the
questions posed below based on the data you find.
Required Software
·
Microsoft Word
·
Microsoft Excel
Steps to Complete Week 5 Lab
Use the Weeks 3 and 5 spreadsheets to help you answer the
questions below.
Step 1: Survey or measure 10 people to find their heights.
Determine the mean and standard deviation for this group by using the Week 3
Excel spreadsheet. Post a screen shot of the portion of the spreadsheet that
helped you determine these values. How does your height compare to the mean
(average) height of the group that you surveyed? Is your height taller,
shorter, or the same as the mean of your group?
Data Example of 10
people with different heights
Step 2: Give some background information on the group of people
you used in your study. You might consider using the following questions to
guide your answer.
a.
How did you choose the
participants for your study (sampling method)?
b.
What part of the country
did your study take place in?
c.
What are the age
ranges of your participants?
d.
How many of each
gender did you have in your study?
e.
What are other
interesting factors about your group?
Step 3: Use the Week 5 Excel spreadsheet for the following.
a.
(Use the Empirical
Ruletab from the spreadsheet). Determine the 68%, 95%, and 99.7%
values of the Empirical Rule in terms of the ten heights in your height study.
b.
What do these values
tell you?
c.
Post a screen shot of
your work from the Week 5 Excel spreadsheet.
Week 5 Spreadsheet Example
d.
(Use the normal
probability tab from the spreadsheet). Based on your study results, what
percent of the study participants are shorter than you? What percent are taller
than you?
e.
Post a screen shot of
your work from the Week 5 Excel spreadsheet.
Example:If my height is 73 inches, then 20.86% of the relevant
population is shorter. The other 79.14%, of course, is taller.
Week 5 Spreadsheet
Example
Step 4: Be sure your name is on the Word document, save it, and
then submit it under “Assignments” and “Week 5: Lab”.
Grading
This activity will be graded based on the Week 5 Lab Rubric.
Course Outcomes (CO): 3, 4, 5
Due Date: By 11:59 p.m. MT on Sunday
Rubric
Week 5 Assignment: Lab
Week
5 Assignment: Lab

Criteria

Ratings

Pts

This criterion is linked to a
Learning OutcomeEmpirical Rule and
Confidence Interval

12.0 pts
Addresses all
elements of the Empirical Rule in the following. *Example of an iron level
considered unusual. *Empirical rule to determine the unusual iron level

10.2 pts
Addresses most
elements of the Empirical Rule in the following. *Example of an iron level
considered unusual. *Empirical rule to determine the unusual iron level.

8.4 pts
Addresses some
elements of the Empirical Rule but is missing one of the following or not
adequately discussed. *Example of an iron level considered unusual.
*Empirical rule to determine the unusual iron level.

6.6 pts
Addresses few
elements of the Empirical Rule and is missing all of the following or did
not adequately discuss the elements. *Example of an iron level considered
unusual. *Empirical rule to determine the unusual iron level.

0.0 pts
No Effort


12.0 pts

This criterion is linked to a
Learning OutcomeCentral Limit
Theorem

15.0 pts
Addresses all
elements of the Central Limit Theorem and Empirical rule in the following.
*Specific sample size and find the standard deviation. *Range of average
Iron level considered usual. *Conclusion that could be made from using CLT
and Empirical rule

12.75 pts
Addresses most
elements of the Central Limit Theorem and Empirical rule but may be missing
one of the following: *Specific sample size and find the standard
deviation. *Range of average Iron level considered usual. *Conclusion that
could be made from using CLT and Empirical Rule

10.5 pts
Addresses some
elements of the Central Limit Theorem and Empirical rule but is missing two
of the following or not adequately discussed. *Specific sample size and
find the standard deviation. *Range of average Iron level considered usual.
*Conclusion that could be made from using CLT and Empirical Rule

8.25 pts
Addresses few
elements of the Central Limit Theorem and Empirical rule and is missing all
of the following or did not adequately discuss the elements. *Specific
sample size and find the standard deviation. *Range of average Iron level
considered usual. *Conclusion that could be made from using CLT and
Empirical Rule.

0.0 pts
No Effort


15.0 pts

This criterion is linked to a
Learning OutcomeMeasures that would
follow a normal distribution in life sciences

15.0 pts
Explains why all
three variables or measures chosen would follow a normal distribution.

12.75 pts
May be missing one
of the variables but explains why the 2 measures chosen follow a normal distribution
adequately OR the lab discusses all 3 three measures chosen with some
explanation to why it follows a normal distribution

10.5 pts
May be missing two
of the variables but adequately explain why the measure chosen follow a
normal distribution OR the lab may be missing one of the variables with
some explanation to why it follows a normal distribution.

8.25 pts
Addresses only one
variable with some explanation to why it follows a normal distribution.

0.0 pts
No Effort


15.0 pts

This criterion is linked to a
Learning OutcomeGrammar and
Formatting

8.0 pts
Lab is easy to
read and presents material in a logical order with no grammatical errors.

6.8 pts
Lab is easy to
read and presents material in a logical order. There are a few grammatical
errors but they do not distract from readability.

5.6 pts
Lab is easy to
read and has few grammatical errors, but it is not logically organized.

4.4 pts
There are
significant grammatical errors and organizational issues that distract from
readability.

0.0 pts
No Effort


8.0 pts

Total
Points: 50.0
