ZOS101 and System Z Jobs Board!

LOGEST function - Microsoft Support
In regression analysis, the LOGEST function calculates an exponential curve that fits your data and returns an array of values that describes the curve. Because this function returns an array of values, it must be entered as an array formula.

STEYX function - Microsoft Support
This article describes the formula syntax and usage of the STEYX function in Microsoft Excel. Returns the standard error of the predicted y-value for each x in the regression. The standard error is a measure of the amount of error in the prediction of y for an individual x. STEYX (known_y's, known_x's)

Use the Analysis ToolPak to perform complex data analysis
Regression The Regression analysis tool performs linear regression analysis by using the "least squares" method to fit a line through a set of observations. You can analyze how a single dependent variable is affected by the values of one or more independent variables.

Project values in a series - Microsoft Support
You can use Excel to project values that are based on existing data or to automatically generate values based on linear or growth trend calculations. Fill in a series that fits a simple trend, use functions to extend complex and nonlinear data, or perform regression analysis with the Analysis ToolPak Add-in.

Statistical functions (reference) - Microsoft Support
Lists all statistical functions, such as the AVERAGE, COUNTBLANK, and MEDIAN functions.

LINEST function - Microsoft Support
The LINEST function checks for collinearity and removes any redundant X columns from the regression model when it identifies them. Removed X columns can be recognized in LINEST output as having 0 coefficients in addition to 0 se values.

Load the Analysis ToolPak in Excel - Microsoft Support
If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.

FORECAST and FORECAST.LINEAR functions - Microsoft Support
The existing values are known x-values and y-values, and the future value is predicted by using linear regression. You can use these functions to predict future sales, inventory requirements, or consumer trends.

Excel functions (by category) - Microsoft Support
Detect errors in formulas. Lists all Excel functions by their category, such as Logical functions or Text functions.

Introduction to What-If Analysis - Microsoft Support
By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, you can do What-If Analysis to build two budgets that each assumes a certain level of revenue.

SLOPE function - Microsoft Support
Returns the slope of the linear regression line through data points in known_y's and known_x's. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.