CraigsReportCaseStudy (3)

MATH 108X - Charts & Graphs Case Study #1 Step #1 Scroll to column U and read Craig's Background Story. Craig's Background Story #2 Step #2 Final page of printouts that Craig was given. The highlighted data on this page needs to be typed into the table to the left. American Community Survey Denver San Diego Seattle Salt Lake City Elementary Students 28,618 151,209 25,798 74,126 Step #3 Middle School Students 30,997 155,481 26,130 76,583 High School Students 26,556 164,279 19,645 76,014 College Students 30,656 240,341 53,443 67,451 Step #4 Insert a chart of the American Community Survey data here. Step #5 Step #6 #3 Current Annual Sales by Age Group Annual Sales Insert chart or graph of Annual Sales for each Age Group here. Elementary Students $ 85,204 Middle School Students $ 115,229 High School Students $ 955,820 College Students $ 402,517 #4 Store 1 Sales Store 2 Sales Store 3 Sales Store 4 Sales Store 5 Sales Store 6 Sales Year 1 Total Sales $ 217,129 1412.2026531 $ 244,143 Year 2 Total Sales $ 257,281 $ 312,409 $ 185,163 $ 280,164 4079.2990207 Year 3 Total Sales $ 232,019 $ 308,782 $ 192,598 $ 279,420 Year 4 Total Sales $ 238,271 $ 304,242 $ 240,355 $ 281,793 $ 181,091 $ 241,258 $ 45,654 Year 5 Total Sales $ 221,061 $ 280,690 $ 283,143 $ 279,280 $ 247,569 $ 247,027 47007.0446 Average Total Sales $ 233,152 $ 301,531 $ 225,315 $ 280,164 $ 214,330 $ 244,143 $ 214,330 $ 301,531 Standard Deviation of Total Sales $ 15,911 $ 14,290 $ 45,654 $ 1,412 $ 47,007 $ 4,079 14,290 Current Stores Distance from Stadium Average Annual Sales Store 1 3.8 233,152 Store 2 1.4 301,531 Store 3 4.3 225,315 Store 4 2.2 280,164 Store 5 3.6 214,330 Store 6 3.5 244,143 Current Stores Month Number Average Monthly Sales January 1 54,345 February 2 67,321 March 3 86,911 April 4 105,222 May 5 110,315 June 6 133,153 July 7 156,213 August 8 168,158 September 9 135,859 October 10 93,628 November 11 80,636 December 12 126,231 Winter 2024 The goal of this project is to practice making and interpreting charts and graphs. Type in the remaining U.S Census Bureau data and recreate a more appropriate bar chart than the one given to summarize that data. Create an appropriate chart or graph that summarizes the company's annual sales by age group category. Check Craig's numerical summaries for accuracy and compute all remaining numerical summaries in order to produce a graph depicting if there is a relationship between Create an appropriate chart or graph (click to review when to u Write a plan or script for what you would say during the next company meeting when presenting these charts and graphs and numerical summaries to Craig's Team. Your comments should be of professional presentation quality.Provide conclusions from the data and graphics for each of parts #2 through #5. One paragraph per section. These values show the breakdown of the annual sales from last year (Year 5) according to age group category. Insert a chart or graph that could illustrate a relationship between the Average Annual Sales for each store and the Distance of the store from the Nearest Stadum here. #5 Insert a chart of Monthly Overall Average Sales against the Month of the Year here. Provide your descriptions of what you would say about these charts and graphs and numerical summaries here... In this week's introductory video, you saw Craig at his internship at the headquarters of a sporting goods store chain. Craig was given the assignment by his boss to make some charts and graphs of his team's data. These will help the team make an informed decision at their next meeting. (Note: your next class period will role play this "next meeting" and your work on this file will help your class make an informed decision.) To rewatch the introductory video, click here . For this Case Study, consider yourself Craig's partner with the same assignment he was given. Craig has already started to type in data for the project. Now it is your job to help him finish, correct any mistakes, and appropriately summarize the data with charts and graphs. What he did already... Craig has entered in most of the data from the pages upon pages of printouts that his boss gave him and has double checked it for accuracy. He has also computed some numerical summaries of the data. However, he hasn't double checked his numerical summaries for accuracy and isn't sure if he did all of his calculations correctly. Finally, Craig tried to make a bar chart that summarizes some of the information, but he hasn't been able to figure out how to get proper labels on it. He also isn't sure what types of charts and graphs to make for the remaining data. What he needs help with... Help Craig finish typing in the remaining data and make appropriate charts and graphs of the data by completing Steps #2 through #5 . Then, help Craig prepare for the next business meeting by writing a description ( Step #6 ) of what you would say about your charts and graphs to Craig's team. You will use this description in your next class period. Remember... Boxes with red triangles in them contain "Hints" which you can read by hovering your mouse over them. Denver San Diego Seattle Salt Lake City - 50,000 100,000 150,000 200,000 250,000 300,000 student enrollment by title Elementary Students Middle School Students High School Students College Students Annual Sales $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 Elementary Students Middle School Students High School Students College Students January Feb ruary March Apr i l May June July August Sep tember Octo b e r Novemb e r December - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 54,345 67,321 86,911 105,222 110,315 133,153 156,213 168,158 135,859 93,628 80,636 126,231 Average Monthly Sales Store 1 Store 2 Store 3 Store 4 Store 5 Store 6 - 50,000.0 100,000.0 150,000.0 200,000.0 250,000.0 300,000.0 350,000.0 3.8 1.4 4.3 2.2 3.6 3.5 233,152 301,531 225,315 280,164 214,330 244,143 distance from stadium and average annual sales Distance from Stadium Average Annual Sales