I have seen other people post multiple questions like this, and there questions have been answered. I don't know what you need in order to answer these questions. PLEASE I NEED HELP.

A Lab4/Task1 c\"! 'C . c a E: 4 g?\" . LG Open the File: US CRime.txt. Produce a chart with a scatter plit, where the X-axis contains the number of robberies in Oregc while the Yaxis 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? Aa. A crime A b. A state Ac. A murder A d. A year 2. What is the slope of the trend line (round to 2 decimal places)? Aa. 1.31 A b. 0.85 Ac. 0.67 Ad. 0.45 3. What is the highest number of robberies recorded for Kentucky? (pick the best answer) Aa. 4001 A b. 4332 Ac. 4076 Ad. 5555 4. What is the approximate average number of robberies for Oregon? (pick the best answer) Aa. 2500 A b. 3000 Ac. 3500 Ad. 4000 A Lab 4 I Task 2 Open the Tornadoes data and create the chart below: 140 120 Tornadoes In August . Vi" 0.1512x+42.314 Tornadoes In US III-0.0838 O O . . . ' 0 Q. o O Q. ' 0 o O Q . O O 9 Q. 3 O . O I T I I I I O 50 100 150 200 250 300 Tomadoesin April 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 Task 2 Task 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) Correlation ? X Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 7 20 21 15 61 28 23 13 3 2 4 Input Input Range: $C$4:$N$ 49) OK 2 10 6 26 57 76 23 27 9 2 12 10 Cancel 12 27 43 37 34 34 27 16 0 F 3 Grouped By: Columns 14 16 40 47 94 111 32 24 5 6 12 21 Rows Help 2 17 62 113 101 107 45 49 21 14 2 17 Labels in First Row 3 4 43 99 148 153 49 33 15 23 20 3 Output options 29 11 157 204 335 216 64 46 26 21 20 3 Output Range: 15 29 55 53 137 399 213 115 81 34 146 20 New Worksheet Ply: 17 34 48 85 177 213 242 112 65 55 19 6 New Workbook 13 9 58 205 161 234 155 120 30 51 42 4 Then click on Input Range space and highlight the desired data. Be sure to highlight the Months labels. The final result: Click OK and the following table should appear:Rows Help Labels in First Row N 17 62 113 101 107 45 49 21 14 2 17 4 43 99 148 153 49 33 15 23 20 3 Output options 29 11 157 204 335 216 64 46 26 21 20 3 Output Range: 15 29 55 53 137 399 213 115 81 34 146 20 New Worksheet Ply: 17 34 48 85 177 213 242 112 65 55 19 6 New Workbook 13 9 58 205 161 234 155 120 30 51 42 4 Then click on Input Range space and highlight the desired data. Be sure to highlight the Months labels. The final result: Click OK and the following table should appear: Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Jan Feb 0.01 Mar 0.23 0.21 1 Apr 0.31 -0.22 0.27 1 May 0.29 0.05 0.38 0.37 June 0.25 0.26 0.28 0.33 0.45 1 July 0.13 0.15 0.03 -0.02 0.11 0.59 1 Aug 0.01 -0.03 -0.05 0.29 0.13 0.43 0.63 1 Sept 0.39 -0.01 0.15 0.11 0.16 0.33 0.41 0.27 1 Oct 0.05 0.12 0.01 0.46 0.09 0.55 0.44 0.56 0.42 1 Nov 0.17 -0.06 0.01 -0.04 0.12 0.34 0.37 0.24 0.3 0.01 1 Dec 0.33 0.08 0.01 0.15 0.36 0.21 0.08 -0.13 0.27 -0.1 0.17 1Use the Tornadoes data and find two months (month X and month Y) for which we have the strongest correlation. Create a chart where the X-axis and the Y-axis represent the number of tornadoes for month X and month Y respectively. Properly label the chart and be sure the you have the fitted line as well as R-squared and answer the questions. Put in the X-axis the month that comes earlier (example May comes before September). cu: 'E