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.
Tip. 1  Create your own formula to convert the degrees, minutes and seconds used in geography to a decimal number. 2  DMS map coordinates consist of whole number degrees that are divided into 60 minutes. 3  Likewise, DMS minutes can be divided into 60 seconds.ype the minutes and seconds you want to use into an empty cell. For example, type 0:45:30 into cell A1. This value represents 0 hours, 45 minutes and 30 seconds. Related Reading: How to Remove the Decimal When Using RAND in Excel.