Week 2 - Assignment: Apply the T-Test Reflect in e Portfolio Submit Feedback

1 Running Head: T-TEST

Apply the T-test

Nikki Owens

BUS-7106: Statistics II

Northcentral University

Dr. Fred Rispoli

May 9, 2021

This study source was downloaded by 100000758634110 from CourseHero.com on 01-02-2022 21:41:28 GMT -06:00

https://www.coursehero.com/file/93587413/OwensNBUS7106-2docx/

2 T-TEST

Apply the T-test

Introduction

“T-test is a statistical test that is used to compare the means of two groups. It is often used

in hypothesis testing to determine whether a process or treatment actually influences the

population or interest, or whether two groups are different from one another” (Bevans, 2020).

This paper will analyze a t-test for a CEO of a firm with 500 employees. The CEO is

performing a study to determine how committed the employees are to the firm. A t-test is

performed to test the null hypothesis which is there is no statistically significant difference

between the two groups of workers in the dataset. The t-test was chosen to analyze the results of

the hypothesis because the two variables have an unknown variance which can be known by the

t-test. The analysis information that was found during the test is discussed below.

T-test Excel

T-Test

t-Test: Two-Sample Assuming Equal Variances

Job Status Commitme

nt

Mean 0.5 3.71666667

Variance 0.2542372

9 0.66624294

Observations 60 60

Pooled Variance 0.4602401

1 Hypothesized Mean Difference 0

df 118

t Stat -25.97015

P(T<=t) one-tail 6.312E-51

t Critical one-tail 1.6578695

2

P(T<=t) two-tail 1.2624E-

50

This study source was downloaded by 100000758634110 from CourseHero.com on 01-02-2022 21:41:28 GMT -06:00

https://www.coursehero.com/file/93587413/OwensNBUS7106-2docx/

3 T-TEST

t Critical two-tail 1.9802722

5

Based on the results in the analysis above the most important number that is really

needed is the P-value. The p-value is what determines if the null hypothesis is accepted or

rejected. The p-value was found to be 1.2624E-50 and the significant alpha value used was 0.05.

Since the P-value of 1.2624E-50 is less than 0.05, the variables of job status and commitment do

have a statistically significant difference and therefore the null hypothesis would be rejected

since the CEO wanted to test the variables for no significant difference amoung them.

T-test SPSS

This study source was downloaded by 100000758634110 from CourseHero.com on 01-02-2022 21:41:28 GMT -06:00

https://www.coursehero.com/file/93587413/OwensNBUS7106-2docx/

4 T-TEST

Based on the results in the analysis above, the P-value was found to be 0.696 and the

significant alpha value used was 0.05. Since the P-value of 0.696 is greater than 0.05, the

variables of job status and commitment do not have a statistically significant difference and

therefore the null hypothesis would be accepted since the results was true based on what the

CEO was testing in the study.

Results

When it comes to calculating the t-value, I would simply use the formula t=mean-

theoretical mean value divided by standard deviation divided by the square root of the variable

dataset size (n). This is how I would calculate the t-value manually, however, I used Microsoft

This study source was downloaded by 100000758634110 from CourseHero.com on 01-02-2022 21:41:28 GMT -06:00

https://www.coursehero.com/file/93587413/OwensNBUS7106-2docx/

5 T-TEST

excel and SPSS software to calculate the t-value for the study which was a lot faster and less

time consuming. When I tested the null hypothesis t-test in Microsoft excel it was determined

that the variables had a difference, so the null hypothesis was rejected. When I tested the null

hypothesis t-test in SPSS software it was determined that the variables were the same and did not

have a difference, so the null hypothesis was accepted. Both software’s had different results but

used the same information that was collected from a survey, but the SPSS was more accurate for

the study and was able to help the CEO determine how committed the employees were based on

their job status.

Conclusion

In conclusion, based on the SPSS software, if I was the CEO, I would accept the null

hypothesis and come up with a plan to keep my employees committed to the firm by determining

where they are most experienced and place them in that position because the two variables used

from the survey had no significant differences between each other due to they had similar mean

values and the p-value was greater than the significant value of 0.05.

References

Bevans, R. (2020). An introduction to t-test. Retrieved from https://www.scribbr.com/statistics/t-

test/

Microsoft Excel Software

SPSS Software

Weiers, R. M. (2011). Introduction to business statistics (7th ed.). Mason, OH: South-

Western, Cengage Learning

This study source was downloaded by 100000758634110 from CourseHero.com on 01-02-2022 21:41:28 GMT -06:00

https://www.coursehero.com/file/93587413/OwensNBUS7106-2docx/

6 T-TEST

This study source was downloaded by 100000758634110 from CourseHero.com on 01-02-2022 21:41:28 GMT -06:00

https://www.coursehero.com/file/93587413/OwensNBUS7106-2docx/ Powered by TCPDF (www.tcpdf.org)