Yet there is considerable opposition to the use of genetically modified plants for food production and other uses. Genetic engineering offers a time-saving method for producing larger, higher-quality crops with less effort and expense. You are a tomato farmer whose crops are threatened by a persistent species of beetle. 2  Each year, you spend large sums of money for pesticides to protect your crops.
To calculate the variance follow these steps: 1  Work out the Mean (the simple average of the numbers). 2  Then for each number: subtract the Mean and square the result (the squared difference). 3  Then work out the average of those squared differences.
Tips. 1  If you know the mean and standard deviation of your data series, you can enter the values into the =NORMDIST formula. 2  The standard deviation is set to 1.0 by default but can be changed by formatting the error bars.  Automatically create a data series using the Series dialog.