Question
Can you please explain how to calculate this on Exel? To find P-Value :- Here, alternative hypothesis is of = type, so this
Can you please explain how to calculate this on Exel?
To find P-Value :-
Here, alternative hypothesis is of "=" type, so this is two-tailed test.
Its p-value will be given by
P-Value = 2 * Pr( T < -|t| )
= 2 * Pr( T < -|0.2972| )
P-Value = 2 * Pr( T < - 0.2972 )
where T is t-distributed with df = n1 + n2 -2 = 40+75-2 = 113 degree of freedom
Now required probability Pr( T < - 0.2972 ) can be computed from from t-table or more accurately from any software like R,Excel
In R, we use function "pt(t,df)" to find Pr(T Using R Thus, we get P-Value = 2 * Pr( T < - 0.2972 ) = 0.7668 P-Value = 0.7668> 2*pt(-0.2972,df=113) # 2 * Pr( T < - 0.2972 ) [1] 0.7668595
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started