Statistical question

[Rachel Costanza]

I am looking to create a dashboard that will tell people how often to
check their social media outlets based on the number of friends / followers
etc they have and the frequency interval of their updates. Can somebody help
me with the formula ... A1 number of friends A2 intervals between updates
(i.e. 2, 5, 60 minutes). Trying to establish an efficiency metric for going
online to various social networks based on activity. Your input is always
appreciated!

 

[ryguy7272]

Not sure what you're doing, but try this:
http://www.cpearson.com/Excel/OnTime.aspx

 

[Rachel Costanza]

Thanks - I am trying to predict updates. So for example if I have 400
friends on facebook and receive 100 updates per day what is the frequency of
updates. Thanks in advance.

 

[ryguy7272]

LOL! This is TOTALLY different than what I thought you were talking about.
Check this out:
http://office.microsoft.com/en-us/excel/HP052090971033.aspx

If that doesn't get you going, here's a video that shows step-by-step: