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.
To find the percentage change, you divide the change from initial to final by the absolute value of the initial value and then multiply by 100%. As an example: if the initia â¦ l value is in cell A1 and the final value is in cell A2, the formula for percent change would be: =(A2-A1)/ABS(A1). You can EITHER multiply that value by 100 to get the percentage OR format the cell to display the number as a percentage. If the original number is negative and the final number is less (even more negative) - this makes the percentage change negative.