+ Reply to Thread
Results 1 to 3 of 3

How do I increase the of significant digits given in the slope i.

  1. #1
    mcozbyl
    Guest

    How do I increase the of significant digits given in the slope i.

    Does anyone know how to increase the number of significant digits given for
    the slope of a trendline in the trendline equation in Excel?

  2. #2
    Tushar Mehta
    Guest

    Re: How do I increase the of significant digits given in the slope i.

    Double click the trendline equation; from the Number tab select a
    format that lets you specify the number of decimal places.

    Alternatively, use the LINEST function to get the value in the
    worksheet directly. [In versions prior to 2003, for certain data sets,
    the chart trendline gave better results than LINEST.]

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <83E9ADDC-4D05-4D75-A64A-906144122FA5@microsoft.com>,
    mcozbyl@discussions.microsoft.com says...
    > Does anyone know how to increase the number of significant digits given for
    > the slope of a trendline in the trendline equation in Excel?
    >


  3. #3
    Jerry W. Lewis
    Guest

    Re: How do I increase the of significant digits given in the slope i.

    Right click on the displayed equation and Format Data Labels|Number

    Alternately you could use the worksheet functions SLOPE and INTERCEPT or
    LINEST for more complicated models.

    Jerry

    mcozbyl wrote:

    > Does anyone know how to increase the number of significant digits given for
    > the slope of a trendline in the trendline equation in Excel?



+ 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