Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Function to Match Power Trendline in Chart?

Status
Not open for further replies.
acjim

acjim

Technical User
Jun 3, 2003
46
0
0
GB
Hi,

I'm using the "Power" trendline in an XY scatter chart and want to use the formula and the rsquared result in a worksheet.

The formula is: y = 644.691x^-0.895

I've looked at LINEST but that seems to only give a straight line trend?

LOGEST gives me the exponential result?

Basically I'm worried about using the rsquared value from the chart if I don't have it through a function as well.

Anyone able to help?

Thanks!
 
Status
Not open for further replies.

Similar threads

renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
360
SoftwareRT
SoftwareRT
M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
228
combo
combo
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
919
Andrzejek
Andrzejek
GPnew
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
416
combo
combo
shytott
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
739
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top