This refers to the chi-square test given in the excel sheet for the exponential distribution, in sheet "Data"
For the Observed, since we do not know the number of claims under the excess, the colleague assumed to make it equal to the expected (532) which is in red font.
Now, part of the formula to get to the expected value of 532 is the total number of observed (which includes the ones below the excess of $50) where this total stands at 1351. However, this 1351 is only able to be fully calculated if you already have the full frequency, and hence the ones below the excess.
Therefore it seems there is a sort of circular error in trying to get to the answer.
For the Observed, since we do not know the number of claims under the excess, the colleague assumed to make it equal to the expected (532) which is in red font.
Now, part of the formula to get to the expected value of 532 is the total number of observed (which includes the ones below the excess of $50) where this total stands at 1351. However, this 1351 is only able to be fully calculated if you already have the full frequency, and hence the ones below the excess.
Therefore it seems there is a sort of circular error in trying to get to the answer.