Question

The following data are final marks for a Strategic Management Accounting course at a University.

30 74 41 65 51 54 36 56 68 57 70 64 76 67 83 61 81 77 60 38 84 68 72 94 71 86 71 75 91 55 90 82 83 54 79 62 68 58 41 49

a. Construct a frequency distribution and a relative frequency distribution for the data .

b. Construct a cumulative frequency distribution and a cumulative relative frequency distribution for the data .

c. Plot a relative frequency histogram for the data (1 mark)

d. Construct an ogive for the data (1 mark)

e. What proportion of the marks is less than or equal to 60? (1 mark)

f. What proportion of the marks is more than 70? (1mark)

i would love if someone can help me it needs to be put into excel

Answer 1

a. Construct a frequency distribution and a relative frequency distribution for the data (2 marks).

b. Construct a cumulative frequency distribution and a cumulative relative frequency distribution for the data (2 marks).

	Data						cumulative
lower		upper	midpoint	width	frequency	relative frequency	frequency	relative
30	<	39	35	10	3	0.1	3	0.1
40	<	49	45	10	3	0.1	6	0.2
50	<	59	55	10	6	0.2	12	0.3
60	<	69	65	10	9	0.2	21	0.5
70	<	79	75	10	9	0.2	30	0.8
80	<	89	85	10	7	0.2	37	0.9
90	<	99	95	10	3	0.1	40	1.0
						0.0
					40	1.0

c. Plot a relative frequency histogram for the data (1 mark)

The histogram is:

d. Construct an ogive for the data (1 mark)

The ogive is:

e. What proportion of the marks is less than or equal to 60? (1 mark)

Proportion = 12/40 = 0.3

f. What proportion of the marks is more than 70? (1mark)

Proportion = 19/40 = 0.475