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

M

mcozbyl

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

Tushar Mehta

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
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I show slope on a chart? 6
How do I show slope of a trendline on a plot ???? 0
Trendline - Linear 1
Trendline Significant Values 7
Calculation of slope when the trendline has a forced intercept 9
EXCEL polynomial trendlines 1
Regression gives slope of zero when x values smaller than 10^-7 4
Setting intercept to zero with SLOPE/STEYX/etc 3

Top