How do you find the percentage error using excel?

Question

Basically, my maths project is "are older people better at estimating than younger people".
I have 3 rows for each graph, one row is for the people's estimations, second one is for the error and the last row is for the percentage error.

I already filled in the people's estimation row and the second row, what formula do I use for row 3 (percentage error)

PLEASE HELP I'M ACTUALLY REALLY DESPERATE

thank you :)

Answer 1

You take the error divided by the actual answer and multiply by 100.

Such as, if the answer is 100 and they guess 75, the error is 25; 25/100 = .25, *100 = 25% error.

If you somehow managed to calculate the error without actually knowing what the actual answer was, then the actual answer will either be estimate+error or estimate-error, and you'll have to guess which one it is. You probably don't need to know that, however.

Answer 2

number error / total number * 100

your answer will be between 1 and 100, this is your percentage error

Answer 3

error/correct number