Statistical functions (reference) - Microsoft Support
WebLists all statistical functions, such as the AVERAGE, COUNTBLANK, and MEDIAN functions.
LINEST function - Microsoft Support
WebThe LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line. You can also combine LINEST with other functions to calculate the statistics for other types of models that are linear in the unknown parameters ...
Analyze Data in Excel - Microsoft Support
WebSimply select a cell in a data range > select the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane. If you're interested in more specific information, you can enter a question in the query box at the top of the pane, and press Enter.
Perform a regression analysis - Microsoft Support
WebPerform a regression analysis. Excel for the web. In Excel for the web, you can view the results of a regression analysis (in statistics, a way to predict and forecast trends), but you can't create one because the Regression tool isn't available.
Use the Analysis ToolPak to perform complex data analysis
WebIf 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.
Create a box and whisker chart - Microsoft Support
WebCreate a treemap chart in Office. Use the new box and whisker chart in Office 2016 to quickly see a graphical representation of the distribution of numerical data through their quartiles. Box and whisker charts are often used in statistical analysis.
View your time played for Xbox-enabled console and PC games
WebGames & apps. View your time played for Xbox-enabled console and PC games. On Xbox consoles, see your time played: Press the Xbox button to open the guide, then select Game activity > All achievements. Select a game, then select Stats. On the web, see your time played: Sign in at account.xbox.com.
Load the Analysis ToolPak in Excel - Microsoft Support
WebPerform statistical and engineering analysis with the Analysis ToolPak. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
Overview of formulas in Excel - Microsoft Support
WebOverview of formulas in Excel. Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture.
Create a chart from start to finish - Microsoft Support
WebExcel Help & Training. Charts. Create a chart from start to finish. Charts help you visualize your data in a way that creates maximum impact on your audience. Learn to create a chart and add a trendline. You can start your document from a recommended chart or choose one from our collection of pre-built chart templates. Windows macOS Web.
Create a forecast in Excel for Windows - Microsoft Support
WebCreate a forecast. In a worksheet, enter two data series that correspond to each other: A series with date or time entries for the timeline. A series with corresponding values. These values will be predicted for future dates. Note: The timeline requires consistent intervals between its data points.
Skip to content