Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question: The data setReal Estatecontains information on the listings of 1,047 real estate properties. Treating this data set as the population, use EXCEL to calculate
Question: The data setReal Estatecontains information on the listings of 1,047 real estate properties.
- Treating this data set as the population, use EXCEL to calculate the population mean of the Price variable. Report this value and include the EXCEL output.
- Use EXCEL to produce a histogram of the Price variable and include the output. Explain if the means of all possible random samples of size 30 from this population would form a normal distribution.
- Now use EXCEL to draw 300 samples of size 1, 10, and 30 from this real estate population and calculate the mean and standard deviation of the sample means and include your outputs.
- Use EXCEL to draw histogram of the sample means of size 1, 10 and 30 and include your outputs. Do they look mound shaped? Why or why not?
- Find the theoretical mean and standard deviation of the statistics involved in (c). Compare the mean and standard deviation of each generated empirical distribution with those of the respective theoretical distributions. Fill out the following table:
n | Distribution (Approx.) | Theoretical | Empirical | |
- | - | ? |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started