Question: (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

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

Step by Step Solution

★★★★★

3.34 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b r 8332 c Graph says that these two years are strongly correlated If a state had ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

485-M-S-S-I (1797).docx

120 KBs Word File

Students Have Also Explored These Related Statistics 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...

(a) Make an Excel scatter plot of X = percent change in U.S. real GDP and Y = percent change in U.S. personal consumption expenditures 20002015. (b) Describe the relationship (if any). Weak? Strong?...

(a) Make an Excel scatter plot of X = weekly closing price of Dolana stock and Y = weekly closing price of ZalParm stock over 52 consecutive weeks. (b) Describe the scatter plot. (c) Calculate the...

Violent crimes include rape. robbery, assault, and homicide. The following Is a summary of the violent-crime rate (violent crimes per 100.000 population) for all states of a country in a certain year...

weber and rate (per 100 000 resident population in each group) of sentenced prisoners under jurisdiction of State and Federal correctional authorities on December 31 ly Ma, United States, 1923-2012...

The time plot in the figure below gives the number of state and federal prisoners per 100 000 population t 450 400 350 300 Number per 100 000 250 200 150 100 50 OL 1980 1982 1984 1986 1988 1990 1992...

Using the article Comparing Crime Rates between Undocumented Immigrants, Legal Immigrants, and Native-born US citizens in Texas, write a 2-3 page-paper (double-spaced, 1-inch margins, times roman...

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

2. Is there anything that the pharmaceutical industry has done or is now doing in the aftermath of that crisis that could legitimately be considered as unethical by its stakeholders? What grade would...

The computer department of a certain city, a General Fund department, charges other funds for data processing services. At the end of the fiscal year, the General Fund is owed $5,000 by the City...

Use the Target Corporations annual report in Appendix B to answer the following questions related to Targets 2009 fiscal year. Required a. What percentage of Targets total revenues end up as net...

If a bond is purchased at a price above the face value, the yield to maturity is: Question 230 options: greater than the stated interest rate. the same as the stated interest rate. less than the...

Which of the following characteristics best describes Lewis antibodies? a. IgM, naturally occurring, cause HDN b. IgM, naturally occurring, do not cause HDN c. IgG, in vitro hemolysis, cause...

The weights (in pounds) of a sample of five boxes being sent by UPS are 12, 6, 7, 3, and 10. a. Compute the range. b. Compute the standard deviation.

Health issues are a concern of managers, especially as they evaluate the cost of medical insurance. A recent survey of 150 executives at Elvers Industries, a large insurance and financial firm...

The Apollo space program lasted from 1967 until 1972 and included 13 missions. The missions lasted from as little as 7 hours to as long as 301 hours. The duration of each flight is listed below. a....

A firm has inventory on 1/1/2019 of RO 98,000, the purchases during the year amounted to RO 56,000 and the closing inventory is RO 73,000. The firm adopts retail price index and the index on 1/1/2019...

Telephone Calls A researcher knew that before cell phones, a person made on average 3.2 calls per day. He believes that the number of calls made per day today is higher. He selects a random sample...

Let X be a random variable, which has a density function f depending on the parameter > 1 f ( x ; ) = {( 1 ) ( x 2 ) 2 , when 2 3 and 0 , otherwise. We have a random sample ( X 1 , ... , X n ) , the...