Asnmnt 14 v.3 - Georgia Southern University College of...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Georgia Southern University College of Business Administration BUSA 3131, Business Statistics Fall 2011 Assignment 14 v.3 Name: _______________ This assignment should follow Activity 14 v.3. The Georgia View file for this course contains a sample set of data for 3000 home sales records which include home sales prices (Column F) and values for variables such as square feet (Column B), subdivision location (Column E), type of construction, e.g. brick or frame (Column C), and whether a swimming pool exists (Column D). Suppose in addition to using square footage as a determinant of price, you want to see if brick construction and the existence of a swimming pool can be used to predict real estate value. These additional independent variables can easily be included in the simple linear regression equation used by Excel. The only change you would make to the Excel regression instructions is to specify the data cells for all the independent variables you want to include. It is easier if all the values of x that you wish to include are in adjacent rows on the worksheet. The Excel file labeled GSU BUSA 3131 RE data F11 Asnmnt 14 v.3 is contained in the Georgia View folders. It is used for both Activity 14 v.3 and Assignment 14 v.3. That file contains the 3000 real estate records that have been used elsewhere in this course. In that Excel file the B column, which contains square footage and is labeled “SF” in cell B 14. Next to that column are two columns: C and D. The label: “Brick” appears in C14 and “Pool” appears in D14. Data provided in cells C15 through C 3014 are values of “0” or “1” meaning either the house is not brick (0) or it is (1). Similarly in the D column (from D15 to D 3014), values of “0” mean there is no pool and “1” means there is a pool. In this assignment both of these housing features (brick construction and existence of a swimming pool) are identified as adding value to the sale price. Sometimes multiple independent variables (values of
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/30/2012 for the course BUSA 3131 taught by Professor Watson during the Fall '11 term at Georgia Southern University .

Page1 / 3

Asnmnt 14 v.3 - Georgia Southern University College of...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online