F.INV.RT function

PRO

The F.INV.RT function in Jspreadsheet Formulas Pro is a statistical tool that gives you the inverse of the right-tailed F probability distribution. Essentially, in statistics, the F-distribution is often used to compare variances of two data sets and the right-tail of this distribution is the section of data on the right side of the graph's peak. This function utilizes this concept to help you determine the F-value that corresponds to a given level of probability. In other words, it helps you find the value when you know the probability in your data analysis.

Documentation

Returns the inverse of the right-tailed F probability distribution.

Syntax

F.INV.RT(probability, degrees_freedom1, degrees_freedom2)

Parameter	Description
`probability`	A probability value greater than 0 and less than 1.
`degrees_freedom1`	The numerator degrees of freedom for the distribution.
`degrees_freedom2`	The denominator degrees of freedom for the distribution.

Behavior

The F.INV.RT function returns the inverse of the F probability distribution. It is a statistical function that calculates and returns the inverse of the F probability distribution. If p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x. The F-distribution can often be used in analysis of variance.

The function takes three arguments:

Probability - The probability associated with the F cumulative distribution.
Deg_freedom1 - The numerator degrees of freedom.
Deg_freedom2 - The denominator degrees of freedom.

Here's how it handles certain situations:

Empty cells: If any of the arguments are empty cells, the function will return a #VALUE! error.
Text: If any of the arguments are text, the function will return a #VALUE! error.
Booleans: If any of the arguments are boolean values, they will be coerced to numbers (TRUE to 1 and FALSE to 0).
Errors: If any of the arguments are error values, the function will propagate that error.
Negative values: If the Probability, Deg_freedom1 or Deg_freedom2 is less than 0, the function will return #NUM! error.
Non-integer degrees of freedom: If the degrees of freedom are not integers, they will be truncated.

Common Errors

Error	Description
`#VALUE!`	This error occurs if any of the arguments are non-numeric, or are empty cells.
`#NUM!`	This error occurs if the probability is less than 0 or greater than 1, or if the degrees of freedom are less than 1.

Best practices

Always ensure that the input values are numeric and within the valid range to avoid errors.

Be aware that the degrees of freedom are truncated if they're not integers.

Avoid using boolean values as inputs, as they might give unexpected results (TRUE is coerced to 1 and FALSE to 0).

Use error handling functions like IFERROR or ISERROR to catch and handle errors produced by F.INV.RT.

Usage

A few examples using the F.INV.RT function.

F.INV.RT(0.05, 3, 5) returns approximately 5.409  
F.INV.RT(0.01, 10, 20) returns approximately 3.368  
F.INV.RT(0.025, 4, 6) returns approximately 6.227

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ODg2NzY3YzFhYjFlYTg1MzE2NWNkZTkyOGNmMzhmMzRjNzA2MmIxNTMxMmZmYjBmNDdkYzY4NTQyNDk0YjdhNzE4ODdmZWI0ZWY2ZDE5N2M5MmIwYmQxZjk0OTU5OGFiMWYwNjVjZTlmYTE2MDZkOTg5YjUwNTQ5ZjMzODE5YWMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9EYzRNVE00TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Probability",
        "DF1",
        "DF2",
        "F Critical Value"
    ],
    [
        0.05,
        3,
        5,
        "=F.INV.RT(A2,B2,C2)"
    ],
    [
        0.01,
        10,
        20,
        "=F.INV.RT(A3,B3,C3)"
    ],
    [
        0.025,
        4,
        6,
        "=F.INV.RT(A4,B4,C4)"
    ],
    [
        0.1,
        2,
        8,
        "=F.INV.RT(A5,B5,C5)"
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('ODg2NzY3YzFhYjFlYTg1MzE2NWNkZTkyOGNmMzhmMzRjNzA2MmIxNTMxMmZmYjBmNDdkYzY4NTQyNDk0YjdhNzE4ODdmZWI0ZWY2ZDE5N2M5MmIwYmQxZjk0OTU5OGFiMWYwNjVjZTlmYTE2MDZkOTg5YjUwNTQ5ZjMzODE5YWMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9EYzRNVE00TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Probability",
        "DF1",
        "DF2",
        "F Critical Value"
    ],
    [
        0.05,
        3,
        5,
        "=F.INV.RT(A2,B2,C2)"
    ],
    [
        0.01,
        10,
        20,
        "=F.INV.RT(A3,B3,C3)"
    ],
    [
        0.025,
        4,
        6,
        "=F.INV.RT(A4,B4,C4)"
    ],
    [
        0.1,
        2,
        8,
        "=F.INV.RT(A5,B5,C5)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('ODg2NzY3YzFhYjFlYTg1MzE2NWNkZTkyOGNmMzhmMzRjNzA2MmIxNTMxMmZmYjBmNDdkYzY4NTQyNDk0YjdhNzE4ODdmZWI0ZWY2ZDE5N2M5MmIwYmQxZjk0OTU5OGFiMWYwNjVjZTlmYTE2MDZkOTg5YjUwNTQ5ZjMzODE5YWMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9EYzRNVE00TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Probability",
        "DF1",
        "DF2",
        "F Critical Value"
    ],
    [
        0.05,
        3,
        5,
        "=F.INV.RT(A2,B2,C2)"
    ],
    [
        0.01,
        10,
        20,
        "=F.INV.RT(A3,B3,C3)"
    ],
    [
        0.025,
        4,
        6,
        "=F.INV.RT(A4,B4,C4)"
    ],
    [
        0.1,
        2,
        8,
        "=F.INV.RT(A5,B5,C5)"
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ODg2NzY3YzFhYjFlYTg1MzE2NWNkZTkyOGNmMzhmMzRjNzA2MmIxNTMxMmZmYjBmNDdkYzY4NTQyNDk0YjdhNzE4ODdmZWI0ZWY2ZDE5N2M5MmIwYmQxZjk0OTU5OGFiMWYwNjVjZTlmYTE2MDZkOTg5YjUwNTQ5ZjMzODE5YWMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9EYzRNVE00TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Probability",
        "DF1",
        "DF2",
        "F Critical Value"
    ],
    [
        0.05,
        3,
        5,
        "=F.INV.RT(A2,B2,C2)"
    ],
    [
        0.01,
        10,
        20,
        "=F.INV.RT(A3,B3,C3)"
    ],
    [
        0.025,
        4,
        6,
        "=F.INV.RT(A4,B4,C4)"
    ],
    [
        0.1,
        2,
        8,
        "=F.INV.RT(A5,B5,C5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub