|t-statistic or t-ratio or tdata||=STANDARDIZE(, m, s/SQRT(n))|
|t-critical [ Excel TINV: If seeking a one tail probability, multiply alpha by two. I do NOT recommend students use this function at this time, refer to your tables. ]||Use table||=TINV(two tail probability,degrees of freedom)|
|P-value from a t-statistic, degrees of freedom, and number of tails (1 or 2). Note that the t-statistic must be the absolute value of the t-statistic. Excel only accepts positive t-statistics.||=TDIST(t-statistic,degrees of freedom, number of tails)|
Open book quiz! Use the formulas, tables, and figures in your book.
The population mean on a test was m = 9.02. A group of 23 students taking the same test had a sample mean of 8.96 with a standard deviation of 2.69. At an alpha of 0.05, is this sample mean different from the population mean?
Lee Ling home
COM-FSM home page