C 9_1 Sample HT Calculator

GPA Copy & Paste your data from the Class Survey Data File into Column A 3.5 ← ← ← ← ← 3.5 3.5 MIS 301 RANDOM SURVEY RESPONES 3.75 GPA 4 Statistical Output Analysis 3.75 2.75 2.75 Sample Mean: 3.51 4 Sample Std.: 0.46 3.25 Sample Size: 47 4 3 Expected Value 3.55 3.75 Alpha: 0.1 3.5 3.75 Hypothesis Test Data: Z test 3.5 3.75 2 Tail CV, z = 1.64 -1.64 3.75 1 Tail CV, z = -1.28 1.28 4 Test Statistic, z = -0.59 3.25 3.75 3.75 4 3.75 2 4 3.25 3.75 3.75 4 3.5 3.75 3.5 3.75 3.75 4 3.25 3.75 3.75 4 3.75 2 4 3.25 A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

3.75 3.75 4 A B C D E F G H 46 47 48

School Debt Copy & Paste your data from the Class Survey Data File into Column A $10,000 ← ← ← ← ← $10,000 $10,000 MIS 301 Random Survey Responses $25,000 School Debt $0 Statistical Output Analysis $30,000 $20,000 $5,000 Sample Mean: 15241.38 $30,000 Sample Std.: 10802.30 $10,000 Sample Size: 29 $2,000 Degrees of Freedom: 28 $25,000 Expected Value 9400.00 $25,000 Alpha: 0.1 $0 $30,000 Comparison HT Data: t Test $0 $5,000 2 Tail CV, t = -1.70 1.70 $30,000 1 Tail CV, t = -1.31 1.31 $5,000 Test Statistic, t = 2.91 $30,000 $5,000 $5,000 $30,000 $10,000 $20,000 $20,000 $10,000 $20,000 $20,000

● Per the directions, input the formulas for the mean, s, and n. The Output Table Will Provide: a\ The Test Statistic (Step 3 of a HT) b\ The Critical Values for a 2-Tail Test (Step 4 of a HT) c\The Critical Values for a Single, Left Tail Test (Step 4 of a HT) d\The Critical Values for a Single, Right Tail Test (Step 4 of a HT) ● Copy & paste the appropriate data from the class survey data file. ● Per the directions, input expected value and alpha. ● To make your test decision (Step 5 of a HT) compare the Test Statistic to the appropriate Critical Value, depending on whether you are doing a 2-tail test, a single left tail test, or a single right tail test.