Posted: 1/9/2006 10:38:16 PM EDT
|
Ok I'm not an excel guru. i can do the basic stuff. This has me stuck. I have a series of data (PBT results) that correspond to a date taken. I want to track the average over the dates. i.e. 2,4, 6, 4 would have averages 2,3,4,4 etc. Basically I want to be able to look at a date and see the average of all the data at that date then on the next date when a new number is added I can see the new average and how it was affect by the new number. How do I do this. I think I can do it in a line graph and got that to go but I want it in a data series. Thanks! Adam |
|
I think that would require some formulas... I think you'd only have to write it once or twice then you could drag it to apply... I guess I'd have to do it myself to be 100% sure (I'm a certified MS Excel 2003 specialist , but havent done any new spreadsheets in a while  )
|
It would require that you input a formula in the cells. Rather than dragging to apply to the selected area, you could just leave a lot of room in between the data and the formula. The formula would then cover your first input to your formula so even if you added new data in a cell the formula would still work. I might not be the best at explaining it...im kinda a hands on guy.....but this is how you do it.... -College Student |
Heh, I think we're thinking of something similer, but Its hard to explain (Excel is pretty much hands on stuff anyhow). I'm thinking of something like this, though I'm not sure if that is what he wants. An alternate is to only have one cell somewhere displaying the final average (but not show a daily running average). 
|
|
I have the final average. The eample sWs2 posted is close. Maybe my math is off but on the third day 2+6+4=12 and 12/3=4 not 4.5. 4 would be the average for the 3 days. I want to look at the table at any point and see the average up to that date. Thanks guys and I hope this helps. |
Ah.. I didnt realize you were doing it that way...I was adding the new score to the previous average, then averaging that. ETA:It looks like to do what you want and have a running daily average, instead of one final one, you would have to manually enter in a new formula for each row. Howeve, if you wan one final average thats pretty easy. AHA I think I got it now. 
|
| I'm a self taught excel person. You guys are great for helping. I don't think I coud do this for my job. (I went to school to be a cop. They didn't cover this there. I get tasked with this kind of stuff because my boss wouldn't have the first clue. I could always pawn it off but I hate doing that to the Sgts.) |
I dont do this for a job, it was required for pre-business majors (such as myself). Alternativly for the formula shown above you could use =AVERAGE($B$2:B6) and delete the first column entirely. (I think slow at 2 am) |
Sounds correct but I did get a B in Excel. Formulas click and drag. |
No, you need to anchor the A1 as A$1 or else you'll get a rolling average when you drag your formula. |
