The utility of MATHCAD for familiar calculations using pH and solubility is demonstrated.
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…
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.