{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Actvty 14 v.3

# Actvty 14 v.3 - Georgia Southern University College of...

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

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.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern