Excel Data Analysis Quiz

What is the first step to calculate the mean in Excel?

• Highlight the data and press 'Enter'

• Start with an equal sign and type 'AVERAGE'

• Use the 'SUM' function and divide by the count

• Type 'MEAN' and select the data range

How do you format the standard deviation result to three decimal places in Excel?

• Go to 'Format Cells' and select 'Number' with three decimal places

• Change the cell format to 'Currency'

• Use the 'ROUND' function

• Use the 'TRUNC' function

What formula is used to calculate the standard error of the mean?

• Mean multiplied by the standard deviation

• Standard deviation divided by the square root of the sample size

• Standard deviation multiplied by the square root of the sample size

• Mean divided by the standard deviation

Which type of error bars should be used for the graph in this tutorial?

• Horizontal error bars

• Vertical error bars

• Both horizontal and vertical error bars

• No error bars

What does it indicate if an error bar crosses over other data points?

• The data point is highly accurate

• The data point may be due to chance

• The data point is an outlier

• The data point is the mean