Topics Map > IT Services > Training
Topics Map > IT Services > Software Support

Microsoft Excel 2016 - Other Common Functions

This guide will show you how to perform various other common functions within Excel.

VIDEO

Rank

The Rank function gives a numerical ranking to each set of data depending on its place in a certain column.
  1. In the desired cell, type =RANK(X#, 1:1). The X# represents the the cell being ranked.
  2. To copy this formula to the other cells, hover the cursor over the bottom right cursor of the cell until the cursor turns into the black/thin +. 
  3. Then, left click and drag the formula into the cells which the formula should go into. 

Median

The median function finds the median number in a set of data.
  • Enter the formula =Median(X1:X2) where X=the column of the data, 1=the first cell to be analyzed and 2=the last cell to be analyzed.

Standard Deviation

The standard deviation function provides the standard deviation for a set of data.
  • Enter the formula =Stdeva(X1:X2) where X=the column of the data, 1=the first cell to be analyzed and 2=the last cell to be analyzed.




If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or helpdesk@uwosh.edu




Keywords:rank, median, "Standard Deviation", "Data Entry"   Doc ID:65921
Owner:William W.Group:UW Oshkosh
Created:2016-08-09 14:33 CDTUpdated:2016-08-09 14:33 CDT
Sites:UW Oshkosh
Feedback:  0   0