EC315 exercise problems 1

# EC315 exercise problems 1 - the size of the home d) The...

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

A sample of 12 homes sold in St.Paul, Minnesota, is selected. Can we conclude that as the size of the home (reported below in thousands of square feet) increases, the selling price (reported in \$ thousands) also increases? Use the MegaStat Scatterplot function in Regression or the Excel Chart Wizard to create a scatter plot, and answer b) through d) below. Then, conduct a regression analysis and answer e), f), and g) a. Place scatter plot below, with a title: (do not connect the dots, but show a "line of best fit") Size vs selling price 0 20 40 60 80 100 120 140 0 0.5 1 1.5 Series1 Linear (Series1) b) Does the relationship appear to be a positive or a negative relationship? Positive relationship c) The independent variable is:

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.

Unformatted text preview: the size of the home d) The dependent variable is: the selling price (which is dependent on the other? Home Size (thousands of sq.ft) Selling Price(\$ thousands) 1.4 100 1.3 110 1.2 105 1.1 120 1.4 80 1.0 105 1.3 110 0.8 85 1.2 105 0.9 75 1.1 70 1.1 95 Use the Analysis ToolPak or Megastat to conduct a regression analysis, and paste the output below: e) Identify the coefficient of correlation 0.30722 f) Identify the coefficient of determination 0.094384 g) Can we conclude that there is a significant positive association between the size of the home and the selling price? Use the .05 significance level. Yes or No? NO Why? p-value=0.3314&gt;alpha=0.05...
View Full Document

## This note was uploaded on 11/11/2011 for the course EC 315 taught by Professor Barcus during the Spring '10 term at Park.

### Page1 / 2

EC315 exercise problems 1 - the size of the home d) The...

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

View Full Document
Ask a homework question - tutors are online