Results 1 to 2 of 2

Math Help - excel

  1. #1
    msg
    msg is offline
    Newbie
    Joined
    Oct 2007
    From
    Lahore Pakistan
    Posts
    5

    excel

    Q: # 1:
    The output in units of 20 employees during one week was as follows:
    65, 69, 70, 71, 70, 68, 69, 67, 70, 68
    72, 71, 69, 74, 70, 73, 71, 67, 69, 70

    a) Arrange them in ascending order using “Sort Ascending” option in tool bar or from Data menu and also find the number of data elements by using COUNT function.
    b) Find range of data.
    c) Start doing tabulation of given data. Make 5 classes by using suitable class interval.
    d) Make the frequency distribution.
    e) Also make the column of class mark.
    f) Also find out the mean by constructing relevant column “f X”
    g) Also compute relative frequency distribution and cumulative frequency distribution.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    GAMMA Mathematics
    colby2152's Avatar
    Joined
    Nov 2007
    From
    Alexandria, VA
    Posts
    1,172
    Awards
    1
    It looks like you are using Excel? The range of the data is simply [min, max]. Divide the length of that range by five and you have five uniform classes.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. help in excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: May 26th 2011, 05:29 AM
  2. From Matlab to Excel
    Posted in the Math Software Forum
    Replies: 3
    Last Post: February 3rd 2010, 02:20 AM
  3. Calculus and Excel
    Posted in the Calculus Forum
    Replies: 0
    Last Post: December 6th 2009, 03:09 PM
  4. excel
    Posted in the Math Software Forum
    Replies: 8
    Last Post: April 23rd 2008, 07:48 AM
  5. Excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: August 13th 2007, 05:26 PM

Search Tags


/mathhelpforum @mathhelpforum