MS 150 Statistics Fall 2004 Q11 • Name:

Global warming?

The data set is too large to type in manually. Obtain the data set by right-clicking with the right mouse button on the link below and choose "Save target as..." to save this file to your computer. The file can then be opened with Excel.
Pohnpei Average Maximum Temperature data
The data is the average maximum temperature by year for Pohnpei. This average consists of the daily high temperature in Celsius. This is actual data obtained in 2003.

  1. __________ Find the sample size n for the temperature data.
  2. __________ Find the minimum temperature.
  3. __________ Find the maximum temperature.
  4. __________ Find the range of the temperature.
  5. __________ Find the median temperature.
  6. __________ Find the mode for the temperature.
  7. __________ Find the sample mean temperature.
  8. __________ Find the sample standard deviation for the temperature.
  9. __________ Find the sample coefficient of variation CV for the temperature.
  10. __________ Calculate the slope of the linear trend line (also known as best fit line, least squares, linear regression) for the year versus temperature.
  11. __________ Calculate the y-intercept for the data.
  12. __________ Is the correlation positive, negative, or neutral?
  13. __________ Determine the correlation coefficient r.
  14. __________ Is the correlation none, low, moderate, high, or perfect?
  15. __________ Does the relationship appear to be linear or non-linear?
  16. __________ Determine the coefficient of determination.
  17. __________ What percent in the variation in the year variable accounts for the variation in temperature variable?
  18. __________ Based on the equation of the linear trend line, what should be the mean annual temperature for the year 2003?
  19. __________ Based on the equation of the linear trend line, what year was predicted to have a mean annual temperature of 31 Celsius?
  20. __________ Based on the equation of the linear trend line, what year is predicted to have a mean annual temperature of 32 Celsius??
Table of statistical functions used by Excel
Statistic or Parameter Symbol Equations Excel
Slope b =SLOPE(y data, x data)
Intercept a =INTERCEPT(y data, x data)
Correlation r =CORREL(y data, x data)
Coefficient of Determination =(CORREL(y data, x data))^2