Question

The following is data on the Survey of Study Habits and Attitudes (SSHA) scores for 18 female college students. The test evaluates motivation, study habits, and attitudes toward school. Create an appropriate frequency distribution to describe the data set. Interpret the results.

how to input into excel

Student #	Score
1	154
2	109
3	137
4	115
5	152
6	140
7	154
8	178
9	101
10	103
11	126
12	126
13	137
14	165
15	165
16	129
17	200
18	148

Answer 1

Answer:

Populate the data in the excel sheet

Student #	Score
1	154
2	109
3	137
4	115
5	152
6	140
7	154
8	178
9	101
10	103
11	126
12	126
13	137
14	165
15	165
16	129
17	200
18	148

Create a score range:

Score Range

101-120

121-140

141-160

161-180

181-200

Based on the score secured by each girl, input the frequency of each score range and the percentage of each frequency with respect to the total of frequency (i.e. 18):

Score Range	Frequency	Percentage of frequency
101-120	4	22%
121-140	6	33%
141-160	4	22%
161-180	3	17%
181-200	1	6%

Create the graph:

Put the “score range” on primary axis and “Percentage” on the secondary axis.

Based on the above graph, it is interpreted that

33% girls (6 students) have score range of 121-140

Only 6% girls (1 student) have score range of 181-200

Equal number of students (4 each) and 22% each have score range of 101-120 and 141-160

17% girls (3 students) have score range of 161-180

Final data can be seen on Excel as under: