0% found this document useful (0 votes)
8 views2 pages

Real Estate Statistics Assignment 2024

The document outlines an assignment for an MBA/EMBA course on Statistics for Economists, requiring students to analyze Real Estate data using Excel. Students must perform various statistical exercises, including creating frequency tables, confidence intervals, hypothesis testing, and regression analysis. The assignment is due by April 6, 2024, at 11:59 p.m.

Uploaded by

sadia.t96
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views2 pages

Real Estate Statistics Assignment 2024

The document outlines an assignment for an MBA/EMBA course on Statistics for Economists, requiring students to analyze Real Estate data using Excel. Students must perform various statistical exercises, including creating frequency tables, confidence intervals, hypothesis testing, and regression analysis. The assignment is due by April 6, 2024, at 11:59 p.m.

Uploaded by

sadia.t96
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

X UNIVERSITY

MBA/EMBA PROGRAM
SPRING- 2024
Course Title: Statistics for Economists 2
Course Code: Section -

Assignment using Excel. Marks:50


First enter the Real Estate data into the Excel Program you are supplied with. Assume the
105 homes is population.
Select a sample of size ------- and answer the following exercises using your sample data.
Exercise 1: Refer to the Real Estate data, which report information on homes sold in the
area last year.
a) Determine a frequency table and relative frequency table from the variable
“Township” and interpret.
b) Select an appropriate class interval and organize the “Selling prices” into a frequency
distribution table and interpret and Prepare a a histogram simultaneously.
c) Compute the Mean, Median, Mode, Range, Standard Deviation, Variance, Quartiles,
85th Percentile of “Selling price” from the raw data of your sample and interpret.
Determine the skewness and interpret.
Exercise 2: Develop a Bar Diagram and also a Pie chart for the variable “Township”. Interpret both
the charts
Exercise-3: a) Develop a 99 percent confidence interval for the mean selling price of the homes.
interpret.
b) Develop a 95 percent confidence interval for the mean size of homes. And interpret.
Exercise-4:
a) A recent article in The Daily Newspaper indicated that the mean selling price of the homes in the
capital city is $357(thousand). Can we conclude that the mean selling price in the capital city is not
different from$357(thousand)? Use the 0.05 significance level.
b) The same article reported that the mean size in the capital city was 3400 square feet. Can we conclude
that the mean size of homes sold in the city area is not different from 3400 square feet? Use the 0.05
significance level.
[Note: Test using p=value for both (a) and (b)].

Exercise-5:
a) At the .05 significance level, can we conclude that there is a difference in the mean
selling price of homes with a pool and homes without a pool?
b) At the .05 significance level, can we conclude that there is a difference in the mean
selling price of homes with an attached garage and homes without an attached garage?

[Note: Test using p=value for both (a) and (b)].

Exercise-6:
At the .05 significance level, is there a difference in the mean selling price of the homes among
the five township? [Note: Test using p-value only]. [
Exercise-6: a) Let selling price be the dependent variable and size of the home the
independent variable.
Determine the regression equation and interpret.
Write down the reression equation in words.
Estimate the selling price for home with an area of 2,200 square feet.
Determine r, R2 and Sy.x . Interpret.
b) Let selling price be the dependent variable and no. of bed rooms the independent variable.
Determine the regression equation and interpret.
Determine r, R2 and Sy.x . Interpret.
Estimate the selling price for home with 5 Bedrooms.
Exercise-8:
Use the selling price as the dependent variable and determine the regression equation with
number of bedrooms, size of the house, whether there is a pool, whether there is an attached
garage, distance from the center of the city and number of bathrooms as independent variables.
a) Write out the regression equation. Discuss each of the variables.
Write down the regression equation in words.
How much does a garage or a swimming pool adds to the selling price of a home?
b) Determine the value of R-square. Interpret.
c) Determine the multiple S.E of the estimate and interpret.
d) Conduct a global test on the set of independent variables. Interpret. [ Test using p-value only].[2]
e) Conduct a test of hypothesis on each of the independent variables. Would you consider
deleting any of the variables? If so, which one? [Note: Test using p=value only].

Date of submission: on or before – 04/06/2024 (11:59 p.m.).

Common questions

Powered by AI

Determining regression equations allows prediction of home selling prices based on size or number of bedrooms. These models help quantify how changes in these variables impact selling prices, assisting buyers and sellers in making informed decisions. It guides pricing strategies and market analyses, offering valuable insights into how specific attributes affect market value.

To develop a histogram for 'Selling Prices', first select an appropriate class interval based on the range of selling prices. Group the selling prices into these intervals and count the frequencies for each interval. Plot the frequencies as bars in the histogram. Interpretation involves analyzing the shape of the distribution (e.g., skewness) and identifying any patterns or anomalies in selling prices.

Developing such a regression model helps understand how different home attributes, like size, number of bedrooms, and presence of a pool, collectively affect selling prices. This allows for prediction and insight into the contribution of each attribute to price variations, aiding in real estate valuation and decision-making.

A pie chart for the 'Township' variable represents each township's proportion of total home sales. Interpretation involves analyzing segment sizes to determine dominant townships regarding sales and identifying trends or market concentration. This visualization illustrates relative market presence and competition among townships.

To construct confidence intervals for mean selling prices, determine the sample mean and standard error, then apply the z-score for 99% and 95% confidence levels. Multiply these z-scores by the standard error to create intervals around the sample mean. Interpret these intervals to assess the reliability of the sample mean as an estimator of the population mean.

Use a hypothesis test for each independent variable's coefficient in the regression model. If a variable has a high p-value (above significance level), it is not contributing to the model's predictive power. Consider deleting such variables to simplify the model without losing explanatory capability. Assess impact on R-square and interpret model changes.

R-square represents the proportion of variation in the dependent variable (Selling Price) that is predictable from the independent variables. A higher R-square indicates a better fit of the model to data. Interpretation involves assessing how effectively the model explains selling price variance, with higher values indicating greater explanatory power.

Conduct a hypothesis test by setting up null and alternative hypotheses: H0: μ = $357,000, Ha: μ ≠ $357,000. Compute the p-value using sample data. If the p-value is less than 0.05, reject H0, concluding that the mean selling price significantly differs from $357,000. This implies the average selling prices in the sample are not representative of the population mean reported.

To determine a frequency table for the 'Township' variable, you must count the number of homes sold per township and record the frequencies. The relative frequency table is created by dividing each township's frequency by the total number of homes, giving the proportion of total sales per township. Interpretation involves analyzing which townships have the highest sales and understanding the distribution of sales across townships.

Performing a global test involves setting up a null hypothesis that none of the independent variables have a significant effect on the dependent variable. Use an F-test to evaluate the joint significance at a specified significance level. If the p-value is below this level, reject the null hypothesis, indicating that at least one variable significantly predicts the dependent variable.

You might also like