GAMMADIST function
PRO
The GAMMADIST
function in Jspreadsheet Formulas Pro is a powerful tool that helps you calculate the gamma distribution. The gamma distribution is a continuous probability distribution used to model positively skewed data, with calculations available for both the probability density function (PDF) and cumulative distribution function (CDF). This means it's particularly useful for data that tends to have higher values on the right side. By using the GAMMADIST
function, you can easily analyze and interpret such data sets in Jspreadsheet.
Documentation
Calculates the gamma distribution (PDF or CDF), which models data with positive skewness and a long right tail.
Category
Statistical
Syntax
GAMMADIST(x, alpha, beta, cumulative)
Parameter | Description |
---|---|
x |
The value at which you want to evaluate the distribution. |
alpha |
A parameter that specifies the shape of the distribution. Alpha must be greater than 0. |
beta |
A parameter that specifies the scale of the distribution. Beta must be greater than 0. |
cumulative |
Parameter that specifies whether to return the cumulative distribution function (CDF) or the probability density function (PDF). Enter TRUE to return the CDF, or FALSE to return the PDF. |
Behavior
The GAMMADIST
function calculates the gamma distribution, often used in probability theory and statistics. Here's how it behaves with different inputs:
- Empty Cells: If any of the input cells are empty, the function will return an error as it requires all the arguments to calculate the distribution.
- Text: If there is any text input in the argument cells,
GAMMADIST
will return an error as it only accepts numerical inputs. - Booleans: Boolean values are also not accepted by
GAMMADIST
. If any Boolean value is provided, the function will return an error. - Errors: If any of the argument cells contain an error, the
GAMMADIST
function will also return an error. - Negative Values: If a negative value is provided for the alpha or beta parameters, the function will return an error as these parameters must be positive.
Common Errors
Error | Description |
---|---|
#NUM! | This error is returned when alpha, beta, or x is less than or equal to zero, as these parameters must be positive in the gamma distribution. |
#VALUE! | This error is returned when a non-numeric argument is supplied or if any of the argument cells contain text. |
#N/A | This error is returned when insufficient arguments are provided to the function. GAMMADIST requires four arguments: x, alpha, beta, and cumulative. |
Best practices
- Always ensure that the alpha, beta, and x parameters are positive. If any of these values are zero or less, the function will return an error.
- The
GAMMADIST
function will return an error if non-numeric values are provided. Therefore, it is essential to validate the input data before using this function.- It's always a good practice to handle possible errors using functions like
IFERROR
to avoid disruption in the calculation flow.- Understand that when the cumulative argument is FALSE,
GAMMADIST
returns the probability density function (PDF). When TRUE, it returns the cumulative distribution function (CDF).
Usage
A few examples using the GAMMADIST function.
GAMMADIST(2,3,2,FALSE) // Returns 0.09196986 (PDF)
GAMMADIST(10,5,1.5,TRUE) // Returns 0.794372753 (CDF)
GAMMADIST(20,7,4,FALSE) // Returns 0.036555702 (PDF)
GAMMADIST(-2,3,2,FALSE) // Returns #NUM! (x must be positive)
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('ZmNmMjExMDVlNzg3YjcyMjBiMTEzMzNjMDE2ZTQwN2FmNjhlY2YxNDRhNjEzNDI1NzJiNDVmMmZkNGJjZDU5NDBiZjg1OTc0M2ViNGM3N2IxYmYyZjI4NThiNjhkMDBkN2FlMmE0YjUwOGZkMjEyN2U2MjA2ZGIyMjMwNDVkOWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOekF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
data: [
[
"x",
"alpha",
"beta",
"cumulative",
"GAMMADIST Result"
],
[
2,
3,
2,
"FALSE",
"=GAMMADIST(A2,B2,C2,D2)"
],
[
10,
5,
1.5,
"TRUE",
"=GAMMADIST(A3,B3,C3,D3)"
],
[
20,
7,
4,
"FALSE",
"=GAMMADIST(A4,B4,C4,D4)"
],
[
15,
4,
3,
"TRUE",
"=GAMMADIST(A5,B5,C5,D5)"
]
]
}]
});
</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('ZmNmMjExMDVlNzg3YjcyMjBiMTEzMzNjMDE2ZTQwN2FmNjhlY2YxNDRhNjEzNDI1NzJiNDVmMmZkNGJjZDU5NDBiZjg1OTc0M2ViNGM3N2IxYmYyZjI4NThiNjhkMDBkN2FlMmE0YjUwOGZkMjEyN2U2MjA2ZGIyMjMwNDVkOWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOekF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default function App() {
// Spreadsheet array of worksheets
const spreadsheet = useRef();
// Worksheet data
const data = [
[
"x",
"alpha",
"beta",
"cumulative",
"GAMMADIST Result"
],
[
2,
3,
2,
"FALSE",
"=GAMMADIST(A2,B2,C2,D2)"
],
[
10,
5,
1.5,
"TRUE",
"=GAMMADIST(A3,B3,C3,D3)"
],
[
20,
7,
4,
"FALSE",
"=GAMMADIST(A4,B4,C4,D4)"
],
[
15,
4,
3,
"TRUE",
"=GAMMADIST(A5,B5,C5,D5)"
]
];
// 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('ZmNmMjExMDVlNzg3YjcyMjBiMTEzMzNjMDE2ZTQwN2FmNjhlY2YxNDRhNjEzNDI1NzJiNDVmMmZkNGJjZDU5NDBiZjg1OTc0M2ViNGM3N2IxYmYyZjI4NThiNjhkMDBkN2FlMmE0YjUwOGZkMjEyN2U2MjA2ZGIyMjMwNDVkOWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOekF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default {
components: {
Spreadsheet,
Worksheet,
},
data() {
// Worksheet data
const data = [
[
"x",
"alpha",
"beta",
"cumulative",
"GAMMADIST Result"
],
[
2,
3,
2,
"FALSE",
"=GAMMADIST(A2,B2,C2,D2)"
],
[
10,
5,
1.5,
"TRUE",
"=GAMMADIST(A3,B3,C3,D3)"
],
[
20,
7,
4,
"FALSE",
"=GAMMADIST(A4,B4,C4,D4)"
],
[
15,
4,
3,
"TRUE",
"=GAMMADIST(A5,B5,C5,D5)"
]
]
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('ZmNmMjExMDVlNzg3YjcyMjBiMTEzMzNjMDE2ZTQwN2FmNjhlY2YxNDRhNjEzNDI1NzJiNDVmMmZkNGJjZDU5NDBiZjg1OTc0M2ViNGM3N2IxYmYyZjI4NThiNjhkMDBkN2FlMmE0YjUwOGZkMjEyN2U2MjA2ZGIyMjMwNDVkOWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOekF4TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// 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: [
[
"x",
"alpha",
"beta",
"cumulative",
"GAMMADIST Result"
],
[
2,
3,
2,
"FALSE",
"=GAMMADIST(A2,B2,C2,D2)"
],
[
10,
5,
1.5,
"TRUE",
"=GAMMADIST(A3,B3,C3,D3)"
],
[
20,
7,
4,
"FALSE",
"=GAMMADIST(A4,B4,C4,D4)"
],
[
15,
4,
3,
"TRUE",
"=GAMMADIST(A5,B5,C5,D5)"
]
]
}]
});
}
}