Purchase Solution

Regression and Correlation

Not what you're looking for?

Ask Custom Question

11. A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:

Speed MPG

44 22
51 26
48 21
60 28
66 33
61 32

a. Plot these data in a scatter diagram.
b. Compute the coefficient of correlation.
c. Determine the regression equation.

Purchase this Solution
Solution Summary

This solution shows how to create a scatter diagram, compute the coefficient of correlation, and determine the regression equation in Excel for the given problem.

Solution Preview

** Please see the attached Excel file. **

Speed MPG
44 22
51 26
48 21
60 28
66 33
61 32

a. Plot these data in a scatter diagram.

Go to insert --> chart.
Choose XY ...

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.

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Regression and Correlation Assumptions

    115795 Regression and correlation 1) When is regression used? What are the assumptions of Linear Regression? 2) What is correlation? How does it differ from regression? What is the interpretation of the correlation coefficient?

  • Real life applications of regression

    This posting provides several real life examples of correlation and regression.

  • Discussion on Causation, Correlation and Regression

    572682 Discussion on Causation, Correlation and Regression I need some help in conceptualizing basic statistic concepts: (1)Briefly defines correlation and regression.

  • Regression: Predictor and Criterion Variables

    550889 Regression: Predictor and Criterion Variables Please help with the following. Explain the relationship between correlation and regression. What do the two approaches have in common, and how are they different?

  • Correlation and Regression

    Three questions related to correlation and regression answered to the point.

  • Student query: Correlation and regression analysis

    186189 Correlation and regression analysis. QUESTIONS: (a) How does correlation analysis differ from regression analysis? (b) What does a correlation coefficient reveal?

  • Correlation and Regression (Descriptive Statistics)

    233165 Correlation and Regression (Descriptive Statistics) 1. Testing for a linear Correlation: Use the scatterplot and the linear correlation coefficient r to determine whether there is a correlation between the two variables.

  • regression model

    Hello and thank you for posting your question to Brainmass! In a regression model, if every sample point is on the regression line (all errors are 0), then (b) the correlation coefficient would be -1 or 1.

  • Correlation Coefficients

    A regression coeffciient of -1 indicates a perfectly inverse relations, that is, the slope of the regression line is -1 and all the points lie on the line.

  • Theory, analysis and interpretation of regression

    82314 Theory, analysis and interpretation of regression Theory of regression: How does regression relate to linear algebra? Regression terms and symbols: What is the difference between strong negative and strong positive?

View More Related Solutions