Content

Plot for S&P 500 monthly log return

Plot for S&P 500 ETF monthly log returns
Correlogram plot for S&P500 monthly prices

The autocorrelation (ACF) and PACF plot for the S&P 500 log monthly prices
Correlogram output table for &P 500 log monthly prices

The autocorrelation (ACF) and PACF table for the S&P 500 log monthly prices
NumXL Correlogram Wizard

NumXL Correlogram Wizard or dialog box
Correlogram icon in NumXL Tab

NumXL toolbar with correlogram icon selected
SPDR log-prices

a plot for daily log prices of S&P 500 ETF between Jan 2009, and July 2012
sp500-price-adftest-tbl.png

Augmented Dickey-Fuller (ADF) test for stationarity. The table is generated using the NumXL ADF Wizard fo r different stationary s…
descstat-summary-tbl.png

Output table generated by descriptive statistics wizard using the daily log-price for Microsoft stock between Jan, 2000 and Jan 20…
descstat-statistics-dlg.png

Descriptive Statistics Dialog or Wizard. Select the cells range for your input data, and select the different stats available (on…
Selecting descriptive statistics icon in the NumXL 2007/2010 toolbar

Invoking the summary statistics wizard in NumXL 1.63 Toolbar
msft-log-price-qqplot.png

A QQ Plot for the distribution of Microsoft stock log prices.
msft-log-price-histogram.png

Histogram plot for log log daily prices for Microsoft stock.
msft-prices-qqplot.png

A QQ Plot for Microsft price distribution between Jan 2000 and Jan 2009
msft-prices-histogram.png

Histogram for daily microsoft prices between Jan 2000 and Jan 2009
msft-prices-q1-q3-band.png

Microsoft stock price plot with a shaded band represent values between 1st quartile (Q1) and third quartile (Q3)
msft-price-wma-plot.png

Microsoft stock price plot with 20-day equally-weighted moving average
Descending-table-0.png
Ascending-table.png

Data table showing a descending chronicle order
msft-price-plot.png

Microsoft stock price plot. Microsoft stock prices between Jan 2000 and Jan 2009
logo-500x500-24-bits-and-72-dpi.png
spider-logo-200x200.png