I think one way to do it is to write TTEST("vales from the first city";"values from the second city";?;?), but I do not know what should be instead of the "? marks".

- Thread starter Lisa A
- Start date
- Tags p-value significance ttest ttest in excel

I think one way to do it is to write TTEST("vales from the first city";"values from the second city";?;?), but I do not know what should be instead of the "? marks".

samples -- if you have measured 31 and 28 = 59 different people.

Regarding one-sided versus two-sided, choose two-sided. It tests whether

there is any statistically significant difference of means between the two

groups (cities), regardless of its direction. Again, regarding Excel that is what

I remember, maybe I've forgotten one or two important points.

Regards

K.

I think one way to do it is to write TTEST("vales from the first city";"values from the second city";?;?), but I do not know what should be instead of the "? marks".

For the fourth parameter, you should put either a 2 or a 3. Put 2 if cities A and B have equal variance, but put 3 if they have unequal variance.

After verifying that my data were normally distributed, I performed an ANOVA and t-tests, as well as the Levene test and f-tests. The Levene test (Table 7) was performed to test for equivalence of variation (population standard deviations) among the three temperature groups of data (different sample sizes) that I compared. The ANOVA were performed to test for shifts in location (population means) among the three temperature groups. These tests were used to compare the three groups simultaneously.

The F-test was then performed across the 3 temperature groups to obtain more specific information about the Levene Test results. The t-tests further support what's evident from the graphical analyses (that I performed, which you'll need to do first) and the ANOVA. The f- and t-tests were used for group-to-group comparisons (comparing 2 groups at a time as opposed to all 3 at the same time) ...indicating a more individualized result. Does this make sense?