3 INUITIVGI VI IInsally values III 14 Ac Number of missing values in x5 ts b. Which observations have missing values? * Answer is complete but not entirely correct. Observations having missing values are 2, 24 and 32 X c. Omit all observations (rows) that have missing values. How many observations remain in the data set? x Answer is complete but not entirely correct. Number of observations remains in the dataset 49 XThe US Census Bureau records the population for the 50 states each year. The accompanying table shows a portion of this data for the years 2010 to 2018. State 2010 2011 2018 Alabama 4,785, 448 4,798, 834 4,887,871 Alaska 713, 906 722, 038 . : 737, 438 Wyoming 564, 483 567, 224 577,737 ? Click here for the Excel Data File a. Create two subsets of the state population data: one with 2018 population greater than or equal to 5 million and one with 2018 population less than 5 million. How many observations are in each subset? States with 2018 population greater than or equal to 5 million States with 2018 population less than 5 million b. In the subset of states with 5 million or more people, remove the states with over 10 million people. How many states were removed? States with 2018 population greater than 10 million that were removed3 Exercise 1-24 Algo The accompanying data set contains five variables, x1, x2, x3, x4, and x5. There are missing values in the data set. ts Click here for the Excel Data File a. How many missing values are there for each variable? Answer is complete and correct. Number of missing values in x1 Number of missing values in x2 20 Number of missing values in x3 Number of missing values in x4 3 Number of missing values in x5 b. Which observations have missing values? x Answer is complete but not entirely correct. Observations having missing values are 2, 24 and 32 X