Question

The marketing division of Family FunTime Mini Golf is wanting to gather information about the spending habits of its visitors. It polls visitors as they leave and gathers information about the amount of money spent at the course. A sample with 40 families and the amounts they spent can be found in the Excel table I have provided below. Please answer all questions using complete sentences.

Amount Spent
18
26
34
36
38
42
43
44
45
45
50
51
52
52
53
53
54
54
56
58
58
58
59
60
60
61
61
62
62
62
63
63
63
65
66
71
71
77
83
84

1. Using Excel’s PivotTable feature, organize the data into a frequency distribution, using 7 classes and 15 as the lower limit of the first class. Copy your table below. (You can do a straight copy/paste from Excel, it will transfer the table over.) What class interval did you need to select? Explain.
2. Where do the data tend to cluster? Describe the distribution in the context of the problem.
3. Determine the relative frequency distribution using your PivotTable in Excel. Copy your table below.
4. Determine the cumulative percent frequency distribution using your PivotTable in Excel. Copy your table below.

Answer 1

The table is:

	Amount Spent						cumulative
lower		upper	midpoint	width	frequency	relative frequency	frequency	percent
15	<	24	20	9	1	0.03	1	2.5
25	<	34	30	9	2	0.05	3	7.5
35	<	44	40	9	5	0.13	8	20.0
45	<	54	50	9	10	0.25	18	45.0
55	<	64	60	9	15	0.38	33	82.5
65	<	74	70	9	4	0.10	37	92.5
75	<	84	80	9	3	0.08	40	100.0
					40	100.0

The data tend to cluster around 55-65. The data is approximately normal.