12 posts tagged with math *and* excel. (View popular tags)

Displaying 1 through 12 of 12. Subscribe:

How do you rejig the formula for CAGR to get the starting value when you know the other variables? [more inside]

posted by MuffinMan on Aug 1, 2013 - 3 answers

posted by MuffinMan on Aug 1, 2013 - 3 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

I have roughly 20 people who each need a project. I have 27 projects and don't want anyone to share a project. I let the people pick their top five projects and rank them so I know who wants what. What is the best (easiest...) way for me to fairly figure out who should get what project so that the most people get their top choice, or at least one of their top choices? [more inside]

posted by pwb503 on Jan 22, 2013 - 8 answers

posted by pwb503 on Jan 22, 2013 - 8 answers

How do you find a number that minus a percentage of itself is a certain number? [more inside]

posted by JulianDay on Dec 6, 2009 - 7 answers

posted by JulianDay on Dec 6, 2009 - 7 answers

MathFilter, NumericSimplificationFilter, RecursionFilter, ExcelFilter: Where X_1,X_2,...,X_n can be any number, is there a name, simplified series, or equation to describe: (X_1)+(X_1+X_2)+(X_1+X_2+X_3)+...+(X_1+X_2+...+X_n) ? Seriously seriously insane exel implementation question inside. [more inside]

posted by Nanukthedog on Aug 28, 2009 - 16 answers

posted by Nanukthedog on Aug 28, 2009 - 16 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 have to create an excel sheet to keep track of a book budget - in the most basic terms, I will have a total budget figure, and I want to subtract invoice figures to keep a running total.
Here's an example of what I want the sheet to look like:
http://i109.photobucket.com/albums/n46/coollibrarian/excel.jpg
The simpler the better.
[more inside]

posted by coollibrarian on Jul 26, 2008 - 7 answers

posted by coollibrarian on Jul 26, 2008 - 7 answers

Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]

posted by korres on Feb 5, 2008 - 4 answers

posted by korres on Feb 5, 2008 - 4 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

In Excel 2007, I need advice on how to round a series of prices to either a $0.50 ending, or a $0.95 ending. [more inside]

posted by Futurehouse on Dec 20, 2007 - 10 answers

posted by Futurehouse on Dec 20, 2007 - 10 answers

Graphing question: My boss has an idea of how our data should be presented. Please help me figure out how to make it happen! [more inside]

posted by nprigoda on Jul 4, 2007 - 5 answers

posted by nprigoda on Jul 4, 2007 - 5 answers

How can one create a best fit ellipse around a cluster of (x,y) points in a scatter plot within Excel? [more inside]

posted by geonags on Apr 12, 2006 - 33 answers

posted by geonags on Apr 12, 2006 - 33 answers

Page:
1