Today’s ridiculous project – a google sheet for AP style computer output

Working through my fourth candy assignment today, we ran into a problem where we could not easily create AP Stat style “computer output” for regression with student data. We do not have licenses for Minitab or JMP, R is outside my sphere (and the output looks different anyway), and Geogebra, statskey, and other free options I have tried either give different data, confusing data, or not enough data. I thought NCTMs Core Math Tools did what I needed, but I misread the output when planning.

I have since learned that StatsCrunch can output very similar data (and is nice enough that I may do subscriptions for it next year and use it more thoroughly with my students), but I did not know that tool this morning.

So what did I do? Made a google sheet that you can paste data into OR enter information for another google sheet (url, tab name, etc) and it will generate computer output for you. I may not ever use it again now that I have figured out StatsCrunch, but for data already in a google sheet this is quite possibly easier. I put it here for anybody who may find it useful.

https://docs.google.com/a/harpethhall.org/spreadsheets/d/1Z1quFFxfVxfkzj4OEpFMrRJIASuLxUW8-qBx2qILxwo/edit?usp=docslist_api

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s