Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Useing a Logrithmic y=intercept in a cell
Please help How can I post this function into a cell: y = 16.899Ln(x) - 11.928 This is the Y-intercept from a tredline. If you right click a line in a scatter chart, you can click "show trendline". Under trend line, you can ask it to display the formula. That is where I got this formulla. So, I want to put this into a cell so I can "drag" it down to solve for X. I.E. With a standard (non logrithmic) line my formula looks like this: y = 0.4121x + 13.416, which I translate into the cell to this: =0.4121*B5+13.416 From that I can drag it down to fill in the blanks. Now, I cant do this with the logrithmic line, becuase I havent figured out how to paste the function for "Ln" Anyone know how? -- swissforestry ------------------------------------------------------------------------ swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719 View this thread: http://www.excelforum.com/showthread...hreadid=496445 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Useing a Logrithmic y=intercept in a cell
Of course within minutes of postingt this i figure it out. y = 16.899Ln(x) - 11.928 translates to this: =(16.899)*LN(B5)-11.928 -- swissforestry ------------------------------------------------------------------------ swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719 View this thread: http://www.excelforum.com/showthread...hreadid=496445 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Useing a Logrithmic y=intercept in a cell
The coefficient values are rounded by default. You can format the
trenline coefficients to display full precision (scientific notation with 14 decimal places), or you can calculate then directly in Excel http://groups.google.com/group/micro...d0f2172c25a661 Jerry swissforestry wrote: Of course within minutes of postingt this i figure it out. y = 16.899Ln(x) - 11.928 translates to this: =(16.899)*LN(B5)-11.928 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |