From the Insert tab, we go to the Charts group and then click on the Scatter Chart command.We collected the covid death data online in Lousiana state in the United States. And now we will plot a Log-Log graph of the weekly cases with respect to the passing weeks. We extracted the weekly covid cases from the parent Excel database. Log Log Graph of Weekly Covid-19 Cases in Lousiana State And whether adopting a logarithmic scale could help us in inferring information.ġ. we will how the weekly count of covid cases changes in relation to the week count. We are going to provide a sample log-log graph with the data from covid-19 case information in the Lousiana state in the USA. if we have created a dataset from this equation and then plot the data in logarithmic scale, then the line should be straight.Ģ Suitable Examples to Plot Log Log Graph in Excel Here the X is in the power of n relation with the Y. This graph demonstrates whether the variables are in a constant power relationship, just like the equation Y = mX^n. We can plot a log-log graph using Excel quite easily by tweaking some axis format options.in the log-log graph, both of the axes are actually on a logarithmic scale. Read More: Excel Logarithmic Scale Start at 0 (A Detailed Analysis) The increasing rate continued to increase till 2000. But then again it was starting to increase, from the 1600 ad. We created a logarithmic scale version of the above graph below.įrom the logarithmic graph, we can infer that the rate at which the population increasing rate in the 700-900 ad was almost stagnated. User, in that case, need to be very careful in choosing the base of that logarithm. One of the most useful benefits of using a logarithmic chart is that it gives information about rates pretty efficiently.
That’s why the graph more stretched in the vertical portion and made it difficult to make any kind of deduction or insight. For example, in the figure below, you can see that the population is increasing at a steeper rate from 1900-to 2000 in the world. In other words, If there is more than one data point skewed in short spaces. Another reason is to gain a clear idea about closely stacked data points in the graph. The main inspiration behind the idea of the logarithm is to extract insight from large numbers.