BookmarkSubscribeRSS Feed
carbs
Calcite | Level 5

I have t-values for mean returns and actual values of mean returns fo r20 countries, and have calculated averages of the country returns. Is it possible based on the  t-values I have to calculate t-values also for the average returns, or do I have to code it earlier?

6 REPLIES 6
Ksharp
Super User

I don't understand what t-value you mean .

Do you get it from proc ttest ?

carbs
Calcite | Level 5

Just the t-statistic I get from testing whether the returns are statistically different from zero. Using:

proc means mean t - approach. So I'm just wondering if I can take an average of the t-statistics as well, or is it statistically impossible?

Ksharp
Super User

I think you should firstly test your data (return) to see whether it conform NORMAL distribution, because t is based on NORMAL distribution, and also should use non-parameter method to test it again to make the result is reliable .

Ksharp

carbs
Calcite | Level 5

I've done normality testing using proc univariate normal, and the Shapiro-Wilk values are on 99% of the cases over 0.90. Most are somewhere close to 0.98. I think this is enough to know that it's close to normal, right? Am I able to get the t-statistic averages now somehow?

Ksharp
Super User

By the way, These return is time serial data ?

Normal Test required these data (i.e. observations) is independent for each other .

So I am not quite sure if it is right to do so. Maybe you need some statistician ,especially for the time serial analysis .

SteveDenham
Jade | Level 19

Ksharp is trying to get you on the right track here.  If this is time series data, getting a whole bunch of t values, say one for each time point, and then averaging them falls into the category of a very bad idea.  First, the values are not independent and have some sort of serial correlation. Second, how could you possibly calculate the correct degrees of freedom to come up with a p value or standardized effect size?  I think you need to look at the ETS suite, especially PROC PANEL, if this describes your dataset.

Try this for a start--look at PROC MIXED for a repeated measures analysis, with country and time as CLASS variables.  Your model should include the interaction between these to get separate estimates by country and time.  I don't know what the repeated nature of the time variable is like, but an AR(1) structure probably fits if your data are equally spaced in time.  It may be heterogeneous by country, so that is something else you will have to investigate.  In any case, the Type III tests are "averaged t-tests" in this context.  Specific t values can be obtained with an LSMEANS statement.

Good luck.

Steve Denham

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1559 views
  • 0 likes
  • 3 in conversation