Purchase Solution

Scatter Plot and data

Not what you're looking for?

Ask Custom Question

Show all steps used in arriving at the final answers. Incomplete solutions will receive partial credit.

Data for a sample of houses sold recently in the suburb of a large metropolis are given below:

Area of House (hundreds of square feet) Selling Price (thousands of dollars)
20 250
19 220
27 350
28 390
30 320
15 200
25 360
23 290
18 210
35 410
(a) Do a scatter diagram for the data, insert the trend line and add the equation and R2 value to the diagram.
(b) Find SSxx, SSyy and SSxy.
(c) Determine the correlation coefficient. Comment on the value of the correlation coefficient.
(d) Find the regression equation manually. Compare with the equation obtained when doing the scatter diagram.
(e) Find SST, SSR and SSE.
(f) Find the degrees of freedom associated with the sum of squares in part (e).
(g) Find MSR and MSE.
(h) Summarize your findings as an ANOVA table.
(i) Find the coefficient of determination R2.
(j) Find standard error of the estimate se
(k) Test the hypothesis that Y and X are not related. That is, test H0: 1 = 0 vs. H1: 1  0 by using a t-statistic. Use  = 0.05.
(l) Find the predicted value of Y given X = 24. Give an interpretation of the predicted value in the context of the problem.
(m) Find a 95% confidence interval for the mean value of Y given X = 24. Give an interpretation of the confidence interval in the context of the problem.

Attachments
Purchase this Solution
Solution Summary

The expert examines scatter plot data to find the MSR and MSE.

Solution Preview

Show all steps used in arriving at the final answers. Incomplete solutions will receive partial credit.

Data for a sample of houses sold recently in the suburb of a large metropolis are given below:

Area of House (hundreds of square feet) Selling Price (thousands of dollars)
20 250
19 220
27 350
28 390
30 320
15 200
25 360
23 290
18 210
35 410
(a) Do a scatter diagram for the data, insert the trend line and add the equation and R2 value to the diagram.

(b) Find SSxx, SSyy and ...

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

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Scatter plot, correlation and linear regression

    207898 Scatter plot, correlation and linear regression Below are four bivariate data sets and the scatter plot for each. (Note that each scatter plot is displayed on the same scale.) Each data set is made up of sample values drawn from a population.

  • scatter plot & least squrares regression line

    To prepare enter the data on excel and then select the data and hit chart. after creating the scatter plot , go to chart in the menu options and add trend line.

  • Excel scatter plot diagram


    Select chart type to be scatter plot.

    I have done the question on excel. After you plot the scatter diagram go to "chart" in the menu and select add trendline.

  • A problem on Regression analysis

    Produce ten scatter plot graphs with the number of pizzas sold as the predictor variable. The scatter plot graphs for the nine expenses and total costs should show the actual data points. 2.

  • Scatter plot on Health care information

    101082 Scatter plot or scatter diagram What kind of information or data is used in a scatter plot or scatter diagram? Could I use any healthcare information in this? Please see the attached file.

  • Correlation coefficient and scatter plot

    86040 Correlation coefficient and scatter plot 3) Display the data in scatter plot. Calculate the linear correlation coefficient.

  • Bivariate data for the quantitive variables

    233765 Least-Squares Regression Lines for Bivariate Data Bivariate data for the quantitive variables x and y are given in the table below. These data are plotted in the scatter plot shown next to the table.

  • Scatter plot and trend line

    C) You obtain new data, 30,000 tons and a cost of 600,000. How do those values match the equation if done by hand? Put the point into an excel spreadsheet and create the scatter plot and trendline. Describe the output.

  • Linear Regression in Excel

    Use the data from Exercise #14.1 (see below) and (a) Plot a scatter diagram, (b) Show the linear trendline on the plot using, (c) Add the trendline equation, and (d) predict the sales for the years 2001 and 2002, (e) Compare with the actual

  • Calculating a Correlation

    500980 Calculating a Correlation 7 For the following data (a) display the data in a scatter plot, (b) calculate the correlation r, and (c) make a conclusion about the data type of correlation.

View More Related Solutions