Part 1 (2/3). Working with Excel (Excel file submitted to Canvas) Worksheet 1: General 1. Gather the 2017 home attendance of the Minnesota Twins with the data oriented vertically different observations reported in rows). 2. Calculate the mean, median, and standard deviation of attendance. 3. Forecast game attendance for each game based on the previous 5-game moving average. 4. Forecast game attendance based on the previous 5-game weighted moving average, with weights ranging from 1-5 and more recent games receiving greater weight. 5. Which forecast do you think is superior? Why? Write your answer in a cell below the data in the worksheet. Worksheet 2: Orienting the Data 6. Sort the data from the highest to lowest attendance. 7. Cut and paste the data so that the data is oriented horizontally different observations reported in columns). I Worksheets 3 and 4: Subtotals (You must use the "Subtotals" tool) 8. Calculate the mean attendance by visiting team. Which visiting team had the highest average attendance? Write your answer in a cell below the data in the worksheet. 9. Calculate the mean attendance by month. Which month had the lowest average attendance? Write your answer in a cell below the data in the worksheet. Worksheets 5 and 6: Charts 10. Create a spreadsheet with the yearly attendance of Major League Baseball teams the AL Central from 2008-2017 11. Generate a single connected scatter-plot of each team's attendance by season, which is on its own worksheet page. Label the graph and make it suitable for a formal public presentation, Excel Worksheet 7: TVM in Excel 12. Execute at least 5 TVM calculations from Homework #1 and #2 using an excel formula (Refer to Ch. 4 p102-106). For example, PV of a lump sum, PV of an annuity, FV of an annuity, loan payment, Bond value, etc. Label which homework and problem # you are calculating! Part 2. (1/3) Reporting (Two pages or less in a Word Document submitted to Canvas) Write up the results of your analysis as a formal memo/report for the General Manager of the club (Hint: figure out his name, and address the report to him). Explain the factors that have governed attendance in recent history. You may want to include outside information on prices, team performance, promotions etc to enhance your analysis. You mawin a n Data Power Pivot Search Share Home Insert Calib BIU-L Comm Page Layout Formulas -11 A A -A- Review View Help - Wrap Test Merge & Center - 28 O $ - % Cel Conditional Formatas Formage Sort & Find des Clipboard 11,140 W 1 Wed Apr 19 16 St Apt 22 Sun Apr 23 I want SURARE Part 1 (2/3). Working with Excel (Excel file submitted to Canvas) Worksheet 1: General 1. Gather the 2017 home attendance of the Minnesota Twins with the data oriented vertically different observations reported in rows). 2. Calculate the mean, median, and standard deviation of attendance. 3. Forecast game attendance for each game based on the previous 5-game moving average. 4. Forecast game attendance based on the previous 5-game weighted moving average, with weights ranging from 1-5 and more recent games receiving greater weight. 5. Which forecast do you think is superior? Why? Write your answer in a cell below the data in the worksheet. Worksheet 2: Orienting the Data 6. Sort the data from the highest to lowest attendance. 7. Cut and paste the data so that the data is oriented horizontally different observations reported in columns). I Worksheets 3 and 4: Subtotals (You must use the "Subtotals" tool) 8. Calculate the mean attendance by visiting team. Which visiting team had the highest average attendance? Write your answer in a cell below the data in the worksheet. 9. Calculate the mean attendance by month. Which month had the lowest average attendance? Write your answer in a cell below the data in the worksheet. Worksheets 5 and 6: Charts 10. Create a spreadsheet with the yearly attendance of Major League Baseball teams the AL Central from 2008-2017 11. Generate a single connected scatter-plot of each team's attendance by season, which is on its own worksheet page. Label the graph and make it suitable for a formal public presentation, Excel Worksheet 7: TVM in Excel 12. Execute at least 5 TVM calculations from Homework #1 and #2 using an excel formula (Refer to Ch. 4 p102-106). For example, PV of a lump sum, PV of an annuity, FV of an annuity, loan payment, Bond value, etc. Label which homework and problem # you are calculating! Part 2. (1/3) Reporting (Two pages or less in a Word Document submitted to Canvas) Write up the results of your analysis as a formal memo/report for the General Manager of the club (Hint: figure out his name, and address the report to him). Explain the factors that have governed attendance in recent history. You may want to include outside information on prices, team performance, promotions etc to enhance your analysis. You mawin a n Data Power Pivot Search Share Home Insert Calib BIU-L Comm Page Layout Formulas -11 A A -A- Review View Help - Wrap Test Merge & Center - 28 O $ - % Cel Conditional Formatas Formage Sort & Find des Clipboard 11,140 W 1 Wed Apr 19 16 St Apt 22 Sun Apr 23 I want SURARE
