Numbers 1.3- Descriptive Statistics in Excel

I had never heard of the descriptive statistics tool in Excel until now. I am finding out that Excel can do many more things that I thought. When learning to use this tool, I had to download the add-on. Unfortunately I have a Macbook Pro and Apple Products do not support this feature. However, I used a close friends laptop to learn. After downloading the add-on feature, I was able to compute the descriptive statistics for male and female test scores. Next, I was able to do the same thing and compare the test scores in each state.


By taking a look at the scatter plot, you will see that Virginia is 24 states from the top with 23 ahead and 28 states below. From the looks of the plot, Virginia is in the average range and doing fine as far as reading scores goes.

I did not have many problems when using this function however I could not get the states to show vertically rather than diagonal, which is a minor detail. Other than that, once I was able to borrow a friends laptop, I was able to complete the requirements. This is another great tool to keep in mind when it comes to grading. Using this for a means of comparison is a great idea!

When using this feature in Excel you are following ISTE NETS-3, Model Digital-Age Work and Learning, primarily focusing on communicating information to students, parents and colleagues as well as analyzing and evaluating data.