Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A comprehensive guide on performing two-group hypothesis tests using the Excel 2013 T-TEST command. It covers the purpose of the test, inputs required, and a step-by-step procedure with examples. The document also explains the difference between dependent, matched subjects, population variances unknown but equal, and population variances unknown & unequal types of T-TEST.
Typology: Exams
1 / 19
This page cannot be seen from the preview
Don't miss anything!
Two group hypothesis tests using Excel 2013 T-TEST command
Two group hypothesis tests using Excel 2013 T-TEST command
Purpose:
Calculate likelihood (p-value) of getting the observed
difference in two sample means (or more extreme) by chancein random samples – assuming there is no difference in thetwo population means (the Null Hypothesis).
Four Inputs: 1)
Array or range of two samples.
Tails: 1 (Excel matches Alternate with sample means) or 2.
Type of T-TEST. 1 dependent, matched subjects.2: population variances unknown but equal. [Often true]3: population variances unknown & unequal. [Conservative]
Two group hypothesis tests using Excel 2013 T-TEST command
Two group hypothesis tests using Excel 2013 T-TEST command
A: From Data tab, select Sort
.
Two group hypothesis tests using Excel 2013 T-TEST command
.
C: Sort Data.
Prepare column headings.
Create headings thatshow what column orquestion is being testedand what column orquestion is used to splitthe data into two groups.Q1 is used as the two-group splitter in thisexample. Any field withbinary data can be used.The vertical bar “|”means “given” soQ2|Q1=1 indicates thevalues of Q2 for whichQ1 equals 1.
Two group hypothesis tests using Excel 2013 T-TEST command
Q1=1 Q1=0.
D: Copy stacked datato separate columns
Two group hypothesis tests using Excel 2013 T-TEST command
T-TEST Command Procedure
Given Separated Data
1:
From Tool Menu, select “Data Analysis”.
2:
From Data Analysis window, select “t-test: Two-sample with unequal variances”.
3:
From associated window, enter inputs and outputs.
Obtain results of t-test.
Two group hypothesis tests using Excel 2013 T-TEST command
1) From the Data ribbon
select Data Analysis
Two group hypothesis tests using Excel 2013 T-TEST command
3) Enter Input & Output:
Q2 by Q
Two group hypothesis tests using Excel 2013 T-TEST command
4) Excel-Generated Results:
Q2 by Q
Difference in Q2 proportions by Q1 in not statistically significant
Technical: Fail to reject the null hypothesis for Q2 by Q1.
Two group hypothesis tests using Excel 2013 T-TEST command
4) Excel-Generated Results:
Q7 by Q
Difference in Q7 means by Q1 IS statistically significant (1 tail)
Technical: Reject the null hypothesis for Q7 by Q1 (1 tail)
Two group hypothesis tests using Excel 2013 T-TEST command
3) Enter Input and Output:
Q8 by Q
Two group hypothesis tests using Excel 2013 T-TEST command
