As your boss is not interested in sorting through data on aspreadsheet, you will then write up a professional reportsummarizing your findings. This report should include yourscatterplot graph and any necessary tables. Within your report, inaddition to any appropriate introductions, conclusions, citations,etc. also discussion the following:
• Interpret the correlation coefficient.
• Discuss the hypothesis in order to determine whether thepopulation correlation between the two variables differs fromzero.
• What are the results of the hypothesis test in the context ofthis task (at the 5% significance level)?
• What is the sample regression equation that could enable your topredict property taxes on the basis of the size of a home?
• Using this, predict the property taxes for a home that is 1,500square ft.

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

Random Sample	Property Taxes	Size		Use Excel functions/tools to calculate thecorrelation coefficient, the value of the test statistic, andp-value. Also use Excel to generate a scatterplot with a linearregression line. Paste these results on this sheet.
1	15333	2189
2	16699	2005
3	18440	2090
4	15693	1000
5	43988	5665
6	33684	2573
7	15187	2200
8	16706	1964
9	18225	2092
10	16073	1380