12 posts tagged with excel and statistics. (View popular tags)
Displaying 1 through 12 of 12. Subscribe: Posts tagged with excel and statistics

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]
posted by rollick on Nov 4, 2009 - 9 answers

I coach a high school soccer team. Each practice we go through a routine which involves repetitions of various skills. The number of repetitions accomplished by a player for each skill is recorded in an excel spreadsheet for ranking purposes. I want to determine the rate of improvement so the players can see their progress and who's improving most. Is there a simple excel function that would help me do this?
posted by TheManticore on Sep 19, 2009 - 2 answers

I am trying to fit my data onto a sigmoidal function. The fit won't be perfect, but I am stuck with it for now. To help with this, I have been (very generously) given a spreadsheet that creates a sigmoidal curve if the values a, b, x0 and x are known. How do I get these values? [more inside]
posted by doctor.dan on May 24, 2009 - 8 answers

How do I check for linearity? [more inside]
posted by ttyn on Feb 28, 2009 - 9 answers

How do I convert a large raster image into a table for analysis and manipulation? [more inside]
posted by agentofselection on Dec 14, 2008 - 9 answers

Am I distorting my data, and not showing the true picture? [more inside]
posted by matholio on Nov 18, 2008 - 9 answers

I need to enter the following information into excel, but excel wants to transform one of them into a date format. This is for a statistics class and being used to make a graph of some kind. [more inside]
posted by Jackie_Treehorn on Oct 24, 2008 - 9 answers

Excel help: How do I make a chart which displays my values as bars extending above and below a particular line. [more inside]
posted by arcticwoman on Mar 9, 2008 - 12 answers

I need a tool to help me analyze the probability of certain events occurring regarding a pool of X dice for a game I am creating. See my examples below. [more inside]
posted by DetonatedManiac on Dec 21, 2007 - 7 answers

If I'm looking at existing statistical data, how do I try to find a correlation between two variables over time? Scatterplots have confused me, because they don't seem to reflect the passage of time, but just where x and y meet. Pearson's r doesn't seem to do it either w/r/t time. [more inside]
posted by trondant on Dec 11, 2007 - 13 answers

How do I compare averages in JMP (statistical software)? Help me stop using Excel. [more inside]
posted by dmd on Jul 22, 2007 - 8 answers

I've spent the past day or so trying to figure out how to calculate a hidden value in my data. It varies linearly with time, or closely enough that we can make that assumption within any given dataset. Where this goes beyond a simple linear regression is that each datapoint is known to be above or below the hidden value. The data is collected in a C# program and processed in Excel; an Excel function would be the ideal solution. [more inside]
posted by bjrubble on Apr 3, 2006 - 14 answers