turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- Analysis Question

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

11-30-2009 09:14 AM

Hi All:

Being a programmer, I'm no great shakes at statistics.

What I have is a measurement for each quarter for a year. I have a value for the first quarter of the following year. (I have YEAR, QUARTER, MEASURE)

I would like to know whether the new quarter is "reasonable" given the values of past year (ie: should I reject that value and investigate).

Remember, I'm a programmer so the simpler the better!

Thanks in advance.

Being a programmer, I'm no great shakes at statistics.

What I have is a measurement for each quarter for a year. I have a value for the first quarter of the following year. (I have YEAR, QUARTER, MEASURE)

I would like to know whether the new quarter is "reasonable" given the values of past year (ie: should I reject that value and investigate).

Remember, I'm a programmer so the simpler the better!

Thanks in advance.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

11-30-2009 11:17 AM

PROC COMPARE with suitable options to satisfy your "reasonable" check. Or a DATA step process to compare related consecutive "period" values.

Scott Barry

SBBWorks, Inc.

Scott Barry

SBBWorks, Inc.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-11-2009 08:34 PM

OK, so you've got something like this

2008 1 10

2008 2 12

2008 3 11

2008 4 10

2009 1 9

2009 2 10

2009 3 11

2009 4 10

2010 1 xxx

then you find that xxx = 12. Is 12 "reasonable".

Is that your question?

If so, may I ask how many years of data you have, and whether there is reason to expect either a long term trend or seasonal variation or both?

Peter

http://www.statisticalanalysisconsulting.com/

2008 1 10

2008 2 12

2008 3 11

2008 4 10

2009 1 9

2009 2 10

2009 3 11

2009 4 10

2010 1 xxx

then you find that xxx = 12. Is 12 "reasonable".

Is that your question?

If so, may I ask how many years of data you have, and whether there is reason to expect either a long term trend or seasonal variation or both?

Peter

http://www.statisticalanalysisconsulting.com/

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-16-2009 01:57 PM

That is exactly what I am looking for.

I only have 2 years of good data (8 quarters) which I know is a problem (not enough data!)

I would like to know that when xxx=12 it is "ok" and when xxx=345 is it not (or whatever) based on the previous set of data for that measure.

I only have 2 years of good data (8 quarters) which I know is a problem (not enough data!)

I would like to know that when xxx=12 it is "ok" and when xxx=345 is it not (or whatever) based on the previous set of data for that measure.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-16-2009 09:34 PM

Sorry, but I don't think there is a good statistical answer for this. You can get a distribution of quarter to quarter change, but there N will = 7, and that's not much to go on; esp. if there are seasonal patterns.

Instead, I think you have to substantively define what would be an unreasonable change.

Instead, I think you have to substantively define what would be an unreasonable change.