Question
TheP04_12.txtfile is a text file with data about uninsured people in each state for the years 2003-2007. Use Power Query to import this data into
TheP04_12.txtfile is a text file with data about uninsured people in each state for the years 2003-2007. Use Power Query to import this data into an Excel table (not a Data Model) and sort in increasing order of Year. As you will see, this is a wide table, with four columns for every state and only five rows, and it isn't very useful for analysis. It would be better to have a narrow, tall table with columns for Year, State, and the four uninsured numbers/percentages reported. Do whatever it takes to rearrange the data this way. Then create pivot table where you can see any of the numbers/percentages across years for any selected state. (Hint: You could do with a lot of cutting and pasting. However, a better way is to use Excel's INDEX function with clever row and column indexes. For example, the number of uninsured females in Alaska in 2004 can be found with=INDEX(range,2,5), where range is the range of the imported numbers/percentages.) What was the total number of uninsured males for the states of California and Florida in 2007?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started