3 4 5 6 7 8 9 10 11 12 13 14 15 4am-6am 6am - 8am 8am -10am 10am-12pm 12pm-2pm 2pm-4pm 4pm - 6pm 6pm - 8pm 8pm - 10pm Monday 2022 Daily Attendance Trends 50 125 100 90 75 62 125 125 75 Balance S Weekday Tuesday 50 100 100 100 65 50 140 150 20 Wednesday Thursday 45 85 110 100 70 55 150 105 40 40 110 90 90 50 50 85 150 30 Friday 30 120 100 100 25 35 35 20 20 Weekend Saturday 100 125 75 50 25 Sunday 90 120 95 50 25 26 27 28 29 30 2. Looking at the charts, what other recommendations would you make about staffing or operating hours during the week? 31 Income Membership Edit Charts Summary Mar Apr May Jun Jul Aug Sep Oct Nov| Dec Jan Feb Better You Fitness Center 3-Year Membership Totals 2020 250 250 255 275 275 260 250 275 275 325 500 550 2021 560 560 560 575 575 575 585 750 750 765 925 930 16 17 18 Create Chart 19 Using the data on this worksheet, create a stacked bar chart that illustrates breakdown of gym visits by hour and by day on the weekday. 20 Create a similar chart for weekend data. Include meaningful titles, legends, and data labels that best reflect the data. 21 22 Then answer the following questions 23 1. If you were the owner and wanted to cut back hours the gym is open without interrupting staffing too much, which time slot(s) would you liminate? Explain your answer. 24 25 O A 2022 935 948 960 990 990 990 1025 1025 1050 1100 1025 1200 P Q R 7 B 9 2. Looking at the charts, what other recommendations would you make about staffing or operating hours during the week? 1 2 3 4 5 6 Using the data on this worksheet, create a stacked bar chart that illustrates breakdown of gym visits by hour and by day on the weekday. Create a similar chart for weekend data. Include meaningful titles, legends, and data labels that best reflect the data. 1 2 Then answer the following questions 31. If you were the owner and wanted to cut back hours the gym is open without interrupting staffing too much, which time slot(s) would you eliminate? Explain your an 4 5 5 7 Sparklines 8 Add Sparklines to the bottom of the 3-Year Membership Totals data. Format the sparklines as follows: 9 1 5 6 a. Choose column sparklines b. Show the Highpoints c. Increase the row height to better display the data. 2 3 What conclusion can you draw from the Sparkline data? 4 Balance Income Membership Edit Charts M Summary N 4 O P