+ Reply to Thread
Results 1 to 4 of 4

Help with calculating percentages and distribution

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    Ελλάδα
    MS-Off Ver
    Excel 2010
    Posts
    2

    Help with calculating percentages and distribution

    Hello!

    I am new to the forum and in need of your help (no surprise there).

    So, I am studying Veterinary Medicine (I am in the first semester) and I have an assignment on Excel that our professor just gave us without any instructions since as he says...Google has everything.

    I did most of it but I am stuck in a couple of things and I thought maybe you could point me in the right direction.

    Firstly, I calculated the age of about 650 cows in years based on the data that our professor provided us with. However, I also need to calculate the % of these cows that are under the age of 3. Now, the ages are all in a column, that is K2-K650 but I don't know what formula to use. I think one way to do it is with the IF formula but I haven't fully understood how to do that...

    Lastly, I have to find the age distribution of these cows but again I can't get it right.

    I would really appreciate any advice you might have on these two problems!
    Thanks in advance

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Help with calculating percentages and distribution

    1. =countif(k2:k650, "<3")/rows(k2:k650)

    2. See the FREQUENCY function.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    01-08-2014
    Location
    Ελλάδα
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Help with calculating percentages and distribution

    Thank you very much!
    It worked :D

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,501

    Re: Help with calculating percentages and distribution

    Well Dr Harleen, if shg's response answered your question, don't forget to mark your post as solved. You can do this using the thread tools bar at the top of the post.
    And i'm sure he'd be glad for adding to his reputation if you haven't already.
    welcome to the forum BTW.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. Calculating equal distribution
    By newbie4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2012, 02:00 PM
  2. calculating a distribution to achieve median
    By tinkerbelle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2010, 08:33 PM
  3. calculating normal distribution, CDF and PDF
    By Pasha81 in forum Excel General
    Replies: 0
    Last Post: 12-17-2009, 05:51 AM
  4. Calculating Percentages
    By tifosi3 in forum Excel General
    Replies: 7
    Last Post: 07-11-2005, 04:05 PM
  5. Calculating percentages
    By tssjhs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-25-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1