Sir, I am stuck on this question

only 5b

Link for 5b: http://www.city-data.com/city/Aurora-Colorado.html

i will attach the drive link for 5a

https://drive.google.com/drive/folders/1IQIr4Wmkqglqtd-f7J_KvxdPXQvOU2qF?usp=sharing

You MUST use correct commands in Excel or Google sheets to complete this project. Please make sure you organize your file neatly. Write the question number and actual question you are solving and put things in order in an organized manner. Use the appropriate notation and tables as demonstrated in the eText and course materials. Round all numbers to the nearest whole number, and round the standard deviation to the hundredths place for all problems on this project. Make sure your project is neatly typed, includes a cover page, and each portion is labeled (include original problem and problem number) Here are some resources to help create graphs: - Data Set for the project . Google Sheets Calculations Video . Pie Chart in Google Sheets . Organizing data to make pie charts in Google Sheets and more detail on how to create . Bar Graphs in Google Sheets - Histogram in Google Sheets . Making Frequency Distribution Tables You will use the following data set to answer all part of the project. This data set is the overall Enrollment by Race/Ethnicity for CCA from 2011-2020. 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Total African American 3044 3289 3307 2884 2704 2352 2330 2380 2287 2476 27053 American Indian/Alaskan Native 142 224 207 226 197 171 191 234 204 199 1995 Asian/Pacific Islands 788 893 932 912 893 817 883 1035 985 1121 9259 Hispanic 1903 2161 2394 2453 2543 2480 2959 3517 3507 4048 27965 White 5015 5308 5266 4886 4505 4042 3971 3809 3616 3713 44131 Unknown 742 702 692 582 515 667 681 803 753 636 677353) Calculate the total number of students of each ethnicity/race in a new row. Use Google Sheets of Excel to make a bar graph and a pie chart showing ethnicity/race totals (one bar graph for total ethnicity numbers and one pie chart). 5b) Compare your graph and chart to the data for Aurora from City Data. How does the ethnicity/race break down at CCA compare to Aurora? Why would someone want to know and use this information? Explain in at least 200 we