Premium Essay

Gm533 Final Project

In:

Submitted By Frankin
Words 3700
Pages 15
Multiple Regression Model | Case # 28 House Prices | | A group of statistic student’s objective is to provide a business solution using statistical calculations and tools on a sample data. | | Upaiwan Porndumrongkit Ana Sanchez George Satiah Kritchapon Sopawatjirarich | 10/16/2010 |

Executive Summary
Summary: Home owners want to determine a reasonable asking price of a house based on a collection of home descriptions and its characteristics. However, home owners can get confused very easily as they see close variation in price based on different descriptive characteristics. Home owners hesitate to get professional advice from real estate agents due to service price. On the other hand, our Multi Regression Model can help real estate agents provide fast predictions and advice to home owners at a minimum service price. Our solution would give real estate agents a competitive advantage in the real estate market.
Problem statement: How to determine a reasonable asking price on n number of houses with its descriptive characteristics.
Solution: Multi Regression Model is one way to assist real estate agents use data to provide an estimate.

Introduction
The objective of this project is to provide the detailed data analysis and resolution to the problem statement mentioned above. As a group of students of statistics in the Keller Graduate School of Management at DeVry University, we have determined collectively and followed statistical calculations to find a solution to the problem statement. We have determined that the regression model analysis produces the best possible solution for formulating an equation to predict the best asking price for a house using real estate data. We

Similar Documents

Premium Essay

Study Guide

...Final Exam Study Guide (Revised 5/17/2011) In preparing for the Final Exam, it will serve you well to take a step back and reflect on the content, structure, and flow of the course. This will enable you to organize your notes, your completed homework and case problems, your annotated Minitab output, and your thoughts. The course is organized around the Terminal Course Objectives (TCOs) and each week builds on the preceding week’s concepts and skills. Each week introduces, explains, and demonstrates the essential concepts, major problem types, and key variations, which embody the TCOs. Here is a week-by-week summary of the major problem types. * Week 1 - Descriptive Statistics: includes central tendency, dispersion, and the shape of the distribution, in numbers, pictures, and tables. * Week 2 – Probability: includes 3 major problem types, and their most important variations: contingency tables, expected value, and the binomial distribution. * Week 3 – Probability continued: includes the normal distribution, its application to sampling distributions, and its most important variations. * Week 4 – Confidence intervals and sample size determinations, and their most important variations. * Week 5 – Hypothesis testing: includes the 5-step hypothesis testing procedure, applied to means and proportions, and its most important variations. * Week 6 – Simple linear regression: includes interpreting Minitab output for point estimates, hypothesis tests, and confidence...

Words: 382 - Pages: 2

Free Essay

Applied Statistics

...GM533 Applied Managerial Statistics Course Project Ebenezer Newman and Mark Cherry * NE (Northeast) 1: Maine, New Hampshire, Vermont, Massachusetts, Rhode Island, Connecticut, New York, Pennsylvania, New Jersey 0: Others * MW (Midwest) 1: Wisconsin, Michigan, Illinois, Indiana, Ohio, Missouri, North Dakota, South Dakota, Nebraska, Kansas, Minnesota, Iowa 0: Others * WEST (West) 1: Idaho, Montana, Wyoming, Nevada, Utah, Colorado, Arizona, New Mexico, Alaska, Washington, Oregon, California, Hawaii 0: Others * Region 3 (South) Delaware, Maryland, District of Columbia, Virginia, West Virginia, North Carolina, South Carolina, Georgia, Florida, Kentucky, Tennessee, Mississippi, Alabama, Oklahoma, Texas, Arkansas, Louisiana Scatter plots Get the scatter plots for each variable against the crime rate VIF From the result we see that there is no Multicorinality Predictor Coef SE Coef T P VIF Constant -340 1101 -0.31 0.759 NEAST -304.9 508.9 -0.60 0.553 3.307 MID-WEST -164.5 475.2 -0.35 0.731 3.564 WEST 351.6 588.9 0.60 0.554 5.773 PINCOME -0.01055 0.07966 -0.13 0.895 4.154 DROPOUT 70.66 26.61 2.66 0.011 2.975 PUBAID -76.43 86.78 -0.88 0.384 2.305 DENSITY -1.6666 0.9109 -1.83 0.075 3.760 KIDS 0.851 1.801 0.47 0.639 3.959 PRECIP 7.69 13.85 0.56 0.582 3.328 UNEMPLOY -93.30 ...

Words: 1030 - Pages: 5