Uppercase 'E' is the Scientific notation for '10 to the power of'. More precisely, it is EXP(1), where EXP() is an Excel function. My question is, what is the capital E? You are correct about the lowercase 'e'. Ibelieve e is the math 'e' > = 2.718 or so. I know what the > variables x and y mean. > The equation is: > y=5E+16e-3E-04x > The '-3E-04x' are in superscript. So, some statistics seem incorrect for the power functions.'ottlots' wrote: > I printed the trendline equation on the chart.

Because the statistics are calculated for the linear model, you see different values in statistics and on the chart.Because the LINEST () and LOGEST () functions return an array of data, you can use the INDEX () function to display only the desired parameter(s) from the returned data array.If you have a version of Microsoft Excel other than Microsoft 365, functions that return arrays must be entered as array functions using Ctrl+Shift+Enter unless you can just press Enter.If stats is FALSE or omitted, the function returns only the calculated parameters.Residual sum of squares (also known as SSE) Regression sum of squares (also known as SSR) Standard error of y estimate (also known as Standard Error of a regression) shows how big the prediction error is If stats is TRUE, the function returns the additional regression statistics in the form of an array:.stats (optional) is a Boolean value specifying whether to return additional regression statistics:.If const is FALSE, the parameter a is equal to 1, so the function will look like y = x b.If const is TRUE or omitted, the parameter a is calculated normally,.const (optional) is a Boolean value specifying whether to force the parameter a to equal 1:.In any case, you should provide the known_x's or array that has the same size as known_y's, These variables cannot be omitted for the correct calculation of a power trend. known_x's (optional) are independent data values:.known_y's (required) are dependent data values,.The array function LOGEST () calculates the power curve that fits best the known data and then returns an array with statistics describing the trend line:

The array function LINEST () calculates the linear trend that fits best the known data and then returns an array with statistics describing the trend line:

Trendline equation excel