Excel Shortcuts for Statistics

Excel Shortcuts for Statistics

Basic Calculations

  • Excel can evaluate mathematical equations directly within cells.

  • To perform a calculation, start by typing = in a cell, followed by the equation.

  • Example: Typing =1+3 into a cell and hitting enter will display the result 4.

Generating Random Numbers

  • The RANDBETWEEN function generates random integers within a specified range.

  • The syntax is =RANDBETWEEN(low, high), where low is the smallest number and high is the largest number for the random number.

  • Example: =RANDBETWEEN(1, 100) will generate a random integer between 1 and 100, inclusive.

Creating a List of Random Numbers

  • To generate multiple random numbers, you can use the fill handle.

  • Enter the RANDBETWEEN function in a cell (e.g., =RANDBETWEEN(1, 100)).

  • Select the cell containing the formula.

  • Click and drag the small square (fill handle) at the bottom-right corner of the cell downwards to the desired number of cells.

  • Excel will automatically copy the RANDBETWEEN function to the selected cells, generating a new random number in each cell.