Probability
Results 1 to 8 of 8

Thread: Probability
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Probability

    Hi, I'm quite new to excel and I need to find the probability of 3 different criteria. My criteria is finding the 'females' who live in 'london' and earn a net wage of 'greater than or equal to £495' can ANYONE help me with the command or formula I need to input to get the answer as I am loosing my mind!! Please! And thankyou in advance 😊

  2. #2
    Board Regular ParamRay's Avatar
    Join Date
    Aug 2014
    Location
    England, UK
    Posts
    1,193
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probability

    Can you give some info on how your worksheet is structured, i.e. what are the columns, where is the data, etc?..

  3. #3
    Board Regular
    Join Date
    Jan 2015
    Posts
    1,121
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probability

    You need to first split your 3 criterias. Calculate how many females over total people. I would use
    Code:
    countif(A1:A99;"Female")/count(A1:A99)
    formula if people sex was in column A, from row 1 to 99. In another cell, calculate how many live in London using the same formula but with London. Third cell would be
    Code:
    Countif(C1:C100;">=495")/count(C1:C99)
    if net salaries are in column C. You then multiply each percentage to get the probability it happens. You can calculate everything at once multiply directly but it is good to check each result the first time.
    Last edited by Kamolga; Jul 6th, 2019 at 03:38 AM.

  4. #4
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probability

    Thankyou so much!!! I've been trying to do it all at the same time and it's just not going to work you're a diamond thankyou ��

  5. #5
    Board Regular
    Join Date
    Jan 2015
    Posts
    1,121
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probability

    You are welcome. Thanks for the feedback.

  6. #6
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    592
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probability

    Two important things to remember about probability:

    1. The probability of an event is a fraction: (#successful ways)/(# total ways)
    2. The probability of TWO events both happening is an AND condition which requires multiplying the individual probabilities and
    the probability of TWO events where EITHER could happen is an OR condition which requires adding the probabilities.

  7. #7
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Probability

    Quote Originally Posted by kweaver View Post
    Two important things to remember about probability:

    1. The probability of an event is a fraction: (#successful ways)/(# total ways)
    2. The probability of TWO events both happening is an AND condition which requires multiplying the individual probabilities and
    the probability of TWO events where EITHER could happen is an OR condition which requires adding the probabilities.
    Thankyou!!!

  8. #8
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,224
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Probability

    You might want to look at a contingency table something like below.

    Also, see this link

    http://www.mathandstatistics.com/lea...and-dependence

    ABCD
    1 >=495<495Total
    2Female London
    3Female Non-London
    4Male London
    5Male Non-London


    Excel tables to the web >> Excel Jeanie HTML 4

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •