🕷️ Crawler Inspector

[Skip to main content]() [ Microsoft](https://www.microsoft.com/) Support [Support](https://support.microsoft.com/en-us) Support - [Home](https://support.microsoft.com/en-us) - [Microsoft 365](https://www.microsoft.com/microsoft-365?ocid=cmmttvzgpuy) - [Office](https://www.microsoft.com/microsoft-365/microsoft-office?ocid=cmml7tr0rib) - Products - [Microsoft 365](https://support.microsoft.com/en-us/microsoft-365) - [Outlook](https://support.microsoft.com/en-us/outlook) - [Microsoft Teams](https://support.microsoft.com/en-us/teams) - [OneDrive](https://support.microsoft.com/en-us/onedrive) - [Microsoft Copilot](https://support.microsoft.com/en-us/microsoft-copilot) - [OneNote](https://support.microsoft.com/en-us/onenote) - [Windows](https://support.microsoft.com/en-us/windows) - [more ...](https://support.microsoft.com/en-us/all-products) - More - Devices - [Surface](https://support.microsoft.com/en-us/surface) - [PC Accessories](https://support.microsoft.com/en-us/pc-accessories) - [Xbox](https://support.xbox.com/) - [PC Gaming](https://support.xbox.com/help/games-apps/my-games-apps/all-about-pc-gaming) - [HoloLens](https://docs.microsoft.com/hololens/) - [Surface Hub](https://learn.microsoft.com/surface-hub/) - [Hardware warranties](https://support.microsoft.com/en-us/warranty) - Account & billing - [Account](https://support.microsoft.com/en-us/account) - [Microsoft Store & billing](https://support.microsoft.com/en-us/microsoft-store-and-billing) - Resources - [Install Microsoft 365](https://support.microsoft.com/en-us/office/4414eaaf-0478-48be-9c42-23adc4716658) - [Community forums](https://answers.microsoft.com/lang/msoffice/forum) - [Microsoft 365 Admins](https://portal.office.com/AdminPortal#/support) - [Small Business Portal](https://go.microsoft.com/fwlink/?linkid=2224585) - [Developer](https://developer.microsoft.com/) - [Education](https://support.microsoft.com/en-us/education) - [Report a support scam](https://www.microsoft.com/reportascam/) - [Product safety](https://support.microsoft.com/en-us/surface/cbc47825-19b9-4786-8088-eb9963d780d3) - [Buy Microsoft 365](https://go.microsoft.com/fwlink/?linkid=849747) - All Microsoft - ## Global - [Microsoft 365](https://www.microsoft.com/microsoft-365) - [Azure](https://azure.microsoft.com/en-us?ocid=cmm4r4ppnhp) - [Copilot](https://copilot.microsoft.com/) - [Windows](https://www.microsoft.com/en-us/windows/) - [Surface](https://www.microsoft.com/surface) - [Xbox](https://www.xbox.com/) - [Deals](https://www.microsoft.com/en-us/store/b/sale?icid=DSM_TopNavDeals) - [Small Business](https://www.microsoft.com/en-us/store/b/business) - [Support](https://support.microsoft.com/en-us) - Software Software - [Windows Apps](https://apps.microsoft.com/home) - [Outlook](https://www.microsoft.com/en-us/microsoft-365/outlook/email-and-calendar-software-microsoft-outlook) - [OneDrive](https://www.microsoft.com/en-us/microsoft-365/onedrive/online-cloud-storage) - [Microsoft Teams](https://www.microsoft.com/en-us/microsoft-teams/group-chat-software) - [OneNote](https://www.microsoft.com/en-us/microsoft-365/onenote/digital-note-taking-app) - [Microsoft Edge](https://www.microsoft.com/edge) - [Moving from Skype to Teams](https://support.microsoft.com/en-us/office/moving-from-skype-to-microsoft-teams-free-3c0caa26-d9db-4179-bcb3-930ae2c87570?icid=DSM_All_Skype) - PCs & Devices PCs & Devices - [Computers](https://www.microsoft.com/en-us/store/b/pc?icid=CNavDevicesPC) - [Shop Xbox](https://www.microsoft.com/en-us/store/b/xbox?icid=CNavDevicesXbox) - [Accessories](https://www.microsoft.com/en-us/store/b/accessories?icid=CNavDevicesAccessories) - [VR & mixed reality](https://www.microsoft.com/en-us/store/b/virtualreality?icid=CNavVirtualReality) - [Certified Refurbished](https://www.microsoft.com/en-us/store/b/certified-refurbished-products) - [Trade-in for cash](https://www.microsoft.com/en-us/store/b/microsoft-trade-in) - Entertainment Entertainment - [Xbox Game Pass Ultimate](https://www.xbox.com/en-us/games/store/xbox-game-pass-ultimate/cfq7ttc0khs0?icid=CNavAllXboxGamePassUltimate) - [PC Game Pass](https://www.xbox.com/en-us/games/store/pc-game-pass/cfq7ttc0kgq8?icid=CNavAllPCGamePass) - [Xbox games](https://www.microsoft.com/en-us/store/b/xboxgames?icid=CNavGamesXboxGames) - [PC games](https://apps.microsoft.com/games) - Business Business - [Microsoft AI](https://www.microsoft.com/en-us/ai?icid=DSM_All_AI) - [Microsoft Security](https://www.microsoft.com/en-us/security) - [Dynamics 365](https://www.microsoft.com/en-us/dynamics-365) - [Microsoft 365 for business](https://www.microsoft.com/en-us/microsoft-365/business) - [Microsoft Power Platform](https://www.microsoft.com/en-us/power-platform) - [Windows 365](https://www.microsoft.com/en-us/windows-365) - [Small Business](https://www.microsoft.com/en-us/store/b/business?icid=CNavBusinessStore) - [Digital Sovereignty](https://www.microsoft.com/en-us/sovereignty?icid=DSM_More_Sovereignty) - Developer & IT Developer & IT - [Azure](https://azure.microsoft.com/en-us/) - [Microsoft Developer](https://developer.microsoft.com/en-us/) - [Microsoft Learn](https://learn.microsoft.com/) - [Support for AI marketplace apps](https://www.microsoft.com/software-development-companies/offers-benefits/isv-success?icid=DSM_All_SupportAIMarketplace&ocid=cmm3atxvn98) - [Microsoft Tech Community](https://techcommunity.microsoft.com/) - [Microsoft Marketplace](https://marketplace.microsoft.com/?icid=DSM_All_Marketplace&ocid=cmm3atxvn98) - [Marketplace Rewards](https://www.microsoft.com/software-development-companies/offers-benefits/marketplace-rewards?icid=DSM_All_MarketplaceRewards&ocid=cmm3atxvn98) - [Visual Studio](https://visualstudio.microsoft.com/) - Other Other - [Microsoft Rewards](https://www.microsoft.com/rewards) - [Free downloads & security](https://www.microsoft.com/en-us/download) - [Education](https://www.microsoft.com/en-us/education) - [Gift cards](https://www.microsoft.com/en-us/store/b/gift-cards?icid=DSM_All_GiftCards) - [Licensing](https://www.microsoft.com/licensing/) - [Unlocked stories](https://unlocked.microsoft.com/) - [View Sitemap](https://www.microsoft.com/en-us/sitemap) Cancel [Sign in to your account](https://support.microsoft.com/en-us/authentication/signin?ru=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fbeta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31) Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. # BETA.DIST function Applies To Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. ## Syntax BETA.DIST(x,alpha,beta,cumulative,\[A\],\[B\]) The BETA.DIST function syntax has the following arguments: - **X** Required. The value between A and B at which to evaluate the function - **Alpha** Required. A parameter of the distribution. - **Beta** Required. A parameter of the distribution. - **Cumulative** Required. A logical value that determines the form of the function. If cumulative is TRUE, BETA.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function. - **A** Optional. A lower bound to the interval of x. - **B** Optional. An upper bound to the interval of x. ## Remarks - If any argument is nonnumeric, BETA.DIST returns the \#VALUE! error value. - If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the \#NUM! error value. - If x \< A, x \> B, or A = B, BETA.DIST returns the \#NUM! error value. - If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1 ## Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. | | | | |---|---|---| | **Data** | **Description** | | | 2 | Value at which to evaluate the function | | | 8 | Parameter of the distribution | | | 10 | Parameter of the distribution | | | 1 | Lower bound | | | 3 | Upper bound | | | **Formula** | **Description** | **Result** | | \=BETA.DIST(A2,A3,A4,TRUE,A5,A6) | Cumulative beta probability density function, for the above parameters | 0\.6854706 | | \=BETA.DIST(A2,A3,A4,FALSE,A5,A6) | Beta probability density function, for the above parameters | 1\.4837646 | [](https://www.facebook.com/sharer.php?u=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fbeta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31 "Share on Facebook") [](https://linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fbeta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31&title=BETA.DIST%20function "Share on LinkedIn") [](mailto://?subject=I%20think%20you%27d%20be%20interested%20in%20this%3A%20BETA.DIST%20function&body=BETA.DIST%20function%20https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fbeta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31 "Share by email") ### Need more help? ### Want more options? Discover Community Explore subscription benefits, browse training courses, learn how to secure your device, and more.  [Microsoft 365 subscription benefits](https://www.microsoft.com/microsoft-365?ocid=cmmg4dr5b7t)  [Microsoft 365 training](https://support.microsoft.com/en-us/training)  [Microsoft security](https://support.microsoft.com/en-us/security)  [Accessibility center](https://support.microsoft.com/en-us/accessibility) Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.  [Ask the Microsoft Community](https://learn.microsoft.com/answers/)  [Microsoft Tech Community](https://techcommunity.microsoft.com/)  [Windows Insiders](https://insider.windows.com/)  [Microsoft 365 Insiders](https://insider.office.com/) ## Thank you for your feedback\! [×]() What's new - [Surface Pro](https://www.microsoft.com/surface/devices/surface-pro) - [Surface Laptop](https://www.microsoft.com/surface/devices/surface-laptop) - [Surface Laptop Studio 2](https://www.microsoft.com/en-us/d/Surface-Laptop-Studio-2/8rqr54krf1dz) - [Copilot for organizations](https://www.microsoft.com/en-us/microsoft-copilot/organizations?icid=DSM_Footer_CopilotOrganizations) - [Copilot for personal use](https://www.microsoft.com/en-us/microsoft-copilot/for-individuals?form=MY02PT&OCID=GE_web_Copilot_Free_868g3t5nj) - [AI in Windows](https://www.microsoft.com/en-us/windows/ai-features?icid=DSM_Footer_WhatsNew_AIinWindows) - [Explore Microsoft products](https://www.microsoft.com/en-us/microsoft-products-and-apps) - [Windows 11 apps](https://www.microsoft.com/en-us/windows/apps-for-windows?icid=DSM_Footer_WhatsNew_Windows11apps) Microsoft Store - [Account profile](https://account.microsoft.com/) - [Download Center](https://www.microsoft.com/en-us/download) - [Microsoft Store support](https://go.microsoft.com/fwlink/?linkid=2139749) - [Returns](https://www.microsoft.com/en-us/store/b/returns) - [Order tracking](https://www.microsoft.com/en-us/store/b/order-tracking) - [Certified Refurbished](https://www.microsoft.com/en-us/store/b/certified-refurbished-products) - [Microsoft Store Promise](https://www.microsoft.com/en-us/store/b/why-microsoft-store?icid=footer_why-msft-store_7102020) - [Flexible Payments](https://www.microsoft.com/en-us/store/b/payment-financing-options?icid=footer_financing_vcc) Education - [Microsoft in education](https://www.microsoft.com/en-us/education) - [Devices for education](https://www.microsoft.com/en-us/education/devices/overview) - [Microsoft Teams for Education](https://www.microsoft.com/en-us/education/products/teams) - [Microsoft 365 Education](https://www.microsoft.com/en-us/education/products/microsoft-365) - [How to buy for your school](https://www.microsoft.com/education/how-to-buy) - [Educator training and development](https://education.microsoft.com/) - [Deals for students and parents](https://www.microsoft.com/en-us/store/b/education) - [AI for education](https://www.microsoft.com/en-us/education/ai-in-education) Business - [Microsoft AI](https://www.microsoft.com/en-us/ai?icid=DSM_Footer_AI) - [Microsoft Security](https://www.microsoft.com/en-us/security) - [Dynamics 365](https://www.microsoft.com/en-us/dynamics-365) - [Microsoft 365](https://www.microsoft.com/en-us/microsoft-365/business) - [Microsoft Power Platform](https://www.microsoft.com/en-us/power-platform) - [Microsoft Teams](https://www.microsoft.com/en-us/microsoft-teams/group-chat-software) - [Microsoft 365 Copilot](https://www.microsoft.com/en-us/microsoft-365-copilot?icid=DSM_Footer_Microsoft365Copilot) - [Small Business](https://www.microsoft.com/en-us/store/b/business?icid=CNavBusinessStore) Developer & IT - [Azure](https://azure.microsoft.com/en-us/) - [Microsoft Developer](https://developer.microsoft.com/en-us/) - [Microsoft Learn](https://learn.microsoft.com/) - [Support for AI marketplace apps](https://www.microsoft.com/software-development-companies/offers-benefits/isv-success?icid=DSM_Footer_SupportAIMarketplace&ocid=cmm3atxvn98) - [Microsoft Tech Community](https://techcommunity.microsoft.com/) - [Microsoft Marketplace](https://marketplace.microsoft.com/?icid=DSM_Footer_Marketplace&ocid=cmm3atxvn98) - [Marketplace Rewards](https://www.microsoft.com/software-development-companies/offers-benefits/marketplace-rewards?icid=DSM_Footer_MarketplaceRewards&ocid=cmm3atxvn98) - [Visual Studio](https://visualstudio.microsoft.com/) Company - [Careers](https://careers.microsoft.com/) - [About Microsoft](https://www.microsoft.com/about) - [Company news](https://news.microsoft.com/source/?icid=DSM_Footer_Company_CompanyNews) - [Privacy at Microsoft](https://www.microsoft.com/en-us/privacy?icid=DSM_Footer_Company_Privacy) - [Investors](https://www.microsoft.com/investor/default.aspx) - [Diversity and inclusion](https://www.microsoft.com/en-us/diversity/default?icid=DSM_Footer_Company_Diversity) - [Accessibility](https://www.microsoft.com/en-us/accessibility) - [Sustainability](https://www.microsoft.com/en-us/sustainability/) [English (United States)](https://support.microsoft.com/en-us/worldwide) [Your Privacy Choices](https://aka.ms/yourcaliforniaprivacychoices) [Your Privacy Choices](https://aka.ms/yourcaliforniaprivacychoices) [Consumer Health Privacy](https://go.microsoft.com/fwlink/?linkid=2259814) - [Sitemap](https://www.microsoft.com/en-us/sitemap1.aspx) - [Contact Microsoft](https://support.microsoft.com/contactus?ContactUsExperienceEntryPointAssetId=11188c9c-780a-42c7-ba43-9ecb5a878d31) - [Privacy](https://go.microsoft.com/fwlink/?LinkId=521839) - [Manage cookies](https://support.microsoft.com/en-us/office/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31) - [Terms of use](https://go.microsoft.com/fwlink/?LinkID=206977) - [Trademarks](https://go.microsoft.com/fwlink/?linkid=2196228) - [Safety & eco](https://go.microsoft.com/fwlink/?linkid=2196227) - [Recycling](https://www.microsoft.com/en-us/legal/compliance/recycling) - [About our ads](https://choice.microsoft.com/) - © Microsoft 2026

Applies To Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. ## Syntax BETA.DIST(x,alpha,beta,cumulative,\[A\],\[B\]) The BETA.DIST function syntax has the following arguments: - **X** Required. The value between A and B at which to evaluate the function - **Alpha** Required. A parameter of the distribution. - **Beta** Required. A parameter of the distribution. - **Cumulative** Required. A logical value that determines the form of the function. If cumulative is TRUE, BETA.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function. - **A** Optional. A lower bound to the interval of x. - **B** Optional. An upper bound to the interval of x. ## Remarks - If any argument is nonnumeric, BETA.DIST returns the \#VALUE! error value. - If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the \#NUM! error value. - If x \< A, x \> B, or A = B, BETA.DIST returns the \#NUM! error value. - If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1 ## Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. | | | | |---|---|---| | **Data** | **Description** | | | 2 | Value at which to evaluate the function | | | 8 | Parameter of the distribution | | | 10 | Parameter of the distribution | | | 1 | Lower bound | | | 3 | Upper bound | | | **Formula** | **Description** | **Result** | | \=BETA.DIST(A2,A3,A4,TRUE,A5,A6) | Cumulative beta probability density function, for the above parameters | 0\.6854706 | | \=BETA.DIST(A2,A3,A4,FALSE,A5,A6) | Beta probability density function, for the above parameters | 1\.4837646 | ### Need more help? ### Want more options? Explore subscription benefits, browse training courses, learn how to secure your device, and more.