enow.com Web Search

Search results

1. Results from the WOW.Com Content Network

2. RAND function - Microsoft Support

   support.microsoft.com/en-us/office/rand-function-4cbfa695-8869-4788-8d90-021ea...

   Learn how to use the RAND function in Excel to generate a random real number greater than or equal to 0 and less than 1. See syntax, examples, and tips for adjusting the range and format of the random numbers.

3. RANDBETWEEN function - Microsoft Support

   support.microsoft.com/en-us/office/randbetween-function-4cc7f0d1-87dc-4eb7-987...

   Learn how to use the RANDBETWEEN function in Excel to generate a random integer number between two values. See the syntax, arguments, and examples of this function.

4. RANDARRAY function - Microsoft Support

   support.microsoft.com/en-us/office/randarray-function-21261e55-3bec-4885-86a6...

   Learn how to use the RANDARRAY function in Excel to generate random numbers in an array. See syntax, arguments, examples, and notes on dynamic arrays and spilled array behavior.

5. Use the Analysis ToolPak to perform complex data analysis

   support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex...

   Learn how to use the Analysis ToolPak to perform complex statistical or engineering analyses in Excel. Find out how to access, load, and apply the tool and its functions, and see examples of output tables and charts.

6. MAKEARRAY function - Microsoft Support

   support.microsoft.com/en-us/office/makearray-function-b80da5ad-b338-4149-a523...

   Learn how to use the MAKEARRAY function in Excel to create a calculated array of a specified size and shape. See examples of creating a multiplication table and a random list of values with LAMBDA function.

7. How to compare data in two columns to find duplicates in Excel

   support.microsoft.com/en-us/office/how-to-compare-data-in-two-columns-to-find...

   Learn two methods to compare data in two columns and highlight duplicate entries in Excel. Use a worksheet formula with IF and MATCH functions, or a Visual Basic macro with a loop and an offset.

8. T.TEST function - Microsoft Support

   support.microsoft.com/en-us/office/t-test-function-d4e08ec3-c545-485f-962e-276...

   Learn how to use the T.TEST function in Excel to perform a Student's t-Test and calculate the probability of the difference between two samples. See syntax, parameters, remarks, and an example with data and formulas.

9. Count how often a value occurs - Microsoft Support

   support.microsoft.com/en-us/office/count-how-often-a-value-occurs-aa1f3067-05c...

   Learn how to use COUNTIF, COUNTIFS, COUNT, IF, SUM, IF, and PivotTable functions to count how many times a value occurs in a range of cells. See examples, formulas, and tips for different scenarios and criteria.

10. RANDARRAY function - Microsoft Support

    support.microsoft.com/en-gb/office/randarray-function-21261e55-3bec-4885-86a6...

    The RANDARRAY function returns an array of random numbers. You can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values. In the following examples, we created an array that's 5 rows tall by 3 columns wide.

11. TDIST function - Microsoft Support

    support.microsoft.com/en-us/office/tdist-function-630a7695-4021-4853-9468-4a1f...

    Learn how to use the TDIST function in Excel to compute the percentage points for the Student t-distribution. Find the syntax, arguments, remarks, and examples of this function.

12. Load the Analysis ToolPak in Excel - Microsoft Support

    support.microsoft.com/en-us/office/load-the-analysis-toolpak-in-excel-6a63e598...

    Learn how to use the Analysis ToolPak to perform complex statistical or engineering analyses in Excel. Follow the steps to load the tool and access its functions, charts, and output tables.