Lab 4.docx - Lab 4 Task 1 Open the File US_CRime Produce a...

This preview shows page 1 - 4 out of 10 pages.

Lab 4 / Task 1 Open the File: US_CRime.txt . Produce a chart with a scatter plot , where the X-axis contains the number of robberies in Oregon while the Y-axis contains the number of robberies in Kentucky . Fit the trend line. Answer questions 1 to 4. (pick the answer that fits best) 1. What does each dot represent? a. A crime b. A state c. A murder d. A year Correct Answer
2. What is the slope of the trend line (round to 2 decimal places)? Correct Answer
3. What is the highest number of robberies recorded for Kentucky? (pick the best answer)
4. What is the approximate average number of robberies for Oregon? (pick the best answer) Correct Answer
c. 3500 d. 4000 Lab 4 / Task 2 Open the Tornadoes data and create the chart below:
Hints: Cut & paste the data next to each other (and in an appropriate order) To get the line right click on chart’s upper right corner until a big PLUS sign appears Click on it and look for Add trendline and then choose More Options At the bottom you will find the tab for equation as well as R-squared. Lab 4 / Task 3 Here is video link as well: Computation Getting the Correlation tab: Click on Data Data Analysis Correlation tabs respectively. (If Data Analysis tab is missing you need to install it)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture