Skip to content Skip to footer

Spreadsheets and computational software

Excel Workshop

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…