Question: Open the file StatePoverty 2 0 2 2 . xlsx which contains Census Bureau estimates for the number of persons below the poverty level in

Open the file StatePoverty2022.xlsx which contains Census Bureau estimates for the number of persons below the poverty level in 2022. Sort the data to determine which states have the most people below the poverty level. (If you are having trouble with the link, right click it and choose download).
Excel Instructions: There are two ways to sort. The easiest way, which only works correctly if your data is not separated by blank columns or rows, is as follows: First click in the top cell of the column you want to sort by. Then click either ascending button (At the upper right of the tool bar) or descending button to sort ascending or descending (under the Home Tab) as the case may be. A second method of sorting that gives more control over the process is as follows: Select all the data you would like to sort, except the header information. Typically this means selecting all the columns you are working with. Then from the Data Tab choose:
Assignment1c.jpg
A window will then give you many sort options.
Now list the two states with the most people below the poverty line and in a sentence explain why we can't necessarily conclude that these two states are the poorest. Think about whether or not these numbers are absolute or relative.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!