weighted

Hello! I am trying to do a budget with the final result to be listed per day like so: <tbody> 01-jan sunday $xxx 02-jan monday $xxx 03-jan tuesday $xxx </tbody> and so on up to the last of december. January budget: $100 000 would give about $3226 per day in average... but, my problem...

Hi there. i am looking for a formula to allocate a percentage out of 100%, to a range of values. I am evaluating 6 options (Column A) and they have different costs (Column B). I wish to write a formula in Column C that displays the cost as a %, where 0% is the least cost and 100% is the most...

Hi, First post here. I found the board by googling various problems and this board came up a lot. I'm using Excel 2010. Here's my problem: I have two sets of data. Column B is the price per ton paid for grapes in a year. Column C is the number of tons for each price paid. For example: B...

I have a list of 14,561 people. We need to do a survey and we want to include about 5,000 random people total, but weighted based on the group they belong to (defined by L4 leader). I calculated really quickly that if I include about 35% of people for each L4 I get to the 5,000ish I need. So if...

Help! I am trying to compile a return on investment (ROI) workbook for my business, which contains four subsequent departments. When I calculate my ROI for the whole organization I get one number, then when I break it down by each of the four departments and then compile those four ROI numbers...

Hi All, I am using a pivot table to show an investment portfolio's position split by investment type and then individual holdings within each type, but there are two things I cannot represent in the pivot table the way I would like: - The data table the pivot table is drawing from has yield %...

I have a scatter plot of X and Y data points. Each point is made up of some number of items. How can I weight the points so that the trendline doesn't count a point that is made up of 10 items the same as it counts a point that is made up of 100 items? An example of my data: X .... Y ...

I need help in creating the formula to perform weighted percentage complete calculations. Say I have 5 job tasks to complete one roll up tasks. I want to weight task one as 30%, task 2 at 10%, task 3 at 15%, task 4 at 5%, and task 5 at 40%- or whatever the weight may be (i would like them to...