Question

What is the excel formula for finding the answers for Columns 9 -12??? Need the answer ASAP!

Professor/Instructor	Number Students Taught	Graduated	Publications	P(Graduated)	Rank by P(G)	P(Publications)	Rank by P(P)	P(P|G)		Sum of Ranks	Overall Rank
J.W. Blake	971	971	466	1	1	0.479917611	1
K.R. Cunningham	1292	1008	433	0.780185759	12	0.335139319	8
R.H. Doughty	361	357	154	0.988919668	3	0.426592798	3
L.M. Edwards	1072	997	359	0.930037313	6	0.33488806	9
W.H. Greiner	1456	1340	389	0.92032967	7	0.26717033	13
I.D. Jackson	2352	2352	1058	1	1	0.449829932	2
O.P. Lawson	1911	1701	680	0.89010989	9	0.355834642	7
G.F. Nelson	1951	1795	574	0.920041005	8	0.294208098	12
A.F. Paul	1608	1254	514	0.779850746	14	0.319651741	11
D.K. Raulson	1042	979	264	0.939539347	5	0.253358925	14
T.R. South	304	286	129	0.940789474	4	0.424342105	4
E.A. Thomas	1119	873	419	0.780160858	13	0.374441466	6
C.F. Viney	351	281	135	0.800569801	10	0.384615385	5
F.E. Yousef	1123	898	359	0.799643811	11	0.31967943	10
Totals	16913	15092	5933	12.47017734	#N/A	5.019669841	#N/A

What is the excel formula for finding these answers?

Answer 1

You have only written the title of one column for which I will write the answer. If you want something more, please comment. I will help you with the same. Thanks.

Now, when you want P ( P|G) so basically it wants to calculate the probability of having a publication if only graduated students are considered.

For the first professor, it will be 466/971

For the second professor, it will be 433/1008

Basically in every row it wil be the value of Publications / Graduated

Excel formula for first row will be D1/C1 then extend it for all other rows