Purchase Solution

Scatter Plot Graph in Excel

Not what you're looking for?

Ask Custom Question

(a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart.(c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain. (e) Interpret the R2.

12.18 Portfolio Returns (%) on Selected Mutual Funds Portfolio
Last Year (X) This Year (Y)
11.9 15.4
19.5 26.7
11.2 18.2
14.1 16.7
14.2 13.2
5.2 16.4
20.7 21.1
11.3 12.0
− 1.1 12.1
3.9 7.4
12.9 11.5
12.4 23.0
12.5 12.7
2.7 15.1
8.8 18.7
7.2 9.9
5.9 18.9

12.19 Number of Orders and Shipping Cost ShipCost
Orders (X) ($) Ship Cost (Y)
1,068 4,489
1,026 5,611
767 3,290
885 4,113
1,156 4,883
1,146 5,425
892 4,414
938 5,506
769 3,346
677 3,673
1,174 6,542
1,009 5,088.

See the attached file.

Attachments
Purchase this Solution
Solution Summary

The solution examines scatter plot trendlines to determine the regression analysis.

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.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Procedure to make a scatter plot in excel

    Procedure to make a scatter plot in excel

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

  • Plot/Regression line

    a) created scatter plot on excel. Looking at the data there doesnt seem to be a relation. The revenue line seems to be a pretty flat hrizontal line.

    b)displayed on graph.

  • Statistics

    340426 Statistics: Scale of Measurement, Frequency Distribution, Histogram, Pie Chart, Stem and Leaf Plot, Graph, Scatter Plot Please refer to the attached Excel Sheets fo the data. 1.

  • Distribution graph

    have answered on excel. Hope it is clear. To prepare enter the dataon 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.

  • XY Scattergraph using Microsoft Excel

    I have drawn the scatter plot. You fill in the values. Trick: Go to Axis Format and then scale. Assign maximum, minimum, major unit and minor unit values manually. The solution creates an XY scattergraph using Microsoft Excel.

  • 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 Plot Linear Regression

    The solution provides detailed explanation how to use excel to graph the scatter plot and find out the regression line.

  • Regression Analysis

    It collected the data for the North Central states in the U.S. and found the following:(PLEASE SEE ATTACHED TABLE) a). Create a scatter plot of the data using excel. b).

  • Correlation/Linear Regression

    Using the equation found in part a, predict the pressure when the age is 50. Round to the nearest year. Instruction to copy a graph from Excel to a Word document 1. Create the graph in Excel. 2.

View More Related Solutions