Purchase Solution

Excel scatter plot diagram

Not what you're looking for?

Ask Custom Question

Given the following data, 1) how do you make Excel create a scatter diagram for you? 2) If you were to draw a line through the points, how straight would the line be? 3) What is the coefficient of determination - r2 for this data, and more importantly, 4) what does it mean?

# Employees # Orders received
1 12
2 10
4 9
3 11
5 12
4 15

Purchase this Solution
Solution Summary

The expert examines an Excel scatter plot diagram.

Solution Preview

Enter the data in excel. select all the data and hit chart icon.
<br>Select chart type to be scatter ...

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
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.

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

  • Linear Regression in Excel

    (a) Plot a scatter diagram, (b) Show the equation on the plot using the trendline option of Excel, (c) State the value of the slope, and (d) State the value of the intercept.

  • Draw the scatter plot

    . ** For the scatter diagram please see the Excel attachment ** Thanks This solution provides explanation of how to draw scatter plot.

  • Regression and Correlation

    Plot these data in a scatter diagram. b. Compute the coefficient of correlation. c. Determine the regression equation. ** Please see the attached Excel file. ** Speed MPG 44 22 51 26 48 21 60 28 66 33 61 32 a.

  • Scatter diagram, regression

    I have done the problem using excel and the inbuilt capabilities of excel to calculate the regression equation. You can do this by first creating a scatter plot on excel and then adding a trendline from the pull down menu. Hope it is clear.

  • Regression analysis - Chemical Reactions

    (a) Make a scatter plot. (b) Use Excel to fit the regression, with fitted equation and R2. (c) In your own words, describe the fit. Please see the attachments. A step by step method for regression analysis is discussed here.

  • Scatter Plot for Absences Versus Grades

    Calculations are done in excel. Step by step method for regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

  • 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 & Regression Analysis

    Draw the fitted regression line on the scatter diagram, obtain the residuals and plot them on the scatter diagram too. Explain your findings. f. Report on any observations on the data, regression estimates or the regression residuals; g.

  • Regression Analysis of league average and body weight

    Make sure you include your chart and calculations from excel as a part of your answer. a. Construct a scatter plot of the data. b. Find the equation for the least squares line of best fit. c.

View More Related Solutions