Tuesday, July 16, 2013

Excel 1

I have to admit that I am really starting to get frustrated with this class.  I have Excel but it is an older version (one in which I probably need to upgrade, but until this class had no need) and it does not have an Add-Ons option.  I have tried to figure this out and can not.  I uploaded the state comparisons into a Google Doc and tried to figure out how to do the descriptive statistics using the HELP menu but it is no help I can not figure it out.  I have included a link to the document that I have so far and will continue to try and get it but it is not looking promising.
Also I posted in the discussion page so hopefully someone will have some advice for what I need to do!
Well I still did not figure out the short cut for descriptive statistics but I did figure out how to do most of the calculations manually in the excel that I have.  I am still trying to figure out how to get the standard error but I think I have the rest.  According to the data West Virginia is not doing so well.  We currently only have nine states that scored lower than us and forty-three that are above us.  The average of all scores is 220.4077278 and West Virginia's overall score is 214.3860242 which is significantly lower.  Below is a picture of my statistics and my scatter plot. I think I figured out how to compute the standard error and it is 0.9275.  It is not filled in in the picture below because I took this Jing shot before I figured it out.

No comments:

Post a Comment