Does anyone know how to increase the number of significant digits given for
the slope of a trendline in the trendline equation in Excel?
Does anyone know how to increase the number of significant digits given for
the slope of a trendline in the trendline equation in Excel?
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?
>
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks