A study was conducted in the US to find out if a relationship between cancer mortality and latitude existed The data collected is shown below State Latitude (Degrees) (x) Mortality (number of deaths per years per 1000 people) (y) Arizona 34 5 160 Colorado 39 149 Connecticut 41 159 Florida 28 210 Georgia 33 200 Idaho 44 5 116 Iowa 42 2 128 Kansas 38 5 166 Louisiana 31 2 190 Maine 45 2 117 Minnesota 46 116 New Jersey 40 2 159 New York 43 145 North Carolina 35 5 180 South Carolina 33 8 178 Virginia 37 5 166 Washington 47 5 117 (6 marks) Plot the data on a scatter plot You are allowed to use Excel to make this graph Based on this graph, does it seem to exist a linear correlation between latitude and mortality in the US (6 marks) Back up your argument with the calculation of the coefficient of linear correlation (r) You must clearly show all steps used in your calculations You can round the numbers to two decimal places You can use Excel to check your answer, but you must present all steps and formulas involved in the calculation of r (6 marks) Determine the equation of the line of best fit You must clearly show all steps used in your calculations You can use Excel to check your answer, but you must present all steps and formulas involved in the formulation of the line of best fit equation You can round the coefficients of the equation to two decimal places

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 27, 2024

A study was conducted in the US to find out if a relationship between cancer mortality and latitude existed. The data collected is shown below:

State	Latitude (Degrees) (x)	Mortality (number of deaths per years per 1000 people) (y)
Arizona	34.5	160
Colorado	39	149
Connecticut	41	159
Florida	28	210
Georgia	33	200
Idaho	44.5	116
Iowa	42.2	128
Kansas	38.5	166
Louisiana	31.2	190
Maine	45.2	117
Minnesota	46	116
New Jersey	40.2	159
New York	43	145
North Carolina	35.5	180
South Carolina	33.8	178
Virginia	37.5	166
Washington	47.5	117

(6 marks) Plot the data on a scatter plot. You are allowed to use Excel to make this graph. Based on this graph, does it seem to exist a linear correlation between latitude and mortality in the US?
(6 marks) Back up your argument with the calculation of the coefficient of linear correlation (r). You must clearly show all steps used in your calculations. You can round the numbers to two decimal places. You can use Excel to check your answer, but you must present all steps and formulas involved in the calculation of "r".
(6 marks) Determine the equation of the "line of best fit". You must clearly show all steps used in your calculations. You can use Excel to check your answer, but you must present all steps and formulas involved in the formulation of the "line of best fit" equation. You can round the coefficients of the equation to two decimal places.