Probability

AmyShann

New Member
Joined
Jul 4, 2019
Messages
4
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 ?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

ParamRay

Well-known Member
Joined
Aug 6, 2014
Messages
1,195
Can you give some info on how your worksheet is structured, i.e. what are the columns, where is the data, etc?..
 

Kamolga

Well-known Member
Joined
Jan 28, 2015
Messages
1,175
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:

AmyShann

New Member
Joined
Jul 4, 2019
Messages
4
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 ��
 

Kamolga

Well-known Member
Joined
Jan 28, 2015
Messages
1,175
You are welcome. Thanks for the feedback.
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,074
Office Version
365, 2010
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.
 

AmyShann

New Member
Joined
Jul 4, 2019
Messages
4
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!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,102,679
Messages
5,488,226
Members
407,632
Latest member
varunwalla

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top