Solved

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

Posted on 2016-09-08
4
83 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
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…

773 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