The following test will determine your best fit in the class - Track 1, the basic data or Track 2, more advanced data. I think some people will migrate from Track 1 to Track 2 over the course of the semester. Others may stay in Track 1. That's fine. I just want to have a decent fit for everyone. The task involves following the instructions below to download data, make calculations in Excel and build a Tableau chart with per capita calculations. Download data: master_file_jan7.csv --This is the Arkansascovid.com data file as of Jan 7, 2021 --"positive" represents total positive cases --Arkansas_all_counties in "county_nam" represents the statewide totals --pop_5yr_est_2018 represents the 2018 population Load the data in a Google Sheet. --Create a new column with the positive per capita calculation Stumped? Consult Excel Refresher here. Create a Google Doc and answer the following questions: 1) What day did the state reach 7% of the population or 0.07 cases per capita? (Question clarified Jan 11) 2) Which county had the highest per capita rate in Jan 1, 2021? 3) Supply the rates for Washington County and its contiguous counties on Jan 1. 2021. 4) Create a separate tab in the spreadsheet, listing just the following: top 10 counties per capita as of Nov. 26, with the date, county, positive, pop_5yr_est_2018, and your per capita calculation, sorted highest to lowest 5) Find the per capita statewide rate for Jan 7, 2021. List the counties were above the statewide rate. 6) Upload your spreadsheet as a Google Sheet with these calculations and the second tab with the top 10 counties per capita. Use Flourish, Tableau Public or Desktop to create bar chart: (updated 9/7 with Flourish option) --Counties above the statewide per capita rate on Jan 7, 2021. --Have a news headline and proper sourcing. --Do a screenshot or export an image file of your chart. Tableau --Consult this tutorial to build a Tableau chart. --Embed the Tableau image in your Google Doc. Post all of your answers and links to a single Google Doc. Post a link to that Google Doc (make sure I can edit it!) on Blackboard by 11:59 pm Tuesday If you can't figure out something, do as much as you can and explain what you can't figure out. Do not spend more than two hours on this exercise.