So I've been assigned for homework, due tomorrow 9/4 to create as the title says a mathematical modeling of the hardy weinberg equilibrium in Excel. I was given this handout http://media.collegeboard.com/digita...EB_1_24_12.pdf The instruction being at page S25 for this assignment. Please help me! I have no clue how to do any of this! Its for my AP Bio class FYI!
Without having to do your homework for you, what part of Excel are having issues with? If you are specific in your request, I can assist you with Excel's functions.
Of course! I expect no one to do my homework, I just don't understand how to do excel! To start off it says to
"To begin this model, let’s define a couple of variables.
Let
p = the frequency of the A allele
and let q = the frequency of the B allele "
I know what the frequency stuff is, but I don't know how to "define these varibles"
Do you have formulas that you are needing to calculate? What is the final expected outcome of this spreadsheet/database?
The formulas are p + q + 1 and 1 - p = q respectively. The final outcome is so that the spreadsheet can be used to randomly calculate allele frequencies, by pushing the F9 button.
You can ignore that statement -- it's just informational.Let
p = the frequency of the A allele
and let q = the frequency of the B allele "
The following paragraphs explain step-by-step and formula-by-formula what you need to do.
Entia non sunt multiplicanda sine necessitate
Sounds like a RAND function...
Ok, so we need to start with the basics!
First you need to label each 'known' value.
In cell A2, write the following, "p = frequency of the A allele"
In cell C2, provide the correct frequency of the A allele
In cell A3, write the following, "q = frequency of the B allele"
In cell C3, provide the correct frequency of the B allele
By doing this, you have now set cells C2 and C3 as values that can be recalled in a formula.
What's next?
A macro does what you tell it, not what you want.
I feel ashamed that I never even pulled up the worksheet before now.Originally Posted by shg
adirandude, it seems fairly basic in the instructions. Just copy down what they have in the pics and you should be good to go my man!
Really? Because I've tried that and nothing working. I reach the end and I can't generate anything. In two of the colums I have #NAME and I'm losing it. I don't know what to do
Here's the kind of question that might get a response:
"Everything was working fine until I got to step__ on page __ where it said __, and I entered __ in cell __, but the result was #NAME? What did I do wrong? Please see the attached workbook, which I knew how to attach to my post because I took three minutes and read the forum rules."
Narrow, specific, shows evidence of you making an honest effort.
All I did was type in the formula identically and I got the #NAME. I have no idea what i did wrong. Some calculation are working now though as I've snuffed some problems out though.
Last edited by Cutter; 09-04-2012 at 08:46 AM. Reason: Removed discourteous remark
Sounds like progress! Good job!
Yes there has been, but now after typing this in exactly =G5IF(G5=“AA”,1,0) I am getting the #NAME. What could be the error?
The error is that what you posted is not what the instructions said to enter in H5.
Actually I have fixed that issue, now my problem is with I5 and the formula that goes there. It claims the #NAME? too. This is the supposed formula to go there =IF(G5=“AB”,1,(IF(G5=“BA”,1,0)))
I don't think the intent was for you to copy and paste. Excel uses straight quotes, not left and right quotes in formulas.
Please don't forget to say thank you, adrian. We are volunteers, and my lawn is calling me to mow.
Ok, well thanks for the help then I will try to figure this out!
You're welcome. The instructions are very well done -- you'll sort it out.
Just wanted to thank you again, I have figured out all the problems! I've got this thing to work beautifully! *takes a bow*
@ adriandude85
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks