Excel and statistics, can you help!? - real estate spreadsheet
I have the following problem:
See Real Estate data, information about real estate in Venice, Florida, last year sold reports. The data are on the website resources available.
The sale price is the dependent variable and the size of the house of the independent variables.
a. Determine the regression equation.
b. To estimate the selling price of a house, with an area of
2.200 square feet.
c. Determine the confidence interval of 95 percent and
d. forecast of 95 percent of the selling price of a house with 2200 square meters.
It also gave me a spreadsheet with columns of 105 examples of Excel price, bedrooms, size, swimming, distance, municipality, garage, bathroom.
I think that probably need to get a graphical representation of this information, but what can I do and how I can answer all these questions? Please help!
Real Estate Spreadsheet Excel And Statistics, Can You Help!?
1 comments:
The first is to ignore them (or hide) columns, and other rooms. Everything you want is the size and price.
Therefore, I propose that the management of the data after.
You can then a graph of price and size.
Hope that helps ...
Post a Comment