Null and Alternative Hypothesis

[wyd69]

Hey, is there any way to get Excel to use Null and Alternative Hypothesis's in generating a test statistic value and a p-value using a level of significance and if so how? Thanks

 

[Aladin Akyurek]

On 2002-03-07 22:28, wyd69 wrote:
Hey, is there any way to get Excel to use Null and Alternative Hypothesis's in generating a test statistic value and a p-value using a level of significance and if so how? Thanks

Have a look at, e.g., T-test. By the way, such a test does not generate info on the Null Hypothesis per se. If you get a p-value lower than your preset significance level, you conclude that you were not able to reject the Null Hypothesis.