Explore BrainMass

Explore BrainMass

    Linear Regression in Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com March 4, 2021, 8:31 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/linear-regression-in-excel-173944

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

    ADVERTISEMENT