Question

1. Using the data from question 1, create a frequency table and a histogram in Microsoft^® Excel^®.
2. QUESTION 1 DATA- enter the following data from the 40 participants by first creating a variable labeled “Score”. Next, compute the mean, median, and mode for the following set of 40 reading scores:

31	32	43	42
24	34	25	44
23	43	24	36
25	41	23	28
14	21	24	17
25	23	44	21
13	26	23	32
12	26	14	42
14	31	52	12
23	42	32	34

Answer 1

The frequency table is:

	Data						cumulative
lower		upper	midpoint	width	frequency	percent	frequency	percent
10	<	19	15	9	7	17.5	7	17.5
20	<	29	25	9	16	40.0	23	57.5
30	<	39	35	9	8	20.0	31	77.5
40	<	49	45	9	8	20.0	39	97.5
50	<	59	55	9	1	2.5	40	100.0
					40	100.0

The histogram is:

mean	28.38
median	25.50
mode	23.00