Basic Statistics and Graphing using Microsoft Excel Exam Questions with Verified Answers Latest
Update 2024-2025 (Already Passed)
Mean/Average (𝒙̄) - Answers The most widely used measure of central value obtained by dividing the
sum of replicate measurements by the number of measurements in the set
Precision - Answers The reproducibility of measurements, determined by repeating the measurement
on replicate samples
Standard deviation (s) - Answers A widely used term to describe the precision of a set of replicate data
Relative standard deviation - Answers Standard deviation expressed as a percentage of the mean
Accuracy - Answers The closeness of the measurement to the true or accepted value, expressed by the
error
Best fit line - Answers A line drawn using the method of least squares to represent the relationship
between variables
Calibration curve - Answers A curve used to evaluate the response of a procedure for known quantities
of analyte
R-Squared (R²) - Answers A statistical measure that determines how well the data fit to a linear curve
Volume (V) - Answers The space occupied by an object, calculated using the formula V = π . r^2 . L
Mass (m) - Answers The amount of matter in an object
Density - Answers The mass of a substance per unit volume
% error - Answers The absolute value of the difference between the calculated and measured values,
divided by the measured value and multiplied by 100
Significant figures - Answers Digits that carry meaningful information about the precision of a
measurement
Cylindrical wire shape - Answers A wire shape that has a circular cross-section and a constant diameter
along its length
Outlier - Answers A data point that deviates significantly from the overall trend
Trendline - Answers A line that represents the general trend of a set of data points
Excel - Answers A software program used for creating spreadsheets and performing calculations
Chart - Answers A graphical representation of data
XY (Scatter) chart - Answers A type of chart used to display the relationship between two variables
Update 2024-2025 (Already Passed)
Mean/Average (𝒙̄) - Answers The most widely used measure of central value obtained by dividing the
sum of replicate measurements by the number of measurements in the set
Precision - Answers The reproducibility of measurements, determined by repeating the measurement
on replicate samples
Standard deviation (s) - Answers A widely used term to describe the precision of a set of replicate data
Relative standard deviation - Answers Standard deviation expressed as a percentage of the mean
Accuracy - Answers The closeness of the measurement to the true or accepted value, expressed by the
error
Best fit line - Answers A line drawn using the method of least squares to represent the relationship
between variables
Calibration curve - Answers A curve used to evaluate the response of a procedure for known quantities
of analyte
R-Squared (R²) - Answers A statistical measure that determines how well the data fit to a linear curve
Volume (V) - Answers The space occupied by an object, calculated using the formula V = π . r^2 . L
Mass (m) - Answers The amount of matter in an object
Density - Answers The mass of a substance per unit volume
% error - Answers The absolute value of the difference between the calculated and measured values,
divided by the measured value and multiplied by 100
Significant figures - Answers Digits that carry meaningful information about the precision of a
measurement
Cylindrical wire shape - Answers A wire shape that has a circular cross-section and a constant diameter
along its length
Outlier - Answers A data point that deviates significantly from the overall trend
Trendline - Answers A line that represents the general trend of a set of data points
Excel - Answers A software program used for creating spreadsheets and performing calculations
Chart - Answers A graphical representation of data
XY (Scatter) chart - Answers A type of chart used to display the relationship between two variables
