To calculate degrees of freedom in Excel, you would use the FREQUENCY function. The FREQUENCY function calculates the number of events that occur within a given unit of time. The units of time are specified as bin periods (or counts).