murder rank in the Northern Central Region (nt: use rank(), row_number()) e. How many states

Using dplyr functions (i.e., filter, mutate ,select, summarise, group_by etc. ) and “murder” dataset (available in dslab R package) and write appropriate R syntax to answer the followings: a. Calculate regional total murder excluding OH, AL, and AZ (nt: filter(! abb %in% x) # here x is the exclusion vector) b. Display the regional population and regional murder numbers. c. How many states are there in each region? (nt: n ()) d. What is Ohio’s murder rank in the Northern Central Region (nt: use rank(), row_number()) e. How many states have murder number greater than its regional average (nt: nrow() ) f. Display 2 least populated states in each region (nt: slice_min() ) Use pipe %>% operator for all the queries.