(a) Make an Excel scatter plot of X = 1990 assault rate per100,0000 population and Y = 2004 assault rate per 100,100 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?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.