+ Reply to Thread
Results 1 to 2 of 2

Derive an equation from plotted data

  1. #1
    jwiam45
    Guest

    Derive an equation from plotted data

    Using Office/Excel 2003, is here a way to derive a formula from experimental
    data plotted on a line graph?

  2. #2
    Mike Middleton
    Guest

    Re: Derive an equation from plotted data

    jwiam45 -

    For equal-time-interval time sequence data, you could use a Line chart type.
    For paired XY data, use an XY (Scatter) chart type.

    Create the chart, click on a point to select the data series, and choose Add
    Trendline from the Chart main menu or from right-click shortcut menu. Choose
    a trendline form, and on the Options dialog check the box for displaying the
    equation. On the chart, select the equation textbox, and click Increase
    Decimal to show more significant digits.

    Other methods besides Add Trendline are worksheet functions and the
    Regression tool.

    - Mike
    www.mikemiddleton.com

    "" <[email protected]> wrote in message
    news:[email protected]...
    > Using Office/Excel 2003, is here a way to derive a formula from
    > experimental
    > data plotted on a line graph?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1