22 posts tagged with excel and statistics.
Displaying 1 through 22 of 22. Subscribe:

How to present and evaluate data relative to weight

I could use some help walking through this: I have Excel data that means more or less depending on where it comes from. When I'm working with it, presenting it, or thinking about it, I want to treat it differently depending on origin. Example within. [more inside]
posted by A Terrible Llama on Jul 19, 2016 - 11 answers

is this a good use case for a gamma distribution?

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

Using Excel's regression tools to determine the 95% confidence interval

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

Find standard deviation in Excel, but first develop a labor-saving trick

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

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

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

How to determine relationship between two dimensions of a 3 x 3 frequency matrix?

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

Weighted regression?

Excel statistics question (linear regression with weighted data points) [more inside]
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?

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

Turns out our top referrer is Zombo.com

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

How do I plot a comparison of points to the normal curve in excel?

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

Rates of success?

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

Help me determine rate of imprement for my players!

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

Stats/Maths filter: How do I solve a sigmoidal?

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

linearity without the scatterplot

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

Adventures in Data Interoperability

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

Need advice about statistics...

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

Please help me format Excel cell correctly - URGENT!

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

Name that Chart!

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

complex dice probability make head esplode

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

StatisticsFilter: Correlation over time?

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 to compare multi-row averages in JMP?

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

Help me calculate a hidden value in my data

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

Page: 1