A given set of data is added and divided by total numbers. I have an MS Excel File 2007 version sample file attached which has name designation blood group and so on. Enter the scores in one of the columns on the Excel spreadsheet see the example below.
Calculate the average The first thing you should do is to calculate the average value of the sample data.
Now to find out your Standard Error and other Statistical metrics do the following. In excel we use the AVERAGE function to calculate the mean of data. Calculate sample size using the below information. Firstly calculate the mean standard deviation SD and standard error of the mean SEM in Excel.