L3 Report (1)

xlsx

School

University of Missouri, Kansas City *

*We aren’t endorsed by this school

Course

341 WI

Subject

Statistics

Date

Apr 3, 2024

Type

xlsx

Pages

7

Uploaded by acook711

Report
Experiment 3 Statistical Evaluation of Acid-Base Indicators Name: Ava Cook Section Am AM, Noon, PM Data Submitted: ### Your Buret Data Indicator 1 Molarity Disc? Indicator 2 Molarity Sample 1 0.1279 no Sample 1 0.1044 Sample 2 0.1385 no Sample 2 0.1107 Sample 3 0.13 no Sample 3 0.0989 Sample 4 0.1336 no Sample 4 0.1032 Sample 5 0.1356 no Sample 5 0.1108 Mean 0.1331 Mean 0.1056 Std Dev 0.0043 Std Dev 0.0051 % Rel St Dev 3.19% % Rel St Dev 0.00% Indicator 1 Phenol Red Indicator 2 Methyl Red Comments? Revised 2/17/2021
M, Eve Grubbs Values Indicator 1 Trial Computed 1 -1.209 2 1.256 Disc? 3 0.7209 no 4 0.1162 no 5 0.093 no no no Grubbs Values Indicator 2 Trial Computed 1 -0.2353 2 1 3 -1.314 4 -0.4705 5 1.019 # of Obs. G 95% 4 1.463 5 1.672 6 1.822 # of Obs. G 95% 4 1.463 5 1.672 6 1.822
of bs. G 95% 1.463 1.672 1.822 of bs. G 95% 1.463 1.672 1.822
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Indicator 1 Results I did not discard any of my samples. Indicator 2 Results I did not discard any of my samples. Class Results Indicator n Methyl Red 0.1041 0.0092 8.88% 1 Methyl Orange 0.0982 0.0038 3.91% 2 Phenol Red 0.1224 0.0107 8.74% 4 Indicator n Methyl Red 0.1035 0.0087 8.40% 9 Methyl Orange 0.0983 0.0046 4.67% 10 Did you discard any of your samples? If so, list the values you kept and recompute the mean and SD in th right. What is the % difference in the recomputed mean (new) and the original mean? Did you discard any of your samples? If so, list the values you kept and recompute the mean and SD in th right. What is the % difference in the recomputed mean (new) and the original mean? There are two basic approaches to treating a large data set such as the one we have developed for this experimen of the data as one large set. Using the data from the class, compute the mean, standard deviation and relative sta each indicator separately. You MUST use Excel's AVERAGE and STDEV.S functions to do this. Mean s Std Dev s % Rel Std Dev s The second approach is to "pool" the data, where the data is treated as a set of subsets of data. (This is the data o worksheet in the excel file.) In other words, each students's data for the five titrations of each indicator is treate data represented by the mean and standard deviation of each set. All the same quantities can be calculated as ab average of the means and the average of the standard deviations for each indicator. Mean s Std Dev s % Rel Std Dev s
Phenol Red 0.1223 0.0114 9.30% 19 (Carry out the following calculations using the pooled data. Use the t -test to decide if the averages are significa confidence. Report your results below and interpret the meaning. (There is an expanded t-test Table in the Lab reason that the two sets of data are so different. ( Hint : See Table 11-3 in your textbook.)
Indicator 1 Molarity Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Recomputed Mean Recomputed Std Dev Indicator 2 Molarity Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Recomputed Mean Recomputed Std Dev n 7 1 1 n 0 00 he table to the he table to the nt. The first treats all andard deviation for on the "By Student" ed as singular piece of bove, using the
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
96 antly different at 95% b 3 folder.) Propose a