##
22 posts tagged with math *and* excel.

Displaying 1 through 22 of 22. Subscribe:

## Data Munge: Uknown combination of 7 numbers produces a given number.

**: In a spreadsheet with ten data columns, Column "A" is related to columns "B" through "J" in that some unknown combination or interaction of some or all of them will produce the data in Column "A". How do we determine what that combination is? (I can't even find what this type of problem is**

*Data Munging Pros**called*, and I've not been able to find any productive Google search terms.) A more thorough explanation/example is provided in-thread. [more inside]

## Math For Spacing Out Three-Day Weekends, But Accounting for Holidays

I'm a big honkin' geek, and I would like to figure out an Excel formula I could reuse from year to year to space out my vacation day choices -- but including holidays, which would prevent even distribution. How can I still get as close as possible? More inside. [more inside]

## I have excel and a sense that this is possible

So imagine I have a population of like 100,000 people. And I have goals for them to achieve for which they get money. Now I want to calculate what my budget might be. [more inside]

## Help with Excel formula to compare 1 column of numbers to other columns.

I have an excel sheet with 4 columns of numbers. The first column is a recent donation amount. The other three columns were the prompts of donation amounts, (the Reach, the Target, and the Anchor). Is there an excel formula that can compare these four columns? [more inside]

## Excel Formula to Weight Ratings By Number of Ratings?

How do I write an Excel formula to weight a rating by the number of ratings, so that a 4 with tens of thousands of ratings weighs more than a 5 with three ratings? [more inside]

## Excel arithmetic glitch explanation

This isn't getting in the way of anything practical, but it's niggling that I don't understand the technicalities. [more inside]

## Help me develop complicated spreadsheet

Note: NOT Homework. Real world application here.
I have to come up with a spreadsheet based on a formula that allocates dollars to people based upon role and participation. I'm good at Excel but this one is boggling my mind. Details and example inside [more inside]

## My Math/Excel Ignorance is Showing

In three cells in a single column in Microsoft Excel, I'd like to be able to input a number in the bottom cell, have the middle cell calculate what a 6% sales tax on the figure below it is, and provide the amount before that 6% tax in the top cell.
Any help will be appreciated. The last math class I took was 44 years ago and I didn't pay much attention in that one.

## How to Tell Excel to Evaluate Last Three Months (NOT Last 90 Entries)

I have an Excel spreadsheet I use to track glucose readings. There’s a value diabetics use called “A1C” which looks at the last three months of readings. It's based on a blood test, but can be estimated by averaging your readings for the last three months. I try to track every day, but I can’t reliably say “look at the last 90 values” – so I’m wondering how to set up a formula to tell it to only look at readings going back 90 days, not necessarily 90 readings. More inside. [more inside]

## How do I solve for a percentage of a total budget...

This will be easy for someone, but math is my second language so I'm at a loss.
How do I solve for the percentage of a TOTAL budget, when one line item is unknown (and is part of the total budget)? [more inside]

## Rearranging the formula for Compound Annual Growth Rate

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

## 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]

## How do I figure out how to divvy out these projects?

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]

## Reverse my percentage?

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

## (3Excel)*(2Help)*(1Please)

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]

## Need advice about statistics...

Am I distorting my data, and not showing the true picture? [more inside]

## Help, Please - I'm an Excel Moron

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]

## Using conditional formulas to sum up data in Microsoft Excel

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]

## 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]

## How can I round prices in Excel?

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]

## Help me make the graph my boss imagined!

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]

## Best Fit Ellipse?

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

Page:
1