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

(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:**## Answer to relevant Questions

(a) Make an Excel scatter plot of X = airspeed (nautical miles per hour) and Y = cockpit noise level (decibels) for 61 aircraft fights. (b) Use Excel's =CORREL function to find the correlation coefficient. (c) What do the ...Given P(A) = .40, P(B) = .50, and P(A ∩ B) = .05, find (a) P(A ∪ B), (b) P(A | B), and (c) P(B | A). (d) Sketch a Venn diagram. Let S be the event that a randomly chosen female aged 1824 is a smoker. Let C be the event that a randomly chosen female aged 1824 is a Caucasian. Given P(S) = .246, P(C) = .830, and P(S ∩ C) = .232, find each ...Suppose 50 percent of the customers at Pizza Palooza order a square pizza, 80 percent order a soft drink, and 40 percent order both a square pizza and a soft drink. Is ordering a soft drink independent of ordering a square ...A study showed that 60 percent of The Wall Street Journal subscribers watch CNBC every day. Of these, 70 percent watch it outside the home. Only 20 percent of those who don't watch CNBC every day watch it outside the home. ...Post your question