The aim of conducting this paired t-test is to assess whether the productivity of employees is impacted positively or negatively by the introduction of the new policy. Interprets and analyzes the findings of the excel t-test to determine whether the results are statistically significant Statistically Significant Statistical significance is the probability of an observation not being caused by a sampling error.Conducts a paired t-test in excel (refer to the heading “types of t-tests” of this article) to determine whether there is any difference in the productivity of the CSAs before and after the introduction of the policy.Collects the data of complaints addressed and resolved (before and after the policy) by a sample of CSAs.According to this policy, if the number of customer complaints resolved in a day crosses 50, two additional leaves (in a month) will be granted to an employee.įurther, the organization performs the following tasks: Such results are reliable and provide confidence in decision-making.įor example, an organization launches a new policy for the employees (customer service associates or CSA) of its marketing department. An outcome (result) is said to be statistically significant if the reason behind its occurrence can be attributed to a specific cause rather than to coincidence (or chance).
By performing a t-test, one can say whether the difference between the two means is statistically significant or by chance alone. A T-test in excel helps compare the means (average) of two samples and make inferences for the entire populations.