CHISQ.INV.RT function

PRO

In Jspreadsheet Formulas Pro, the CHISQ.INV.RT function is used to compute the inverse of the one-tailed probability of the chi-squared distribution. It's used when you have the probability, and you want to find the corresponding chi-squared value. This is particularly useful in statistical analysis, for tasks like hypothesis testing. You simply need to provide the degrees of freedom and the probability as arguments to this function.

Documentation

Returns the inverse of the one-tailed probability of the chi-squared distribution.

Syntax

CHISQ.INV.RT(probability, degrees_freedom)

Parameter	Description
`probability`	A probability associated with the chi-squared distribution.
`degrees_freedom`	The number of degrees of freedom of the distribution. Must be a positive integer.

Behavior

The CHISQ.INV.RT function calculates the inverse of the right-tailed probability of the chi-squared distribution. This function is commonly used in statistical analysis and research.

The function takes two arguments: probability, the right-tailed probability, and degrees_freedom, the number of degrees of freedom. Both arguments must be numerical.
If the cells referenced in the arguments are empty or contain text, the function will return a #VALUE! error.
Boolean values are interpreted as 0 (for FALSE) and 1 (for TRUE).
If probability is less than 0 or greater than 1, the function will return a #NUM! error.
If degrees_freedom is not an integer greater than 0, the function will return a #NUM! error.

Common Errors

Error	Description
#VALUE!	The input argument is non-numeric, an empty cell, or text.
#NUM!	The `probability` is less than 0 or greater than 1, or `degrees_freedom` is not an integer greater than 0.

Best Practices

Always ensure that the probability argument is a numerical value between 0 and 1. Any value outside of this range will result in a #NUM! error.

The degrees_freedom argument should be a positive integer. Non-integer or negative values will return a #NUM! error.

Use cell references instead of directly inputting numbers into the function for easier modifications and understanding.

Handle possible errors using error-checking functions like IFERROR to keep your spreadsheet clean and professional.

Usage

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

CHISQ.INV.RT(0.05, 3)       // ≈ 7.8147 — critical value at 5% significance with 3 degrees of freedom  
CHISQ.INV.RT(0.01, 6)       // ≈ 16.8119 — chi-square value for 1% significance (df=6)  
CHISQ.INV.RT(0.001, 10)     // ≈ 29.5882 — used in stricter hypothesis testing thresholds  
CHISQ.INV.RT(0.95, 2)       // ≈ 0.1026 — shows low values at high probability (used for testing model fit)

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('ZjJiZmM0NWU0Yzc1YzU5ZmRmZDQ1ZDM2ZDMyNzI2MTliYjhhZWVlYjlkMmI5NmFkMWYzMzVhN2NlMDRhNGNlMGYyNGRlY2MxN2RjOTk0MzQyZjc5YzYwMDdmMDM2ZTFhNzljNjUwN2E3ZDdlODA3YjI5ZGI1ODBiNzZiN2EyZDEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Probability",
        "Degrees of Freedom",
        "Chi-Square Critical Value"
    ],
    [
        0.05,
        1,
        "=CHISQ.INV.RT(A2,B2)"
    ],
    [
        0.01,
        3,
        "=CHISQ.INV.RT(A3,B3)"
    ],
    [
        0.001,
        5,
        "=CHISQ.INV.RT(A4,B4)"
    ],
    [
        0.1,
        2,
        "=CHISQ.INV.RT(A5,B5)"
    ]
]
  }]
});
</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('ZjJiZmM0NWU0Yzc1YzU5ZmRmZDQ1ZDM2ZDMyNzI2MTliYjhhZWVlYjlkMmI5NmFkMWYzMzVhN2NlMDRhNGNlMGYyNGRlY2MxN2RjOTk0MzQyZjc5YzYwMDdmMDM2ZTFhNzljNjUwN2E3ZDdlODA3YjI5ZGI1ODBiNzZiN2EyZDEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Probability",
        "Degrees of Freedom",
        "Chi-Square Critical Value"
    ],
    [
        0.05,
        1,
        "=CHISQ.INV.RT(A2,B2)"
    ],
    [
        0.01,
        3,
        "=CHISQ.INV.RT(A3,B3)"
    ],
    [
        0.001,
        5,
        "=CHISQ.INV.RT(A4,B4)"
    ],
    [
        0.1,
        2,
        "=CHISQ.INV.RT(A5,B5)"
    ]
];

    // 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('ZjJiZmM0NWU0Yzc1YzU5ZmRmZDQ1ZDM2ZDMyNzI2MTliYjhhZWVlYjlkMmI5NmFkMWYzMzVhN2NlMDRhNGNlMGYyNGRlY2MxN2RjOTk0MzQyZjc5YzYwMDdmMDM2ZTFhNzljNjUwN2E3ZDdlODA3YjI5ZGI1ODBiNzZiN2EyZDEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Probability",
        "Degrees of Freedom",
        "Chi-Square Critical Value"
    ],
    [
        0.05,
        1,
        "=CHISQ.INV.RT(A2,B2)"
    ],
    [
        0.01,
        3,
        "=CHISQ.INV.RT(A3,B3)"
    ],
    [
        0.001,
        5,
        "=CHISQ.INV.RT(A4,B4)"
    ],
    [
        0.1,
        2,
        "=CHISQ.INV.RT(A5,B5)"
    ]
]

        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('ZjJiZmM0NWU0Yzc1YzU5ZmRmZDQ1ZDM2ZDMyNzI2MTliYjhhZWVlYjlkMmI5NmFkMWYzMzVhN2NlMDRhNGNlMGYyNGRlY2MxN2RjOTk0MzQyZjc5YzYwMDdmMDM2ZTFhNzljNjUwN2E3ZDdlODA3YjI5ZGI1ODBiNzZiN2EyZDEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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",
        "Degrees of Freedom",
        "Chi-Square Critical Value"
    ],
    [
        0.05,
        1,
        "=CHISQ.INV.RT(A2,B2)"
    ],
    [
        0.01,
        3,
        "=CHISQ.INV.RT(A3,B3)"
    ],
    [
        0.001,
        5,
        "=CHISQ.INV.RT(A4,B4)"
    ],
    [
        0.1,
        2,
        "=CHISQ.INV.RT(A5,B5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub