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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TutorJosh. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
