🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 168 (from laksa088)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa168.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical, ml_categories_json AS ml_categories_json, ml_types_json AS ml_types_json, ml_intent_types_json AS ml_intent_types_json, meta_language AS meta_language, attrs_author AS attrs_author, ifNull(toUnixTimestamp(attrs_publish_time), 0) AS attrs_publish_time, ifNull(toUnixTimestamp(attrs_original_publish_time), 0) AS attrs_original_publish_time, ifNull(attrs_is_republished, 0) AS attrs_is_republished, ifNull(attrs_nr_words, 0) AS attrs_nr_words, ifNull(attrs_boilerpipe_nr_words, 0) AS attrs_boilerpipe_nr_words, ifNull(body_ext_links_number, 0) AS body_ext_links_number, ifNull(body_int_links_number, 0) AS body_int_links_number, ifNull(meta_nofollow, 0) AS meta_nofollow, ifNull(meta_noarchive, 0) AS meta_noarchive, ifNull(props_was_rendered, 0) AS props_was_rendered, ifNull(src_redirect, \'\') AS src_redirect, ifNull(download_time_msec, 0) AS download_time_msec, ifNull(download_ttfb_msec, 0) AS download_ttfb_msec, ifNull(download_size, 0) AS download_size FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://support.microsoft.com/en-us/office/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31\')), getAhrefsUnparsedNoserviceFromURL(\'https://support.microsoft.com/en-us/office/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/support.microsoft.com\/en-us\/office\/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31","crawl_time":1774226518,"first_indexed_time":1593971987,"http_code":200,"src_unparsed":"com,microsoft!support,\/en-us\/office\/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31 s443","src_root_hash":"14615152987638977768","history_drop_reason":null,"meta_title":"BETA.DIST function - Microsoft Support","meta_descriptions":["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."],"attrs_boilerpipe_text":"Applies To\nExcel for Microsoft 365\nExcel for Microsoft 365 for Mac\nExcel for the web\nExcel 2024\nExcel 2024 for Mac\nExcel 2021\nExcel 2021 for Mac\nExcel 2019\nExcel 2016\nReturns the beta distribution.\nThe 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.\nSyntax\nBETA.DIST(x,alpha,beta,cumulative,[A],[B])\nThe BETA.DIST function syntax has the following arguments:\nX\n     Required. The value between A and B at which to evaluate the function\nAlpha\n     Required. A parameter of the distribution.\nBeta\n     Required. A parameter of the distribution.\nCumulative\n     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.\nA\n     Optional. A lower bound to the interval of x.\nB\n     Optional. An upper bound to the interval of x.\nRemarks\nIf any argument is nonnumeric, BETA.DIST returns the #VALUE! error value.\nIf alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error value.\nIf x < A, x > B, or A = B, BETA.DIST returns the #NUM! error value.\nIf you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1\nExample\nCopy 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.\nData\nDescription\n2\nValue at which to evaluate the function\n8\nParameter of the distribution\n10\nParameter of the distribution\n1\nLower bound\n3\nUpper bound\nFormula\nDescription\nResult\n=BETA.DIST(A2,A3,A4,TRUE,A5,A6)\nCumulative beta probability density function, for the above parameters\n0.6854706\n=BETA.DIST(A2,A3,A4,FALSE,A5,A6)\nBeta probability density function, for the above parameters\n1.4837646\nNeed more help?\nWant more options?\nExplore subscription benefits, browse training courses, learn how to secure your device, and more.","attrs_markdown":"[Skip to main content]()\n\n[![](https:\/\/uhf.microsoft.com\/images\/microsoft\/RE1Mu3b.png) Microsoft](https:\/\/www.microsoft.com\/)\n\nSupport\n\n[Support](https:\/\/support.microsoft.com\/en-us)\n\nSupport\n\n- [Home](https:\/\/support.microsoft.com\/en-us)\n- [Microsoft 365](https:\/\/www.microsoft.com\/microsoft-365?ocid=cmmttvzgpuy)\n- [Office](https:\/\/www.microsoft.com\/microsoft-365\/microsoft-office?ocid=cmml7tr0rib)\n- Products\n  \n  - [Microsoft 365](https:\/\/support.microsoft.com\/en-us\/microsoft-365)\n  - [Outlook](https:\/\/support.microsoft.com\/en-us\/outlook)\n  - [Microsoft Teams](https:\/\/support.microsoft.com\/en-us\/teams)\n  - [OneDrive](https:\/\/support.microsoft.com\/en-us\/onedrive)\n  - [Microsoft Copilot](https:\/\/support.microsoft.com\/en-us\/microsoft-copilot)\n  - [OneNote](https:\/\/support.microsoft.com\/en-us\/onenote)\n  - [Windows](https:\/\/support.microsoft.com\/en-us\/windows)\n  - [more ...](https:\/\/support.microsoft.com\/en-us\/all-products)\n- More\n  \n  - Devices\n    - [Surface](https:\/\/support.microsoft.com\/en-us\/surface)\n    - [PC Accessories](https:\/\/support.microsoft.com\/en-us\/pc-accessories)\n    - [Xbox](https:\/\/support.xbox.com\/)\n    - [PC Gaming](https:\/\/support.xbox.com\/help\/games-apps\/my-games-apps\/all-about-pc-gaming)\n    - [HoloLens](https:\/\/docs.microsoft.com\/hololens\/)\n    - [Surface Hub](https:\/\/learn.microsoft.com\/surface-hub\/)\n    - [Hardware warranties](https:\/\/support.microsoft.com\/en-us\/warranty)\n  - Account & billing\n    - [Account](https:\/\/support.microsoft.com\/en-us\/account)\n    - [Microsoft Store & billing](https:\/\/support.microsoft.com\/en-us\/microsoft-store-and-billing)\n  - Resources\n    - [Install Microsoft 365](https:\/\/support.microsoft.com\/en-us\/office\/4414eaaf-0478-48be-9c42-23adc4716658)\n    - [Community forums](https:\/\/answers.microsoft.com\/lang\/msoffice\/forum)\n    - [Microsoft 365 Admins](https:\/\/portal.office.com\/AdminPortal#\/support)\n    - [Small Business Portal](https:\/\/go.microsoft.com\/fwlink\/?linkid=2224585)\n    - [Developer](https:\/\/developer.microsoft.com\/)\n    - [Education](https:\/\/support.microsoft.com\/en-us\/education)\n    - [Report a support scam](https:\/\/www.microsoft.com\/reportascam\/)\n    - [Product safety](https:\/\/support.microsoft.com\/en-us\/surface\/cbc47825-19b9-4786-8088-eb9963d780d3)\n- [Buy Microsoft 365](https:\/\/go.microsoft.com\/fwlink\/?linkid=849747)\n\n- All Microsoft\n  \n  - ## Global\n    - [Microsoft 365](https:\/\/www.microsoft.com\/microsoft-365)\n    - [Azure](https:\/\/azure.microsoft.com\/en-us?ocid=cmm4r4ppnhp)\n    - [Copilot](https:\/\/copilot.microsoft.com\/)\n    - [Windows](https:\/\/www.microsoft.com\/en-us\/windows\/)\n    - [Surface](https:\/\/www.microsoft.com\/surface)\n    - [Xbox](https:\/\/www.xbox.com\/)\n    - [Deals](https:\/\/www.microsoft.com\/en-us\/store\/b\/sale?icid=DSM_TopNavDeals)\n    - [Small Business](https:\/\/www.microsoft.com\/en-us\/store\/b\/business)\n    - [Support](https:\/\/support.microsoft.com\/en-us)\n  - Software\n    Software\n    - [Windows Apps](https:\/\/apps.microsoft.com\/home)\n    - [Outlook](https:\/\/www.microsoft.com\/en-us\/microsoft-365\/outlook\/email-and-calendar-software-microsoft-outlook)\n    - [OneDrive](https:\/\/www.microsoft.com\/en-us\/microsoft-365\/onedrive\/online-cloud-storage)\n    - [Microsoft Teams](https:\/\/www.microsoft.com\/en-us\/microsoft-teams\/group-chat-software)\n    - [OneNote](https:\/\/www.microsoft.com\/en-us\/microsoft-365\/onenote\/digital-note-taking-app)\n    - [Microsoft Edge](https:\/\/www.microsoft.com\/edge)\n    - [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)\n  - PCs & Devices\n    PCs & Devices\n    - [Computers](https:\/\/www.microsoft.com\/en-us\/store\/b\/pc?icid=CNavDevicesPC)\n    - [Shop Xbox](https:\/\/www.microsoft.com\/en-us\/store\/b\/xbox?icid=CNavDevicesXbox)\n    - [Accessories](https:\/\/www.microsoft.com\/en-us\/store\/b\/accessories?icid=CNavDevicesAccessories)\n    - [VR & mixed reality](https:\/\/www.microsoft.com\/en-us\/store\/b\/virtualreality?icid=CNavVirtualReality)\n    - [Certified Refurbished](https:\/\/www.microsoft.com\/en-us\/store\/b\/certified-refurbished-products)\n    - [Trade-in for cash](https:\/\/www.microsoft.com\/en-us\/store\/b\/microsoft-trade-in)\n  - Entertainment\n    Entertainment\n    - [Xbox Game Pass Ultimate](https:\/\/www.xbox.com\/en-us\/games\/store\/xbox-game-pass-ultimate\/cfq7ttc0khs0?icid=CNavAllXboxGamePassUltimate)\n    - [PC Game Pass](https:\/\/www.xbox.com\/en-us\/games\/store\/pc-game-pass\/cfq7ttc0kgq8?icid=CNavAllPCGamePass)\n    - [Xbox games](https:\/\/www.microsoft.com\/en-us\/store\/b\/xboxgames?icid=CNavGamesXboxGames)\n    - [PC games](https:\/\/apps.microsoft.com\/games)\n  - Business\n    Business\n    - [Microsoft AI](https:\/\/www.microsoft.com\/en-us\/ai?icid=DSM_All_AI)\n    - [Microsoft Security](https:\/\/www.microsoft.com\/en-us\/security)\n    - [Dynamics 365](https:\/\/www.microsoft.com\/en-us\/dynamics-365)\n    - [Microsoft 365 for business](https:\/\/www.microsoft.com\/en-us\/microsoft-365\/business)\n    - [Microsoft Power Platform](https:\/\/www.microsoft.com\/en-us\/power-platform)\n    - [Windows 365](https:\/\/www.microsoft.com\/en-us\/windows-365)\n    - [Small Business](https:\/\/www.microsoft.com\/en-us\/store\/b\/business?icid=CNavBusinessStore)\n    - [Digital Sovereignty](https:\/\/www.microsoft.com\/en-us\/sovereignty?icid=DSM_More_Sovereignty)\n  - Developer & IT\n    Developer & IT\n    - [Azure](https:\/\/azure.microsoft.com\/en-us\/)\n    - [Microsoft Developer](https:\/\/developer.microsoft.com\/en-us\/)\n    - [Microsoft Learn](https:\/\/learn.microsoft.com\/)\n    - [Support for AI marketplace apps](https:\/\/www.microsoft.com\/software-development-companies\/offers-benefits\/isv-success?icid=DSM_All_SupportAIMarketplace&ocid=cmm3atxvn98)\n    - [Microsoft Tech Community](https:\/\/techcommunity.microsoft.com\/)\n    - [Microsoft Marketplace](https:\/\/marketplace.microsoft.com\/?icid=DSM_All_Marketplace&ocid=cmm3atxvn98)\n    - [Marketplace Rewards](https:\/\/www.microsoft.com\/software-development-companies\/offers-benefits\/marketplace-rewards?icid=DSM_All_MarketplaceRewards&ocid=cmm3atxvn98)\n    - [Visual Studio](https:\/\/visualstudio.microsoft.com\/)\n  - Other\n    Other\n    - [Microsoft Rewards](https:\/\/www.microsoft.com\/rewards)\n    - [Free downloads & security](https:\/\/www.microsoft.com\/en-us\/download)\n    - [Education](https:\/\/www.microsoft.com\/en-us\/education)\n    - [Gift cards](https:\/\/www.microsoft.com\/en-us\/store\/b\/gift-cards?icid=DSM_All_GiftCards)\n    - [Licensing](https:\/\/www.microsoft.com\/licensing\/)\n    - [Unlocked stories](https:\/\/unlocked.microsoft.com\/)\n  - [View Sitemap](https:\/\/www.microsoft.com\/en-us\/sitemap)\n\nCancel\n\n[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)\n\nSign in with Microsoft\n\nSign in or create an account.\n\nHello,\n\nSelect a different account.\n\nYou have multiple accounts\n\nChoose the account you want to sign in with.\n\n# BETA.DIST function\nApplies To\n\nExcel 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\n\nReturns the beta distribution.\n\nThe 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.\n\n## Syntax\nBETA.DIST(x,alpha,beta,cumulative,\\[A\\],\\[B\\])\n\nThe BETA.DIST function syntax has the following arguments:\n\n- **X** Required. The value between A and B at which to evaluate the function\n- **Alpha** Required. A parameter of the distribution.\n- **Beta** Required. A parameter of the distribution.\n- **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.\n- **A** Optional. A lower bound to the interval of x.\n- **B** Optional. An upper bound to the interval of x.\n\n## Remarks\n- If any argument is nonnumeric, BETA.DIST returns the \\#VALUE! error value.\n- If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the \\#NUM! error value.\n- If x \\< A, x \\> B, or A = B, BETA.DIST returns the \\#NUM! error value.\n- If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1\n\n## Example\nCopy 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.\n\n|   |   |   |\n|---|---|---|\n| **Data** | **Description** |   |\n| 2 | Value at which to evaluate the function |   |\n| 8 | Parameter of the distribution |   |\n| 10 | Parameter of the distribution |   |\n| 1 | Lower bound |   |\n| 3 | Upper bound |   |\n| **Formula** | **Description** | **Result** |\n| \\=BETA.DIST(A2,A3,A4,TRUE,A5,A6) | Cumulative beta probability density function, for the above parameters | 0\\.6854706 |\n| \\=BETA.DIST(A2,A3,A4,FALSE,A5,A6) | Beta probability density function, for the above parameters | 1\\.4837646 |\n\n[![Facebook](https:\/\/support.microsoft.com\/images\/Facebook-GrayScale.png)](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\")\n\n[![LinkedIn](https:\/\/support.microsoft.com\/images\/Linkedin-GrayScale.png)](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\")\n\n[![Email](https:\/\/support.microsoft.com\/images\/Mail-GrayScale.png)](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\")\n\n### Need more help?\n### Want more options?\nDiscover\n\nCommunity\n\nExplore subscription benefits, browse training courses, learn how to secure your device, and more.\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/f4e85874-2a1a-438d-9c3c-17b069c454c0)\n\n[Microsoft 365 subscription benefits](https:\/\/www.microsoft.com\/microsoft-365?ocid=cmmg4dr5b7t)\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/a9241eee-a729-4513-97b4-5b87c381c21b)\n\n[Microsoft 365 training](https:\/\/support.microsoft.com\/en-us\/training)\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/9e557d93-f803-44df-a274-1282d542cf63)\n\n[Microsoft security](https:\/\/support.microsoft.com\/en-us\/security)\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/fbf6e41b-ddbe-43db-a616-7a8e48d43d18)\n\n[Accessibility center](https:\/\/support.microsoft.com\/en-us\/accessibility)\n\nCommunities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/9255871d-06a6-4de5-9236-5fd7af100c5c)\n\n[Ask the Microsoft Community](https:\/\/learn.microsoft.com\/answers\/)\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/ccb7c2a6-17dd-4cc3-88b7-8da966e59f59)\n\n[Microsoft Tech Community](https:\/\/techcommunity.microsoft.com\/)\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/bcd2fdf1-530a-482f-b96d-5f2f2a49ac66)\n\n[Windows Insiders](https:\/\/insider.windows.com\/)\n\n![](https:\/\/support.microsoft.com\/images\/en-us\/f4e85874-2a1a-438d-9c3c-17b069c454c0)\n\n[Microsoft 365 Insiders](https:\/\/insider.office.com\/)\n\n## Thank you for your feedback\\!\n[×]()\n\nWhat's new\n\n- [Surface Pro](https:\/\/www.microsoft.com\/surface\/devices\/surface-pro)\n- [Surface Laptop](https:\/\/www.microsoft.com\/surface\/devices\/surface-laptop)\n- [Surface Laptop Studio 2](https:\/\/www.microsoft.com\/en-us\/d\/Surface-Laptop-Studio-2\/8rqr54krf1dz)\n- [Copilot for organizations](https:\/\/www.microsoft.com\/en-us\/microsoft-copilot\/organizations?icid=DSM_Footer_CopilotOrganizations)\n- [Copilot for personal use](https:\/\/www.microsoft.com\/en-us\/microsoft-copilot\/for-individuals?form=MY02PT&OCID=GE_web_Copilot_Free_868g3t5nj)\n- [AI in Windows](https:\/\/www.microsoft.com\/en-us\/windows\/ai-features?icid=DSM_Footer_WhatsNew_AIinWindows)\n- [Explore Microsoft products](https:\/\/www.microsoft.com\/en-us\/microsoft-products-and-apps)\n- [Windows 11 apps](https:\/\/www.microsoft.com\/en-us\/windows\/apps-for-windows?icid=DSM_Footer_WhatsNew_Windows11apps)\n\nMicrosoft Store\n\n- [Account profile](https:\/\/account.microsoft.com\/)\n- [Download Center](https:\/\/www.microsoft.com\/en-us\/download)\n- [Microsoft Store support](https:\/\/go.microsoft.com\/fwlink\/?linkid=2139749)\n- [Returns](https:\/\/www.microsoft.com\/en-us\/store\/b\/returns)\n- [Order tracking](https:\/\/www.microsoft.com\/en-us\/store\/b\/order-tracking)\n- [Certified Refurbished](https:\/\/www.microsoft.com\/en-us\/store\/b\/certified-refurbished-products)\n- [Microsoft Store Promise](https:\/\/www.microsoft.com\/en-us\/store\/b\/why-microsoft-store?icid=footer_why-msft-store_7102020)\n- [Flexible Payments](https:\/\/www.microsoft.com\/en-us\/store\/b\/payment-financing-options?icid=footer_financing_vcc)\n\nEducation\n\n- [Microsoft in education](https:\/\/www.microsoft.com\/en-us\/education)\n- [Devices for education](https:\/\/www.microsoft.com\/en-us\/education\/devices\/overview)\n- [Microsoft Teams for Education](https:\/\/www.microsoft.com\/en-us\/education\/products\/teams)\n- [Microsoft 365 Education](https:\/\/www.microsoft.com\/en-us\/education\/products\/microsoft-365)\n- [How to buy for your school](https:\/\/www.microsoft.com\/education\/how-to-buy)\n- [Educator training and development](https:\/\/education.microsoft.com\/)\n- [Deals for students and parents](https:\/\/www.microsoft.com\/en-us\/store\/b\/education)\n- [AI for education](https:\/\/www.microsoft.com\/en-us\/education\/ai-in-education)\n\nBusiness\n\n- [Microsoft AI](https:\/\/www.microsoft.com\/en-us\/ai?icid=DSM_Footer_AI)\n- [Microsoft Security](https:\/\/www.microsoft.com\/en-us\/security)\n- [Dynamics 365](https:\/\/www.microsoft.com\/en-us\/dynamics-365)\n- [Microsoft 365](https:\/\/www.microsoft.com\/en-us\/microsoft-365\/business)\n- [Microsoft Power Platform](https:\/\/www.microsoft.com\/en-us\/power-platform)\n- [Microsoft Teams](https:\/\/www.microsoft.com\/en-us\/microsoft-teams\/group-chat-software)\n- [Microsoft 365 Copilot](https:\/\/www.microsoft.com\/en-us\/microsoft-365-copilot?icid=DSM_Footer_Microsoft365Copilot)\n- [Small Business](https:\/\/www.microsoft.com\/en-us\/store\/b\/business?icid=CNavBusinessStore)\n\nDeveloper & IT\n\n- [Azure](https:\/\/azure.microsoft.com\/en-us\/)\n- [Microsoft Developer](https:\/\/developer.microsoft.com\/en-us\/)\n- [Microsoft Learn](https:\/\/learn.microsoft.com\/)\n- [Support for AI marketplace apps](https:\/\/www.microsoft.com\/software-development-companies\/offers-benefits\/isv-success?icid=DSM_Footer_SupportAIMarketplace&ocid=cmm3atxvn98)\n- [Microsoft Tech Community](https:\/\/techcommunity.microsoft.com\/)\n- [Microsoft Marketplace](https:\/\/marketplace.microsoft.com\/?icid=DSM_Footer_Marketplace&ocid=cmm3atxvn98)\n- [Marketplace Rewards](https:\/\/www.microsoft.com\/software-development-companies\/offers-benefits\/marketplace-rewards?icid=DSM_Footer_MarketplaceRewards&ocid=cmm3atxvn98)\n- [Visual Studio](https:\/\/visualstudio.microsoft.com\/)\n\nCompany\n\n- [Careers](https:\/\/careers.microsoft.com\/)\n- [About Microsoft](https:\/\/www.microsoft.com\/about)\n- [Company news](https:\/\/news.microsoft.com\/source\/?icid=DSM_Footer_Company_CompanyNews)\n- [Privacy at Microsoft](https:\/\/www.microsoft.com\/en-us\/privacy?icid=DSM_Footer_Company_Privacy)\n- [Investors](https:\/\/www.microsoft.com\/investor\/default.aspx)\n- [Diversity and inclusion](https:\/\/www.microsoft.com\/en-us\/diversity\/default?icid=DSM_Footer_Company_Diversity)\n- [Accessibility](https:\/\/www.microsoft.com\/en-us\/accessibility)\n- [Sustainability](https:\/\/www.microsoft.com\/en-us\/sustainability\/)\n\n[English (United States)](https:\/\/support.microsoft.com\/en-us\/worldwide)\n\n[Your Privacy Choices](https:\/\/aka.ms\/yourcaliforniaprivacychoices)\n\n[Your Privacy Choices](https:\/\/aka.ms\/yourcaliforniaprivacychoices)\n\n[Consumer Health Privacy](https:\/\/go.microsoft.com\/fwlink\/?linkid=2259814)\n\n- [Sitemap](https:\/\/www.microsoft.com\/en-us\/sitemap1.aspx)\n- [Contact Microsoft](https:\/\/support.microsoft.com\/contactus?ContactUsExperienceEntryPointAssetId=11188c9c-780a-42c7-ba43-9ecb5a878d31)\n- [Privacy](https:\/\/go.microsoft.com\/fwlink\/?LinkId=521839)\n- [Manage cookies](https:\/\/support.microsoft.com\/en-us\/office\/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31)\n- [Terms of use](https:\/\/go.microsoft.com\/fwlink\/?LinkID=206977)\n- [Trademarks](https:\/\/go.microsoft.com\/fwlink\/?linkid=2196228)\n- [Safety & eco](https:\/\/go.microsoft.com\/fwlink\/?linkid=2196227)\n- [Recycling](https:\/\/www.microsoft.com\/en-us\/legal\/compliance\/recycling)\n- [About our ads](https:\/\/choice.microsoft.com\/)\n- © Microsoft 2026","attrs_readable_markdown":"Applies To\n\nExcel 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\n\nReturns the beta distribution.\n\nThe 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.\n\n## Syntax\nBETA.DIST(x,alpha,beta,cumulative,\\[A\\],\\[B\\])\n\nThe BETA.DIST function syntax has the following arguments:\n\n- **X** Required. The value between A and B at which to evaluate the function\n- **Alpha** Required. A parameter of the distribution.\n- **Beta** Required. A parameter of the distribution.\n- **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.\n- **A** Optional. A lower bound to the interval of x.\n- **B** Optional. An upper bound to the interval of x.\n\n## Remarks\n- If any argument is nonnumeric, BETA.DIST returns the \\#VALUE! error value.\n- If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the \\#NUM! error value.\n- If x \\< A, x \\> B, or A = B, BETA.DIST returns the \\#NUM! error value.\n- If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1\n\n## Example\nCopy 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.\n\n|   |   |   |\n|---|---|---|\n| **Data** | **Description** |   |\n| 2 | Value at which to evaluate the function |   |\n| 8 | Parameter of the distribution |   |\n| 10 | Parameter of the distribution |   |\n| 1 | Lower bound |   |\n| 3 | Upper bound |   |\n| **Formula** | **Description** | **Result** |\n| \\=BETA.DIST(A2,A3,A4,TRUE,A5,A6) | Cumulative beta probability density function, for the above parameters | 0\\.6854706 |\n| \\=BETA.DIST(A2,A3,A4,FALSE,A5,A6) | Beta probability density function, for the above parameters | 1\\.4837646 |\n\n### Need more help?\n### Want more options?\nExplore subscription benefits, browse training courses, learn how to secure your device, and more.","meta_canonical":null,"ml_categories_json":"{\"\/Computers_and_Electronics\":672,\"\/Computers_and_Electronics\/Software\":616,\"\/Computers_and_Electronics\/Software\/Educational_Software\":409,\"\/Science\":384,\"\/Science\/Mathematics\":353,\"\/Science\/Mathematics\/Statistics\":318}","ml_types_json":"{\"\/Article\":475,\"\/Article\/Tutorial_or_Guide\":316}","ml_intent_types_json":"{\"Informational\":997}","meta_language":"en-us","attrs_author":null,"attrs_publish_time":0,"attrs_original_publish_time":1593971987,"attrs_is_republished":0,"attrs_nr_words":"894","attrs_boilerpipe_nr_words":"336","body_ext_links_number":21,"body_int_links_number":195,"meta_nofollow":0,"meta_noarchive":0,"props_was_rendered":1,"src_redirect":"","download_time_msec":109,"download_ttfb_msec":89,"download_size":144864}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

1 month ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	1.1 months ago (distributed domain, exempt)
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property

Value

URL

https://support.microsoft.com/en-us/office/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31

Last Crawled

2026-03-23 00:41:58 (1 month ago)

First Indexed

2020-07-05 17:59:47 (5 years ago)

HTTP Status Code

200

Content

Meta Title

BETA.DIST function - Microsoft Support

Meta Description

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.

Meta Canonical

null

Boilerpipe Text

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.

Markdown

[Skip to main content]() [![](https://uhf.microsoft.com/images/microsoft/RE1Mu3b.png) 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 | [![Facebook](https://support.microsoft.com/images/Facebook-GrayScale.png)](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") [![LinkedIn](https://support.microsoft.com/images/Linkedin-GrayScale.png)](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") [![Email](https://support.microsoft.com/images/Mail-GrayScale.png)](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. ![](https://support.microsoft.com/images/en-us/f4e85874-2a1a-438d-9c3c-17b069c454c0) [Microsoft 365 subscription benefits](https://www.microsoft.com/microsoft-365?ocid=cmmg4dr5b7t) ![](https://support.microsoft.com/images/en-us/a9241eee-a729-4513-97b4-5b87c381c21b) [Microsoft 365 training](https://support.microsoft.com/en-us/training) ![](https://support.microsoft.com/images/en-us/9e557d93-f803-44df-a274-1282d542cf63) [Microsoft security](https://support.microsoft.com/en-us/security) ![](https://support.microsoft.com/images/en-us/fbf6e41b-ddbe-43db-a616-7a8e48d43d18) [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. ![](https://support.microsoft.com/images/en-us/9255871d-06a6-4de5-9236-5fd7af100c5c) [Ask the Microsoft Community](https://learn.microsoft.com/answers/) ![](https://support.microsoft.com/images/en-us/ccb7c2a6-17dd-4cc3-88b7-8da966e59f59) [Microsoft Tech Community](https://techcommunity.microsoft.com/) ![](https://support.microsoft.com/images/en-us/bcd2fdf1-530a-482f-b96d-5f2f2a49ac66) [Windows Insiders](https://insider.windows.com/) ![](https://support.microsoft.com/images/en-us/f4e85874-2a1a-438d-9c3c-17b069c454c0) [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

Readable Markdown

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.

ML Classification

ML Categories

/Computers_and_Electronics		67.2%
/Computers_and_Electronics/Software		61.6%
/Computers_and_Electronics/Software/Educational_Software		40.9%
/Science		38.4%
/Science/Mathematics		35.3%
/Science/Mathematics/Statistics		31.8%

Raw JSON

{
    "/Computers_and_Electronics": 672,
    "/Computers_and_Electronics/Software": 616,
    "/Computers_and_Electronics/Software/Educational_Software": 409,
    "/Science": 384,
    "/Science/Mathematics": 353,
    "/Science/Mathematics/Statistics": 318
}

ML Page Types

/Article		47.5%
/Article/Tutorial_or_Guide		31.6%

Raw JSON

{
    "/Article": 475,
    "/Article/Tutorial_or_Guide": 316
}

ML Intent Types

Informational

99.7%

Raw JSON

{
    "Informational": 997
}

Content Metadata

Language

en-us

Author

null

Publish Time

not set

Original Publish Time

2020-07-05 17:59:47 (5 years ago)

Republished

Word Count (Total)

894

Word Count (Content)

336

Links

External Links

Internal Links

195

Technical SEO

Meta Nofollow

Meta Noarchive

JS Rendered

Yes

Redirect Target

null

Performance

Download Time (ms)

109

TTFB (ms)

Download Size (bytes)

144,864

Shard

168 (laksa)

Root Hash

14615152987638977768

Unparsed URL

com,microsoft!support,/en-us/office/beta-dist-function-11188c9c-780a-42c7-ba43-9ecb5a878d31 s443