(a) Make an Excel scatter plot of X = 1990 assault rate per 100,000 population and Y = 2004 assault rate per 100,000 population for the 50 U.S. states.
(b) Use Excel's =CORREL function to find the correlation coefficient.
(c) What do the graph and correlation coefficient say about assault rates by state for these two years?
(d) Use MegaStat or Excel to find the mean, median, and standard deviation of assault rates in these two years. What does this comparison tell you?