The file P18_03.xlsx is the result of importing a text (.txt) file into Excel. The first column
Question:
The file P18_03.xlsx is the result of importing a text (.txt) file into Excel. The first column should be Year, and this should be followed by four columns for each state: the number and the percentage of females without health insurance and similar data for males. Starting in row 202, you can see that the numbers were imported correctly. However, the variable names that should all be in row 1 were imported badly. Do whatever it takes to get the correct labels in row 1, with the corresponding numbers below them in rows 2-6. You can shorten the labels to Virginia Male Pct, for example. Then create a time series chart that contains a few time series variables of your choice?
Step by Step Answer:
Business Analytics Data Analysis And Decision Making
ISBN: 1209
6th Edition
Authors: S. Christian Albright, Wayne L. Winston