I’m working on a mathematics spreadsheet and need a sample draft to help me study.
Open the excel workbook called Density. The first column indicates a states two-letter abbreviation and the second column indicates the number of people per square mile. We want to classify each state as having low population density, medium population density, or high population density. States with low population density have less than 75 people per square mile. States with medium population density have at least 75 people per square mile, but less than 200 people per square mile. States with at least 200 people per square mile have a high population density. Label column C Population Density. In column C of the spreadsheet, have excel classify each state’s population density as being one of “low”, “Medium”, or “HIGH”.