+ Reply to Thread
Results 1 to 8 of 8

how to calculate the probability to be homozygous?

Hybrid View

  1. #1
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: how to calculate the probability to be homozygous?

    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)
    Last edited by leelnich; 06-30-2017 at 09:34 AM.

+ 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. Formula/formatting to calculate probability
    By kjrmitch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2015, 10:19 PM
  2. how to use & calculate probability in excel
    By Navin Agrawal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2015, 12:01 PM
  3. Calculate the probability to reach at certain point......
    By edneco in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-03-2014, 04:47 PM
  4. Replies: 4
    Last Post: 11-26-2011, 02:33 PM
  5. Using Time Results to Calculate Probability
    By shad in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-05-2010, 02:48 PM
  6. How to calculate total probability of loss from combination of probabilities
    By prr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2009, 06:48 PM
  7. [SOLVED] How to calculate probability
    By Al in forum Excel General
    Replies: 4
    Last Post: 12-01-2005, 08:10 PM

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