Purchase Solution

Scatter Plot Linear Regression

Not what you're looking for?

Ask Custom Question

Can you help me create a scatterplot, with an inserted trend line, showing the regression equation using the data below?

A sample of 12 homes sold last week in St Paul, Minnesota, is selected. The results are shown below.

Home Size (1000s sq feet) Home Price ($1000)
1.4 100
1.3 110
1.2 105
1.1 120
1.4 80
1 105
1.3 110
0.8 85
1.2 105
0.9 75
1.1 70
1.1 95

.

Purchase this Solution
Solution Summary

The solution provides detailed explanation how to use excel to graph the scatter plot and find out the regression line.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Scatter plot, correlation and linear regression

    The expert examines the scatter plot, correlation and linear regression.

  • scatter plot & least squrares regression line

    10265 Scatter Plot & Least Squrares Regression Line See the attached file. a. Create a scatter plot of the data. Do you think that there is a linear relationship between number of kilometers traveled and the number of cars? b.

  • Correlation Coefficient and Linear Regression

    The solution creates a correlation coefficient and linear regression for a scatter plot. A complete, neat and step-by-step solution is provided in the attached file.

  • Scatter plot & Linear Regression

    Scatter plot & Linear Regression for IRS to detect overstated deductions for charitable

  • Linear Regression: Limiting and Empowering Factors

    Once the scatter plot has been made, the trendline feature of Excel can be used to fit the linear regression line and state the value of the coefficient of determination R^2.

  • Regression

    10641 Regression A). Create a scatter plot (using excel) of the data. b). Find the equation of the linear regression line. c). Plot the regression line on the same plot as the data. d). How well do you think the line fits the data? e).

  • Regression analysis

    198747 Scatter Plot and Trend Line Please see the attached file. Please answer these questions based on the data file Packages. a.

  • Correlation aand regression analysis

    Construct a scatter plot. What does it suggest about the relationship between x and y? The points in the scatter diagram are away from the regression line. Thus non linear relationship is more suitable here. D. Construct a residual plot.

  • Regression model husband's education & wife's education

    Using the Graphs menu, make a scatter plot of husband's education against wife's education (variables husbeduc and wifeduc). Edit the chart to draw the regression line and print R². Graph (scatter plot with regression line).

  • Excellent Manufacturing Company lean six sigma project case

    The scatter plot looks linear, so we use linear regression to find linear regression equation y = 0.295x + 96.43. In the generated scatter plot using excel, we add a trendline to show the equation of the linear fit.

View More Related Solutions