CraigsReportCaseStudyONLINE new

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 Year 2 Total Sales $ 257,281 $ 312,409 $ 185,163 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 Year 5 Total Sales $ 221,061 $ 280,690 $ 283,143 $ 279,280 $ 247,569 $ 247,027 Average Total Sales $ 233,152 $ 301,531 $ 225,315 $ 280,164 $ 214,330 $ 244,143 Standard Deviation of Total Sales $ 15,911 $ 14,290 $ 45,654 $ 1,412 $ 47,007 $ 4,079 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 Spring 2023 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 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. Provide a recommendation for both where and when the sporting goods company should open, based on your insights from the graphics and data. 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. We can see from the studant chart that the studant attendance is seen as the follwing with Sand Diago has the highest attendence. Then It would be Salt Lake City. When it comes to third and 4th place Denver has an over all higher atendance, but Seattle has more attending collage. As we look at anual sales we notice that High School made more sales then all the others. When it comes to stores we can see that store two Has made the most average sale but that store four has the smallest diveation from year to year. We can also see that the stores closer to stadium are more profitable. Along with where the stores are profitable we see that profits are the most profitable during the summer months with a peek in August. I would sugest that you put the store the closest to the stadim that you can and that you make sure it is opened all during the summer. That will give you the most profitable sales. 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. Elementa ry St ud en ts Middle Sch oo l S tudents High School Students Col leg e Students $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 Current Annual Sales by age group Denver San Diego Seattle Salt Lake City - 50,000 100,000 150,000 200,000 250,000 300,000 American Community Survey Elementary Students Middle School Students High School Students College Students 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 Current Stores Distance from Stadium Average Annual Sales January February March Apri l May June July August Sep tember Octo be r Novembe r Decemb er - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 Average Monthly Sales Month Average Monthly Sales

MATH 108X - Craig's Report Case Study 0 Total Errors 22 Total Correct #1 #2 #3 Note, this "How Did I Do" page does not check your charts and graphs for correctness. #4 #5 Your instructor will grade your written response.