Refer to the previous exercise for a description of the data set. a. Create a new variable

Question:

Refer to the previous exercise for a description of the data set.

a. Create a new variable called “Difference” that contains the difference between the 2018 population and the 2017 population for each state (i.e., 2018 population - 2017 population). What is the average difference?

b. Create a new variable called “PercentDifference” that contains the percent difference between the 2017 and 2018 population values for the states (i.e., (2018 population - 2017 population)/2017 population). What is the average percent difference?

c. Create a new variable called “Log” that contains the natural logarithms for the 2018 population values for the states. Bin the logarithm values into five equal-interval groups. Label the groups using numbers 1 (lowest values) to 5 (highest values). How many observations are in group 2?

d. Create a new variable called “SquareRoot” that contains the square root of the 2018 population values for the states. Bin the square root values into five equal-interval groups. Label the groups using numbers 1 (lowest values) to 5 (highest values). How many observations are in group 2?

e. Compare the groups in parts c and d. Are the groupings the same or different?

Data from Exercises 43

The U.S. Census Bureau records the population for the 50 states each year. The accompanying table shows a portion of these data for the years 2010 to 2018.