Prepare a Two Sample t-test in Excel

  

Module 4: Assignment 1

Instructions:

Prepare a Two Sample t-test in Excel using the following information:

Suppose we want to know whether or not the mean weight between two different species of turtles is equal. To test this, perform a two sample t-test at significance level α = 0.05.

Sample 1:

· Sample size n1 = 40

· Sample mean weight x1 = 300

· Sample standard deviation s1 = 18.5

Sample 2:

· Sample size n2 = 38

· Sample mean weight x2 = 305

· Sample standard deviation s2 = 16.7

(Refer back to The Independent Samples T-Test link in this week’s lecture material).

Submission Instructions:

· Submit your assignment by 11:59 pm ET on Sunday.

· Contribute a minimum of 2 pages. It should include at least 3 academic sources, formatted and cited in APA.

Official Assignment Rubric

Leave a Comment