(1) to complete the assignment using the 2 Independent Samples and Paired Data Samples Excel sheets from the Class Survey Data File, and then fill-out assignment Submission Form Directions:
1. T-test: 2 Independent Samples Assuming Unequal Variances
From the Class Survey Data File, using data from the 2 Independent Samples sheet -Use the data set labeled with the first letter of your FIRST name.
A\ Click on the DATA TAB and then select DATA ANAYLSIS
B\ Select t-test: 2 Samples Assuming Unequal Variances
C\ Inputs:
● Variable 1 Range: 1st Column of Data, including heading
● Variable 2 Range: 2d Column of Data, including heading
● Hypothesized Mean Difference: 0
● click on Labels
● Alpha : .10
● Output Range: click on New Worksheet ply
First Name!
2. T-Test: 2 Dependent Samples (Paired)Test
From the Class Survey Data File, using data from the Paired Data Sample sheet -Use the data set labeled with the first letter of your LAST name.
Last Name!
A\ Click on the DATA TAB and then select DATA ANAYLSIS
B\ Select: t-Test: Paired Two Sample for Means
C\ Inputs: Same as for above Test using the Before and After columns of data.
3. See Assignment Submission Form
A & C\ State your Test Decision & Basis for the Decision: This is Step 5 of a hypothesis test and state
what values are you comparing to make your decision. Do not state all the steps of a HT
B & D\ Interpretation\Analysis of Results: This is Step 6 of a HT – application of results to context.
● It is suggested you read the Survey Question (from the Survey Question sheet of the
Survey Data File) for the response variable being tested.
● Whether you reject or fail to reject, the issue then becomes what is some plausible reason
or explanation or interpretation for the outcome the test produced or what is an inference
that can be made about the population (identify your assumed population)?
● Responses should be concise, clear, and organized.
● You are not asked to state H0 and H1, but it will help you answer B & D. See next page.
2 Independent Samples: there are no facts given because the class body – upper-division business
students at a major university in San Diego – is the facts; you are analyzing the survey data you
created in Week 1. Knowing that, these are the 4 facets of the null with the bold applying here:
4 Facets of the Null
1\ the null is the status quo
2\ everything arises from chance
3\ there are no differences between groups
4\ everything is unrelated
● There is nothing in the facts (again you, as a class body, are the facts) to indicate direction.
● Thus the two groups/measurements should be equal (not statistically significantly different).
● So, we perform a 2-tail test.
Paired Data Samples: this is a Before\After test, with the same student sample being measured
twice, regarding Students MIS 301 Anxiety Levels. Between the two measurements there was an
intervening event: Coverage of the Syllabus and the Class Introduction. We do NOT know whether
being informed about the course via the Syllabus and Introduction material reduced or raised (or
had no effect) – perhaps not for everyone but on average – Students Anxiety Levels. Therefore:
● We perform a 2-tail test on the Difference Group, using the following pattern -● ↓ Before − ↑ After = Negative Difference
● ↑ Before − ↓ After = Positive Difference
● So the Sign of the Test Stat indicates whether the Before or After Sample
had the Higher\Lower Anxiety Level.
2 Independent Samples
Paired Data Samples (Before\After Test)
H0: μ1 = μ2
H0 : μD = 0
H0: μ1 ≠ μ2
H0 : μD ≠ 0
Submitting:
A\ Before Coping & Pasting the two output tables to the Submission Form set decimals to 3- 4
places, format column widths and make any needed adjustments so the tables are clear, clean,
and readily understandable. (See side 5 – 7 of the PowerPoint located with the Assignment),
B\ You may need to PASTE SPECIAL PICTURE or PASTE SPECIAL BITMAP so copied images paste
cleanly and clearly into the space provided.
C\ Do not submit any raw data.
D\ You are limited to 1 page (including the tables).
Last Name:
Click or tap here to enter text.
First Name: Click or tap here to enter text.
Use of the phrase “slight difference” (or similar) will likely result in a lower grade.
Independent Samples
[STEP 5 Of HT]
Highlight or Bold Correct Answer:
REJECT THE NULL
FAIL TO REJECT THE NULL
[STEP 6 of a HT]
State a Plausible Explanation\Inference\Application of the Test Result that is not a reiteration Step 5:
Dependent Samples
[STEP 5 Of HT]
Highlight or Bold Correct Answer:
REJECT THE NULL
FAIL TO REJECT THE NULL
[STEP 6 of a HT]
State a Plausible Explanation\Inference\Application of the Test Result that is not a reiteration Step 5
IMPORTANT: Submission Forms must be kept as a Word document (.doc or .docx) or PDF or if needed
try as an image (jpeg, jpg, or png). Other formats do not open on my end.
DO NOT GO BEYOND 1 PAGE (INCLUDING THE ABOVE TABLES)
Additional Material: C-10 — Excel’s
Analysis ToolPak & Business World
2 Sample Testing
A 7-slide PPT Presentation showing how to run, interpret, and format the
output of a hypothesis test using
Excel’s Data Analysis Tool.
