The utility of MATHCAD for familiar calculations using pH and solubility is demonstrated.
c. Spreadsheets and computational software
Students learn to: Learn basic Excel functionality, including data entry, mathematical manipulations, built-in functions (AVERAGE, STDEV), importing data, etc.
Use Excel to plot data (scatter plot) and format for scientific reports.
Find the best-fit line for x-y data using least squares regression. This will be accomplished using two different methods in Excel:
Add trendline to scatter plot
LINEST function
Construct calibration curve
Assess “goodness of fit” using R2, and uncertainties in m, and b
Calculate the concentration of an
Students learn to:
Use Excel to create a basic spreadsheet.
Translate mathematical equations into Excel functions.
Provide Spreadsheet Documentation for your work.
Use the extra features of Excel to communicate your results clearly.