On the writing had previously been shelled manufacture table test test r, and F the following advanced manufacturing. testing table t. Hopefully there are benefits ... ....
T test table, often used in research, particularly regression analysis. Good simple regression or multiple regression. Hypothesis testing is to test the coefficient of constants and variables.
Example: the regression coefficient will be tested from the free variable (e.g. promotion).
Deem in research have been obtained regression Equation as follows:
Y = 111.53 + 3.90 X, where
Y = Sales
X = the cost of promotion of the company's issued
Regression
equation of interpretation as follows: constant of 111, 53 States that
if there is a sales promotion costs, then generates a 111.53. While the
regression coefficient of 3.90 States that any additions (e.g. 1 the
rupiah), then the cost of the promotion will increase sales of 3.90.
The use of the t-test as the basis of decision-making by means of:
Made in advance hipotesi to the case:
Ho = regression coefficient is not significant
H1 = regression coefficient is significant, and do the calculation of t test, namely:
Compare the statistics count with statistical tables
If statistics to calculate statistical tables, then < Ho accepted
If statistics count > statistics tables, then Ho denied
The following table makes technical test for t statisti with the help of MS excel.
After the application MS excel open, do:
- Place thepointeron the cellA3, and then type1
- Move thepointeron the cellA4, and then type2.And so on,with the addition ofnumbers1 throughnumber80 (for example)
- Place thepointeron the cellB2, and then type0
- Move thepointeron the cellC2, then type0.01. so onto the rightwith number0025;0.05and0.1
Input the formula calculation, i.e. = TINV (kindergarten. significantly, the degree of freedom)
See picture below:
Lakukan copy dan di paste kan pada A4 demikian seterusnya sampai A12
Lihat gambar seperti di bawah
Lakukan copy dan di paste-kan pada C4 demikian seterusnya sampai C12
Pada sel D4, dan sel E4, lakukan proses seperti di atas.
Dan hasil akhir tabel t seperti gambar berikut
