Pfadintegral
pfadintegral.com โบ articles โบ linspace-logspace-vba
linspace() and logspace() functions in VBA | Pfadintegral dotCom
Create linearly or logarithmically spaced arrays with linspace() and logspace() functions in Excel โ VBA.
What's the difference between LOG, LOG10, and LN in Excel?
LOG is flexible and allows you to specify any base; LOG10 specifically uses base 10 (equivalent to =LOG(number,10)); LN uses the natural logarithm with base e (approximately 2.71828). LOG10 and LN are faster for their specific bases, while LOG offers versatility when you need custom bases.
getelyxai.com
getelyxai.com โบ excel formulas โบ math and trigonometry โบ log
LOG Function in Excel: Complete Guide & Examples | ElyxAI
Can I use LOG with base 2 for binary calculations?
Absolutely! =LOG(number,2) calculates the logarithm base 2, which is essential for binary systems and computer science applications. For example, =LOG(256,2) returns 8 because 2โธ equals 256.
getelyxai.com
getelyxai.com โบ excel formulas โบ math and trigonometry โบ log
LOG Function in Excel: Complete Guide & Examples | ElyxAI
Can LOG handle very large numbers?
Yes, LOG handles very large numbers efficiently because logarithms compress large values into manageable scales. LOG(1000000,10) returns 6 without any overflow issues, making it ideal for scientific and financial calculations involving large datasets.
getelyxai.com
getelyxai.com โบ excel formulas โบ math and trigonometry โบ log
LOG Function in Excel: Complete Guide & Examples | ElyxAI
Videos
03:33
Excel: les logarithmes finalement c'est simple! - YouTube
01:32
Comment mettre echelle logarithmique Excel - YouTube
- YouTube
05:42
How to plot Log graph in excel - YouTube
01:22
Change Y Axis to Logarithmic Scale in Microsoft Excel With One Click!
04:38
Excel Graphs and Charts Tutorial - Logarithmic Scale - YouTube
YouTube
youtube.com โบ watch
Logarithmic Scale: Graphing in Microsoft Excel - YouTube
In this video I go over a very useful and interesting topic, which is graphing in the logarithmic scale, or log scale for short. The most common log scale, w...
Published ย November 13, 2016
Stack Overflow
stackoverflow.com โบ questions โบ 42577824 โบ vba-equivalent-of-matlab-logspace
vba equivalent of matlab logspace - Stack Overflow
May 23, 2017 - The matlab code is n = 2.^(0:floor(log2(N/2)))'; maxN = n(end); endLogInc = log10(maxN); m = unique(ceil(logspace(0,endLogInc,pts)))'; where N = 604891 and pts is 5 the result in Matlab is n = 1 2 4 8 16 32 64 128 256 512 1024 2048 4096 8192 16384 32768 65536 131072 262144 ยท maxN = 262144 endLogInc = 5.4185 m = 1 23 513 11586 ยท 262145 ยท How can i execute the same in vba for excel?
Excel Forum
excelforum.com โบ excel-general โบ 1307635-logarithmic-graph-interpolation.html
Logarithmic Graph Interpolation
I'm not sure I understood exactly what you are doing, but your chart shows a log-log plot, so I guessed you are looking for something similar to what I proposed here: https://www.excelforum.com/excel-cha...ml#post3904113 In this example, I proposed a "linear" interpolation in log-log space.
ElyxAI
getelyxai.com โบ excel formulas โบ math and trigonometry โบ log
LOG Function in Excel: Complete Guide & Examples | ElyxAI
Since 2007=LOG(number,[base]) - Fully supported in Excel 2007, 2010, 2013, 2016, 2019, and Excel 365 with identical syntax and behavior.
Logspace
logspace.com โบ features โบ reporting
Run Reports with LogSpace
Export to Excel or CSV using the filter and column selections you've made.
Microsoft Support
support.microsoft.com โบ en-au โบ office โบ log-function-4e82f196-1ca9-4747-8fb0-6c4a3abb3280
LOG function - Microsoft Support
This article describes the formula syntax and usage of the LOG function, which returns the logarithm of a number to the base you specify.
CodeProject
codeproject.com โบ Questions โบ 188926 โบ Generating-a-logarithmically-spaced-numbers
[Solved] Generating a logarithmically spaced numbers - CodeProject
April 29, 2011 - Free source code and tutorials for Software developers and Architects.; Updated: 29 Apr 2011
MathWorks
mathworks.com โบ matlab โบ language fundamentals โบ matrices and arrays
logspace - Generate logarithmically spaced vector - MATLAB
First bound, specified as a numeric scalar. The a argument defines a bound of the interval over which logspace generates points. a can be real or complex, and the other bound, b, can be either larger or smaller than a.
Top answer 1 of 3
18
If a is start, c is end and b is number of intervals:
{a, b, c} = {1, 10, 1000};
t = (c/a)^(1/b) // N
a*t^Range[b]
1.99526
{1.99526, 3.98107, 7.94328, 15.8489, 31.6228, 63.0957, 125.893, 251.189, 501.187, 1000.}
I used N just to see better, what do we have.
2 of 3
7
Here is one way:
In[11]:= base = Block[{a}, a /. NSolve[a^9 == 1000, a][[-1, 1]]]
Out[11]= 2.15443
In[13]:= base^Range[0, 9]
Out[13]= {1., 2.15443, 4.64159, 10., 21.5443, 46.4159, 100.,
215.443,464.159, 1000.}
EDIT
Here is a much shorter and more direct way to get the same:
In[18]:= N[10^Range[0, 3, 1/3]]
Out[18]= {1., 2.15443, 4.64159, 10., 21.5443, 46.4159, 100.,
215.443, 464.159, 1000.}
IU Knowledge Base
kb.iu.edu โบ d โบ abrv
In Microsoft Excel, how can I make a log-log graph?
January 18, 2018 - Loading ยท Skip to page content
Reddit
reddit.com โบ r/excel โบ create a logarithmic curve from 2 datapoints
r/excel on Reddit: Create a logarithmic curve from 2 datapoints
August 11, 2022 -
I have 2 data points: 2022 (8.151) and 2030 (39.200).
I know that this growth is intended to be more or less logarithmic based on our other forecasts. Is there any easy way through Excel to get data points between these two dates that fits a logarithmic curve?
I've been searching and found mathematic ways to solve the problem, but I feel like there must be an easier way.
Thanks!
Top answer 1 of 3
1
u/Coolnave - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 3
1
I am not sure if that fits your needs but use your data in a chart and use a logarithmic trendline, show the equation in the chart and copy it. Here is how to add trendlines , the second last option in the format menu is show equation. Here are the different trendlines . If you want linear-logarithmic you could also use LINEST . Logarithmic Trendline: Equation: y = (c * ln(x)) + b c =INDEX(LINEST(y,LN(x)),1) b =INDEX(LINEST(y,LN(x)),1,2) Source for last equations