User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Weighted median in Excel Page [1]  
neodata686
All American
11577 Posts
user info
edit post

Does anyone know how to do this without writing VB or using Access?

9/11/2011 4:35:33 PM
darkone
(\/) (;,,,;) (\/)
11608 Posts
user info
edit post

Try a real data analysis package.

Nevertheless, it shouldn't be hard. How are you wanting to do the weighting?

9/11/2011 4:41:14 PM
neodata686
All American
11577 Posts
user info
edit post

NEVERMIND I FOUND AN EASY WAY TO DO IT. I feel dumb.

Just divide column B by 2 to get the average then match up column A with the cumulative to get the median.

[Edited on September 11, 2011 at 4:59 PM. Reason : s]

9/11/2011 4:49:03 PM
 Message Boards » Tech Talk » Weighted median in Excel Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.38 - our disclaimer.