|

Excel statistics functions – simple answers to simple questions

I have colleagues who hate Excel with a passion. Why, they demand to know, would ANYONE use Excel for statistics when there are so many options that are so much better? Actually, I don’t find the Excel add-on for statistics that terrible, but that isn’t even the topic of this post. I use Excel because…

| |

Logistic regression using SAS On-Demand with SAS Enterprise Guide – a movie and a rant

If you have a mad desire to do logistic regression with SAS On-Demand with SAS Enterprise Guide, here is a movie that shows how to do it. It is a .avi file so you may want to just download it and run it on your PC. Here is why the movie is not all that…

| |

How to do a regression analysis with SAS web editor and SAS Enterprise Guide

Here we have analysis of open data using free software with – uh, SAS? Click the links below and watch the videos. Seriously. They are too large to embed in the post. Sorry. Yes, you might think of SAS as the choice of multinational corporations with unlimited software budgets. You now have two options, if…

|

Software packages I cannot live without

I read an interesting question years ago, on the JMP blog, “What are 5-9 software packages you can’t live without?” That reminded me that when I started this blog almost four years ago, I wrote a post with the title “Nine software packages I can’t live without” . I never finished publishing the list, I started another list…

| | |

On being a start-up unicorn

Not a day goes by that I don’t read an article saying I don’t exist. Apparently, there are no women actually running start-ups, no Latinos in technology. No one outside of Silicon Valley is doing anything. Maybe I’m a unicorn. Or perhaps I’m invisible. If I were to actually exist, and if it was possible…

|

Super-Duper Easy Calculator for Confidence Interval of Difference in Proportions

Today, I wanted to find the confidence interval for the difference between two proportions. I have SAS, SPSS, Stata, JMP,  Excel and God knows what else laying around. I did not want to go to the effort of plugging the numbers into a calculator, but it really is a pretty straightforward formula, so you would…

I feel a macro coming on: Part 2 positional, optional & default parameters

Yesterday and the day before, I gave an example of using SAS to sort student responses into the class they were in using the DATEPART function, TIMEPART function and a few DO-loops. After making sure my code runs, I decided it was pretty redundant and thus a classic case for a macro. What I want…