A. The spreadsheet below shows the results of two different analytical methods used to determined calcium (Ca) in a standard sample. Method A is the accepted method, and Method B is a newly developed procedure. Method Method A B 20.4 21.0 25.4 23.6 25.1 22.2 22.5 17.8 24.9 24.2 26.2 21.6 (a) find the means of the two methods, the standard deviations and the standard deviations of the means (b) Give the 95% confidence interval for the means of the two methods (c) Do the variances differ at the 95% confidence interval (d) Do the t-test and test the null hypothesis that the two means are equal at the 95% confidence interval
A. The spreadsheet below shows the results of two different analytical methods used to determined calcium (Ca) in a standard sample. Method A is the accepted method, and Method B is a newly developed procedure. Method Method A B 20.4 21.0 25.4 23.6 25.1 22.2 22.5 17.8 24.9 24.2 26.2 21.6 (a) find the means of the two methods, the standard deviations and the standard deviations of the means (b) Give the 95% confidence interval for the means of the two methods (c) Do the variances differ at the 95% confidence interval (d) Do the t-test and test the null hypothesis that the two means are equal at the 95% confidence interval
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 13PPS
Related questions
Question
Please do this on MS EXCEL. Please show me the step by step in EXCEL so I can use it as a guide. Thank you.
Transcribed Image Text:A. The spreadsheet below shows the results of two different analytical methods used to determined calcium
(Ca) in a standard sample. Method A is the accepted method, and Method B is a newly developed procedure.
Method Method
B
20.4
21.0
25.4
23.6
25.1
22.2
22.5
17.8
24.9
24.2
26.2
21.6
(a) find the means of the two methods, the standard deviations and the standard deviations of the means
(b) Give the 95% confidence interval for the means of the two methods
(c) Do the variances differ at the 95% confidence interval
(d) Do the t-test and test the null hypothesis that the two means are equal at the 95% confidence interval
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 8 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Do the t-test and test the null hypothesis that the two
Solution
by Bartleby ExpertRecommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill