Chat with us, powered by LiveChat Prepare a Two Sample t-test in Excel - Tutorie

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

Are you struggling with this assignment?

Our team of qualified writers will write an original paper for you. Good grades guaranteed! Complete paper delivered straight to your email.

Place Order Now