Here is a link to a google sheet containing a data set. copy and paste the dataset into microsoft excel. then, use the techniques from the video to calculate descriptive statistics to answer the questions below.

either copy & paste each answer from your data sheet, or round your answers to two decimal places where applicable.

mean
standard error
median
mode (report #n/a if no mode)
standard deviation
sample variance
kurtosis
skewness
range
minimum/smallest
maximum/largest
sum
count

did you notice the mistake in the video while using the data analysis tool? the data range to b1: b100 was selected instead of b1: b101 so there were only 99 values for the count when the data analysis tool ran. be sure not to make the same mistake.