Toolsz testtwo sample for means enter value usually 0

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: yards. test statistic upper tail test lower tail test twotailed test Difference Between 2 Population Means ( x Par - x Ace ) - D0 z STAT = s Par 2 s Ace 2 n Par + n Ace = 6.484 H0: DPar–Ace ≤ 0 Ha: DPar–Ace > 0 reject H0 if zSTAT > z.05 or pvalue<0.05 H0: μ1 – μ2 ≥ D0 Ha: μ1 – μ2 < D0 reject H0 if zSTAT < zα or p-value<α H0: μ1 – μ2 = D0 Ha: μ1 – μ2 ≠ D0 reject H0 if zSTAT < –zα/2 or zSTAT > zα/2 or if p-value<α Using MS Excel… for Inferences about the difference between two population means (σ1 and σ2 known) 2 possibilities within Excel: 1. can set up formulas for specific case or template for any case (e.g., Templates 10.xlsx) 2. can use the Data Analysis Tools that can be added on to MS Excel Hypothesis Tests Interval Estimation Hypothesis Testing raw data can set up worksheet for specific case or template for any case can use Data Analysis Tools:—zTest:Two-Sample for Means summary statistics can set up worksheet can set up worksheet for specific case or for speci...
View Full Document

Ask a homework question - tutors are online