October is historically the most volatile month for stocks, but is this a persistent signal or just noise in the data?

Stocks, Significance Testing & p-Hacking. Follow me on Twitter (twitter.com/pdquant) for more. Over the past 32 years, October has been the most volatile month on average for the S&P500 and December the least, in this article we will use simulation to assess the statistical significance of this observation and to what extent this observation could occur by chance. All code included! Originally posted here.

- Demonstrate how to use Pandas to analyze Time Series
- Understand how to construct a hypothesis test
- Use simulation to perform hypothesis testing
- Show the importance of accounting for multiple comparison bias

We will be using Daily S&P500 data for this analysis, in particular we will use the raw daily closing prices from 1986 to 2018 (which is surprisingly hard to find so I’ve made it publicly available).

The inspiration for this post came from Winton, which we will be reproducing here, albeit with 32 years of data vs their 87 years.

For those on Kaggle I’ve created an interactive Kernel — give it an upvote!

To answer the question of whether the extreme volatility seen in certain months really is significant, we need to transform our 32yrs of price data into a format that shows the phenomena we are investigating.

Our format of choice will be **average monthly volatility rankings (AMVR).**

The following code shows how we get our raw price data into this format:

#standard importsimport numpy as np

import pandas as pd

import matplotlib.pyplot as plt

import matplotlib.patches as mpatches

%matplotlib inline

import seaborn as sns

A nice trick to make charts display full width in Jupyter notebooks:

#resize charts to fit screen

plt.rcParams[‘figure.figsize’]=[15,5]

import our data and convert into daily returns using pct_change

#Daily S&P500 data from 1986==>2018

url = "https://raw.githubusercontent.com/Patrick-David/AMVR/master/spx.csv"

df = pd.read_csv(url,index_col='date', parse_dates=True)

#To model returns we will use daily % change

daily_ret = df['close'].pct_change()

#drop the 1st value which is a NaN

daily_ret.dropna(inplace=True)

#daily %change

daily_ret.head()

Now we use one of the more powerful tools in Pandas: Resample. This allows us to change the frequency of our data from daily to monthly and to use standard deviation as a measure of volatility. These are the design choices we have when constructing an analysis.

#use pandas to resample returns per month and take standard deviation as measure of Volatility#then annualize by multiplying by sqrt of number of periods (12)

mnthly_annu = daily_ret.resample(‘M’).std()* np.sqrt(12)

print(mnthly_annu.head())

#we can see major market events show up in the volatility

plt.plot(mnthly_annu)

