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

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Topic Video
Question

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
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
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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON