I am looking to find the formula to solve for the logarithmic equation/formula. I have my X axis and Y axis and want to have the logarithmic equation to solve for data points in between. I do not want to graph this as I am doing this function many times and hence want to automate. Thanks.
Last edited by JoshF; 01-24-2012 at 04:04 PM.
=LOGEST(B1:B3,A1:A3,TRUE,TRUE)
Where B is Y axis and A is X axis
This is horizontal array covering two columns,The first column of array is R and second column of array is T
Simple T*R^(x value)
--D--- -E- -F- --G--- --H--- -------I------- 7 X Axis 17 11 6 1 8 Y axis 95% 85% 77% 73% 9 10 1.0170 0.7084 y = H10 * G10^x
Select two cells (G10:H10 in the example above), paste
=LOGEST(E8:H8, E7:H7)
in the formula bar and confirm with Ctrl+Shift+Enter.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks