Solved

What statistical method/formula can be used for Range and Trend?

Posted on 2016-09-08
4
104 Views
Last Modified: 2016-09-23
I have a set of data (attached) which shows the volume of web traffic by Country, trended weekly. I'm trying to learn/find a statistical method that help me analyze the data in the following way:

  1. How much does it change? (Max, Min) -- I actually don't need an answer to this, I know how to do it, just reference for the second question below
  2. What is it's normal range? (Normal highs and lows, not maximums/minimums)
  3. What is the trend? (increasing, decreasing)

Are there statistical formulas to help understand this?
0
Comment
  • 2
4 Comments
 
LVL 18

Expert Comment

by:xtermie
ID: 41790141
Can't see the attachment
1
 

Author Comment

by:Elizabeth "Smalls" Eckels
ID: 41790352
0
 
LVL 8

Accepted Solution

by:
ShannonEE earned 500 total points
ID: 41790485
Hi there Elizabeth,

Lookong at your data I would make the following points -

  • You have 10 time series (one for each country) and for **correct** analysis you would need to use time series techniques**
  • They only show 18 weeks of data.  Is that all there is at the moment?  Can you go back in history to get previous values?  Will this project be going forward in time?
  • Is there likely to be more countries? and would you be interested in inter-country comparisions?
  • It is possible that a trend is going to be definitionally difficult to specify.  Are there likely to be ups and downs related to any of:  Christmas commerce, Summer holidays, political events, ...?  If so are you looking for the trend leading up (potential relative increase) and eventual settling down after (relative decrease) or do you want the trend going through such bumps?
  • Do you just want to describe the data?  Or do you want to use the data to estimate values of the bigger population or the process that generates the values? Or do you want to predict future values or ranges of values?  Your data collection technique/methods will be an important aspect to asddress these questions.
  • Typically with such time based data where it is measured over a longer period (ie at least a few years), it is **seasonally adjusted** with the aim to remove some of the usual up and down swings.  Is that going to be appropriate for you?  - cant be done for 18 weeks; you may be more interested to the seasonal effect rather than week to week change;  These are questions you need to ponder.

** - With data measured through time the inter measurement period is an important parameter.  When measured at points close in time a data point is not giving us a lot of new information  as it is going to be close in value to the previous value.  This concept is measured by auto-correlation.  When you use basic statistical summaries typically mean values will be correct but variances, standard deviations and standard error of estimates will be incorrect (and usually too small) .  Time series techniques (which are more involved) overcome this problem.
 

Hope this helps to clear your mind as to what you want/need.  Get back with more thoughts.

Regards,

ian
1
 

Author Comment

by:Elizabeth "Smalls" Eckels
ID: 41812973
This was really helpful in my thought process, Ian, and it stunned me in a good way. I realized I don't have enough timespan of data to get a reliable trend yet, so I just took a look at the slope over the time period I had. I might be getting back to you with a question down the road though now that I know what I need as inputs :) thanks so much!
1

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question