![](https://lh5.googleusercontent.com/-iysBVTZFYMg/Ty3r4xyY2HI/AAAAAAAAA8A/rA-bjU4NH8M/s800/pola250.jpg")
![I have come to a point in my life where “proficient in Excel” is no longer a lie lol
Man, we’ve been doing these t-tests a lot ately— probably every other day— and it drives me crazy when I have to manually recalculate everything and quadruple check that I didn’t enter a single value wrong. The B1 and B2 values trigger my OCD the most. It’s the sum of all the squares of the numbers that add up to A1 and A2 so it’s a doozy to double-check them (I seriously mutter, “I hate myself,” when I end up with a different value) especially when dealing with a large sample. (The most we’ve had so far is n=30, fortunately.)
This is important because if you screw B1 and B2 up, then it screws C1 and C2 up (=B - [A^2 / n]), which screws t-calc up (=(|X1-X2|) / √ (([C1+C2]/n1+n2-2)*([1/n1]+[1/n2]))) which is the only value you really need o say, “a bloo bloo bloo there is/isn’t a statistically significant difference between the two samples.”
So I decided to learn Excel. You just copy and paste, man! Copy and paste, and it does all the math for you! All you have to do is check that you set up the right formulas! Ah, the things you learn out of laziness time-efficiency. lol](http://25.media.tumblr.com/tumblr_lyxu75m4Do1qatfc8o1_1280.jpg)
I have come to a point in my life where “proficient in Excel” is no longer a lie lol
Man, we’ve been doing these t-tests a lot ately— probably every other day— and it drives me crazy when I have to manually recalculate everything and quadruple check that I didn’t enter a single value wrong. The B1 and B2 values trigger my OCD the most. It’s the sum of all the squares of the numbers that add up to A1 and A2 so it’s a doozy to double-check them (I seriously mutter, “I hate myself,” when I end up with a different value) especially when dealing with a large sample. (The most we’ve had so far is n=30, fortunately.)
This is important because if you screw B1 and B2 up, then it screws C1 and C2 up (=B - [A^2 / n]), which screws t-calc up (=(|X1-X2|) / √ (([C1+C2]/n1+n2-2)*([1/n1]+[1/n2]))) which is the only value you really need o say, “a bloo bloo bloo there is/isn’t a statistically significant difference between the two samples.”
So I decided to learn Excel. You just copy and paste, man! Copy and paste, and it does all the math for you! All you have to do is check that you set up the right formulas! Ah, the things you learn out of laziness time-efficiency. lol
