PSYC 3402-Assignment 2

Note: This lab is the same lab as assignment 1. Please calculate all 13 problems again, this time using Excel instead of doing the work by hand.

VARIANCE & STANDARD DEVIATION

State all relevant formulas.

For 1-6: Calculate the mean, median, variance and standard deviation for each set of data. Show your

work.

1) 1, 9, 9, 10, 11, 20

2) 3, 3, 4, 4.5, 5

3) 1,2,3,4,5

4) 1, 2, 5, 8, 9

5) 4, 4, 5, 9, 10

6) 1, 1, 2, 2, 8, 10