How do I calculate a daily average in Excel?

Answers

1. Lewiy

   On 2006-08-11 11:04:52

   
   
   I have already answered your updated question so have a look at that.

2. kartoos5050

   On 2006-08-11 05:07:57

   
   
   Calculate the maximum discharge for each water year in the period of record. The AVERAGE, MAX, and MIN functions in excel can be used to calculate these values for each water year. It may be more efficient to calculate the mean, maximum, and minimum flows for each water year in the period of record at one time. also see the following link http://water.oregonstate.edu/streamflow/analysis/floodfreq/meandaily_tutorial.htm

3. neha

   On 2006-08-13 10:46:02

   
   
   We the surfers of cyber world meet with so many people every day. Surfing the net is the best pastime one can ever develop, as internet has the most knowledge, a surfer will never have to wait for a answer. The vast knowledge of cyber world is nothing as compared to the cyber society that it gives. Internet is a community but so vast that we need a place to make conversation easy. What more can be better than a chat room for this purpose, well a chat room and a message board along with a forum is the best combination really. I was actually looking for a place where we can find all these things with a profile and photo brouse option. Finally I got this site, this place is a very nice community where we can share every thing online. And also about the leader board, I must tell it is great. The thought of the leader board is unique, as not to many people has thought about this thing. And the method of getting the leader is very different and one must check out this site once. The cyber culture is growing, and it is about time that we find our club and that to a very different club, which is not a part of any big website house like the yahoo and google. This site am talking about has every thing that a cyber surfer ever wants. This is the website address, http://www.friendscyberclub.com/ Features of this site is: 1) chatting 2) view profiles and photos 3) upload your photos and make a cool profile. 4) your message board 5) forum 6) See your name on the leader board. There are also many more features available in the site, free to join.

4. robleot

   On 2006-08-11 05:10:40

   
   
   at the bottom of the amounts use the formula =AVERAGE(B1:B45) where B1 is the first cell of amount and B45 (or similar) is the last cell of amount. Note this assumes that you have no zero amounts any only one amount per day. HTH

5. malung786

   On 2006-08-11 05:06:55

   
   
   here is the example of daily fat calories http://www.microsoft.com/education/calories.mspx let me know if u need more help i have plenty of samples with me

6. luckyfriend26

   On 2006-08-11 05:10:06

   
   
   sum up the total amount & then divide it with the total days, daily average should come up.

7. Tom H

   On 2006-08-11 05:08:11

   
   
   Excel has an AVG function and for the # of days in column 1 calculate 1st - last and use that # in your avg function on the amount column.

8. Computer Guy

   On 2006-08-11 05:10:57

   
   
   =AVERAGEA(B1:B31)