Week 1 Reflection (Ch 2) Name: Answer each of the following questions in complete sentences and relate your answers to the context of the problem. Once you have typed your answers here, save this file...

See attached documents. Excel worksheet


Week 1 Reflection (Ch 2) Name: Answer each of the following questions in complete sentences and relate your answers to the context of the problem. Once you have typed your answers here, save this file as a PDF and upload with your name as part of the file name. (For example, Erika_Bracher_Reflect1.pdf) Chapter 2 Reflection (Excel File Attached): You are expected to use Excel for the following problem, but you should still explain your work in the context of the problem. Be sure to upload your well labeled Excel file in your submission. 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 amount they spent can be found in the Excel file attached to this Reflection assignment. 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.