Question: a Make an Excel scatter plot of X 1990

(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?

View Solution:


Sale on SolutionInn
Sales0
Views125
Comments
  • CreatedAugust 19, 2015
  • Files Included
Post your question
5000