Do you have questions not answered here? Please send suggestions for other questions to "faq" at catherinechhood.net.
Please also see the Seasonal Adjustment Glossary.
If you are not using the Windows interface to X-12, you should download this program. X-12-ARIMA is a DOS program, and it will not run if you simply double-click on an X-12 input file.
If you are using the Windows interface to X-12, you may want to download the newest version of the program from December 2009.
If you are running the older version of the interface, the first step is to check the directory structure of your computer compared to the .ini file that comes with the program.
If you are running the December 2009 version of the interface and it doesn't load, it could be a sign that you've changed the directory where the program is. If you want to move the program, you should probably reinstall the program .
There is help available on X-12-ARIMA and the interface from the US Census Bureau by writing to the address x12a at census.gov.
The minimum length to seasonally adjust a time series in X-12-ARIMA is four years. However, there is something we can do for short series.
Seasonal adjustment can be difficult under the following conditions:
Fortunately, if we have a short series that is fairly well-approximated by a straight line, and if we don’t need to estimate trading day, moving holidays, or outliers, then we can do a simple seasonal adjustment in Excel. The good news is that for short series, we probably can estimate the trend fairly well with a straight line. With only a few data points for a particular month or quarter, we don’t have enough data to estimate trading day or moving holiday effects anyway, so we won’t try to estimate them.
I've outlined the steps to compute a seasonal adjustment, with examples, in the paper (in PDF) "Seasonal Adjustment for Short Time Series in Excel."
X-12-ARIMA does run Windows Vista, Windows 7, and earlier versions of Windows. Your can run X-12 using the Windows interface, or run X-12 from the command prompt. You can download Win X-12 (the Windows interface to X-12) for free from the Census Bureau site at
http://www.census.gov/srd/www/x12a/winx12home.html.I have been using the interfaces in Windows Vista for years without any problems.
Below are some tips for editing spec files. Thanks to Kathleen M. McDonald-Johnson for writing the tips for older versions of Windows.
Some people have had trouble with spec files (extension .spc) because the file extension is already associated with Microsoft files of type PKCS #7 Certificates.
One solution is to open the text editor (NotePad, PFE, etc.) first and then open the spec file from the editor. However, many of us find it more convenient to be able to double click on the file name in Windows Explorer.
In versions of Windows BEFORE Vista,
the following steps are a guide to setting up the file type:
You can add several Actions if you think you will use different programs in different settings - you might like one program better for editing, but another program for times when you just want to view the file quickly. To access the different actions, right click on the file instead of double clicking. Make your favorite program the default so it will open when you double-click on the spec file.
In Windows Vista,
the following steps are a guide to setting up the file type:
You can use these steps for all the different kinds of X-12 input, output, and save files. If the file type doesn't have another program associated with it yet, you can click on New Type instead of Edit.
Page design by David Joyce at Exit 42 Design
FAQ written by Catherine C.H. Hood
with help from Lynn Imel, Kathy McDonald-Johnson, David Findley, Brian Monsell, and James Ashley
Copyright 2006-2010
Last modified: 26 April 2010