I'm looking at a large collection of values. These values follow an exponential distribution. I have their probabilities and a pre-made Excel spreadsheet that will auto calculate expected values from values that I put into the spreadsheet.
Now, my question is related to what seems very much close to the idea of standard deviation, chi squared test, and percent error. I want to create a column in Excel next to each.
| Name | Expected | Observed | Percent Error | |---------|----------|----------|---------------| | Thing1 | | | | | Thing2 | | | | | Thing3 | | | | | Thing4 | | | | | Thing5 | | | | | Thing6 | | | | | Thing7 | | | | | Thing8 | | | | | Thing9 | | | | | Thing10 | | | | | Thing11 | | | | | Thing12 | | | | | Thing13 | | | | | Thing14 | | | |
I've already created the percent error column which made me realize what the problem is. I have some results in that column that are 100% different from each other because expected is roughly 0.5 and observed is 0. Then I have some results where the expected is 1605 and the observed is 1533. So the percent difference is 5% when there's a difference of 72. So I'm trying to think of something that is more relative to the values.