Results 1 to 3 of 3

Thread: Need help to compute a 75% chebyshev interval around the mean in Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    94

    Need help to compute a 75% chebyshev interval around the mean in Excel

    How do you compute the above with a set of data. I need some basic help related to syntax used. I also want to know is there any better way to work on the same on a large database.

  2. #2
    Join Date
    Aug 2011
    Posts
    695

    Re: Need help to compute a 75% chebyshev interval around the mean in Excel

    Try this out : % of values within mean +- k => 1-1/k^2 where k=standard deviation and 75% = 1-1/4 (k=2).

  3. #3
    Join Date
    Nov 2010
    Posts
    503

    Re: Need help to compute a 75% chebyshev interval around the mean in Excel

    The Chebyshev inequality , it follows that the random variable is removed from its expectation by more than k standard deviations of the probability of less than 1 / k ². For example, at least 75% of the random variable is removed from the average by no more than two standard deviations, and in about 89% - no more than three.

Similar Threads

  1. Windows Aero Dies when browsing folders on other compute
    By Honey Singh in forum Operating Systems
    Replies: 8
    Last Post: 26-09-2010, 06:42 AM
  2. Replies: 4
    Last Post: 25-09-2010, 05:11 PM
  3. Delete and Remove Recovery Partition in HP Compute
    By Xylon in forum Operating Systems
    Replies: 3
    Last Post: 25-05-2009, 07:15 PM
  4. Extraction of data on interval - Excel
    By machok in forum Software Development
    Replies: 3
    Last Post: 16-02-2009, 07:31 PM
  5. Big problem No More Connections can be made to this remote compute
    By JohnMcKlane in forum Windows Server Help
    Replies: 7
    Last Post: 26-03-2008, 09:12 AM

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
  •  
Page generated in 1,714,046,233.31257 seconds with 17 queries