To make a spreadsheet similar to the one in Example 3, use the steps below. [Note that Step 6 uses the half-life formula given in Example 3, .]
- Enter the titles "Time, t" and "Amount, A" into row 1.
- Enter 0 into cell A2.
- Enter the formula =A2 + 3 into cell A3.
- Select cell A3. From the Edit menu, choose Copy.
- Select cells A4 through A10. From the Edit menu, choose Paste.
- Enter the formula =500*0.5^(A2/3) into cell B2
- Select cell B2. From the Edit menu, choose Copy.
- Select cells B3 through B10. From the Edit menu, choose Paste.
- Select cells B2 through B10. From the Format menu, choose Cells….
- In the Format Cells dialog, select the Number tab.
- From the Category: list, select Number.
- For Decimal places:, enter 2. Then click OK.
Did you know that every two seconds someone in the U.S. needs blood and more than 38,000 blood donations are needed every day? One donation can save the lives of up to three people.
There are eight different blood types with the most common being O-positive. A supply of each blood type is needed by hospitals. Blood types typically in short supply are O-negative and AB-positive.
To learn more about blood types and donating blood, visit the American Red Cross.
You can estimate how much longer it will take for there to be less than 1 milligram of the drug in your bloodstream by entering the half-life formula
into a spreadsheet.
You can see that the amount of the drug drops to below 1 milligram after about 27 hours. About
2 milligrams were left after 24 hours so this takes about 3 hours longer.
These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.