Within the Excel spreadsheet, use the Excel tools/functions to calculate the correlation coefficient, test statistic, and the p-value. You will also use Excel to generate a scatterplot of your sample data with a linear regression (line of best fit) model. All of these results should be shown on the Excel spreadsheet.

As your boss is not interested in sorting through data on a spreadsheet, you will then write up a professional report summarizing your findings. This report should include your scatterplot graph and any necessary tables. Within your report, in addition to any appropriate introductions, conclusions, citations, etc. also discussion the following:

? Interpret the correlation coefficient.

? Discuss the hypothesis in order to determine whether the population correlation between the two variables differs from zero.

? What are the results of the hypothesis test in the context of this task (at the 5% significance level)?

? What is the sample regression equation that could enable your to predict property taxes on the basis of the size of a home?

? Using this, predict the property taxes for a home that is 1,500 square ft.

This should be written as if you were writing a professional report to your employer.

A B C D E F G H K M N O P Q Paste the random sample of data 2 from 10 homes below Random Property Use Excel functions/tools to calculate the correlation coefficient, the value of the test statistic, and p-value. Also use 3 Sample Taxes Size Excel to generate a scatterplot with a linear regression line. Paste these results on this sheet. 1 15333 2189 16699 2005 3 18440 2090 A 15693 1000 5 43988 5665 6 33684 2573 10 7 15187 2200 11 16706 1964 12 18225 2092 13 10 16073 1380 14