Results 1 to 7 of 7

Formula to create a regression line chart.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Formula to create a regression line chart.

    I have NO idea of how to do this so I hope you guys might be able to offer some assistance.

    I have attached an example showing the “Days” (days eating wheat) from 120 to 180 days.

    As far as column B goes- this is the Average Daily Gain. I can tell you that at 120 days the gain is 2.80 and at 180 its 2.25. Just so you understand what I am actually looking at this is Cattle. So as you can imagine as the Cattle get larger they daily gain will shrink but its not lateral (a straight line). The slope should start out slight then drop off almost exponentially as you approach the 180th day to 2.25.

    I assume there needs to be a couple of additional numbers to make this happen but again I don’t even know where to start.

    Thank you for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I plot a Regression Line on Chart?
    By Jim15 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-04-2017, 06:09 PM
  2. [SOLVED] Chart confidence intervals around regression (or trend) line
    By LeAnne in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-28-2013, 11:06 AM
  3. Replies: 3
    Last Post: 04-07-2013, 07:40 AM
  4. Replies: 1
    Last Post: 12-31-2012, 05:31 AM
  5. How to create a vertical reference line on a time series line chart
    By Bladebgii in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-23-2012, 10:17 AM
  6. Replies: 2
    Last Post: 10-24-2007, 04:39 AM
  7. [SOLVED] How do I put a regression line on a scatter chart
    By Charles Hall in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2006, 10:25 PM

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