Do all of the work and analysis below with the Database Virginia Park Temperature Readings.xlsx

A)

1. Obtain the mean and standard deviation of annual temperature in a Virginia Park. 2. Obtain a five-number summary and interquartile range of the annual temperature in Virginia Park. Are there any outliers? (use the fences to identify outlier if any) 3. Construct a boxplot and use it to investigate the data for outliers 4. Construct a histogram and normal probability plot (QQ plot) for annual temperature.

B)

5. Construct and interpret a 95% confidence interval for , for the mean annual temperature. 6. Using regression analysis ( hint use a scatter plot, r r² ) investigate if there is a relationship between year and temperature in Virginia Park. 7. If there is a relationship, provide an equation that can be used to predict temperature based on year. Comment on how reliable and useful the model (equation) is in predicting temperature

C) Write a brief introduction of the project Interpret the mean, and standard deviation in the context of the data given Compare the measures of center and comment on which measure of the center would best describe the data given

Comment on the shape of the distribution, Are there any outliers in the data? Include results of your investigation for outliers and identify the outlier

Comment on your assessment of normality. Which test will be most appropriate for the inferential statistics (confidence Interval)? Z-test or t-test? Why?

Write interpretation for the confidence interval estimate in context of the data State the summary, interpretation, and conclusion of your investigation if there is a relationship between year and temperature in the Virginia park

Virginia Park Temperature Readings.xlsx