Spectral Density Plot
 Open Chemical Process Concentration – Series A.xlsx (Sheet 1 tab). This is the Series A data from Box and Jenkins, a set of 197 concentration values from a chemical process taken at twohour intervals.
 Click SigmaXL > Time Series Forecasting > Spectral Density Plot. Ensure that the entire data table is selected. If not, Use Entire Data Table. Click Next.

Click Concentration, click Numeric Time Series Data (Y) >>.
 Click OK. A Spectral Density Plot for Concentration is produced.
The detected seasonal frequency is 1, which means that it is a nonseasonal process. The peak at 28 does not have enough seasonal “strength” to be considered for use as seasonal frequency in a time series model.  Open Monthly Airline Passengers  Series G.xlsx (Sheet 1 tab). This is the Series G data from Box and Jenkins, monthly total international airline passengers for January 1949 to December 1960.
 Click SigmaXL > Time Series Forecasting > Spectral Density Plot. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
 Select Ln(Airline Passengers),
click Numeric Time Series Data (Y) >>.

Click OK. A Spectral Density Plot for
Ln(Airline Passengers) is produced.
As expected, the detected seasonal frequency for the monthly data is 12. The peak at 6 does not have enough seasonal “strength” to be considered as a second seasonal frequency.
Daily Electricity Demand with Predictors – ElecDaily
 Open Daily Electricity Demand with Predictors – ElecDaily.xlsx (Sheet 1 tab). This is daily electricity demand (GW) for the state of Victoria, Australia, every day during 2014 (Hyndman, fpp2). This data has a seasonal frequency = 7 (observations per week).
 Click SigmaXL > Time Series Forecasting > Spectral Density Plot. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
 Select Demand, click
Numeric Time Series Data (Y) >>.

Click OK. A Spectral Density Plot for Demand is
produced.
As expected, the detected seasonal frequency for the daily data is 7.
Sales with Indicator  Modified Series M
 Open Sales with Indicator  Modified Series M.xlsx. (Sheet 1 tab). This is modified Series M data from Box and Jenkins, with 50 quarters of corporate sales values along with a leading indicator. The data is treated as nonseasonal, as done in Box and Jenkins.
 Click SigmaXL > Time Series Forecasting > Spectral Density Plot. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
 Select Sales, click
Numeric Time Series Data (Y) >>.

Click OK. A Spectral Density Plot for Sales is
produced.
The detected seasonal frequency is 1, which means that it is confirmed to be a nonseasonal process. The peak at 10 does not have enough seasonal “strength” to be considered for use as seasonal frequency in a time series model.
HalfHourly Multiple Seasonal Electricity Demand – Taylor
 Open HalfHourly Multiple Seasonal Electricity Demand  Taylor.xlsx (Sheet 1 tab). This is halfhourly electricity demand (MW) in England and Wales from Monday, June 5, 2000 to Sunday, August 27, 2000 (taylor, R forecast). This data has multiple seasonality with frequency = 48 (observations per day) and 336 (observations per week), with a total of 4032 observations.
 Click SigmaXL > Time Series Forecasting > Spectral Density Plot. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
 Select Demand, click
Numeric Time Series Data (Y) >>.

Click OK. A Spectral Density Plot for Demand is
produced.
The detected multiple seasonal frequency is confirmed as 48, 336.
The Spectral Density Plot is used to identify the dominant integer seasonal frequency in time series data using spectral analysis with fast Fourier transforms. The algorithm used here is the same as used in the forecast model option to automatically detect seasonal frequency. If there is multiple seasonality, up to three integer frequencies will be identified. If the peak frequency is not an integer, it is rounded.
The Y axis is Spectral Density, the X axis is Seasonal Frequency. The Spectral Density Plot is also known as a Periodogram. Note that SigmaXL’s use of the term “seasonal frequency” is the inverse of what is typically used in Fourier transforms “seasonal period”, as discussed in the Introduction.
Chemical Process Concentration  Series A
Monthly Airline Passengers  Series G
Web Demos
Our CTO and CoFounder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!
Contact Us
Phone: 1.888.SigmaXL (744.6295)
Support: Support@SigmaXL.com
Sales: Sales@SigmaXL.com
Information: Information@SigmaXL.com