CraigsReportCaseStudyONLINE (1)

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 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 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. Good evening, to start my presentation I'd like to show this bar graph that displays the student population in different communities. As you can see, the student population in San Diego is significatntly higher than the population of students in other areas like Denver, Seattle, and Salt Lake City. To go more in depth, there is a total of 30,656 students in Denver, 711,310 in San Diego, 125,016 in Seattle, and finally 294,174 in Salt Lake City. Moving on to the annual sells by age group, as represented on the pie chart, a total of $85,204 is spent by to elementary school students, $115,229 by middle school students, $955,820 by High School students, and $402,517 by college students. To proceed, this graph depicts the relationship between the average annual sales of each store and the store's distance from the nearest athletic stadium. As you can see, the store with the highest average total sales price made, was store 2 and the lowest was store 5. This makes sense because store 2 is at the closest distance from the athletic stadium, making it more likely for people to go and buy things, while store 5 is farther, making it less probable for people to go to it. Lastly, like shoen on the chart, the month in which the most sales were made was August. The month with the least amount of sales was January. In august an averag e amount of $168,158 was made, while in January an average of $54,345 was made. 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. $85,204 $115,229 $955,820 $402,517 Annual Sales Elementary Students Middle School Students High School Students College Students American Community Survey Elementary Students Middle School Students High School Students College Students 0.00 50,000.00 100,000.00 150,000.00 200,000.00 250,000.00 300,000.00 28,618 30,997 26,556 30,656 151,209 155,481 164,279 240,341 25,798 26,130 19,645 53,443 74,126 76,583 76,014 67,451 Student population Column I Column J Column K Column L Cur rent Stores January February March April May June July August September Octo ber Novemb e r Decem ber 0.00 20,000.00 40,000.00 60,000.00 80,000.00 100,000.00 120,000.00 140,000.00 160,000.00 180,000.00 Monthly Sales Column I Column J 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 Store chart Distance from Stadium Average Annual Sales