how to calculate the probability to be homozygous?

Hi, welcome to the forum

Isnt this just x factorial?

Hi all- Sort of. The calculation involves (n)(n+1)/2 "parts". Paste the following formula in C2 and copy down. Then sum Column C (not shown).

=B2*SUM(B$2:B2)

Row\Col	A	B	C
1		Mut.Freq.	Partial Sums
2	A	4.19E-06	1.76E-11
3	B	4.17E-06	3.49E-11
4	C	4.12E-06	5.14E-11
5	D	3.28E-05	1.49E-09

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Based on the layout of the screenshot in post #4, paste the following formula into cell D4, then copy down and across:

Formula:

=IF(ROW()<=COLUMN(),$C4*D$3,"")

Let us know if you have any questions.

I would anchor that to the UL corner of the table, so it works if you insert rows or columns:

=IF(ROWS($C$3:D4) <= COLUMNS($C$3:D4), $C4 * D$3, "")

My solution from post#3 yields the same result as OP's post#4, after summing the partials as instructed:
(Bear in mind, our data is rounded to 3 significant figures because we're copying from a picture. )
This is why C2 shows "1.08" instead of "1.07".

Row\Col	B	C	D
2	3.28E-05	1.08E-09	=B2*SUM(B$2:B2)
3	4.09E-06	1.51E-10	=B3*SUM(B$2:B3)
4	4.06E-06	1.66E-10	=B4*SUM(B$2:B4)
5	4.08E-06	1.84E-10	…
6	4.08E-06	2.00E-10	…
7	8.68E-06	5.02E-10	…
8	4.48E-06	2.79E-10	…
9		2.56E-09	=SUM(C2:C8)

Each entry is multiplied by itself PLUS all preceding entries.
To fit the layout in your picture, paste this in D4 and copy down:
=C4*SUM(C$4:C4)

Continuing from post #7, re-arranging the inputs even demonstrates the SAME SUBTOTALS (in reverse order) as shown in post #4:

Untitled.png

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee