+ Reply to Thread
Results 1 to 3 of 3

Trendline Equation When Solved for X (as seen on graph) Does NOT Match

  1. #1
    Registered User
    Join Date
    10-11-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    2

    Trendline Equation When Solved for X (as seen on graph) Does NOT Match

    Hello All,

    I am working on staffing projections so I can create a budget for 2019 based off of projected growth. Seems simple enough, but I wanted to use a trendline equation for active staff (green) instead of rough percentages, which looks good on the graph but yields bizarre results when I plug in the excel number for the dates I'm looking for (12/01/2019=43388).

    I read that not having enough decimal places to see the full equation could create problems so I added in 30 decimal places. I also checked my math on Wolfram Alpha and got the same result. In the attached graph/ image it looks like I should expect a number around 180. When I solve the equation I get 155.54 in both excel and Wolfram Alpha. Any ideas on whats causing this and how I can get the correct equation for the (green) visual trendline?

    Thank you!
    Attached Images Attached Images
    Last edited by sundrop; 10-11-2018 at 03:19 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,810

    Re: Trendline Equation When Solved for X (as seen on graph) Does NOT Match

    Where did you get that 1 Dec 2019 is serial number 43388? Using the 1900 date system, I get that 43388 is the serial number for 15 Oct 2018 and the serial number for 1 Dec 2019 is 43800. 43800 in that equation gives me 188. I suggest that you double check the date serial number you are using.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    10-11-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Trendline Equation When Solved for X (as seen on graph) Does NOT Match

    Thank you so much! I figured it was probably something simple I'd overlooked. Works now, than you for your assistance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Graph of three variables and trendline equation
    By suchitkolpe in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-18-2018, 10:11 AM
  2. Trendline and equation doesnot match
    By sxu in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-12-2014, 04:34 PM
  3. Excel prints wrong trendline equation on graph
    By justyna-whitney in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-19-2013, 06:13 PM
  4. Scatter graph linear trendline and equation to find unknown
    By S_9 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-09-2013, 08:26 PM
  5. Excel graphed trendline does not match derived equation
    By Keith in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-13-2006, 04:20 PM
  6. [SOLVED] How to link trendline equation in graph to cell?
    By rossgus in forum Excel General
    Replies: 1
    Last Post: 08-08-2005, 10:05 AM
  7. [SOLVED] How can I see general form of an equation's graph in Excel?
    By Mahrokh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-09-2005, 08:06 AM

Tags for this Thread

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