In this activity we needed to download an existing spreadsheet, do some statistical analysis on the data, create a graph and use it to analyze information. Downloading the spreadsheet was not a problem, however, I found out having a Mac was not optimal for the statistical analysis. It would have been nice to use the Data Analysis Toolpak that was available to Windows users. I was able to get some of the statistics easily with functions, but some I had to google and figure out on my own. In the end, I ended up doing most of the calculating by hand to verify the output because I just didn't quite trust that I was using the formulas correctly.
According to the descriptive statistics females have a high mean score on the 8th grade reading assessments.
After graphing the results for all students in all states, we can see that Virginia is almost in the middle of the pack with 23 testing regions/states scoring higher and 28 testing regions/states. Virginia comes out just above the average score.
If it is too difficult to read the state data in the graph above, the original spreadsheet can be found
here.
NETS:
3d - Using information resources to support research and teaching. Knowledge of the descriptive statistics availability will be helpful for many applications.
No comments:
Post a Comment