F.DIST.RT()

Description

Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.

How To Use in Sheets

F.DIST.RT(x, degrees_freedom1, degrees_freedom2)

External Links

SOCY201-Using Google Sheets to Solve a Simple, Oneway ANOVA Problem

ANOVA problems can be solved using a spreadsheet and this video shows how to use Google sheets to do this. Beside showing how to set up and solve for the F-statistic, some tips like using named ranges, absolute addresses, and some interesting spreadsheet functions are explained.

0Better Sheets Tutorials

No videos yet. Stay tuned!