confidence

In my case, I need to perform an accuracy audit where my required accuracy is 99.90% and my required confidence level is 90.00%. I'm stumped on how to assign penalties in a case where the measured accuracy passes the requirement, but the required confidence fails. I know that if I have a...

Hello Everybody I'm doing the parameters estimation of a model using the Excel solver with the GNG Nonlinear method. My question is, how can I get the confidence intervals of the optimized values? Thanks

I have some data I have inherited from several years back and no-one who was around back then is still around to ask. Year Question # Lower 95% confidence interval Scored percentage Upper 95% confidence interval No of responses for this question and trust 2014...

Hi all, Any help would be appreciated. I am trying to create a way to model some data in Excel. This involves taking three sections (lets call them a,b,c) and their sub-sections (lets call them A1, A2, A3, A4, B1, B2, B3, B4, B5, C1, C2, C3) and adds individual confidence ratings to these sub...

Hi all, A skills assessment questionnaire has been sent to staff and I now need to collate the information for each different site. I am a bit unsure the best way to set up the spreadsheet and then how to combine the information for all sites <tbody> Name Job Title & Team </tbody>...

Hi All, I inherited a power point presentation that shows the average, minimum and maximum values from survey response question. I have the underlying Excel data but don't have the work of the person that calculated these things. The average is shown, including the confidence level. I'm not a...

Hi all, I am doing work around assessing our staff skills and how competent/ confident they are for each skill. The information is broken down on individual worksheets for each location but I also want particular information to copy through to a master sheet. Is this possible? Below is how...

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...

I use the workbook referenced below to provide me with the minimum sample sizes needed for a range of allowed errors, given a required accuracy and required confidence. In a round-about way, I fill-down the BINOMDIST function in a column to provide me with the probability/confidence that my...