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.

Please help me create the pivot table with instructions

Answer 1

1. Bring data in to excel sheet.

Select data and go to Insert tab --> choose pivot table

2. Keep data in both Rows and data value.

3. Change data value as count in the value field settings

4. Right click the row lables and choose "Grouping".

5. Frequency table

Class interval should be 9

Formula Reference: