Hence log10 calculation can be done using the formula Log 10 n 10 x n. This is equivalent to raising 19500 to the 15-th power. Eventually we divide the sum by number of rows to calculate the mean in excel.
In a spreadsheet enter the formula LN current priceoriginal price For example if you purchased a stock for 25 a share that is currently 50 a share you would enter LN 5025.
For example with a set of 7 9 and 12 you would type in log7 log9 log12 before hitting on your calculator. For example the numbers 10 100 1000 and 10000 are equally spaced on a log scale because their numbers of digits is going up by 1 each time. In a spreadsheet enter the formula LN current priceoriginal price For example if you purchased a stock for 25 a share that is currently 50 a share you would enter LN 5025. Entering the number then pressing the log or ln button.