Oz | search
Click here to view Oz news from 60+ newspapers.
Bookmark or Share- Z.TEST function - Microsoft SupportThis article describes the formula syntax and usage of the Z.TEST function in Microsoft Excel. Returns the one-tailed P-value of a z-test. For a given hypothesized population mean, x, Z.TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.
- Create a custom number format - Microsoft SupportCreate and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format codes, see Review guidelines for customizing a number format. Select the numeric data.
- Replace a formula with its result - Microsoft SupportReplace a formula with its result. You can convert the contents of a cell that contains a formula so that the calculated value replaces the formula. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.
- Use calculated columns in an Excel table - Microsoft SupportCalculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the rest of the column by itself. There’s no need to use the Fill or Copy commands.
- Sort data in a range or table - Microsoft SupportSort data in a range or table. Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons.
More
