Question: how to calculate accuracy and precision in excel?
Answer: Find the difference (subtract) between the accepted value and the experimental value, then divide by the accepted value. To determine if a value is precise find the average of your data, then subtract each measurement from it. This gives you a table of deviations. Then average the deviations.