=incidence
Chat with our AI personalities
You calculate the mean.For each observation, you calculate its deviation from the mean.Convert the deviation to absolute deviation.Calculate the mean of these absolute deviations.
It isn't clear what you want to calculate.
If the true value is t and the calculated or measured value is v then absolute error = |v - t|, the absolute value of (v - t).If v >= t then the absolute value is v - tif v
There is no single function in Excel.You calculate the mean (average).For each observation, you calculate its deviation from the mean.Convert the deviation to absolute deviation.Calculate the mean (average) of these absolute deviations.
You multiply the percentage uncertainty by the true value.