Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 06, 04:40 PM posted to microsoft.public.excel.newusers
phm
 
Posts: n/a
Default Weighted Average


I am new to the weighing of numbers using excel. I really need help.
I am able to do this manually, but I it takes too long. Yes I still
use the calculator instead of excel. I am new at this.
Please help. I need to figure out the Quaterly total of the Average
second.
Manualy, I divide the total of the month and divide it by quaterly
total then this number is the multiple by the months average second.
And I repeat for all months. I then add and this is where my 0:18 comes
from.
Please help if this makes sense.


Total Average
seconds
October 7,727 0:26
November 6,292 0:12
December 5,468 0:14
Quarterly Total 19,487 0:18


--
phm
------------------------------------------------------------------------
phm's Profile: http://www.excelforum.com/member.php...o&userid=31105
View this thread: http://www.excelforum.com/showthread...hreadid=507722


  #2   Report Post  
Old February 2nd 06, 04:46 PM posted to microsoft.public.excel.newusers
phm
 
Posts: n/a
Default Weighted Average


I am new to the weighing of numbers using excel. I really need help.
I am able to do this manually, but I it takes too long. Yes I still
use the calculator instead of excel. I am new at this.
Please help. I need to figure out the Quaterly total of the Average
second.
Manualy, I divide the total of the month and divide it by quaterly
total then this number is the multiple by the months average second.
And I repeat for all months. I then add and this is where my 0:18 comes
from.
Please help if this makes sense.


first column is the month
second is the total of calls
third is the average of minutes per call

October 7,727 - 0:26

November 6,292 - 0:12

December 5,468 - 0:14

Quarterly Total 19,487 - 0:18


--
phm
------------------------------------------------------------------------
phm's Profile: http://www.excelforum.com/member.php...o&userid=31105
View this thread: http://www.excelforum.com/showthread...hreadid=507722

  #3   Report Post  
Old February 2nd 06, 05:23 PM posted to microsoft.public.excel.newusers
Roger Govier
 
Posts: n/a
Default Weighted Average

Hi

There is some information you are not giving here - the total time
duration for each month.
Calculating this from the information provided, you must have something
like

Month Total Calls Total Time Average Time
October 7,727 2009.02 0.26
November 6,292 755.04 0.12
December 5,468 765.62 0.14

To get the overall average for the quarter take the total time and
divide by the total calls

=Sum(C2:C4) /SUM(B2:B4) or 3259.58/19487 = 0.1811

--
Regards

Roger Govier


"phm" wrote in message
news

I am new to the weighing of numbers using excel. I really need help.
I am able to do this manually, but I it takes too long. Yes I still
use the calculator instead of excel. I am new at this.
Please help. I need to figure out the Quaterly total of the Average
second.
Manualy, I divide the total of the month and divide it by quaterly
total then this number is the multiple by the months average second.
And I repeat for all months. I then add and this is where my 0:18
comes
from.
Please help if this makes sense.


first column is the month
second is the total of calls
third is the average of minutes per call

October 7,727 - 0:26

November 6,292 - 0:12

December 5,468 - 0:14

Quarterly Total 19,487 - 0:18


--
phm
------------------------------------------------------------------------
phm's Profile:
http://www.excelforum.com/member.php...o&userid=31105
View this thread:
http://www.excelforum.com/showthread...hreadid=507722



  #4   Report Post  
Old February 3rd 06, 11:42 AM posted to microsoft.public.excel.newusers
 
Posts: n/a
Default Weighted Average

"phm" wrote:
first column is the month[,] second is the total of calls
third is the average of minutes per call
October 7,727 - 0:26
November 6,292 - 0:12
December 5,468 - 0:14
Quarterly Total 19,487 - 0:18


I assume the last column is entered in the form mm:ss.
I have trouble making Excel do the right thing with that
format; probably my mistake. But the following should
help you with the concept, if not the solution.

If you are content to enter the third column in seconds,
assuming the table above is in A1:C3, the average is:

=sumproduct(B1:B3,C1:C3) / sum(B1:B3)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weighted Average phm New Users to Excel 0 February 2nd 06 04:39 PM
Weighted Average - Copy Function Melissa Excel Worksheet Functions 7 January 6th 06 05:51 PM
Weighted Average MedicEric New Users to Excel 2 November 26th 05 07:29 PM
Show weighted average value after filter. BillC Excel Worksheet Functions 3 May 3rd 05 04:13 PM
Weighted Average Aloysicus Excel Discussion (Misc queries) 4 January 5th 05 11:10 AM


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017