C
Claire123
Member
Hi,
On paper 1 we are asked to produce a chart to illustrate the variability of potential outcomes. In the solutions, this is done by typing out all the possible ranks (1 to 100) and then using the MATCH function to look up the simulation number of that rank. However, my formulae returns #NA errors because there are some ranks missing (e.g. there is no rank 65 in my data, and this is consistent with the solutions too), whereas the examiners solution doesn't seem to have this error, despite them missing a rank 65 too. There is no mention of any corrections or amendments in the audit trail, and the solutions don't even have formulae in the profit chart tab after the top row, so I'm not sure how they've got the results out. Can someone help?
Thanks.
On paper 1 we are asked to produce a chart to illustrate the variability of potential outcomes. In the solutions, this is done by typing out all the possible ranks (1 to 100) and then using the MATCH function to look up the simulation number of that rank. However, my formulae returns #NA errors because there are some ranks missing (e.g. there is no rank 65 in my data, and this is consistent with the solutions too), whereas the examiners solution doesn't seem to have this error, despite them missing a rank 65 too. There is no mention of any corrections or amendments in the audit trail, and the solutions don't even have formulae in the profit chart tab after the top row, so I'm not sure how they've got the results out. Can someone help?
Thanks.