Inputting Formulas into Microsoft Excel (Average, Standard Deviation, and Standard Error)

This video demonstrates how to calculate basic descriptive statistics in Microsoft Excel, including the mean (average), standard deviation, and standard error. Using student test score data from traditional and problem-based learning formats, the tutorial walks through formula entry, cell referencing, and efficient copying of formulas across data sets. The video also briefly discusses how these statistics are used to interpret data and create graphs with error bars.
Excel formulas:
Mean =AVERAGE(cell_range)
Standard Deviation =STDEV.S(cell_range)
Standard Error =STDEV.S(cell_range)/SQRT(COUNT(cell_range))

Видео Inputting Formulas into Microsoft Excel (Average, Standard Deviation, and Standard Error) канала Sara Baltz