Course Hero Logo

final Lab03 Simulating genetic drift.xlsx - Complete and...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 5 out of 19 pages.

Part 1:Step 1) Start with a population of 100 individuals, 50 with allele 0 and 50Step 2) Randomize the original population and draw 50 individuals to beStep 3) Expand Draw 1 to 100 individuals with the same allele frequenciStep 4) Randomize the expanded population (of step 3) and select 50 inStep 5) Expand Draw 2 to 100 individuals with the same allele frequenciRepeat this process until you've created 10 populations total.Plot the changing allele frequencies over the generations in a scatterploPart 2:Repeat the same but draw 25 individuals for each generation (and expand). Plot the resuPart 3:Compare the two figures and tell me what you observe. Write the comments in a cell.Complete and post the following spreadsheet to Blackboard.Create a spreadsheet with
0 with allele 1; this is Gen 1e Draw1, calculate their allele frequencies in the table using a formula.ies as the draw 50 in Gen 2ndividuals to be Draw 2, calculate their allele frequencies in the table usinies as the sampled 50 from step 4, this will be Gen 3.ot with Gen on the X-axis and frequencies on the Y-axisults.the following:
ng a formula.
Random Gen01Random Gen02Random Gen03Random Gen04Random Gen05Random0.5725400.32431 0.574920 0.179441 0.587071 0.006710.8069910.68791 0.067971 0.679190 0.840111 0.960710.63880 0.544590 0.673391 0.351381 0.0321810.19550.545871 0.580531 0.842620 0.900791 0.385111 0.989740.0330310.6121 0.557160 0.624111 0.899910 0.375960.333661 0.4147800.89860 0.456731 0.150120 0.824220.126021 0.330510 0.502450 0.8229510.44430 0.128690.312310 0.245991 0.757230 0.407990 0.988730 0.787870.701240 0.115890 0.821510 0.203951 0.067050 0.944740.043711 0.125381 0.154611 0.459381 0.909281 0.732540.294021 0.541070 0.120181 0.656971 0.387860 0.929640.3105310.72520 0.776741 0.086581 0.587291 0.581870.713211 0.218821 0.479161 0.886421 0.432280 0.311610.658541 0.538720 0.768720 0.422861 0.501491 0.089040.671890 0.438081 0.142391 0.795020 0.617441 0.635290.398171 0.127960 0.501681 0.123930 0.606081 0.678280.920041 0.388410 0.272310 0.119990 0.6581610.69680.107321 0.883830 0.221481 0.936690 0.323481 0.697540.982450 0.924141 0.289191 0.353370 0.255180 0.287360.937621 0.248710 0.374581 0.700051 0.460470 0.576590.877091 0.151940 0.5342800.93230 0.945541 0.735010.201380 0.854670 0.942251 0.955481 0.943120 0.985710.294551 0.577991 0.184650 0.583361 0.154940 0.975060.900751 0.198211 0.725281 0.238951 0.158870 0.521170.776040 0.482460 0.863040 0.7607910.45971 0.659380.796431 0.2653410.04530 0.0621300.50070 0.599660.812690 0.6937510.122910.93481 0.634480 0.402510.808660 0.253491 0.917560 0.383840 0.473190 0.004720.753581 0.367540 0.358830 0.468941 0.688861 0.883380.619300.78551 0.993750 0.768080 0.100730 0.280540.022110 0.654081 0.920051 0.514740 0.082880 0.522140.670810 0.537840 0.716441 0.151110 0.301660 0.026150.178941 0.872110 0.895981 0.962781 0.759281 0.060810.17790 0.416481 0.463850 0.623671 0.5869610.70760.028931 0.671060 0.440020 0.923040 0.960471 0.992390.86821 0.642531 0.4613410.63690 0.080811 0.044740.883911 0.934220 0.697391 0.334351 0.849380 0.832920.215160 0.145531 0.207060 0.939010 0.096681 0.362840.085330 0.173920 0.241151 0.7296300.26461 0.831520.215521 0.738730 0.028880 0.249980 0.833450 0.212070.932050 0.200380 0.9524600.98560 0.771390 0.703850.192060 0.4279110.73771 0.458340 0.313221 0.72823

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 19 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture