Question

Run a t-Test:Two-sample Assuming Equal Variances on the the Math and History variables from Data Set B:

Math	History	Oceanography
43	66	31
53	54	40
49	58	53
54	64	42
43	64	51
43	64	38
45	56	55
51	55	46
54	54	40

What number P (T<=t) two-tail numerical output did you get?

Group of answer choices

0.13

-4.75

0.0002

.075

Run a t-Test:Two-sample Assuming Equal Variances on the the Speech and Statistics variables from Data Set B:

Data Set A:

Speech	Statistics	Chemistry
19	69	35
14	14	12
7	32	17
28	9	30
39	5	35
33	16	8
16	15	37
18		26
39		10
26
6

What number P (T<=t) two-tail numerical output did you get?

Group of answer choices

0.00004

0.94

1.48

0.003

In a short response, tell me what you learned about both Data Sets. You can cite the numbers from above along with basic definitions. Give me a solid idea that you understand the concepts. You don't have to write a long paper here. Just enough so that I understand your thought process.

Answer 1

(A) Ho: There is no significant difference between Mahematics and History

To test the HO he we go with the MS - Excel

Step1: Type the data in excel sheet. as X = Maths and Y = History

Step2: Select fx that is the formuls icon from the ribbon

Step3: Choose T - test from the Window. It will ask Array1, Array 2, Tails, Equal variance like that. Fill the required In Array1 we give X value and in Array2 we fill the Y values

Step4: After pressing OK we get the calculated value of t

Step 5: Next find the t - Critical value. From the Formula window by selecting TINV

NOTE: I have give the Screenshots of those. Please Check those.

Step 6: We compare t-cal with t-cri. If t-cal is less than or equal to t-cri; we accept HO. Otherwise we Reject it at 5% Level Of Significant.

X	Y
43	66		t - cal	0.000202
53	54
49	58		t - cri	0.690132
54	64
43	64
43	64
45	56
51	55
54	54

From the above calculations it's clear that t-cal is less than t-cri. So, we Accept HO at 5% level of significant. Therefore we conclude that there is no significant differences between the Maths and HIstory.

SCREESHOTS AS FOLLOWS:

Problem (b): Ho: There is no significant difference between the subjects speech and statistics.

We adopt the same steps which we did in the above problem.

X	Y
19	69		t - cal	0.915221
14	14
7	22		t - cri	0.690132
28	9
39	5
33	16
16	15
18
39
26
6

Since t-cal is lessthan t-cri; we accept Ho at 5% Level of significant and we conclude that there is no significant difference between the speech and statistics.

Screenshots:

REMARK: In both the above problem i referred degrees of freedom as 16. That is (n1+n2)-2. Where n1 and n2 are no: of observation of X and Y