KINE 3700 Barstow Community College Statistics Worksheet

SubjectAge
1
2
3
4
5
6
7
8
9
10
Weight (kg)
18
70
25
55
24
65
23
80
24
84
19
59
20
90
25
89
23
75
22
70
KINE 3700: Statistics in Kinesiology
Class Assignment #2
Points Available: 40
Directions: Use the Excel data sheet Class Assignment 2 Data to complete questions 1 and 2.
Once completed, take a screenshot of the completed sections, and include the screenshot in
your answer on this document to questions 1 and 2. Answer questions 3 – 9 by providing the
answers directly on this document. You do not have to answer the questions in complete
sentences; however, your answers should be clear and easy to find. You must show all work for
any calculations and if necessary, round to two decimal places. Late assignments will not be
accepted, and once you submit an assignment you cannot make any changes. Only documents
saved and uploaded in the appropriate format (PDF, .doc, .docx) will be graded. Failure to
follow the directions will result in point deductions for the assignment.
1. Using the Excel data sheet, Class Assignment 2 Data, create a new data table on the
Excel sheet and find the mean, max, and standard deviation for the variables age and
weight (in kilograms). Screenshot your completed table and attach it below as the
response. (5 points)
2. On the Excel sheet, create a column graph of the mean data for age and weight (kg).
Include a graph title and units. (*Note: you can just label the units as “units”) Screenshot
your completed graph and attach it below as the response. (5 points)
3. What is the purpose of freezing panes on Excel? (2 points)
4. What is the main difference between variable view and data view in SPSS? (2 points)
KINE 3700: Statistics in Kinesiology
5. Using the data set below, calculate the central tendency for parts a-c (show your work
as best as you can when applicable).
3, 4, 6, 3, 2, 5, 1
M=
∑𝑋
𝑛
a. Find the mean (3 points)
b. Find the median (3 points)
c. Find the mode (3 points)
6. Using the set of data below and given equations, calculate the variability for parts a-c
(show your work as best as you can when applicable).
3, 4, 6, 3, 2, 5, 1
𝑆= √
Σ𝑋 2 −
a. Range (3 points)
b. Variance (3 points)
(Σ𝑋)2
𝑛
𝑛−1
𝑆2 =
Σ𝑋 2 −
(Σ𝑋)2
𝑛
𝑛−1
KINE 3700: Statistics in Kinesiology
c. Standard deviation (3 points)
7. If we are measuring the score of a vertical jump test in inches, what scale of
measurement would this be? (2 points)
8. If we wanted to divide up the class into two groups: those wearing light colored shirts
and those wearing dark colored shirts, what scale of measurement would this be? (2
points)
9. Use the frequency data table below, “Steps per day” to answer questions a and b.
a. What is the percentile for an individual who completed 5500 steps? (2 points)
b. What does the above percentile mean for this individual? (2 points)