How can I test the statistical significance of these strategies A & B

Water Cooler Investing
#1

Hello

I’m testing a strategy and the average forward return across time.

The Google sheet has the original average forward price return, and then the same for a strategy A and a different strategy B.

How can I test the statistical significance of these series of average returns across time?

Thanks!!

https://docs.google.com/spreadsheets/d/1za9cQwiAkgsc46Lwgvgr110-JCvMgKOOOvxgvvXiAf8/edit?usp=sharing

#2

Statistical significance vs what? If you’re testing them as statistically different vs one another, I believe you would just do a pooled variance t test with the null that the difference between the means is 0.

If against the market, then I think you do the same thing but vs the market. That said, you’d first want to compare the variance vs the market because if the strategies are not similarly volatile you may not be able to do pooled variance and would have to opt for the unequal variance t test between the two samples.

#3

Do you have a google sheet as an example so I can take a look at it?

#4

I actually don’t but if you google some stat course explanations or even try like a reddit statistics forum you should be able to get to the bottom of it.