i NEED HELP ON HOW TO GET THE SCATTER PLOT

UploadUS crimedata and compare the burglary counts for the states ofHawaii, California, ArizonaandNevada. Your job is to identify which of the three states ismost correlatedtoCalifornia. Make scattered plot chart withX representing Californiaand Y representing that state in question, plot the line and compute the R-square. Answer questions 5 to 8:

5. What are the approximate slope and the R-squares on your chart? (4 points)

• a. Slope=0.048 and R-square=0.9086
• b. Slope=18.841 and R-square=0.9086
• c. Slope=0.0287 and R-square=0.7959
• d. Slope=27.753 and R-square=0.7959

6. Interpret the slope based on the chart. (4 points)

• a. One expects 0.0287 burglaries in Hawaii when there are no burglaries in California.
• b. For 100 additional burglaries in California one expects to see an increase of about 3 burglaries in Hawaii.
• c. For one additional burglary in Hawaii one expects to see an increase of about 19 burglaries in California.
• d. For 100 additional burglaries in California one expects to see an increase of about 5 burglaries in Hawaii
• e. For one additional burglary in Hawaii one expects to see an increase of about 28 burglaries in California.

7. What is the approximate Y-intercept and what is its statistical interpretation? (4 points)

• a. Y-intercept=18607. It is the predicted number of burglary in California when there are no burglaries in Hawaii
• b. Y-intercept=0.0287. It is the predicted number of burglary in Hawaii when there are no burglaries in California
• c. Y-intercept=27.753. For one additional burglary in Hawaii one expects to see an increase of about 28 burglaries in California
• d. Y-intercept= 1912.4. It is the predicted number of burglary in Hawaii when there are no burglaries in California

8. The highest dot on your chart has (approximately) the following X-coordinate. (4 points)

• a. 17822
• b. 545138
• c. 540806
• d. 16726