Create An F-Distribution Table In Excel – F-Test Of The Equality Of Two Variances

We use the F distribution when we are testing the equality of the variances of two normally distributed populations. Applications of this include comparing the volatility of securities in different periods or against benchmarks. Each F distribution is described by two values of degrees of freedom, where one is referred to as the numerator and the other as the denominator. To create our F distribution table, we will use the F.INV.RT function which returns the inverse of the right tailed F probability distribution. This function consists of three parameters: the probability, the numerator degrees of freedom and the denominator degrees of freedom. Access the templates featured in The Excel Hub's video tutorials here: https://theexcelhub.myshopify.com/ Create A T-Distribution Table Using T.INV In Excel – Student’s T-Distribution:    • Create A T-Distribution Table Using T.INV ...   Create A Normal Distribution Table In Excel – Standard Normal Distribution    • Create A Normal Distribution Table In Exce...   Create A Chi-Square Distribution Table In Excel – Test Of A Single Variance Using CHISQ.INV.RT:    • Create A Chi-Square Distribution Table In ...   Subscribe for weekly Excel tutorials, techniques and examples:    / @theexcelhub   Please share this video with others that may find it useful:    • Create An F-Distribution Table In Excel – ...   Please comment below if you have any feedback or any suggestions for videos you would like us to upload next! 🌍 The Excel Hub website: https://theexcelhub.com/ 📸 Instagram:   / theexcelhub   ABOUT US: The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level. For any enquiries, please contact: [email protected] Overview: (0:00) Create F Distribution Table: (1:38) How To Use It: (3:36)