i NEED HELP ON HOW TO GET THE SCATTER PLOT
Upload US crime data and compare the burglary counts for the states of Hawaii, California, Arizona and Nevada. Your job is to identify which of the three states is most correlated to California. Make scattered plot chart with X representing California and 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
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
