ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Statistical question (https://www.excelbanter.com/excel-worksheet-functions/252363-statistical-question.html)

Rachel Costanza[_2_]

Statistical question
 
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

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rachel Costanza" wrote:

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!


Rachel Costanza[_2_]

Statistical question
 
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" wrote:

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rachel Costanza" wrote:

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

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

If that doesn't get you going, here's a video that shows step-by-step:
http://www.youtube.com/watch?v=QKVpqYYM7zQ


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rachel Costanza" wrote:

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" wrote:

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rachel Costanza" wrote:

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!



All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com