Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2017, 12:30 PM
SerenityNetworks SerenityNetworks is offline Find allowed errors when accuracy, confidence, and number of trials is known Windows 10 Find allowed errors when accuracy, confidence, and number of trials is known Office 2016
Advanced Beginner
Find allowed errors when accuracy, confidence, and number of trials is known
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Question Find allowed errors when accuracy, confidence, and number of trials is known

I can use the BINOMDIST to find the sample size needed when I provide the required accuracy, confidence level, and number of errors. But I'd like to go the other way and find the number of allowed errors when I know the required accuracy, required confidence level, and number of trials. Is there a similar statistical function or formula I can use to do this?

Thanks in advance,
Andrew
Reply With Quote
  #2  
Old 10-24-2017, 06:33 AM
SerenityNetworks SerenityNetworks is offline Find allowed errors when accuracy, confidence, and number of trials is known Windows 10 Find allowed errors when accuracy, confidence, and number of trials is known Office 2016
Advanced Beginner
Find allowed errors when accuracy, confidence, and number of trials is known
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Default

Cross posted at OzGrid: https://www.ozgrid.com/forum/forum/h...rials-is-known
Reply With Quote
  #3  
Old 10-27-2017, 09:21 AM
SerenityNetworks SerenityNetworks is offline Find allowed errors when accuracy, confidence, and number of trials is known Windows 10 Find allowed errors when accuracy, confidence, and number of trials is known Office 2016
Advanced Beginner
Find allowed errors when accuracy, confidence, and number of trials is known
 
Join Date: May 2005
Location: Allen, Texas, USA
Posts: 37
SerenityNetworks
Default

Never mind. I figured it out.
Reply With Quote
Reply

Tags
confidence level, statistics



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find allowed errors when accuracy, confidence, and number of trials is known Ribbon button sizes, number of of buttons allowed, and other questions FenceFurniture Excel 2 04-23-2016 08:22 PM
Find allowed errors when accuracy, confidence, and number of trials is known [Project 2013] More accuracy with resource, unit %, and cost? cag8f Project 18 01-02-2016 01:51 PM
find IP in range / find number between numbers gn28 Excel 4 06-14-2015 03:46 PM
How to find number of coma and then add that number of rows in word using macro? PRA007 Word VBA 7 05-27-2015 10:45 PM
Roll-Up Duration: Changing Units of Measure & Also Accuracy Of Pmacdaddy Project 3 04-20-2012 07:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft