Purchase Solution

Scatterplot and Trendline

Not what you're looking for?

Ask Custom Question

13. The following data are prices for custom homes comparing square feet (given in hundreds) and price (in thousands).

Square Feet Price
26 259
27 274
32 315
29 296
29 325
34 380
32 359
40 523
22 215

a. Construct a scatterplot for this data set in the region to the right.

b. Based on the scatterplot, does it look like a linear regression model is appropriate for this data? Why or why not?

c. Add the line-of-best fit (trend line/linear regression line) to your scatterplot. Give the equation of the trend line below.

d. Use your trend line to predict the cost of a home with 4500 (45) square feet.

e. Determine the value of the correlation coefficient. Explain what the value tells you about the data pairs?

f. Does the value of the correlation coefficient tell you there is or is not statistically significant evidence that correlation exists between square feet and price of custom homes? Explain your position. (HINT: application of table A-6 is needed!)

g. What percent of the variation in cost can be explained by the regression line in regard to knowing the square footage? (HINT: review coefficient of determination)

Attachments
Purchase this Solution
Solution Summary

The solution answers the question below.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Three regression analyses using Excel

    Create a graph with the trendline displayed. (an x y scatterplot showing trendline) b. What is the least squares regression line equation? What are the slope and the y-intercept? c. What is the R-squared value? 2.

  • Linear Regression Analysis

    - create graph with trendline 25 Least squares regression line 5 Slope and y-intercept 5 R-squared value 5 Run regression with Benefits and OVERALL - create graph with trendline 25 Least squares regression line 5 Slope

  • Statistics: Scatterplot and Trendline

    198822 Statistics: Scatterplot and Trendline You are in charge of your company's complaint department.

  • Linear Regression Equation

    After making the chart, I went to the "Chart" menu, and clicked on "Add Trendline".

  • Scatter plot and trend line

    Using only these two data points, determine the cost functions for Manchester.B) Use Excel's "scatterplot" graphing function to plot the two points and the "trendline" option to determine the equation of interest.

  • Non-Linear Scatterplot

    In other in the above table keep the x values the same and replace the y values by y' values. 3. Draw a scatterplot of this data. What can you say about the shape of this scatterplot? 4.

  • Linear Regression in Excel

    173944 Scatterplot and regression Please see attachment! Use the data from Exercise #12.3 below.

  • What is the regression equation?

    Insert the trendline into the graph and show the regression equation. -What is the regression equation? Identify the slope and y-intercept. -What does the slope tell you? -Determine and interpret the coefficient of determination.

  • Best Fit Curve in Excel

    First, I made a scatterplot: x is the independent variable, and y is the dependent variable (this is based on the curve that the data are supposed to follow; however, I would have said the opposite if I had only been given the table, not the curve).

View More Related Solutions