Monetary Unit Sampling (MUS) Sample Size Help

nathan488

New Member
Joined
Sep 5, 2017
Messages
1
Hi everyone,

For a significant number of hours now I've been trying to calculate the sample size of a population via the MUS method. (It's a very similar way to systematic sampling)

At my work we have a data analysis software called "IDEA" which I'm sure some of you have heard of. Within this, we have our own "global" plugin which computes MUS work for us (ie: using given inputs to determine a sample size of the population)

I've wanted to make an efficiency to this, as most people do not like using this software, and additionally creating a replica on excel would significantly speed up the process of this type of work.

I've attached a workbook, which has two examples:
- I've got two different population amounts, and provided just the information that our MUS plugin requires the user to input
- From that, I've used the MUS plugin on IDEA to calculate the sample sizes and have included these on the workbook

Ideally: I would be most grateful if anyone could determine a formula or method to replicate these sample sizes in excel. (with the main goal being a formula of some sorts that can determine the sample size of the population to test based on the criteria given below)

Everything needed is in the workbook, and ideally I'd like to be able to work out the sample size from just this information: (as this is all MUS plugin needs)
a) population value (sum of the data being tested)
b) performance materiality
c) expected misstatement (always 1/6 of performance materiality)
d) confidence level (changes based on criteria) - this is the most taxing area to work out the sample size

^^So somehow, using just a-d above, a formula or something else in excel to accurately determine the same sample size as IDEA did.

This is why I've provided two different examples within the workbook, as well showing different confidence levels so it could be tested.

I hope someone can assist me on this as I've run in to a dead end. I appreciate any responses and look forward to hearing back from you guys soon

TLDR: To create a formula that determines the sample size of a population using just the information provided (a-d above) for MUS sampling (See WB attached)

NOTE: As first time posting, I cannot attach the file directly to the post: So instead please see this link which will take you to download it: http://www.filedropper.com/musexample

All the best,

Nathan
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,098,846
Messages
5,465,061
Members
406,411
Latest member
Xiaoming

This Week's Hot Topics

Top