A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

compute a 75% chebyshev interval around the mean



 
 
Thread Tools Display Modes
  #1  
Old January 19th 09, 12:27 AM posted to microsoft.public.excel.misc
shortjam
external usenet poster
 
Posts: 1
Default compute a 75% chebyshev interval around the mean

how do you compute the above with a set of data
Ads
  #2  
Old January 19th 09, 05:09 PM posted to microsoft.public.excel.misc
Herbert Seidenberg
external usenet poster
 
Posts: 1,180
Default compute a 75% chebyshev interval around the mean

% of values within mean +- k => 1-1/k^2
k=standard deviation
75% = 1-1/4 (k=2)
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Look-up a value within an interval Christine Excel Worksheet Functions 12 September 26th 08 06:14 PM
interval formula xposedphotography Excel Discussion (Misc queries) 1 April 6th 08 05:51 PM
contour interval Really now... Charts and Charting in Excel 1 November 16th 07 10:12 AM
Sum.if date is in an interval... Mikael Lindqvist Excel Worksheet Functions 6 November 13th 07 11:06 AM
Confidence Interval cwbecker Excel Worksheet Functions 1 June 29th 06 09:29 PM


All times are GMT +1. The time now is 06:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.