DATA EXERCISE 1 INSTRUCTIONS 1 
QUESTION 1: Which three states had the largest (positive) change in average weekly earnings over this time period (remember to use the correct units in your answer)?
North Dakota $30.49
Nevada $17.11
Texas $15.42
How does Florida compare to the rest of the states in terms of the change in average weekly earnings?
In comparison to the other states, Florida ranks 25th out of 50 states and this is due to a -$1.00 change in average weekly earnings.
How does New York compare to the rest of the states in terms of the change in average weekly earnings?
In comparison to the other states, New York ranks 38th out of 50 states and this is due to a -$10.45 change in average weekly earnings.
QUESTION 2: How many states experienced an increase in average weekly earnings?
22 states experienced an increase in average weekly earnings.
How many experienced a decrease or no change?
29 states experienced a decrease or no change in average weekly earnings.
What do you think we can say about our national economic recovery based on this information?
Overall, based on this information, our nation’s economy is slowly recovering due to a positive number of states showing increase in average wage compensation.
QUESTION 3: Looking next at percentage changes over time, which three states had the largest increase in average weekly earnings?
North Dakota 3.40%
Nevada 2.46%
Maine 2.07%
Are these three states the same as the three you picked for question 1? If they are different, explain how this can be the case.
No, the three states (North Dakota, Nevada and Maine) are not the same as Question 1. The percentage change uses the midpoint formula, which calculates the average of the range from 2013 and 2014.
How do Florida and New York compare to the rest of the states in terms of their percentage changes in average weekly earnings?
Florida ranks 25th out of 50 states in terms of percentage change in weekly earnings due to a -0.13% decrease.
New York ranks 34th out of 50 states in
North Dakota $30.49
Nevada $17.11
Texas $15.42
How does Florida compare to the rest of the states in terms of the change in average weekly earnings?
In comparison to the other states, Florida ranks 25th out of 50 states and this is due to a -$1.00 change in average weekly earnings.
How does New York compare to the rest of the states in terms of the change in average weekly earnings?
In comparison to the other states, New York ranks 38th out of 50 states and this is due to a -$10.45 change in average weekly earnings.
QUESTION 2: How many states experienced an increase in average weekly earnings?
22 states experienced an increase in average weekly earnings.
How many experienced a decrease or no change?
29 states experienced a decrease or no change in average weekly earnings.
What do you think we can say about our national economic recovery based on this information?
Overall, based on this information, our nation’s economy is slowly recovering due to a positive number of states showing increase in average wage compensation.
QUESTION 3: Looking next at percentage changes over time, which three states had the largest increase in average weekly earnings?
North Dakota 3.40%
Nevada 2.46%
Maine 2.07%
Are these three states the same as the three you picked for question 1? If they are different, explain how this can be the case.
No, the three states (North Dakota, Nevada and Maine) are not the same as Question 1. The percentage change uses the midpoint formula, which calculates the average of the range from 2013 and 2014.
How do Florida and New York compare to the rest of the states in terms of their percentage changes in average weekly earnings?
Florida ranks 25th out of 50 states in terms of percentage change in weekly earnings due to a -0.13% decrease.
New York ranks 34th out of 50 states in