The difference in the intercept (5.7594 instead of 5.7609) might be due to the different values of X and Y that I used and/or to insufficient precision in your presentation of the trendline formula.
The formula in B3 calculates the price, based on the data in A6:A11.įor clarity, I calculate the slope and intercept separated in D7:E7.
Hopefully, the example in the attached Excel file and image below will be "straight-forward" enough.ī3: =ROUND( SLOPE($B$7:$B$11, LN($A$7:$A$11)) * LN(A3) + Perhaps it is just the meandering and varied opinions, which I can image might be daunting. It is unclear what is not "straight-forward" about the solution(s) in the discussion that you cite. For example, this thread is at techcommunity dot microsoft dot com /t5/excel/how-do-i-set-a-cell-equivalent-to-a-chart-trendline-equation/m-p/3589034. If the forum does permit you to post a URL (yet), spell it out manually. You might like because it uses the same login as this forum. If the forum does not permit that (yet), upload the file to a file-sharing website and post the download URL here. Ideally, attach an example Excel file by clicking "browse" at the bottom of a edit window. Quicker and better answers come when you include a concrete example. I hope there is a more straight forward solution. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.I have an excel chart that plots a logarithmic trendline based on a table with data For example, if the trendline equation is y=-0.407ln(x)+5.7609, I want the user to be able to enter an x value (quantity) in one cell and another cell outputs the corresponding y value (unit price). Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
0 kommentar(er)
