| |

Excel for regression analysis: What a surprise!

I wouldn’t normally consider Excel for analysis, but there are four reasons I’ll be using it sometimes for the next class I’m teaching. First of all, we start out with some pretty basic statistics, I’m not even sure I’d call them statistics, and Excel is good for that kind of stuff. Second, Excel now has…

|

Standardized testing: Solving your reliability problem

Where we left off, the reliability was unacceptably low for our measure to assess students knowledge of multiplication, division and other third and fourth grade math standards. We were sad. One person, whose picture I have replaced with the mother from our game, Spirit Lake, so she can remain anonymous, said to me: But there…

|

Statistics Answers the Most Important Social Question

Occasionally, when I am teaching about a topic like repeated measures Analysis of Variance, a brave student will raise a hand and ask, Seriously, professor, WHEN will I ever use this? The aspiring director of a library, clinic, afterschool program, etc. does not see how statistics apply to conducting an outreach campaign or HIV screening…

| | |

Mom! That Evaluator Keeps Looking at Me!

If I were to give one piece of advice to a would-be program evaluator, it would be to get to know your data so intimately it’s almost immoral. Generally, program evaluation is an activity undertaken by someone with a degree of expertise in research methods and statistics (hopefully!) using data gathered and entered by people’s…

| |

Filter Data with SAS Enterprise Guide: Even More Useful than You Think

Occasionally, a brave student will ask me, When will I ever use this? The “this” can be anything from a mixed model analysis to nested arrays. (I have answers for both of those, by the way.) I NEVER get that question when discussing topics like filtering data, whether for records or variables, because it is…

| |

Data Analysis by Example: That’s funny …

In the last post, I used SAS Enterprise Guide to filter out a couple of ‘bad’ records that came from test data, then I created a summary table of the number of questions answered and the percentage correct. Then, I calculated the mean percentage correct for the  around 84%. That seemed a bit high to me….