plt.axvspan(‘1987’,’1989',color=’r’,alpha=.5)

plt.axvspan(‘2008’,’2010',color=’r’,alpha=.5)

plt.title(‘

Monthly Annualized vol — Black Monday and 2008 Financial Crisis highlighted’)

labs = mpatches.Patch(color=’red’,alpha=.5, label=”Black Monday & ’08 Crash”)

plt.legend(handles=[labs])

A quick look at the annualized monthly vol, shows major market events clearly, such as Black Monday and the 2008 Financial Crisis:

Here’s where we can use the power of pandas to group our volatility by year and create a ranking for each of the 12 months over all 32 years of data

#for each year, rank each month based on volatility lowest=1 Highest=12

ranked = mnthly_annu.groupby(mnthly_annu.index.year).rank()

#average the ranks over all years for each month

final = ranked.groupby(ranked.index.month).mean()

final.describe()

this gives our final **Average Monthly Volatility Rankings.** Numerically we can see that month 10 (October) is the highest and 12 (December) is the lowest.

#the final average results over 32 years

final

By plotting our AMVR we can clearly see the most volatile month has been October and the lowest, December.

#plot results for S&P AMVR: clearly October has the highest ave vol rank and December has the lowest. Mean of 6.45 is plotted

b_plot = plt.bar(x=final.index,height=final)

b_plot[9].set_color(‘g’)

b_plot[11].set_color(‘r’)

for i,v in enumerate(round(final,2)):

plt.text(i+.8,1,str(v), color=’black’, fontweight=’bold’)

plt.axhline(final.mean(),ls=’ — ‘,color=’k’,label=round(final.mean(),2))

plt.title(‘Average Monthly Volatility Ranking S&P500 since 1986’)

plt.legend()

plt.show()

So that’s our data, now onto Hypothesis testing…

Hypothesis testing is one of the most fundamental techniques of data science, yet it is one on the most intimidating and misunderstood. The basis for this fear, is the way it is taught in Stats 101, where we are told to:

*perform a t-test, is it a one-sided or two-sided test?, choose a suitable test-statistic such as Welch’s t-test, calculate degrees of freedom, calculate the t score, look up the critical value in a table, compare critical value to t statistic ……*

Understandably, this is leads to confusion over what test to conduct and how to conduct it. However, all of these classical statistical techniques for performing a hypothesis test, were developed at a time when we had very little computing power and were simply closed-form analytical solutions for calculating a p-value,that's it! But with the added complication of needing to pick the right formula for the given situation, due to their restrictive and sometimes opaque assumptions.

But rejoice!

There is a better way. Simulation.

To understand how simulation can help us, lets remind ourselves what a hypothesis test is:

We wish to test **“whether the observed effect in our data is real or whether it could happen simply by chance”.**

and to perform this test we do the following:

- Choose an appropriate ‘test statistic’: this is simply a number that measures the observed effect. In our case we will choose the
**absolute deviation in AMVR from the mean.** - Construct a Null Hypothesis: this is simply a version of the data where the observed effect in not present. In our case we will shuffle the labels of the data repeatedly (
**permutation**). The justification for this is detailed below. - Compute a p-value: this is the probability of seeing the observed effect amongst the null data, in other words, by chance.
**We do this through repeated simulation**of the null data. In our case, we shuffle the ‘date’ labels of the data many times and simply count the occurrence of our test statistic as it appears through multiple simulations.

That’s hypothesis testing in 3 steps! No matter what phenomena we are testing, the question is always the same: “**is the observed effect real, or is it due to chance”**

**There is only one test! This great blog by Allen Downey has more de...**

**The real power of simulation is that we have to make explicit what our model assumptions are through code**. Whereas classical techniques can be a ‘black-box’ when it comes to there assumptions.

Example: The left plot shows the true data and the observed effect with a certain probability (green). The right plot is our simulated null data with a recording of when the observed effect was seen by chance (red). This is the basis of hypothesis testing, what is the probability of seeing the observed effect in our null data.

The most important part of hypothesis testing is being clear what question we are trying to answer. In our case we are asking:

**“Could the most extreme value happen by chance?”**

The most extreme value we define as the **greatest absolute AMVR deviation from the mean**. This question forms our null hypothesis.

In our data the most extreme value is the December value (1.23) not the October value (1.08), because we are looking at the biggest absolute deviation from the mean not simply the highest volatility:

#take absolute AMVR from the mean, we see Dec and Oct are the biggest absolute moves (Oct to the upside, Dec to the downside), with Dec being the greatest.

fin = abs(final — final.mean())

print(fin.sort_values())

Oct_value = fin[10]

Dec_value = fin[12]

print(‘Extreme Dec value:’, Dec_value)

print(‘Extreme Oct value:’, Oct_value)

Now we know what question we are asking, we need to construct our ‘Null Model’.

There are a number of options here:

**Parametric models**. If we had a good idea of the data distribution or simply made assumption on it, we could use ‘classical’ hypothesis testing techniques,*t-test, X², one-way ANOVA etc.*These models can be restrictive and something of a blackbox if their assumptions aren’t fully understood by the researcher.**Direct Simulation.**We could make assumptions about the data generating process and simulate directly. For example we could specify an ARMA time series model for the financial data we are modeling and deliberately engineer it to have no seasonality. This could be a reasonable choice for our problem, however if we knew the data generating process for the S&P500 we would be rich already!**Simulation through Resampling.**This is the approach we will take. By repeatedly sampling at random from the existing dataset and shuffling the labels, we can make the observed effect equally likely amongst all labels in our data (*in our case the labels are the dates*), thus giving the desired null dataset.

Sampling is a big topic but we will focus on one particular technique**, permutation** or shuffling**.**

To get the desired null model, we need to construct a dataset that has **no seasonality** present. If the null is true, *that there is no seasonality in the data and the observed effect was simply by chance*, then the labels for each month (Jan,Feb etc) are meaningless and therefore we can shuffle the data repeatedly to build up what classical statistics would call the ‘*sampling distribution of the test statistic under the null hypothesis*’. This has the desired effect of making the observed phenomena (*the extreme December value*) **equally likely** for all months, which is exactly what our null model requires.

To prove how powerful simulation techniques are with modern computing power, the code in this example will actually permute the *daily* price data, which requires lots more processing power, yet still completes in seconds on a modern CPU. Note: *shuffling either the daily or the monthly labels will give us the desired null dataset in our case.*

*Shuffle ‘date’ labels to create null dataset*

A great resource for learning about sampling is by Julian Simon.

Note: *The way our test is constructed is the equivalent of a two sided test using ‘classical’ methods, such as Welch’s t-test or ANOVA etc, because we are interested in the most extreme value, either above or below the mean.*

These decisions are design choices and we have this freedom because **the Null Model is just that, it’s a Model!** This means we can specify its parameters as we choose, the key is to really be clear what question we are trying to answer.

Below is the code to simulate 1000 sets of 12 AMVR, permuting the date labels each time to build up the sampling distribution. The output from this code is included below in the p-hacking section…

#as our Null is that no seasonality exists or alternatively that the month / day does not matter in terms of AMVR, we can shuffle 'date' labels.

#for simplicity, we will shuffle the 'daily' return data, which has the same effect as shuffling 'month' labels

#generate null data

new_df_sim = pd.DataFrame()

highest_only = []

count=0

n=1000

for i in range(n):

#sample same size as dataset, drop timestamp

daily_ret_shuffle = daily_ret.sample(8191).reset_index(drop=True)

#add new timestamp to shuffled data

daily_ret_shuffle.index = (pd.bdate_range(start='1986-1-3',periods=8191))

#then follow same data wrangling as before...

mnthly_annu = daily_ret_shuffle.resample('M').std()* np.sqrt(12)

ranked = mnthly_annu.groupby(mnthly_annu.index.year).rank()

sim_final = ranked.groupby(ranked.index.month).mean()

#add each of 1000 sims into df

new_df_sim = pd.concat([new_df_sim,sim_final],axis=1)

#also record just highest AMVR for each year (we will use this later for p-hacking explanation)

maxi_month = max(sim_final)

highest_only.append(maxi_month)

#calculate absolute deviation in AMVR from the mean

all_months = new_df_sim.values.flatten()

mu_all_months = all_months.mean()

abs_all_months = abs(all_months-mu_all_months)

#calculate absolute deviation in highest only AMVR from the mean

mu_highest = np.mean(highest_only)

abs_highest = [abs(x - mu_all_months) for x in highest_only]

Here’s the interesting bit. We’ve constructed a hypothesis to test, we’ve generated simulated data by shuffling the ‘date’ labels of the data , now we need to perform our hypothesis test to find the probability of observing a result as significant as the December result given that the null hypothesis (*no seasonality*) is true.

Before we perform the test lets set our expectations.

**Whats the probability of seeing at least one significant result given a 5% significance level?**

= 1-p(not significant)

= 1-(1–0.05)¹²

= 0.46

so there’s a **46%** chance of seeing **at least one** month with a significant result, given our null is true.

Now lets ask, **for each individual test** (*comparing each of the 12 months absolute AMVR to the mean*) **how many significant values should we expect to see amongst our random, non-seasonal data?**

12 x 0.05 = 0.6

So with a 0.05 significance level we should expect a false positive rate of **0.6**. In other words, for each test (with the null data) comparing all 12 months AMVR to the mean, 0.6 months will have show a significant result.(*obviously we cant have less than 1 month showing a result, but under repeat testing the math should tend towards this number*).

All the way through this work, we have stressed the importance of being really clear with the question we are trying to answer. The problem with the expectations we’ve just calculated is **we have assumed we are testing for a significant result against all 12 months!** That’s why the probability of seeing at least one false positive is so high at 46%.

This is an example of **multiple comparison bias****.** Where we have expanded our search space and increased the likelihood of finding a significant result. This a problem because we could abuse this phenomena to cherry pick the parameters of our model which give us the ‘desired’ p-value.

This is the essence of p-hacking.

This xkcd nicely highlights the issue with multiple comparison bias and it’s subsequent abuse, p-hacking.

Whoa! Green Jelly beans are significant

To illustrate the effect of p-hacking and how to reduce multiplicity, we need to understand the subtle but significant difference between the following 2 question:

- “Whats the probability that
**December**would appear this extreme by chance.” - “Whats the probability
**any month**would appear this extreme by chance.”

The beauty of simulation lies in its simplicity. The following code is all we need to compute the p-value to answer the 1st question. We simply count how many values in our dataset using all 12000 AMVR deviations (12 months x 1000 trials) are greater than the observed December value. We get a **p-value of 4.4%,** close to our somewhat arbitrary 5% cut off, but **significant** none the less.

#count number of months in sim data where abs AMVR is > Dec

#Here we are comparing against ALL months

count=0

for i in abs_all_months:

if i> Dec_value:

count+=1

ans = count/len(abs_all_months)

print('p-value:', ans )

p-value: 0.044

To answer the 2nd question and to avoid multiplicity, instead of comparing our result to the distribution made with all 12000 AMVR deviations, we only consider the **highest** value from each of the absolute AMVR 1000 trials. This gives a **p-value of 23%**, very much **not significant!**

#same again but just considering highest abs AMVR for each of 1000 trials

count=0

for i in abs_highest:

if i> Dec_value:

count+=1

ans = count/len(abs_highest)

print('p-value:', ans )

p-value: 0.234

Now lets plot these distributions.

#calculate 5% significance

abs_all_months_95 = np.quantile(abs_all_months,.95)

abs_highest_95 = np.quantile(abs_highest,.95)

#plot the answer to Q1 in left column and Q2 in right column

fig, ((ax1,ax2),(ax3,ax4)) = plt.subplots(2,2,sharex='col',figsize=(12,12))

#plot 1

ax1.hist(abs_all_months,histtype='bar')

ax1.set_title('AMVR all months')

ax1.set_ylabel('Frequency')

n,bins,patches = ax3.hist(abs_all_months,density=1,histtype='bar',cumulative=True,bins=30)

ax3.set_ylabel('Cumulative probability')

ax1.axvline(Dec_value,color='b',label='Dec Result')

ax3.axvline(Dec_value,color='b')

ax3.axvline(abs_all_months_95,color='r',ls='--',label='5% Sig level')

#plot2

ax2.hist(abs_highest,histtype='bar')

ax2.set_title('AMVR highest only')

ax2.axvline(Dec_value,color='b')

n,bins,patches = ax4.hist(abs_highest,density=1,histtype='bar',cumulative=True,bins=30)

ax4.axvline(Dec_value,color='b')

ax4.axvline(abs_highest_95,color='r',ls='--')

ax1.legend()

ax3.legend()

The left column is the data that answers question 1 and the right column, question 2. The top row are the probability distributions and the bottom row are the CDF. The red dashed line is the 5% significance level that we arbit

rarily decided upon. The blue line is the original extreme December AMVR value of 1.23.

probability distributions for Q1 and Q2

#### Conclusions

The left side plot shows that the original December value is significant at a 5% level, but only just! However, when we account for multiple comparison bias, in the right hand plot the threshold for significance moves up from around 1.2 (abs AMVR) up to around 1.6 (see the redline).

By accounting for multiple comparison bias our December value of 1.23 is no longer significant!

By taking into consideration the specific question we are trying to answer and avoiding multiple comparison bias, we have avoided p-hacking our model and avoided showing a significant result when there isn’t one.

To further explore p-hacking and how it can be abused to tell a particular story about our data, see this great interactive app from FiveThirtyEight…

https://fivethirtyeight.com/features/science-isnt-broken/#part2

We have learnt that hypothesis testing is not the big scary beast we thought it was. Simply follow the 3 steps above to construct your model for any kind of data or test statistic.

We’ve show that asking the right question is vital for scientific analysis. A slight change in the wording can lead to a very different model with very different results.

We discussed the importance of recognizing and correcting for multiple comparison bias and avoiding the pitfalls of p-hacking and showed how a seemingly significant result can become non-significant.

With more and more ‘big data’ along with academic pressure to produce a research paper with ‘novel’ findings or political pressure to show a result as being ‘significant’, the temptation for p-hacking is ever increasing. By learning to recongise when we are guilty of it and correcting for it accordingly we can become better researchers and ultimately produce more accurate and therefore actionable scientific results!

Authors Notes: *Our results differ slightly from the original* *Winton research,* *this due in part to having a slightly different data set (32yrs vs 87yrs) and they have October being the month of interest whereas we have December. Also they used an undisclosed method for their ‘simulated data’ whereas we have made explicit, through code our methodology for creating that data. We have made certain modeling assumptions through out this work, again, these have been made explicit and can be seen in the code. These design and modeling choices are part of the scientific process, so long as they are made explicit, the analysis has merit.*

Hope you found this useful and interesting, follow to be notified with my latest posts!

Follow twitter.com/pdquant for more!

© 2020 Data Science Central ® Powered by

Badges | Report an Issue | Privacy Policy | Terms of Service

**Upcoming DSC Webinar**

- DataOps: How Bell Canada Powers their Business with Data - July 15

Demand for data outstrips the capacity of IT organizations and data engineering teams to deliver. The enabling technologies exist today and data management practices are moving quickly toward a future of DataOps. DataOps is an automated, process-oriented methodology, used by analytic and data teams, to improve the quality and reduce the cycle time of data analytics. Register today.

**Most Popular Content on DSC**

To not miss this type of content in the future, subscribe to our newsletter.

- Book: Statistics -- New Foundations, Toolbox, and Machine Learning Recipes
- Book: Classification and Regression In a Weekend - With Python
- Book: Applied Stochastic Processes
- Long-range Correlations in Time Series: Modeling, Testing, Case Study
- How to Automatically Determine the Number of Clusters in your Data
- New Machine Learning Cheat Sheet | Old one
- Confidence Intervals Without Pain - With Resampling
- Advanced Machine Learning with Basic Excel
- New Perspectives on Statistical Distributions and Deep Learning
- Fascinating New Results in the Theory of Randomness
- Fast Combinatorial Feature Selection

**Other popular resources**

- Comprehensive Repository of Data Science and ML Resources
- Statistical Concepts Explained in Simple English
- Machine Learning Concepts Explained in One Picture
- 100 Data Science Interview Questions and Answers
- Cheat Sheets | Curated Articles | Search | Jobs | Courses
- Post a Blog | Forum Questions | Books | Salaries | News

**Archives:** 2008-2014 |
2015-2016 |
2017-2019 |
Book 1 |
Book 2 |
More

**Upcoming DSC Webinar**

- DataOps: How Bell Canada Powers their Business with Data - July 15

Demand for data outstrips the capacity of IT organizations and data engineering teams to deliver. The enabling technologies exist today and data management practices are moving quickly toward a future of DataOps. DataOps is an automated, process-oriented methodology, used by analytic and data teams, to improve the quality and reduce the cycle time of data analytics. Register today.

**Most popular articles**

- Free Book and Resources for DSC Members
- New Perspectives on Statistical Distributions and Deep Learning
- Time series, Growth Modeling and Data Science Wizardy
- Statistical Concepts Explained in Simple English
- Machine Learning Concepts Explained in One Picture
- Comprehensive Repository of Data Science and ML Resources
- Advanced Machine Learning with Basic Excel
- Difference between ML, Data Science, AI, Deep Learning, and Statistics
- Selected Business Analytics, Data Science and ML articles
- How to Automatically Determine the Number of Clusters in your Data
- Fascinating New Results in the Theory of Randomness
- Hire a Data Scientist | Search DSC | Find a Job
- Post a Blog | Forum Questions

## You need to be a member of Data Science Central to add comments!

Join Data Science Central