The LOGEST function in Microsoft Excel is a Statistical function, and its purpose is to calculate an exponential curve that fits your data and returns an array of values that describes the curve. The LOGEST function returns an array of values, so it must be entered as an array formula. The formula and syntax for the LOGEST formula are below.
Formula:
LOGEST(known_y’s, [known_x’s], [const], [stats])
Syntax:
- Known_y’s: The set of y values you already know in the relationship y=b*m˄x. It is required.
- Known_ x’s: An optional set of x values that you may already know in the relationship y= b*m˄x. It is optional.
- Const: A logical value specifying whether to force the constant b to equal 1. It is optional.
- Stats: A constant value specifying to return additional regression statistics. It is optional.
What does Logest function do in Excel?
The LOGEST function returns statistics that describe an exponential curve matching known data points. When using the LOGEST function, when entering an array constant such as known x’s as an argument, use commas to separate values in the same row and semicolons to separate rows.
How to use the LOGEST function in Microsoft Excel
Follow the steps below to use the LOGEST function in Microsoft Excel:
- Launch Microsoft Excel.
- Enter data into the spreadsheet or using existing data.
- Select the cell you want to place the result
- Enter the formula, then press Enter.
Launch Microsoft Excel.
Enter data into the spreadsheet or use existing data.
Select the cell where you want to place the results and type the formula =LOGEST (B2:B5, A2:A5, D2, E2), then press the Enter key to see the result. See the photo above.
The range B2:B5 is the known_y’s values.
The range A2:A5 is the known_x’s values.
The Const is FALSE, and the Stats is TRUE.
There are two other methods to use the LOGEST function.
Method one is to click the fx button on the top left of the Excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box, in the section Select a Category, select Statistical from the list box.
In the section Select a Function, choose the LOGEST from the function list.
Then click OK.
A Function Arguments dialog box will open.
Type into the entry boxes the cells that you want to convert.
Then click OK. See the photo above.
Method two is to click the Formulas tab and click the More Functions button in the Function Library group.
Hover the cursor over Statistical.
Then select LOGEST from the drop-down menu.
A Function Arguments dialog box will open.
Follow the same method in Method 1.
Then click OK.
What is the best way to master Excel?
There are several ways that individuals can use to master Microsoft Excel:
- Learn some useful shortcuts.
- Protect your data.
- Learn how to navigate your Excel interface.
- Summarize your data with a pivot table.
- Visualize important data with conditional formatting.
- Using Flash Fill.
- Using the Freeze Pane feature.
- Create a drop-down list to organize certain data.
We hope this helps.
