Creating a T-Table Using Excel
Usually,
when comparing t-test values with t-counts, we always see the attachment of
the t-test table in the Reference Book. but actually, we can make it on
Microsoft Excel by using the Excel Formula "= TINV (Significance Value;
Degree of Freedom)" or "= TINV (Significance Value, Degree of
Freedom)" depending on the Excel settings used.
Creating a T-Table Using Excel
The procedure for making this Statistical T Test Table is
First, prepare a table layout like the following,
Second, Enter the formula in cell B5 = ---> = TINV (B $ 4; $ A5)
$ captions are used to mark numbers or fixed letters and cannot be changed if
copy the formula by sliding it.
Third, copy the formula in cell B5 to all cells that you want to get the value of t table
Fourth, the table that will be obtained as below,
SUBSCRIBE TO OUR NEWSLETTER
0 Response to "Creating a T-Table Using Excel"
Post a Comment