Respuesta :

Answer:

See attached image.

Step-by-step explanation:

See the attached image.

Use Microsoft Excel to produce a scatter chart.

Ver imagen rspill6

The correlation coefficient is -0.12 and the line of the best fit is y = -0.11x + 385.50

What is correlation?

It is defined as the relation between two variables which is a quantitative type and gives an idea about the direction of these two variables.

[tex]\rm r = \dfrac{n(\sum xy)-(\sum x)(\sum y)}{\sqrt{{[n\sum x^2- (\sum x)^2]}}\sqrt{[n\sum y^2- (\sum y)^2]}}[/tex]

 

From the table, the value of r:

r = -0.12

The negative correlation exist between year and time.

Since the value of r is not near the -1 or -1 we can say the relation is very weak.

The line of best fit:

y = mx + c

m = -0.11

c = 385.50

y = -0.11x + 385.50

Thus, the correlation coefficient is -0.12 and the line of the best fit is y = -0.11x + 385.50

Learn more about the correlation here:

brainly.com/question/11705632

#SPJ2

Ver imagen maheshpatelvVT
ACCESS MORE