Share
Explore BrainMass

Linear Regression in Excel

Please see attachment!

Use the data from Exercise #12.3 below.

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

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 data shown for 2001 and 2002 then discuss your answer.

Attachments

Solution Preview

Here is how to add a regression line to a chart in Excel:

1. You need to create the chart, then click somewhere in the chart to highlight all four corners,
2. Click on "Chart", then "Add Trendline",
3. Click on "Linear" chart type, to add the line, then
4. Go back to "Chart", and "Add Trendline" again and click on "Options" then click "Display equation on chart" to show the equation on the chart.

-------------------------------------------------------------------------------

Use the data from Exercise #12.3 below. (a) Plot a scatter diagram, (b) Show the equation on the plot using the trendline option of Excel, (c) State ...

$2.19