0
   

Logarithmic regression in Excel

Forums: Statistics, Excel, Regression, Logarithm
Email this Topic • Print this Page
 
 
nicholas9976
 
Reply Tue 4 Nov, 2014 07:14 pm
With reference to this regression line:
https://dl.dropboxusercontent.com/u/46186972/regression_line.gif
As shown in the bottom-right of this chart, the formula for the black regression line is:
y = 0.075ln(x) + 0.2775
How can I write this formula in Microsoft Excel, so that I can calculate y for any given value of x ? (I tried calculating it using Excel help, but it did not give me the correct y values shown in the regression line chart linked above).
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 1,767 • Replies: 0
No top replies

 
 

Related Topics

1 in 5 women get raped? - Discussion by maxdancona
how do you figure out the mode,median,mean and range - Question by gobucks45503
How will you die? - Discussion by Robert Gentel
What type of statistical analysis would have been carried out on this data? - Question by sararfhusi
Statistics - probability - Question by jrl06
Statistics: What statistical tool can I use to find the significance of my hypothesis? - Question by alau8088
probability and statistics for economists - Question by armandok
area under standard normal curve help please - Question by nanoah
Correlating Education Course(s) to Value - Question by CDobyns
Sampling formula - Question by Moses mbeya
Need Help on data on Nominal and Likert scale - Question by mnhabib
 
  1. Forums
  2. » Logarithmic regression in Excel
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 04/25/2024 at 08:45:32
▲ ▼