Use the Descriptive Statistics data file. Click on DATA, then Data Analysis, then Descriptive Statistics. For input range, select ALL data. You should see the screen below. Since we include the labels in first row make sure to check that option. For the output option which is the place where excel will enter the results select O1 or you can select a new worksheet or even new workbook. and the press OK. Check “Summary statistics” You will get the following: While the whole descriptive statistics cells are selected go to Format Cells to – change all numbers to have one decimal point. When you get the ‘format cells’ window, select the following: Click OK. All numbers should now have one decimal as follows: Now we know something about our data. The average student in this sample is 25.2 years, has a SAT score of 1848.9, got a grade of 80.4, is 66.4 inches tall and reads the newspaper 4.9 times a week. We know this by looking at the value on each variable. ‘mean’ Mean is the sum of the observations divided by the total number of observations. It is the most common indicator of central tendency of a variable. If you look at the last two and you can estimate the mean rows: “Sum” “Count” dividing by “Sum” ”Count” (sum/count). You can also calculate the mean using the function below (IMPORTANT: All functions start with the equal “=” sign):
Use the Descriptive Statistics data file. Click on DATA, then Data Analysis, then Descriptive Statistics. For input range, select ALL data. You should see the screen below. Since we include the labels in first row make sure to check that option. For the output option which is the place where excel will enter the results select O1 or you can select a new worksheet or even new workbook. Check “Summary statistics” and the press OK. You will get the following: While the whole descriptive statistics cells are selected go to Format – Cells to change all numbers to have one decimal point. When you get the ‘format cells’ window, select the following: Click OK. All numbers should now have one decimal as follows: Now we know something about our data. The average student in this sample is 25.2 years, has a SAT score of 1848.9, got a grade of 80.4, is 66.4 inches tall and reads the newspaper 4.9 times a week. We know this by looking at the ‘mean’ value on each variable. Mean is the sum of the observations divided by the total number of observations. It is the most common indicator of central tendency of a variable. If you look at the last two rows: “Sum” and “Count” you can estimate the mean dividing “Sum” by ”Count” (sum/count). You can also calculate the mean using the function below (IMPORTANT: All functions start with the equal “=” sign):