POLS210

Assignment 6

Descriptive statistics

 

Labor force participation rates (percent employed) and percent high school graduate in 10 states are reported below. Using the 10 cases below, calculate a mean and a standard deviation for both groups for each variable. (i.e. You will be calculating a total of four standard deviations.) Calculate manually using N instead of N-1. Do NOT use EXCEL. (You will have no access to Excel, when you take the next test.) Do not use SPSS. (Your answer will be wrong, if you use SPSS, since SPSS uses N-1 instead of N.) Follow the second table below to calculate the standard deviation for the first variable, Labor force participation (Male). Show your work. You can type or take a picture of your hand written answers and copay and paste them into a Word file and submit it to Blackboard after showing it to the instructor.

 

 

 

Labor force participation

%High school graduates

State

Male

Female

Male

Female

A

73.9

54.2

65

67

B

81.1

63.2

57

60

C

80.9

59.9

72

76

D

76.6

59.9

77

75

E

80.0

60.8

75

74

F

74.1

51.5

70

72

G

73.5

50.6

68

66

H

77.6

54.9

70

71

I

77.4

54.1

66

66

J

80.1

75.2

72

75

 

 Hint for the first variable “Labor force participation-Male”:

 

Calcualte the mean first and fill in the table below:

 

State

X

(Xi-mean)

(Xi-mean)2

A

73.9

73.9-mean

B

81.1

C

80.9

D

76.6

E

80.0

F

74.1

G

73.5

H

77.6

I

77.4

J

80.1

Total

78.9

 

Variance=7.89

Standard deviation=?

 

Submit the assignment to Blackboard after showing your assignment to the instructor. Blackboard allows you to deposit only once. Make sure to show your work.

 

Extra Credit Assignment (Addition to Exam 2)

Bonus points: Maximum of 3 points will be added to your Exam 2, if you calculate the standard deviations of the two variables below using EXCEL. Follow the format above and make sure to show tables with the columns for deviation and deviation squared. Copy the excel tables and paste them into a Word file and show them to the instructor. Deposit the final version to "Extra Credit (Excel)" under the Content area in Blackboard. You can submit an EXCEL file without converting it to a WORD file.

 

See the following link for more instruction: Excel-Standard deviation  (The column for Z scores is not required.)

 

 

Mean

Income

State

Male

Female

A

35623

27345

B

32345

28134

C

35789

30546

D

38907

31788

E

42023

35560

F

34000

35980

G

25800

19001

H

29000

26603

I

31145

30550

J

34334

29117