How shall I confirm the significance of week days' Up-Downs for some stock?

4 views (last 30 days)
I survey on the ups and downs of one stock in the past 3000 trading days and sort them by week day: Monday (ups53%, 0.53-0.5=0.03), Tuesday(ups55%, 0.55-0.5=0.05),... like this; Then I get below picture:
Then how shall I confirm the difference between week days is significant or just random?

Accepted Answer

Brendan Hamm
Brendan Hamm on 29 Dec 2015
Typically one would perform an Analysis of Variance ( anova1) on the actual dataset, not on your summary statistics. This will test the null hypothesis of equal mean returns vs. the alternative that at least one day's mean return is different. If you want a pairwise comparisson you can then pass the stats output to the multcompare function.
[p,tbl,stats] = anova1(data);
c = multcompar(stats);
If your data (returns) are non-normal then use the kruskal-wallis test, similar concept but uses the medians.
  1 Comment
vx2008
vx2008 on 30 Dec 2015
Thank you for your advice; I have done my try, but....
Could you analyze my data to show me the analysis course?
My raw data is attached as 'rawdata.xls' here;
The data is divided into two column:
first column is weekday(1 means Monday; 2 Tuesday; 3 Wednesday; 4 Thursday; 5 Friday);
Second column is up/down's value;
I want to confirm whether some day is more like up / down?
Thank you again!

Sign in to comment.

More Answers (0)

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!