But thats a topic that falls under statistics, You really need to look at a book of statistics, then apply formula in excel.
On Oct 12, 3:44 pm, "v sheeba" <[EMAIL PROTECTED]> wrote: > Dear All, > Its any one taught me test of significance & how to apply this in FMCG data > with example files. > > Its a need of the hour. > > Regards > Akash sheeba > Rama Arcade, > Delhi > > On Fri, Oct 10, 2008 at 1:15 PM, Ajay Varshney > <[EMAIL PROTECTED]>wrote: > > > your query resolved in the attached file. > > > Regards, > > Ajay Varshney > > > On Thu, Oct 9, 2008 at 7:28 PM, Krishna Kishore <[EMAIL PROTECTED]>wrote: > > >> Hello All > > >> I am looking for a help to create a file in excel which can capture the > >> exact tenure of people in an organization. Your inputs can help me in > >> achieving this. > > >> I am looking for a report in which excel can segregate the staff in the > >> following categories. > > >> Name > > >> Date of Joining > > >> Rahul > > >> 19-12-2004 > > >> Lakshman > > >> 22-11-2005 > > >> Azhar > > >> 01-01-2008 > > >> Vinod > > >> 01-08-2008 > > >> Through this the end result should be out in this format > > >> Total > > >> Less than 6 months > > >> 6 months to 1 year > > >> 1 year to 2 years > > >> 2 years to 3 years > > >> 4 > > >> 1 > > >> 1 > > >> 1 > > >> 1 > > >> I would be thankful to all in advance. > > >> <http://smsxite.com/picdetail.php?catId=43&tid=39> > > >> Krishna Kishore > >> [image: Friendship SMS]<http://smsxite.com/picdetail.php?catId=43&tid=39> > > > > image001.jpg > 23KViewDownload --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
