Statistical Analysis

Statistical Analysis

Here are my results. I have a feeling that they are no where close to being right. I think that I messed up the Excel sheet with all of the information on it. I was playing around with it after I downloaded it, trying to learn the Sort and Filter tabs. I have read all of the discussion posts up to this point, and I have watched the video tutorials repeatedly. After doing so I believe that I am doing the procedures correctly, but I can't get numbers to match up with what was given to us.

My results are a screen shot of an Excel page. I have saved the results of the tests in Excel. So if those are needed as well I can submit them as an attachment.

I see how these tests would be beneficial. Especially comparing progress between this year's class/students and last year's. The check could be to see how the classes compare, or to see what kind of job you're doing as a teacher. Numerous other possiblities exist, I know.

NETS-T
2d, 3a, 3b, 3d, 5a, 5b, 5c, 5d

Data Preparation

Hypothesis: Females have a higher average number of discussion posts than do the males.
Dependent variable- Sex. Independent variable- # of posts.
Results: Females average # of posts was 15.63, males was 16.57. The hypothesis was incorrect.

Null Hypothesis: Teaching or Not Teaching does not affect the average number of discussion posts.
Dependent variable- Teaching/Not Teaching. Independent variable- # of posts.
Results: Those Teaching average 18.7 posts. Those Not Teaching average 9.55 posts. The Null Hypothesis was incorrect.

I have found that YouTube is an incredible resource for tutorials. There are many well-done selection out there that would be great to teach the novice, all the way to advanced users. Glad to see that YouTube isn't just a place to post videos of someone's dumbest moment and stupid choices.

NETS-T
1a, b, c, d
2a, b, c, d
3a, b, c, d
4a, b, c, d
5a, b, c, d

This exercise can be adapted to multiple subject matter in the classroom. Research projects would've been much more interesting in school if we(the students) could've come up with our own numbers rather than finding them in an encyclopedia.

Excel Basics

I have replaced all words with numbers- that's what I understood to do by the instructions. The average blog posts it 16. I have posted 41 times, so I am above average. I can sort, but I'm afraid to do too much before I know what the next step is with page.

NETS-T: most are covered with this simple exercise. The use of Excel in this type of activity is a great way to model 21st Century Learning to teachers. "This is how easy it can be".

1a, b, c, d
2a, b, c, d
3a, b, c, d
4a, c
5a, b, c