Purchase Solution

Procedure to make a scatter plot in excel

Not what you're looking for?

Ask Custom Question

I need help plotting a scatter graph in excel. How do you type it in to get a graph?

For example if my Y , X
72 2
99 3
65 1

How do I plot this in excel to get a scatter graph?

Purchase this Solution
Solution Summary

Procedure to make a scatter plot in excel

Purchase this Solution
Free BrainMass Quizzes
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.

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

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

View More Free Quizzes
Related BrainMass Solutions

  • Excel scatter plot diagram

    10284 Excel scatter plot diagram 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?

  • Sample Correlation

    332008 Scatter plot to calculate the sample correlation, SSxx, SSyy, SSxy (a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y? (b) Make an Excel worksheet to calculate SSxx , SSyy, and SSxy.

  • Scatter Plot, Trendline Equation, Correlation and Regression

    (c) Would the intercept be meaningful if this regression applies to home sales in a certain subdivision? 4. Choose one of these three data sets. (a) Make a scatter plot.

  • 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.

  • Scatter plot, correlation coefficient, and a hypothesis test

    210758 Scatter plot, correlation coefficient, and a hypothesis test (a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y? (b) Use Megastat or Excel to calculate the correlation coefficient.

  • Exponential Distribution Function and Derivation of the Equation

    This will convert the numbers in column E to percentages. Now, plot a scatter plot by taking Percent (column D) in the X axis and Expected percent (Column E) in the Y axis.

  • Regression and scatter plot analysis

    Uses Excel to make a scatter plot and fit a regression equation. Also interprets the slope and intercept values.

  • Applied Statistics for Lean Body Mass and Resting Metabolic Rate

    Then we make scatter plot using females' data. The explanatory variable is the mass of females. (refer to attached excel file for scatter plot) 2. Based on the scatter plot, the association between these variables is positive.

  • Scatter Plots and Correlation Coefficients

    Include the scatter plot you created in your word document. Question 2: Problem 2.37 from the text. Use Excel to construct a scatter plot. Compute the correlation coefficient by using columns in excel.

View More Related Solutions