Week 5: Assignment: Lab
Required Resources
Read/review the following resources for this activity:
•
OpenStax Textbook: Chapter 2, 6, and 7
•
Introductory Statistics Textbook:
•
•
•
•
•
2.2 Measures of the Location of DataLinks to an external site.
6.1 The Standard Normal DistributionLinks to an external site.
6.2 Using the Normal DistributionLinks to an external site.
7.1 The Central Limit Theorem for Sample MeansLinks to an external site.
7.2 Using the Central Limit TheoremLinks to an external site.
•
7.3 The Central Limit Theorem for Proportions
•
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
Demonstrate
•
•
•
•
Steps to Complete Week 5 Lab
Use the Weeks 3 and 5 spreadsheets from the Weeks 3 and 5 Lessons to help
you answer the questions below.
Step 1: Your instructor will provide you with 10 values to use for this lab.
Gather 10 MORE of your own to add to the 10 provided by your instructor. Do
the following:
•
•
Survey or measure 10 people to find their heights. Determine the mean and
standard deviation for the 20 values 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 20 values? Is your height taller, shorter, or the same as the mean of the
sample?
Note: The following image is just an example. They are NOT the values you
should be using for your lab. Your instructor should have sent you our data values
for your Week 5 Lab. Please reach out to your instructor if you do not have your
data values.
a) Data Example of 10 people with different heights
(your spreadsheet will have 20 values—10 from your instructor and 10 from your own
data gathering).
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.
1. How did you choose the participants for your study? What was the sampling
method: systematic, convenience, cluster, stratified, simple random?
2. What part of the country did your study take place in?
3. What are the age ranges of your participants?
4. How many of each gender did you have in your study?
5. What are other interesting factors about your group?
Step 3: Use the Week 5 Excel spreadsheet for the following.
99. (Use the Empirical Rule tab from the spreadsheet). Determine the 68%, 95%, and
99.7% values of the Empirical Rule in terms of the 20 heights in your height
study.
100.
What do these values tell you?
101.
Post a screen shot of your work from the Week 5 Excel spreadsheet.
B (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?
C 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.
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.
Rubric
Week 5 Assignment: Lab
Week 5 Assignment: Lab
Criteria
This criterion is
linked to a Learning
OutcomeMeasures
of Central Tendency
and Variation
Ratings
12 pts
Addresses all
elements of the
following: *20
height values
*mean of data
*standard
deviation of
data
*screenshot of
values
calculated on
spreadsheet
*comparison of
heights
10 pts
Addresses 4
out of 5 of the
following: *20
height values
*mean of data
*standard
deviation of
data
*screenshot of
values
calculated on
spreadsheet
*comparison of
heights
8 pts
Addresses 3
out of 5 of the
following: *20
height values
*mean of data
*standard
deviation of
data
*screenshot of
values
calculated on
spreadsheet
*comparison of
heights
Pts
6 pts
Addresses 1 or
2 out of 5 of
the following:
*20 height
values *mean
of data
*standard
deviation of
data
*screenshot of
values
calculated on
spreadsheet
*comparison of
heights
0 pts
No
Effort
12 pts
Week 5 Assignment: Lab
Criteria
This criterion is
linked to a Learning
OutcomePopulation
Data and Sampling
Techniques
This criterion is
linked to a Learning
OutcomeProbability,
and Measures that
would follow a
normal distribution
in life sciences
Ratings
Pts
15 pts
Addresses all
elements of the
following:
*Sampling
method
*Location *Age
group of
participants
*Gender of
participants
*Other factors
about
participants
12 pts
Addresses 4
out of 5 of the
following:
*Sampling
method
*Location *Age
group of
participants
*Gender of
participants
*Other factors
about
participants
10 pts
Addresses 3
out of 5 of the
following:
*Sampling
method
*Location *Age
group of
participants
*Gender of
participants
*Other factors
about
participants
8 pts
Addresses 1 or
2 out of 5 of
the following:
*Sampling
method
*Location *Age
group of
participants
*Gender of
participants
*Other factors
about
participants
0 pts
No
Effort
15 pts
Addresses all
elements of the
following:
*Empirical Rule
values
*Interpretation
of Empirical
Rule values
*Screenshot of
Empirical
spreadsheet
*Interpretation
of Normal
Distribution
spreadsheet
values
*Screenshot of
probabilities/
percentiles
12 pts
Addresses 4
out of 5 of the
following:
*Empirical Rule
values
*Interpretation
of Empirical
Rule values
*Screenshot of
Empirical
spreadsheet
*Interpretation
of Normal
Distribution
spreadsheet
values
*Screenshot of
probabilities/
percentiles
10 pts
Addresses 3
out of 5 of the
following:
*Empirical Rule
values
*Interpretation
of Empirical
Rule values
*Screenshot of
Empirical
spreadsheet
*Interpretation
of Normal
Distribution
spreadsheet
values
*Screenshot of
probabilities/
percentiles
8 pts
Addresses 1 or
2 out of 5 of
the following:
*Empirical Rule
values
*Interpretation
of Empirical
Rule values
*Screenshot of
Empirical
spreadsheet
*Interpretation
of Normal
Distribution
spreadsheet
values
*Screenshot of
probabilities/
percentiles
0 pts
No
Effort
15 pts
15 pts
Week 5 Assignment: Lab
Criteria
This criterion is
linked to a Learning
OutcomeGrammar
and Formatting
Ratings
8 pts
Lab is easy to
read and
presents
material in a
logical order
with no
grammatical
errors.
6 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 pts
Lab is easy to
read and has
few
grammatical
errors, but it is
not logically
organized.
Pts
4 pts
There are
significant
grammatical
errors and
organizational
issues that
distract from
readability.
0 pts
No
Effort
8 pts
Put values in blue cells; output or answers in YELLOW cells
Data
1
1
2
2
4
5
6
9
11
Mean
Median
Mode
Sample Variance
Sample Standard Deviation
Population Variance
Population Standard Deviation
Range
Count (n)
Min
Quartile 1
Median
Quartile3
Max
Interquartile Range (IQR)
4.5556
4.0000
1.0000
12.7778
3.5746
11.3580
3.3702
10.0000
9.0000
1.0000
1.5000
4.0000
7.5000
11.0000
6.0000
2
#N/A
#N/A
#N/A
(Returns more than one mode)
Enter input in blue cells; See answers in yellow cells
Z score
x
mean
standard deviation
LESS THAN(At most)
AREA LESS THAN
MORE THAN (at least)
ENTER
Asked to find x
32
Mean
28
Stdev
5
AREA MORE THAN
ENTER
Asked to find x
12
Mean
14
Stdev
3
Probability INBETWEEN
INBETWEEN
3.5
6.5
1.5
ENTER
Asked to find Large value
370
Asked to find smaller value
Mean
Stdev
360
365.45
4.9
ANSWER
Z score
-2
Z score
Probability Less than F7
0.8
0.7881
Z score
Probability more than F13
-0.666667
0.7475
ANSWER
Probability between F19 and F20 is
0.6904
Enter input in blue cells; See answers in yellow cells
Find x given Area to Right or Left
Enter
Area to the left
no
Area
0.03
Enter Mean
47500
Enter Standard deviation
3000
Find X given Area in the middle
Area
0.5
Enter Mean
81
Enter Standard deviation
4
If area to the left is given enter yes; otherwise say no
enter decimal
enter decimal
SUMMARY
z
Find x
1.8807936
53142.381
SUMMARY
Lower x
Upper x
78.302041
83.697959
Enter input in blue cells; See answers in yellow cells
Empirical Rule
mean
92
standard deviation
13
68%
95%
99.70%
ANSWER
68-95-99.7
Lower number Upper number
79
105
66
118
53
131
Enter input in blue cells; See answers in yellow cells
CLT THEOREM FOR MEANS
n
Standard deviation
10
8.97
CLT THEOREM FOR PROPORTION
n
proportion of success
30
0.5
Standard error
2.8366
Standard error
0.0913
Week 5 Lab TEMPLATE
Please use this template to help answer the questions listed in the lab
instructions. The “steps” below refer to the steps listed in the lab
instructions. Type your answers and post your screenshots in the spaces
given below. Then, save this document with your name and submit it
inside the courseroom.
Step 1. Gather Data
Your instructors will post 10 data values to use for this lab. The data
values represent the HEIGHTS of 10 people. This data set is posted in the
FILES area, in the “Lab Files” folder. (NOTE: This is NOT the data used in
the lab video, which is about midterm grades. Do not use the midterm
grades data.)
1a. Gather 10 MORE heights on your own to add to the 10 provided by
your instructor. Do the following: Survey or measure 10 people to find
their heights. Determine the mean and standard deviation for the 20 values
by using the Week 3 Excel spreadsheet. (Round statistics to two
decimals.)
Sample mean =
Sample standard deviation =
1b. Post a screen shot in the space BELOW of the portion of the
spreadsheet that helped you determine these values. The screenshot
should show ALL 20 pieces of data. Make sure the instructor data is listed
first and then your data is listed under.
(post screenshot here… delete this line before submitting report)
1c. Answer the following two questions. Use at least two sentences to
answer each question.
How does your height compare to the mean (average) height of the 20
values? Is your height taller, shorter, or the same as the mean of the
sample?
Step 2. Data Characteristics
Answer the following questions to give some background information on
the group of people you used in your study. Write at least two sentences
for each question.
1. How did you choose the participants for your study? What was the
sampling method: systematic, convenience, cluster, stratified, simple
random?
2. What part of the country did your study take place in?
3. What are the age ranges of your participants?
4. How many of each gender did you have in your study?
5. What are other interesting factors about your group?
Step 3. Data Analysis
Answer the following questions. Use the Week 5 Excel spreadsheets to
help analyze the data.
Empirical Rule
1. Determine the 68%, 95%, and 99.7% values of the Empirical Rule in
terms of the 20 heights in your height study. (Use the Empirical Rule tab
from the spreadsheet).
(post screenshot here… delete this line before submitting report)
2. What do these values tell you? (Write at least one paragraph.)
Normal Distribution
3. Based on your study results, what percent of the study participants are
shorter than you? What percent are taller than you? (Use the normal
probability tab from the spreadsheet).
4. Post a screen shot of the normal distribution from the Week 5 Excel
spreadsheet to support your answer above..
(post screenshot here… delete this line before submitting report)
Step 4. Save and submit this document
Be sure your name is on the Word document, save it, and then submit it. In
the assignment module, click “start assignment” and then “upload file” and
“submit assignment”.
Heights (in)
61
64
65
66
67
68
68
68
70
72
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Dissertation Writing Service Works
First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download