# 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)