Biology report at least 6 pages
Mak220
DrosophilaGroupData2.xlsxClass Data
| Group Name | Population | Observed Ebony | Observed Wildtype | Total | q | p | Expected Ebony | Expected Wildtype | Ebony W | Wildtype W |
| 1 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 1 | Tube 1 | 7.00 | 13.00 | 20.00 | 0.59 | 0.41 | 12.00 | 8.00 | 1.00 | 0.54 |
| 1 | Tube 2 | 9.00 | 17.00 | 26.00 | 0.59 | 0.41 | 15.60 | 10.40 | 0.53 | 1.00 |
| 1 | Tube 3 | 13.00 | 22.00 | 35.00 | 0.61 | 0.39 | 21.00 | 14.00 | 0.59 | 1.00 |
| 1 | Cage | 81.00 | 127.00 | 208.00 | 0.62 | 0.38 | 124.80 | 83.20 | 0.64 | 1.00 |
| 2 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 2 | Tube 1 | 13.00 | 5.00 | 18.00 | 0.85 | 0.15 | 10.80 | 7.20 | 1.00 | 0.38 |
| 2 | Tube 2 | 8.00 | 9.00 | 17.00 | 0.69 | 0.31 | 10.20 | 6.80 | 0.89 | 1.00 |
| 2 | Tube 3 | 1.00 | 2.00 | 3.00 | 0.58 | 0.42 | 1.80 | 1.20 | 0.50 | 1.00 |
| 2 | Cage | 44.00 | 65.00 | 109.00 | 0.64 | 0.36 | 65.40 | 43.60 | 0.68 | 1.00 |
| 3 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 3 | Tube 1 | 18.00 | 12.00 | 30.00 | 0.77 | 0.23 | 18.00 | 12.00 | 1.00 | 0.67 |
| 3 | Tube 2 | 32.00 | 28.00 | 60.00 | 0.73 | 0.27 | 36.00 | 24.00 | 1.00 | 0.88 |
| 3 | Tube 3 | 51.00 | 34.00 | 85.00 | 0.77 | 0.23 | 51.00 | 34.00 | 1.00 | 0.67 |
| 3 | Cage | 122.00 | 93.00 | 215.00 | 0.75 | 0.25 | 129.00 | 86.00 | 1.00 | 0.76 |
| 4 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 4 | Tube 1 | 4.00 | 4.00 | 8.00 | 0.71 | 0.29 | 4.80 | 3.20 | 1.00 | 1.00 |
| 4 | Tube 2 | 3.00 | 4.00 | 7.00 | 0.65 | 0.35 | 4.20 | 2.80 | 0.75 | 1.00 |
| 4 | Tube 3 | 5.00 | 6.00 | 11.00 | 0.67 | 0.33 | 6.60 | 4.40 | 0.83 | 1.00 |
| 4 | Cage | 31.00 | 32.00 | 63.00 | 0.70 | 0.30 | 37.80 | 25.20 | 0.97 | 1.00 |
| 5 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 5 | Tube 1 | 0.00 | 2.00 | 2.00 | 0.00 | 1.00 | 1.20 | 0.80 | 0.00 | 1.00 |
| 5 | Tube 2 | 7.00 | 5.00 | 12.00 | 0.76 | 0.24 | 7.20 | 4.80 | 1.00 | 0.71 |
| 5 | Tube 3 | 3.00 | 3.00 | 6.00 | 0.71 | 0.29 | 3.60 | 2.40 | 1.00 | 1.00 |
| 5 | Cage | 103.00 | 48.00 | 151.00 | 0.83 | 0.17 | 90.60 | 60.40 | 1.00 | 0.47 |
| 6 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 6 | Tube 1 | 26.00 | 18.00 | 44.00 | 0.77 | 0.23 | 26.40 | 17.60 | 1.00 | 0.69 |
| 6 | Tube 2 | |||||||||
| 6 | Tube 3 | |||||||||
| 6 | Cage | |||||||||
| 7 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 7 | Tube 1 | 40.00 | 0.00 | 40.00 | 1.00 | 0.00 | 24.00 | 16.00 | 1.00 | 0.00 |
| 7 | Tube 2 | 6.00 | 0.00 | 6.00 | 1.00 | 0.00 | 3.60 | 2.40 | 1.00 | 0.00 |
| 7 | Tube 3 | 1.00 | 1.00 | 2.00 | 0.71 | 0.29 | 1.20 | 0.80 | 1.00 | 1.00 |
| 7 | Cage | 102.00 | 0.00 | 102.00 | 1.00 | 0.00 | 61.20 | 40.80 | 1.00 | 0.00 |
| 8 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 8 | Tube 1 | 4.00 | 8.00 | 12.00 | 0.58 | 0.42 | 7.20 | 4.80 | 0.50 | 1.00 |
| 8 | Tube 2 | 0.00 | 2.00 | 2.00 | 0.00 | 1.00 | 1.20 | 0.80 | 0.00 | 1.00 |
| 8 | Tube 3 | 5.00 | 13.00 | 18.00 | 0.53 | 0.47 | 10.80 | 7.20 | 0.38 | 1.00 |
| 8 | Cage | 33.00 | 145.00 | 178.00 | 0.43 | 0.57 | 106.80 | 71.20 | 0.23 | 1.00 |
| 9 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 9 | Tube 1 | |||||||||
| 9 | Tube 2 | 6.00 | 2.00 | 8.00 | 0.87 | 0.13 | 4.80 | 3.20 | 1.00 | 0.33 |
| 9 | Tube 3 | |||||||||
| 9 | Cage | 276.00 | 20.00 | 296.00 | 0.97 | 0.03 | 177.60 | 118.40 | 1.00 | 0.07 |
| 10 | Initial | 30.00 | 20.00 | 50.00 | 0.77 | 0.23 | 30.00 | 20.00 | 1.00 | 0.67 |
| 10 | Tube 1 | 26.00 | 40.00 | 66.00 | 0.63 | 0.37 | 39.60 | 26.40 | 0.65 | 1.00 |
| 10 | Tube 2 | 4.00 | 2.00 | 6.00 | 0.82 | 0.18 | 3.60 | 2.40 | 1.00 | 0.50 |
| 10 | Tube 3 | 9.00 | 12.00 | 21.00 | 0.65 | 0.35 | 12.60 | 8.40 | 0.75 | 1.00 |
| 10 | Cage | 100.00 | 129.00 | 229.00 | 0.66 | 0.34 | 137.40 | 91.60 | 0.78 | 1.00 |
Graph
| Week | q | p |
| 0 | 0.77 | 0.23 |
| 1 | 0.66 | 0.34 |
| 2 | 0.68 | 0.32 |
| 3 | 0.65 | 0.35 |
| 4 | 0.73 | 0.27 |
Time (weeks)
Allele Frequency
Sheet3
| Population | Observed Ebony | Observed Wildtype | Total | q | p | Expected Ebony | Expected Wildtype | Ebony W | Wildtype W | O-E | (O-E)SQ | (O-E)SQ/E | t-Test: Two-Sample Assuming Equal Variances | F-Test Two-Sample for Variances | Ebony | |||||||||||||||
| Tube 1 | 7.00 | 13.00 | 20.00 | 0.59 | 0.41 | 12.00 | 8.00 | 0.54 | 1.00 | -5.00 | 25.00 | 2.08 | Week | Observed | Expected | X² | Critical Value | Decision | ||||||||||||
| Tube 1 | 13.00 | 5.00 | 18.00 | 0.85 | 0.15 | 10.80 | 7.20 | 1.00 | 0.38 | 2.20 | 4.84 | 0.45 | Variable 1 | Variable 2 | Variable 1 | Variable 2 | 1 | 15.33 | 16.00 | 20.63 | 15.507 | Reject | ||||||||
| Tube 1 | 18.00 | 12.00 | 30.00 | 0.77 | 0.23 | 18.00 | 12.00 | 1.00 | 0.67 | 0.00 | 0.00 | 0.00 | Mean | 0.7431623932 | 0.7492877493 | Mean | 0.7431623932 | 0.7492877493 | 2 | 8.33 | 9.60 | 7.20 | 15.507 | Fail to Reject | ||||||
| Tube 1 | 4.00 | 4.00 | 8.00 | 0.71 | 0.29 | 4.80 | 3.20 | 1.00 | 1.00 | -0.80 | 0.64 | 0.13 | Variance | 0.1239784681 | 0.1273467748 | Variance | 0.1239784681 | 0.1273467748 | 3 | 11.00 | 13.58 | 8.07 | 14.067 | Fail to Reject | ||||||
| Tube 1 | 0.00 | 2.00 | 2.00 | 0.00 | 1.00 | 1.20 | 0.80 | 0.00 | 1.00 | -1.20 | 1.44 | 1.20 | Observations | 9 | 9 | Observations | 9 | 9 | 4 | 99.11 | 103.40 | 168.57 | 15.507 | Reject | ||||||
| Tube 1 | 26.00 | 18.00 | 44.00 | 0.77 | 0.23 | 26.40 | 17.60 | 1.00 | 0.69 | -0.40 | 0.16 | 0.01 | Pooled Variance | 0.1256626214 | df | 8 | 8 | |||||||||||||
| Tube 1 | 40.00 | 0.00 | 40.00 | 1.00 | 0.00 | 24.00 | 16.00 | 1.00 | 0.00 | 16.00 | 256.00 | 10.67 | Hypothesized Mean Difference | 0 | F | 0.9735501219 | ||||||||||||||
| Tube 1 | 4.00 | 8.00 | 12.00 | 0.58 | 0.42 | 7.20 | 4.80 | 0.50 | 1.00 | -3.20 | 10.24 | 1.42 | df | 16 | P(F<=f) one-tail | 0.485343996 | ||||||||||||||
| Tube 1 | 26.00 | 40.00 | 66.00 | 0.63 | 0.37 | 39.60 | 26.40 | 0.65 | 1.00 | -13.60 | 184.96 | 4.67 | n=9 | X2= 15.507 | t Stat | -0.0366551113 | F Critical one-tail | 0.2908582186 | ||||||||||||
| MEAN | 15.33 | 11.33 | 26.67 | 0.66 | 0.34 | 16.00 | 10.67 | 0.74 | 0.75 | 20.63 | reject | P(T<=t) one-tail | 0.4856067179 | |||||||||||||||||
| t Critical one-tail | 1.7458836763 | t-test | ||||||||||||||||||||||||||||
| ebony | wild | P(T<=t) two-tail | 0.9712134359 | Week | Ew | WTw | t-statistic | p-value | Decision | |||||||||||||||||||||
| t Critical two-tail | 2.1199052992 | 1 | 0.74 | 0.75 | -0.04 | 0.97 | Fail to Reject | |||||||||||||||||||||||
| 2 | 0.80 | 0.71 | 0.50 | 0.62 | Fail to Reject | |||||||||||||||||||||||||
| 3 | 0.76 | 0.96 | -2.10 | 0.06 | Fail to Reject | |||||||||||||||||||||||||
| 4 | 0.81 | 0.70 | 0.67 | 0.51 | Fail to Reject | |||||||||||||||||||||||||
| t-Test: Two-Sample Assuming Equal Variances | F-Test Two-Sample for Variances | |||||||||||||||||||||||||||||
| Tube 2 | 9.00 | 17.00 | 26.00 | 0.59 | 0.41 | 15.60 | 10.40 | 0.53 | 1.00 | -6.60 | 43.56 | 2.79 | ||||||||||||||||||
| Tube 2 | 8.00 | 9.00 | 17.00 | 0.69 | 0.31 | 10.20 | 6.80 | 0.89 | 1.00 | -2.20 | 4.84 | 0.47 | Variable 1 | Variable 2 | Variable 1 | Variable 2 | ||||||||||||||
| Tube 2 | 32.00 | 28.00 | 60.00 | 0.73 | 0.27 | 36.00 | 24.00 | 1.00 | 0.88 | -4.00 | 16.00 | 0.44 | Mean | 0.7964778504 | 0.7136243386 | Mean | 0.7964778504 | 0.7136243386 | ||||||||||||
| Tube 2 | 3.00 | 4.00 | 7.00 | 0.65 | 0.35 | 4.20 | 2.80 | 0.75 | 1.00 | -1.20 | 1.44 | 0.34 | Variance | 0.1154384472 | 0.1317003653 | Variance | 0.1154384472 | 0.1317003653 | ||||||||||||
| Tube 2 | 7.00 | 5.00 | 12.00 | 0.76 | 0.24 | 7.20 | 4.80 | 1.00 | 0.71 | -0.20 | 0.04 | 0.01 | Observations | 9 | 9 | Observations | 9 | 9 | ||||||||||||
| Tube 2 | 6.00 | 0.00 | 6.00 | 1.00 | 0.00 | 3.60 | 2.40 | 1.00 | 0.00 | 2.40 | 5.76 | 1.60 | Pooled Variance | 0.1235694063 | df | 8 | 8 | |||||||||||||
| Tube 2 | 0.00 | 2.00 | 2.00 | 0.00 | 1.00 | 1.20 | 0.80 | 0.00 | 1.00 | -1.20 | 1.44 | 1.20 | Hypothesized Mean Difference | 0 | F | 0.8765233637 | ||||||||||||||
| Tube 2 | 6.00 | 2.00 | 8.00 | 0.87 | 0.13 | 4.80 | 3.20 | 1.00 | 0.33 | 1.20 | 1.44 | 0.30 | df | 16 | P(F<=f) one-tail | 0.4283412353 | ||||||||||||||
| Tube 2 | 4.00 | 2.00 | 6.00 | 0.82 | 0.18 | 3.60 | 2.40 | 1.00 | 0.50 | 0.40 | 0.16 | 0.04 | n=9 | X2= 15.507 | t Stat | 0.4999904368 | F Critical one-tail | 0.2908582186 | ||||||||||||
| MEAN | 8.33 | 7.67 | 16.00 | 0.68 | 0.32 | 9.60 | 6.40 | 0.80 | 0.71 | 7.20 | fail to reject | P(T<=t) one-tail | 0.31194407 | |||||||||||||||||
| t Critical one-tail | 1.7458836763 | |||||||||||||||||||||||||||||
| P(T<=t) two-tail | 0.6238881399 | |||||||||||||||||||||||||||||
| t Critical two-tail | 2.1199052992 | |||||||||||||||||||||||||||||
| t-Test: Two-Sample Assuming Unequal Variances | F-Test Two-Sample for Variances | |||||||||||||||||||||||||||||
| Tube 3 | 13.00 | 22.00 | 35.00 | 0.61 | 0.39 | 21.00 | 14.00 | 0.59 | 1.00 | -8.00 | 64.00 | 3.05 | ||||||||||||||||||
| Tube 3 | 1.00 | 2.00 | 3.00 | 0.58 | 0.42 | 1.80 | 1.20 | 0.50 | 1.00 | -0.80 | 0.64 | 0.36 | Variable 1 | Variable 2 | Variable 1 | Variable 2 | ||||||||||||||
| Tube 3 | 51.00 | 34.00 | 85.00 | 0.77 | 0.23 | 51.00 | 34.00 | 1.00 | 0.67 | 0.00 | 0.00 | 0.00 | Mean | 0.7573572261 | 0.9583333333 | Mean | 0.7573572261 | 0.9583333333 | ||||||||||||
| Tube 3 | 5.00 | 6.00 | 11.00 | 0.67 | 0.33 | 6.60 | 4.40 | 0.83 | 1.00 | -1.60 | 2.56 | 0.39 | Variance | 0.0593324641 | 0.0138888889 | Variance | 0.0593324641 | 0.0138888889 | ||||||||||||
| Tube 3 | 3.00 | 3.00 | 6.00 | 0.71 | 0.29 | 3.60 | 2.40 | 1.00 | 1.00 | -0.60 | 0.36 | 0.10 | Observations | 8 | 8 | Observations | 8 | 8 | ||||||||||||
| Tube 3 | 1.00 | 1.00 | 2.00 | 0.71 | 0.29 | 1.20 | 0.80 | 1.00 | 1.00 | -0.20 | 0.04 | 0.03 | Hypothesized Mean Difference | 0 | df | 7 | 7 | |||||||||||||
| Tube 3 | 5.00 | 13.00 | 18.00 | 0.53 | 0.47 | 10.80 | 7.20 | 0.38 | 1.00 | -5.80 | 33.64 | 3.11 | df | 10 | F | 4.2719374157 | ||||||||||||||
| Tube 3 | 9.00 | 12.00 | 21.00 | 0.65 | 0.35 | 12.60 | 8.40 | 0.75 | 1.00 | -3.60 | 12.96 | 1.03 | n=8 | X2= 14.067 | t Stat | -2.100731505 | P(F<=f) one-tail | 0.0372550201 | ||||||||||||
| MEAN | 11.00 | 11.63 | 22.63 | 0.65 | 0.35 | 13.58 | 9.05 | 0.76 | 0.96 | 8.07 | fail to reject | P(T<=t) one-tail | 0.031000482 | F Critical one-tail | 3.7870435399 | |||||||||||||||
| t Critical one-tail | 1.8124611228 | |||||||||||||||||||||||||||||
| P(T<=t) two-tail | 0.0620009641 | |||||||||||||||||||||||||||||
| t Critical two-tail | 2.228138852 | |||||||||||||||||||||||||||||
| t-Test: Two-Sample Assuming Equal Variances | F-Test Two-Sample for Variances | |||||||||||||||||||||||||||||
| Cage | 81.00 | 127.00 | 208.00 | 0.62 | 0.38 | 124.80 | 83.20 | 0.64 | 1.00 | -43.80 | 1918.44 | 15.37 | ||||||||||||||||||
| Cage | 44.00 | 65.00 | 109.00 | 0.64 | 0.36 | 65.40 | 43.60 | 0.68 | 1.00 | -21.40 | 457.96 | 7.00 | Variable 1 | Variable 2 | Variable 1 | Variable 2 | ||||||||||||||
| Cage | 122.00 | 93.00 | 215.00 | 0.75 | 0.25 | 129.00 | 86.00 | 1.00 | 0.76 | -7.00 | 49.00 | 0.38 | Mean | 0.8095831509 | 0.7000864742 | Mean | 0.8095831509 | 0.7000864742 | ||||||||||||
| Cage | 31.00 | 32.00 | 63.00 | 0.70 | 0.30 | 37.80 | 25.20 | 0.97 | 1.00 | -6.80 | 46.24 | 1.22 | Variance | 0.0696726539 | 0.1740536557 | Variance | 0.0696726539 | 0.1740536557 | ||||||||||||
| Cage | 103.00 | 48.00 | 151.00 | 0.83 | 0.17 | 90.60 | 60.40 | 1.00 | 0.47 | 12.40 | 153.76 | 1.70 | Observations | 9 | 9 | Observations | 9 | 9 | ||||||||||||
| Cage | 102.00 | 0.00 | 102.00 | 1.00 | 0.00 | 61.20 | 40.80 | 1.00 | 0.00 | 40.80 | 1664.64 | 27.20 | Pooled Variance | 0.1218631548 | df | 8 | 8 | |||||||||||||
| Cage | 33.00 | 145.00 | 178.00 | 0.43 | 0.57 | 106.80 | 71.20 | 0.23 | 1.00 | -73.80 | 5446.44 | 51.00 | Hypothesized Mean Difference | 0 | F | 0.4002941142 | ||||||||||||||
| Cage | 276.00 | 20.00 | 296.00 | 0.97 | 0.03 | 177.60 | 118.40 | 1.00 | 0.07 | 98.40 | 9682.56 | 54.52 | df | 16 | P(F<=f) one-tail | 0.1084522553 | ||||||||||||||
| Cage | 100.00 | 129.00 | 229.00 | 0.66 | 0.34 | 137.40 | 91.60 | 0.78 | 1.00 | -37.40 | 1398.76 | 10.18 | n=9 | X2= 15.507 | t Stat | 0.6653819059 | F Critical one-tail | 0.2908582186 | ||||||||||||
| MEAN | 99.11 | 73.22 | 172.33 | 0.73 | 0.27 | 103.40 | 68.93 | 0.81 | 0.70 | 168.57 | reject | P(T<=t) one-tail | 0.2576421502 | |||||||||||||||||
