Students learn about push-pull factors and corresponding population mobility patterns. This lesson plan was given the 2006 Geography Excellence in Media (GEM) Award by the National Council for Geographic Education (NCGE).
ED50V10 (Readme) is an Excel add-in for calculating IC50/EC50 values. Input your data in the left columns, and your results will be shown in the right half of the Excel table. To calculate IC50, input 50 in the INTERPOLATE... table (highlighted in blue), the result will be shown on the right (highlighted in green).inear Regression. The simplest estimate of IC50 is to plot x-y and fit the data with a straight line (linear regression). IC50 value is then estimated using the fitted line, i.e., Y = a * X + b, IC50 = (0.5 - b)/a. Log transformation. Frequently, linear regression is not a good fit to dose-response data.
1 To get around this, you can calculate your numbers as percentages first. 2  For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. 3  If you then format that decimal as a percentage, the number will be displayed as 10% , as you âd expect. Format existing values: When you apply percentage formatting to a cell that already has a number in it, Excel multiplies that number by 100 and adds the % sign at the end. 2  This causes confusion, so let me explain whatâs happening. 3  Letâs say that you type 10 into cell A2, and you then apply the percentage number format.