Question

In: Statistics and Probability

The marketing division of Family FunTime Mini Golf is wanting to gather information about the spending...

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.
  1. Determine the cumulative percent frequency distribution using your PivotTable in Excel. Copy your table below.

Solutions

Expert Solution

2.

3.

Classes
Class # Lower limit Upper Limit Freq. Rel. Freq.
1 15 25 1 0.025
2 25 35 2 0.05
3 35 45 5 0.125
4 45 55 10 0.25
5 55 65 15 0.375
6 65 75 4 0.1
7 75 85 3 0.075
Sum 40 1

4.

Classes
Class # Lower limit Upper Limit Freq. Rel. Freq. Cumulative Freq. % cumulative Freq.
1 15 25 1 0.025 1 2.5%
2 25 35 2 0.05 3 7.5%
3 35 45 5 0.125 8 20.0%
4 45 55 10 0.25 18 45.0%
5 55 65 15 0.375 33 82.5%
6 65 75 4 0.1 37 92.5%
7 75 85 3 0.075 40 100.0%
Sum 40 1

Related Solutions

The marketing division of Family FunTime Mini Golf is wanting to gather information about the spending...
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...
The marketing division of Family FunTime Mini Golf is wanting to gather information about the spending...
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...
As a nurse, discuss the importance of these: 1)Assessment—gather information or data about the individual, family,...
As a nurse, discuss the importance of these: 1)Assessment—gather information or data about the individual, family, or community. 2)Analysis and identification of the problem 3)Prioritizing Nursing Diagnoses 4)Selecting Interventions and Planning Care 5)Documentation
What is the first step in conducting marketing research? a. Gather information from primary sources b....
What is the first step in conducting marketing research? a. Gather information from primary sources b. Defining the purpose c. Gathering the participants d. Creating a survey e. Sole proprietorship What does the term “sweat equity” refer to? a. The amount of time and labor an entrepreneur has completed for the business. b. An entrepreneur’s personal funds invested into the business c. The amount of money your investor has put into the business d. Friends and family funding If an...
What do you know about NAFTA? Use the internet to gather some information about NAFTA and...
What do you know about NAFTA? Use the internet to gather some information about NAFTA and why and when it was started. Do you think NAFTA has been successful in its objectives? Why or why not? Make sure you clearly state the source of your information.
What do you know about NAFTA? Use the internet to gather some information about NAFTA and...
What do you know about NAFTA? Use the internet to gather some information about NAFTA and why and when it was started. Do you think NAFTA has been successful in its objectives? Why or why not? Make sure you clearly state the source of your information.
9)Attley Inc. has three separate divisions: Division A, Division B, and Division C. Information about the...
9)Attley Inc. has three separate divisions: Division A, Division B, and Division C. Information about the three divisions follows: Division A Division B Division C Operating income $ 26,750 $121,000 $22,400 Average operating assets $250,000 $412,000 $83,000 The company has recently implemented a new performance evaluation system. Based on this new system, a division manager would only receive a bonus if the ROI of the division was greater than 25% and residual income was in excess of $20,000. If management...
Briefly describe what information a speaker should gather about the audience in regards to public speaking
Briefly describe what information a speaker should gather about the audience in regards to public speaking
3. How do you gather competitive information? Why do you want to know about competition? (5...
3. How do you gather competitive information? Why do you want to know about competition?
audit cycle Crossties of 1-Gather information about the client Internal control system 2-Testing the client internal...
audit cycle Crossties of 1-Gather information about the client Internal control system 2-Testing the client internal control system (Sufficiency and effectiveness) 3-Testing the financial statements. 4-Review and completion. 5-Communicate report explain each term
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT