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.
Step by Step Answer:
Business Analytics Communicating With Numbers
ISBN: 9781260785005
1st Edition
Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen