+ Reply to Thread
Results 1 to 3 of 3

Monetary Unit Sampling (MUS) Sample Size Help

  1. #1
    Registered User
    Join Date
    07-13-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    12

    Monetary Unit Sampling (MUS) Sample Size Help

    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)

    All the best,

    Nathan
    Attached Files Attached Files
    Last edited by nathan488; 09-05-2017 at 04:56 PM.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Monetary Unit Sampling (MUS) Sample Size Help

    http://archives.cpajournal.com/2005/...ntials/p36.htm

  3. #3
    Registered User
    Join Date
    07-13-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    12

    Re: Monetary Unit Sampling (MUS) Sample Size Help

    I've seen this website already early on to this project.

    Very detailed and informative about the process but sadly due to the age of the website, the link to the spreadsheet is broken.

    Furthermore, the information doesn't describe how to calculate the sample size from the information above :/

    Thank you for the initial reply though, it's much appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Monetary Unit Sampling (MUS) Coding help needed
    By nathan488 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-05-2017, 10:10 AM
  2. [SOLVED]Function to add total monetary values within a row.
    By communistflamingo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-31-2014, 03:20 PM
  3. sample size formula
    By scott28 in forum Excel General
    Replies: 2
    Last Post: 07-10-2012, 10:55 AM
  4. Graph - add labels of sample size
    By simone77 in forum Excel General
    Replies: 3
    Last Post: 03-07-2012, 12:26 PM
  5. sample size (population)
    By jw01 in forum The Water Cooler
    Replies: 0
    Last Post: 03-09-2011, 03:24 PM
  6. Sample Size
    By STEVEB in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2005, 02:27 PM
  7. In a yes or no situation how do I choose a sample size
    By Stat Challenged in forum Excel General
    Replies: 3
    Last Post: 07-26-2005, 02:04 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1