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(FExplanation / 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
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.