MAT 312 PLEASE HELP After being hired as a financial advisor for a large real estate company, you have been tasked with exploring trends between home size (square ft) and property taxes to see if a relationship exists and if that trend can be applied outside of just the sample data. In the Excel Lab #5 Data File, you will find raw data on sheet 1. However, to simplify your calculations, you have only been asked to test a random sample of 10 homes. So, your first step will be to randomly select data from 10 of the homes and paste them into sheet 2 called “sample data”. This will be the data that you will analyze. (You can generate 10 random numbers between 5 and 30 however you want for your sample, but know that there is essentially no chance two students should have the same 10 samples). Within the Excel spreadsheet, use the Excel tools/functions to calculate the correlation coefficient, test statistic, and 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. Don’t forget to put your name on the first sheet of the spreadsheet as this will be uploaded as an Excel file to Canvas. 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 discuss 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, not an outline of tasks you did for a project in stat class. You can find a sample report (for a different type of test!) on page 536 in the textbook to see how a statistical report can look. Raw Data: randomly select 10 homes from the list below and copy/paste them into the second sheet called "sample data" Property Taxes Size 21928 2449 17339 2479 18229 1890 15693 1000 43988 5665 33684 2573 15187 2200 16706 1964 18225 2092 16073 1380 15187 1330 36006 3016 31043 2876 42007 3334 14398 1566 38968 4000 25362 4011 22907 2400 16200 3565 29235 2864 16745 1010 43900 5602 35478 2698 15333 2189 16699 2005 18440 2090 Transcribed Image Text:Paste the random sample of data from 10 homes below Use Excel functions/tools to calculate the correlation coefficient, the value of the test statistic, and p- Random Property value. Also use Excel to generate a scatterplot with a linear regression line. Paste these results on this Sample Taxes Size sheet. 1. 2 3 4 5 6 8 9 10
MAT 312 PLEASE HELP
After being hired as a financial advisor for a large real estate company, you have been tasked with exploring trends between home size (square ft) and property taxes to see if a relationship exists and if that trend can be applied outside of just the sample data.
In the Excel Lab #5 Data File, you will find raw data on sheet 1. However, to simplify your calculations, you have only been asked to test a random sample of 10 homes. So, your first step will be to randomly select data from 10 of the homes and paste them into sheet 2 called “sample data”. This will be the data that you will analyze. (You can generate 10 random numbers between 5 and 30 however you want for your sample, but know that there is essentially no chance two students should have the same 10 samples).
Within the Excel spreadsheet, use the Excel tools/
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 discuss 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, not an outline of tasks you did for a project in stat class. You can find a sample report (for a different type of test!) on page 536 in the textbook to see how a statistical report can look.
| Raw Data: randomly select 10 homes from the list below and copy/paste them into the second sheet called "sample data" | |
| Property Taxes | Size |
| 21928 | 2449 |
| 17339 | 2479 |
| 18229 | 1890 |
| 15693 | 1000 |
| 43988 | 5665 |
| 33684 | 2573 |
| 15187 | 2200 |
| 16706 | 1964 |
| 18225 | 2092 |
| 16073 | 1380 |
| 15187 | 1330 |
| 36006 | 3016 |
| 31043 | 2876 |
| 42007 | 3334 |
| 14398 | 1566 |
| 38968 | 4000 |
| 25362 | 4011 |
| 22907 | 2400 |
| 16200 | 3565 |
| 29235 | 2864 |
| 16745 | 1010 |
| 43900 | 5602 |
| 35478 | 2698 |
| 15333 | 2189 |
| 16699 | 2005 |
| 18440 | 2090 |
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
