Lab 7 (1)
.docx
keyboard_arrow_up
School
Tunxis Community College *
*We aren’t endorsed by this school
Course
MAT*137
Subject
Mathematics
Date
Jan 9, 2024
Type
docx
Pages
2
Uploaded by MinisterHedgehogPerson922
Lab 7 – Complete Data Analysis
Description
The purpose of this lab is to do a complete statistical analysis of a data set.
Resources Required
Microsoft Excel
Procedure
1.
Download the Lab 7 Data Excel file and click “enable editing” if necessary.
2.
Select cells A1 through B197. Then click on the
Data
tab and select
Sort
. In the dialog
box that pops up, make sure it says Sort by:
GDP per capita (in thousands of dollars)
,
Sort on:
Cell Values
, Order:
Smallest to Largest
. Then click
Ok
.
3.
In D1, type “
Min=
”. In D2, type “
Q1=
”. In D3, type “
Median=
”. In D4, type “
Q3=
”. In
D5, type “
Max=
”. In D6, type “
IQR=
”. Then bold all of these cells.
4.
In E1, type “
=min(b2:b197)
” and hit enter.
5.
In E3, type “
=median(b2:b197)
” and hit enter.
6.
There are 196 countries in the list, so there are 98 countries in each half when we divide
the data set in two to find Q
1
and Q
3
. In E2, type “
=median(b2:b98)
” and hit enter.
7.
In E4, type “
=median(b99:b197)
” and hit enter.
8.
In E5, type “
=max(b2:b197)
” and hit enter.
9.
In E6, type “
=e4-e2
” and hit enter.
10. Select cells B1 through B197, then click on the
Insert
tab and select the statistic chart
icon.
From the dropdown list, choose
Box and Whisker
. Click and drag down on
the bottom edge to enlarge the graph.
11. Click on the Chart Title area and change it to
GDP per capita (in thousands of dollars)
.
12. Right-click on a number on the vertical axis and select
Format Axis
. Change the
minimum to
-20
and the maximum to
200
. Then exit the formatting window.
13. Click to select the horizontal axis, then click the
delete
button to remove it.
MAT167 – PRINCIPLES OF STATISTICS
14. Click
Insert
, then
Text
, then
Text Box
and insert a text box from roughly F2 to K5. Then
type into the box
the shape of the distribution
based on the boxplot. You may need to
tilt your head to the left to get a sense for it since the boxplot is displayed vertically. Just
be sure the numbers are increasing to the right as you look at the plot (if they’re not, try
turning your head the other way).
15. Click the plus sign at the bottom left next to where it says Sheet 1. Click on Sheet 1 again
and select A1 to B197. Then
copy
the data into the new sheet (A1 to B197). Adjust the
widths of columns A and B.
16. Type
Mean
into G1 and
Standard Deviation
into H1. Bold both entries. Then type
“
=average(b2:b197)
” in G2 and “
=stdev(b2:b197)
” into H2.
17. Now we will create a histogram. Type “
Lower
” into D1 and “
Upper
” into E1. Bold both
entries. These columns will be lower- and upper-class limits for our histogram. We will
set our first lower class limit to be 0 and select a class width of 5. Thus, we will need 39
classes to cover the range of our data.
18. Enter “
0
” in D2. Then type “
=d2+5
” in D3. Copy D3 into cells D4 through D40.
19. Enter “
4
” in E2. Then type “=
e2+5
” in E3. Copy E3 into cells E4 through E40.
20. Click on
Data
, then
Data Analysis
. Select
Histogram
and click
Ok
. Enter
B2:B197
for
Input Range
and
E2:E40
for
Bin Range
. Check the box for
Chart Output
and click
Ok
. Click and drag to enlarge the histogram.
21. Right-click on the bars of the histogram and select
Format Data Series
. Change the
Gap
Width
to
0%
. Exit the formatting window. Change the title from Histogram to
GDP per
capita (in thousands of dollars)
. Change the horizontal axis title to
GDP per capita (in
thousands of dollars)
. Click on the
Frequency
label on the right side and delete it.
22. Insert a text box next to the histogram and type into the box
the shape of the
distribution
based on the histogram. Does your answer here match your answer in step
14?
23. Compare the median and the mean of this data set and
answer
(in the text box) how this
comparison supports your choice of shape for this distribution.
24.
Save the file and upload it to Blackboard under Lab 7.
2
MAT167 – PRINCIPLES OF STATISTICS
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help