Name: ______________________________

Use the following data for the quiz. The x data is in the second column and the y data is in the third column. Use Excel to perform your calculations. The data refers to World Heritage Sites, sites of immense cultural and historic importance. Nan Madol and the Lelu ruins are sites of such importance.

Region | Countries (x) | Percent with World Heritage Sites (y) |
---|---|---|

North America | 2 | 100 |

Europe | 47 | 82.98 |

Latin America | 32 | 62.5 |

Asia | 43 | 55.81 |

Africa | 54 | 29.63 |

Oceania | 14 | 14.29 |

- __________ What is the slope of the best fit linear trendline?
- __________ What is the intercept of the best fit linear trendline?
- __________ What is the correlation coefficient r for the best fit linear trendline?
- __________ What is the coefficient of determination for the best fit linear trendline?
- __________ If a continent had 20 countries, use the trendline equation to predict the number of World Heritage Sites?
- __________ If 65 percent of the countries on a continent have World Heritage Sites, how many countries would we predict that continent to have?
- __________ Are World Heritage Sites distributed evenly according to the number of countries in each continental region?