To:  sbaker@odu.edu

From:  Thomas Meyer
tmeyer@ph.vccs.edu
276 656-0283
Patrick Henry Community College

Subject:  Statistics - w/  Dr.Spencer Baker - Homework Assignment #2, Ch 2 - Problem 17, page56.

Date: February 15, 2004

Question:

a.    Use the SPSS program and SPSS data bank for the data set named career.sav to obtain a frequency table for level of mathematics anxiety (anxiety).

Answer:

How to do it, step by step:

Load the CD containing data;
Load SPSS;
Double-click SPSS;
File - Open - A-drive - Careers.sav; Press Enter
Analyze Menu - Descriptive Statistics - Frequencies
Scroll to and select Anxiety;
Click the move arrow;
Click OK

 

Anxiety About Doing Math

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

14

1

.5

.5

.5

17

1

.5

.5

1.0

18

2

1.0

1.0

2.0

19

1

.5

.5

2.5

20

1

.5

.5

3.0

21

3

1.5

1.5

4.5

22

2

1.0

1.0

5.5

23

1

.5

.5

6.0

25

1

.5

.5

6.5

26

1

.5

.5

7.0

27

3

1.5

1.5

8.5

28

2

1.0

1.0

9.5

29

5

2.5

2.5

12.0

30

5

2.5

2.5

14.5

31

3

1.5

1.5

16.0

32

5

2.5

2.5

18.5

33

7

3.5

3.5

22.0

34

3

1.5

1.5

23.5

35

6

3.0

3.0

26.5

36

5

2.5

2.5

29.0

37

6

3.0

3.0

32.0

38

12

6.0

6.0

38.0

39

10

5.0

5.0

43.0

40

3

1.5

1.5

44.5

41

4

2.0

2.0

46.5

42

10

5.0

5.0

51.5

43

4

2.0

2.0

53.5

45

9

4.5

4.5

58.0

46

11

5.5

5.5

63.5

47

4

2.0

2.0

65.5

48

10

5.0

5.0

70.5

49

9

4.5

4.5

75.0

50

7

3.5

3.5

78.5

51

6

3.0

3.0

81.5

52

5

2.5

2.5

84.0

53

5

2.5

2.5

86.5

54

4

2.0

2.0

88.5

55

2

1.0

1.0

89.5

56

6

3.0

3.0

92.5

57

1

.5

.5

93.0

58

3

1.5

1.5

94.5

59

3

1.5

1.5

96.0

60

8

4.0

4.0

100.0

Total

200

100.0

100.0

 

Question:
 

b.    From the frequency table in part (a), construct a grouped cumulative frequency table.   Construct a grouped cumulative frequency curve from this table.

Answer:

How to do it, step by step:

Subtract High value - low value = 60-14=46

Divide the difference by 3, by 5, by 7 etc. until the interval is from 10 to 20.

46/3=15 1/3 or approx. 16 intervals with a width of 3 will cover up to 48 scores

Start with 12-14; that makes the score limit of 12 a multiple of the interval width.

Grouped Frequency Table, Interval width =3, Math Anxiety
Score Interval Midpoint X Frequency f Cumulative frequency cf
60-62 61 8 200
57-59 58 7 192
54-56 55 12 185
51-53 52 16 173
48-50 49 26 157
45-47 46 24 131
42-44 43 14 107
39-41 40 17 93
36-38 37 23 76
33-35 34 16 53
30-32 31 13 37
27-29 28 10 24
24-26 25 2 14
21-23 22 6 12
18-20 19 4 6
15-17 16 1 2
12-14 13 1 1

The Grouped Cumulative Frequency Curve is sent via Jpeg attachment to email.

The graph of the cumulative frequency curve should look like the cumulative histogram below if the cumulative histogram had an infinite number of intervals.

 

Question:
 

c.    Using the SPSS program, construct a grouped frequency histogram and pie chart for level of mathematics anxiety that matches the table in part (b).

Answer:

How to do it, step by step:

Load the CD containing data;
Load SPSS;
Double-click SPSS;
File - Open - A-drive - Careers.sav; Press Enter
Click Graphs menu; Interactive; Histogram;
Select Anxiety; drag this label to the X-axis; click OK; (Place a check in cumulative histogram if you want a cumulative histogram.)
Click the table; Click Edit menu; Click Copy command
On Frontpage click the location; Click Edit menu and click Paste command.
Save your work;
Refresh the web page.
 

Grouped Frequency Histogram
Math Anxiety		 Cumulative Histogram
Math Anxiety

 

Question:
 

d.    Use the SPSS program and SPSS data bank to construct a bar graph and a pie chart for career interest area (interest) from the data set career.sav.

Answer:

How to do it, step by step:

Load the CD containing data;
Load SPSS;
Double-click SPSS;
File - Open - A-drive - Careers.sav; Press Enter

Select Graphs menu - Bar... (or Pie...)
Scroll to and select Current Career Interest
Click "N of Cases"
Click Arrow box
Right-click the picture - Copy
Click the location desired on Frontpage
Edit menu - paste
Save
Refresh the web page.

 

Bar Graph
Number of Cases
Career Interest Area
from data set career.sav		 Pie Chart

Career Interest Area
from data.set career.sav

 

 

Question:
 

e.    Use the SPSS program and SPSS data set career.sav to construct a box plot of level of mathematics anxiety (anxiety) by the category of grade level (gradelvl) and a box plot of level of mathematics anxiety (anxiety) by the category of career interest area (interest).

Answer:

How to do it, step by step:

Load the CD containing data;
Load SPSS;
Double-click SPSS;
File - Open - A-drive - Careers.sav; Press Enter

Select Graphs menu
Select Boxplot... ; Define
Scroll to and select Anxiety About Doing Math; click the arrow labeled Variable;
Scroll to and select Current Career Interest; click the arrow labeled Category Axis;
Click OK

Right-click the picture; Copy;
Select a location on Frontpage; Paste
Save.
Refresh the web.

Click the left green arrow (to bring the menus back to active status)

Select Graphs menu
Select Boxplot... ; Define;  Click Reset;
Scroll to and select Anxiety About Doing Math; click the arrow labeled Variable;
Scroll to and select Grade Level In School; click the arrow labeled Category Axis;
Click OK

Right-click the picture; Copy;
Select a location on Frontpage; Paste
Save.
Refresh the web.

 

Boxplot of Anxiety About Doing Math
versus
Grade Level In School		 Boxplot of Anxiety About Doing Math
versus
Current Career Interest

 


filename: StatHW2Ch2Prob17page56TomMeyer.doc

Tom Meyer

Thomas Meyer