Question:

How do you put a best fit cure on a microsoft ex graph?!?

by  |  earlier

0 LIKES UnLike

chem lab ends very soon... I need imediate help!

 Tags:

   Report

1 ANSWERS


  1. Best Fit Line, Slope and Intercept

    Often, we need to determine the mathematical relationship between the points on a graph.  In the graph above, you can see that the points form a straight line.  A best fit line can be added to the graph by the following:

        1.  Click once on the chart to that it is selected.

        2.  From the toolbar, select "Chart" > "Add Trendline".

        3.  The default type of line is "Linear" and that is what we will most often use.

    The equation of that line will follow the form:

            y = mx + b        where m is the slope and b is the y-intercept.  

    To determine the value of m and b:

        1.  Return to the "Add Trendline" dialog box.  Select the "Options" tab (at the top of the box).

        2.  Check the box for "Display Equation on Chart"

        3.  For some graphs you may also want to check the box for "Display R-squared Value on Chart"

        4.  When you return to your graph, a new text box will have the equation of the best fit line, along with the R-squared value.  Often the text box is in the middle of the graph, so move it to one side.

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.