21 posts tagged with excel *and* statistics. (View popular tags)

Displaying 1 through 21 of 21. Subscribe:

I want to generate synthetic user-session data to predict how big a peak in application usage might be shortly before a weekly deadline (for timesheet submission - it's a time and labour tracking application). I've come up with a method that looks like it works - it involves a gamma distribution for the login time. But I don't have enough (in fact, any) statistical training to know whether I'm using that distribution meaningfully. Statisticians, please reassure me. Thanks! Excel functions inside... [more inside]

posted by rd45 on Sep 10, 2014 - 3 answers

posted by rd45 on Sep 10, 2014 - 3 answers

MS Excel's regression tools provide 95% lower/upper confidence results but how does one properly interpret and then express those as a single ± (plus/minus) figure? [more inside]

posted by kartguy on Jan 26, 2014 - 4 answers

posted by kartguy on Jan 26, 2014 - 4 answers

Help me with statistics and Excel. Especially help me if you know any labor saving methods. I want the median, mean and standard deviation for the average price of all items sold, but my spreadsheet-full-of-data doesn't tell me the price of each sale -- just the average price per store, and the number sold at that store. Something like this: [more inside]

posted by croutonsupafreak on Jun 21, 2013 - 10 answers

posted by croutonsupafreak on Jun 21, 2013 - 10 answers

What is this type of chart called and/or how do you create one in Excel? [more inside]

posted by tippiedog on Aug 17, 2012 - 8 answers

posted by tippiedog on Aug 17, 2012 - 8 answers

Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel? [more inside]

posted by Susurration on Apr 10, 2012 - 10 answers

posted by Susurration on Apr 10, 2012 - 10 answers

Excel statistics question (linear regression with weighted data points) [more inside]

posted by dabug on Nov 30, 2011 - 9 answers

posted by dabug on Nov 30, 2011 - 9 answers

How can I find the average of multiple columns in excel without selecting each individual row that I want averaged? [more inside]

posted by gibbsjd77 on Sep 2, 2011 - 8 answers

posted by gibbsjd77 on Sep 2, 2011 - 8 answers

What are best enterprise level Web Analytic / Stat programs that work with IIS and Apache sever logs? [more inside]

posted by wcfields on Mar 10, 2010 - 1 answer

posted by wcfields on Mar 10, 2010 - 1 answer

How do I compare a scatter of points in excel to a normal curve? [more inside]

posted by jefficator on Feb 8, 2010 - 12 answers

posted by jefficator on Feb 8, 2010 - 12 answers

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

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

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

posted by doctor.dan on May 24, 2009 - 8 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

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

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

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

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

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

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

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

posted by bjrubble on Apr 3, 2006 - 14 answers

Page:
1