The attached CSV file contains age adjusted death rates (based upon 100,000 people) and average annual percent change (trend) over 5 years from 2016-2020 for pancreatic cancer for all ages, races, and both sexes in the United States. 95% confidence intervals for the death rate and trend are also included. Data were generated from the CDC State Cancer Profile website with the following filters selected (State Cancer Profile). Follow the instructions and answer ALL of the questions below:
I. Read the dataset into RStudio using the read.csv() function. pancreatic_cancer2.csv
II. Using the micromapST() function, create a linked micromap that contains the following features and formatting exactly as follows:
i. The first column should display the maps where states are highlighted from the extremes to the middle state.
ii. The second column should display the names of the states and their corresponding colors (full names or abbreviations are acceptable).
iii. The third column should display the confidence intervals for age-adjusted death rates.
iv. The fourth column should display the confidence intervals for the recent 5-year trend and a reference line at zero.
v. The rows should be sorted according to the recent 5-year trend in decreasing order from top to bottom.
vi. Appropriate titles and labeling should be included to completely and accurately describe the information in the micromap and in each column including the source of the information.