Actvty 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

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

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

Unformatted text preview: Georgia Southern University College of Business Administration BUSA 3131, Business Statistics Fall 2011 Activity 14 v.3 Name: _______________ Suppose you want to know whether the price of a home is statistically dependent on the size of the house in square feet (SF) of living space. 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), whether a swimming pool exists (Column D), and some other data. If sale prices are in Column F and square feet are in Column B, it is possible to use Excel to perform the regression calculations to assess whether square feet of a home are significant in predicting the sale price of a home. Complete the missing Excel instructions below: Step 1. Open the Excel spreadsheet with the data required, and in the toolbar click on the _______DATA____ tab. Step 2. Select: ___Data __Analysis_______ from the right side of the Data toolbar. Step 3: Select _________________________ from the data analysis window. Step 4: Excel requires entry of the data range for values of Y first. Review which two variables are being compared for this assignment (sale price and square feet). Which of these variables are the values of y? ___________________________________ Step 5: The Excel worksheet containing this real estate data shows Column labels in the 14 th row. Data values for all variables are displayed in the 15 th through 3014 th rows for each column....
View Full 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

Actvty 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