Question

1-Draw a scatter plot of the given CO_{2} levels versus
temperature and write down your observation of the graph about
relationship between CO_{2} levels and temperature.

320.09 | 8 |

321.44 | 9.29 |

322.17 | 9.39 |

323.09 | 8.61 |

324.68 | 8.95 |

325.74 | 8.36 |

326.33 | 9.11 |

327.52 | 8.43 |

329.78 | 8.39 |

330.24 | 8.18 |

331.18 | 9.06 |

332.09 | 9.12 |

333.88 | 8.11 |

335.43 | 7.51 |

336.83 | 7.42 |

338.78 | 7.78 |

340.17 | 8.2 |

340.99 | 8.6 |

342.97 | 8.9 |

344.23 | 8.04 |

345.94 | 7.18 |

347.26 | 7.89 |

349.06 | 7.66 |

351.56 | 8.9 |

352.91 | 9.68 |

354.21 | 9.98 |

355.54 | 8.88 |

356.29 | 9.46 |

356.97 | 8.83 |

358.69 | 10.29 |

360.71 | 10.27 |

362.41 | 8.01 |

363.53 | 9.28 |

366.64 | 9.3 |

368.16 | 9.78 |

369.45 | 9.88 |

371.12 | 9.6 |

373.24 | 9.73 |

375.88 | 10.35 |

377.6 | 9.48 |

379.87 | 9.53 |

381.89 | 9.94 |

383.79 | 10.59 |

Answer #1

1. Bring data in to excel sheet

2. Select both data set and go to insert tab --> select scatter pot diagram.

3.

4. Right click data point and add trend line

5. This trend line shows the relationship of CO_{2}
level and temperature.

6, we have to find correlation coefficient of CO_{2} and
temperature. If correlation between 0.6 to 0.79 is considered as
strong linear relationship.

7. CO_{2 and temperature correlation coefficient value is
0.6}

8. Trend line also clearly explains the relationship is
**positive, and strong linear relationship between
CO**_{2 and
temperature}

_{9. finding correlation formula is
"=CORREL(Array1,Array2)}

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 1 minute ago

asked 12 minutes ago

asked 15 minutes ago

asked 16 minutes ago

asked 21 minutes ago

asked 24 minutes ago

asked 32 minutes ago

asked 34 minutes ago

asked 40 minutes ago

asked 52 minutes ago

asked 1 hour ago