Scenario You area new Global Bike employeeassigned to a team in the sales department. Global Bike Incorporated (GBI) is multinational manufacturing company based in the US and Germany that sells bikes and accessories to specialized dealers throughout the world. On yourfirst day at work, you aretasked with analyzing U.S. census data to understand the demographics for yourhome and university cityand/orstate.The demographic data will be used to help the sales team devise a targeted sales and marketing plan. AnalysisInstructions a.The assignment requires you to identify/comparecurrent demographics data for the city and/or state of your university and home (e.g., current residence) to answer the questions listed below. UseSt. Louis and Missouri as your university city and state.Ifyour current residence is St. Louis, MO, then pick another state (e.g., birth state) as your home state for comparison purposes. If you don't live in a metro area, choose the closest metro area to your home address where you can find data. b.Access the U.S. Census data at this url: https://www.census.gov c.Familiarize yourself with the Census website. Start by clicking "QuickFacts" on the "Explore Data Main" page to explore some quick facts. If you cannot find answers to the questions from the quick facts, click "GO TO DATA.CENSUS.GOV" on the "Explore Data Main" page and then use the search and advance search function. d.Once you find an answermake screen captures and paste them to the answer sheet. For some questions, you may need to export the table you find to Excel and do some simple calculations. e. Include screen captures of the Census/Exceldata visualizations and tables tosupport your answers. For each questioninclude a shortsentencethat clearly answersthe question,and for question 9 writea short paragraphbased on yourinsight from areview of the datain the other questions.

Question 1: What is the average travel (commute) time to work for individuals in your university and home state metro areas? Question 2: What is the median household income for individuals within your university and home states? Question 3: How does the median income in your university state compare to your home and other states? (Hint: Use a chart or mapto compare the incomes.) Question 4: What is the population of your university and home states? Question 5: Is the population in your university and home statesgrowing or shrinking? By how much? Question 6: What percent of the population within your university and home statesis between the ages of 20 and 60? Question 7: How many individuals in your university and home states take alternative methods, such as cabs, motorcycles or bicycles, to get to work? Question 8: Create a dashboard of two or more tables/charts that you accessed on the census website and paste a screen shot here. Comment on how the dashboard could be used by GBIto develop a targeted sales and marketing plan. Question 9: Comment and provide rationale on which state (your university or home) you would recommend foraGBItargeted sales and marketing plan.