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…