
Perform a regression analysis - Microsoft Support
If you have the Excel desktop application, you can use the Open in Excel button to open your workbook and use either the Analysis ToolPak's Regression tool or statistical functions to …
Use the Analysis ToolPak to perform complex data analysis
Learn how to use the Analysis ToolPak to perform complex Excel data analysis. Explore the various data analysis functions available in Excel.
Project values in a series - Microsoft Support
You can fill in a series of values that fit a simple linear trend or an exponential growth trend by using the fill handle or the Series command. To extend complex and nonlinear data, you can …
Load the Analysis ToolPak in Excel - Microsoft Support
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.
Predict data trends - Microsoft Support
You can use trendline and moving average in two-dimensional charts to graphically display trends and analyze problems of prediction (also known as regression analysis).
SLOPE function - Microsoft Support
This article describes the formula syntax and usage of the SLOPE function in Microsoft Excel. Description Returns the slope of the linear regression line through data points in known_y's …
FORECAST and FORECAST.LINEAR functions - Microsoft Support
This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with …
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas.
Perform a regression analysis - Microsoft Support
If you have the Excel desktop application, you can use the Open in Excel button to open your workbook and use either the Analysis ToolPak's Regression tool or statistical functions to …
LINEST function - Microsoft Support
In addition to using LOGEST to calculate statistics for other regression types, you can use LINEST to calculate a range of other regression types by entering functions of the x and y …
Incorrect output is returned when you use the Linear Regression …
Discusses a problem in which the incorrect output is returned when you use Linear Regression (LINEST) function in Excel.