Learn Data Analysis for Excel in 2.5 Hours, Part 2: Statistical Testing

excel test

(Image by James Vaughan)

If you’ve ever tried to set up a legitimate statistical test in Excel, you already know it’s painful, but if you have the Analysis ToolPak enabled, things get a bit easier. Today, we’re going to learn how to run statistical tests in Excel. We’ll cover F-tests to compare variances, t-tests to compare 2 averages, and ANOVAs to compare multiple averages.

(If you need to know how to enable the Analysis ToolPak, or how to run in-depth regression analysis, click here and take a look at Part 1 now.)

A word of warning: the ToolPak might seem self explanatory, but some of the results are easy to interpret incorrectly.

This post should take between 22 and 44 minutes to read and toy with. Alright, let’s go ahead and get started.

Continue reading →

Learn Data Analysis for Excel in 2.5 Hours, Part 1: Enabling the ToolPak, and Regression Analysis

excel-2010-logoStatistical analysis in Excel is a huge pain unless you know how to enable the Analysis Toolpak. In part 1 of this series on data analysis in Excel, I’m going to tell you how to do that. Next, we’ll talk about regression analysis (the real thing, including multiple variables, not just fitting a line to a graph). This whole post should take 20 to 40 minutes.

(If you’re looking for info on statistical tests for Excel, click here to check out Part 2.)

Continue reading →

The P-Value “Formula,” Testing Your Hypothesis

ztest4
The p-value, while it is one of the most widely-used and important concepts in statistics, is actually widely misunderstood. Today we’ll talk about what it is, and how to obtain it.

(If you’re in a statistics class, or using this stuff out there in the real world, consider ordering “Statistics in Plain English” by Timothy Urdan. It’s got the readability of the Idiot’s Guide on the same subject, and (thank God) a non-textbook price, but without the glaring mistakes.)

Continue reading →

The Theory of Relativity for Kids, Part 4 – Time and Space in General Relativity

einstein4Welcome back! This is the last part of the series on relativity. Today we’ll talk about how gravity effects time and space. You might want to look at last week’s post before you read this one. It explains the basics of gravity in General Relativity. Go back to the Theory of Relativity for Kids if you want to start at the very beginning.

Continue reading →

Friday Roundup: Stem Cells to Brain Cells, Swallow Evolution in 30 Years, and Cold Sores That Treat Cancer

A monkey’s skin cells were transformed into stem cells, then implanted in its brain, where they turned into brain cells, wired themselves up, and took on normal function. We now have brain scans capable of measuring activity on the cellular level throughout the whole brain. Well…fish brains anyway. The universe is just slightly older than [...]

Continue reading →

The Theory of Relativity, For Kids

einsteinSo you want to understand the theory of relativity, and you’re a kid? No problem. Let’s get started.

(If you’re a parent looking for some activities to help teach your kid, consider ordering Albert Einstein and Relativity for Kids: His Life and Ideas with 21 Activities and Thought Experiments. And if you’re an adult who just wants to understand relativity, there’s no shame in reading on.)

Continue reading →

Friday Roundup: Arctic Camels, Wireless Computer/Brain Interfaces

This insect’s wings contain tiny nanostructures that actually tear bacteria apart, the first structure of its kind discovered in nature. Giant camel fossils in the arctic. Using nanoparticles, scientists deliver bee venom to HIV viruses, destroying them without damaging the surrounding cells. In related news, an infant was functionally cured of HIV using normal HIV drugs by [...]

Continue reading →