Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Given Excel Stats. Data were obtained in an experiment designed to check whether

ID: 3322220 • Letter: G

Question

Given Excel Stats. Data were obtained in an experiment designed to check whether there is a
systematic difference in the weights obtained with two different scales

1) What are the null and alternative hypotheses?

2) What is the sample means?

3) Which test(s) should be used here?

4) What is the P-value ?

5) Can null hypothesis be rejected at

a. Alpha = 0. 10 level

b. Alpha = 0.05 level

Descriptive Statistics Scale II Scale lI Rock Specimen 1 Rock Specimen 2 Rock Specimen 3 Rock Specimen 4 Rock Specimen 5 Rock Specimen 6 Rock Specimen 7 Rock Specimen 8 Rock Specimen 9 Rock Specimen 10 12.87 Mean 1.63 Standard Error 11.82 Median #N/A Mode Mean 12.89 14.36 Standard Error Median #N/A 23.42 23.41 Standard Devi- ation Standard Devi- ation 13.47 26.69 Sample Vari- 0.72Kurtosis 1.04 Skewness 16.95 Range 6.47 Minimum 23.42 Maximum 26.59 ance ance Kurtosis Skewness 19.38 19.35 16.95 F-Test Two-Sample for Variances Minimum Maximum Scale Scale II Mean 128.71 Sum 128.91 ariance Observations df 10.00Count Count Confidence Level(95.0% Confidence evel(95.0% P(F

Explanation / Answer

1) What are the null and alternative hypotheses?

Null Hypothesis : H0: There is no systematic difference in the weights obtained with two different scales. 1 -2= 0

Alternative hypothesis : Ha : There is a significant systematic difference in the weights obtained with two different scale. 1 -2 0

2) What is the sample means?

Sample mean scale I = x1 = 12.87

Sample mean scale II = x2 = 12.89

3) Which test(s) should be used here?

Here we should paired t test for two dependent samples as we in experiment study we use the same sample for both the tests.

4) What is the P-value ?

Here P - value = 0.05 ; as given in the test.

t = - 2.21 < 2.26 (aalpha = 0.05)

5) Can null hypothesis be rejected at

a. Alpha = 0.10 level ; we will reject the null hypothesis at alpha = 0.10 level. as p -values < 0.10

b. Alpha = 0.05 level; we failed to reject the null hypothesis at alpha = 0.05 level. as p - value > 0.05

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote