This is your Science Fair, on SAS

Last week I talked about how I volunteered to serve as a judge for a middle-school science fair. As I expected, I enjoyed the experience quite a bit, and I hope the students got something positive from me as well. I evaluated several really impressive projects at the 7th grade level. The "first place" project was presented by a girl who built a homemade calorimeter (and used some math) to measure the amount of energy in different types of horse feeds. It turns out that horse feed is not labeled like human food; manufacturers do supply nutrition information, but not the amount of calories. Different horses need widely different amounts of caloric intake based upon their size and activity level. (Yes, I learned a lot.)

As I mentioned in my previous post, my 6th-grade daughter presented a project to answer this question: which will react more when you add Mentos mint candy to it: Diet Coke or Diet Pepsi? Her hypothesis was that Diet Coke should have the higher reaction, because its higher density allows the soda to fill the microscopic dimples on the surface of the candy more efficiently and thus produce a greater force, owing to the surface tension. (Yes, she has inherited my gift for Making Things Up. I'm sure she really had no idea, but she was rooting for Diet Coke.)

According to the results of her tests, her hypothesis was proved correct (although who knows for what reason?). The project rubric required her to use Microsoft Excel to present the data and charts, but fortunately I'm not restricted in that way when reporting to you here.

I recoded her results into SAS, and then used PROC TTEST and ODS GRAPHICS to produce these charts to compare the results between Diet Pepsi and Diet Coke. This first chart shows the results for 3 trials, with 3 pairs of 2-liter bottles tested in each trial (a total of 18 bottles, or 9 for each brand).

Considering results of all trials

Two trials were conducted on the same day when the ingredients were "fresh" from the store. But trial 3 was conducted weeks later as the materials sat in our garage, exposed to heat and cold over time. The trial 3 numbers were much lower for both brands, and so these skew the overall results. Here's another chart with trial 3 excluded, and you can see a more dramatic difference between the two brands.

Considering results of just 2 trials

How would you analyze these data? I don't have formal training as a statistician, so it's probable that I've missed something important. At the end of this post, there is a SAS program that contains the numbers. If you have some good ideas for a different way to look at this, post back in the comments.

Update 26Jan2011, 8pm: I found a data entry error in my numbers! I corrected the data and refreshed the results.

data results;
  length brand $ 12
     trial 8
     height 8;
  label height="Height (cm)";
  infile datalines dsd;
  input brand trial height;
Diet Coke,1,160
Diet Coke,1,145
Diet Coke,1,183
Diet Coke,2,152
Diet Coke,2,168
Diet Coke,2,229
Diet Coke,3,91
Diet Coke,3,76
Diet Coke,3,84
Diet Pepsi,1,114
Diet Pepsi,1,152
Diet Pepsi,1,150
Diet Pepsi,2,175
Diet Pepsi,2,107
Diet Pepsi,2,137
Diet Pepsi,3,89
Diet Pepsi,3,74
Diet Pepsi,3,61

tags: ODS Graphics, SAS life, science fairs, t-test


  1. Larry Hoyle
    Posted January 27, 2011 at 4:48 pm | Permalink

    A couple of observations: the sample size is fairly small given the initial results. Using the SAS Power and Sample Size Tool yielded these narratives:
    "For a two-sample pooled t test of a normal mean difference with a two-sided significance level of 0.05, assuming a common standard deviation of 51, a sample size of 110 per group is required to obtain a power of at least 0.95 to detect a difference between the means 143 and 118. The actual power is 0.951.

    For a two-sample pooled t test of a normal mean difference with a two-sided significance level of 0.05, assuming a common standard deviation of 39, a sample size of 53 per group is required to obtain a power of at least 0.9 to detect a difference between the means 143 and 118. The actual power is 0.905."

    This could get expensive for dad.

    What looks interesting to me in the graphs is the possibility that the variances might be different between the two brands.

  2. Rick Wicklin
    Posted January 31, 2011 at 9:27 am | Permalink

    The t-test is a good test for these data. Your graphs indicate that the mean height of DC is greater than the mean height of DP, but in statistics "greater than" is different than "significantly greater than." As Larry mentions, you'd need more data to be able to claim that the height of DC is *significantly* greater than the height of DP.

    Larry also notes that the variances of each group might vary. PROC TTEST can account for that as well. Look at the "Satterthwaite" statistic in the TTEST output, instead of the "Pooled" statistic. In either case, the differences between the DC and DP means are not significant at a 95% level. (Sorry!)

    What I think is interesting is how much the heights degraded in the third trial. You can use the Interaction Plot in PROC GLM to examine the effect of the Trial parameter:

    ods graphics on;
    proc glm data=results;
    class Brand Trial;
    model Height = Brand Trial;

    The Trial parameter is a significant factor. I think the main result of your daughter's experiment is "the reaction between soda and mentos depends (strongly) on the freshness of the soda."

    This statement assumes that the temperature was the same in all trials; if not, the Trial parameter might actually be a proxy for "cooler temperature." This suggests another science fair product: compare room temperature soda to refrigerated soda.

3 Trackbacks

  1. [...] known to elementary school students. (If you like analyzing kids' experiments with SAS, see also Chris Hemedinger's 2011 analysis of his daughter's "Mentos and Coke" science fair project.) The experiment measured the drying times for 40 loads of laundry. Each load was weighed upon [...]

  2. [...] This is your science fair, on SAS on the SAS Dummy blog. [...]

  3. […] was inspired by Chris Hemedinger's blog posts about his daughter's science fair project. Explaining statistics to a pre-teenager can be a humbling […]

Post a Comment

Your email is never published nor shared. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>