Question: Big Data. Modern analyses can generate thousands of data points. This problem introduces techniques for handling larger data sets. A spreadsheet with the data can

Big Data. Modern analyses can generate thousands of data points. This problem introduces techniques for handling larger data sets. A spreadsheet with the data can be found on SaplingPlus or at macmillanlearning.com. Students at the University of Sydney each determined the molecular mass of one of three unknown diprotic acids by weighing a precise mass of the unknown and titrating it with standardized 0.1 MNaOH 0.1 MNaOH. They then pooled their data. Data validation and visualization are critical to handling such large data sets.

127.9127.0 148.81 48.8 133.0 33.00 138.0138.0 123.21 23.2 136.236.2 149.4149.4 134.0134.0 150.3150.3

a. Validation. Confirm that you have the complete and accurate data set in Excel by comparing the mean, standard deviation, and number of data points with those of the original data set (mean=140.859 2, s =113.112 7, n=98). (mean = 140.859 2, s = 113.112 7, n = 98).
b. Visualization and classification are the next steps in handling large data sets. Trends and groups are more apparent in ordered data. Highlight the data in Excel. On the Data ribbon select Sort. Select Continue with the current selection and Smallest to Largest in the windows that appear. Confirm that the mean, standard deviation, and number of data remain unchanged. Graphs help visualize groups. Highlight the data in Excel. On the Insert ribbon select Scatter Chart. What are the two most suspect data points within the data? Visually inspect the data to determine the approximate molecular mass of the three diprotic acids. There are about the same number of analyses for each acid.
c. Statistical analysis. Select the data for the lowest molecular mass diprotic acid. Use the Grubbs test to determine if any data should be rejected. Determine the mean, standard deviation, and 95%95%. confidence interval for the molecular mass of this diprotic acid.
d. Interpretation. Does the experimental molecular mass agree with the expected value of 104.061g/mol 104.061g/mol for malonic acid?

127.9127.0 148.81 48.8 133.0 33.00 138.0138.0 123.21 23.2 136.236.2 149.4149.4 134.0134.0 150.3150.3 134.7134.7 102.81012.8 151.5151.5 135.4135.4 105.1105.1 146.7146.7 104.31014.3 134.41 34.4 103.2103.2 134.2134.2 108.6108.6 150.6150.6 105.0105.0 146.6146.6 134.2 34.2 60.460.4 135.335.3 100.0100.0 134.9134.9 104.61 014 6 12321 232 104.41 (14.4 104.91 [14.0 153.4153.4 107.7107.7 150.3150.3 153.5153.5 136.0136.0 148.6148.6 150.9150.9 133.81 33.8 108.3108.3 142.0142.0 134.1134.1 140.7140.7 103.91013.9 149.1149.1 132.0 32.0 150.8150.8 136.9136.9 154.7154.7 129.91 29.9 105.0105.0 142.1142.1 131.7131.7 160.7160.7 103.5103.5 102.8102.8 149.6149.6 135.9135.9 106.0106.0 105.1105.1 136.7136.7 104.11(14.1 149.8149.8 137.41 37.4 104.61014.6 149.2149.2 119.1119.1 105.7105.7 113.5113.5 105.4105.4 156.1156.1 105.0105.0 151.1151.1 137.4137.4 150.1150.1 135.11 35.1 134.9134.9 135.51 35.5 133.81 33.8 150.9150.9 134.5134.5 151.7151.7 134.6134.6 106.61 16.6 104.11(14.1 104.41 (14.4 104.91014.9 104.3104.3 149.3140.3 145.1145.1 149.7149.7 109.0109.0 133.7133.7 139.939.9 150.350.3 151.0 51.0 151.151.1

Step by Step Solution

★★★★★

3.29 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Without access to the spreadsheet and the ability to execute the actual calculations or manipulate the data in Excel I cannot confirm the statistics directly However I can guide you through the steps ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Quantitative Chemical Analysis Questions!

Create a spreadsheet with the following columns: Plaintext character ASCII code (7-bits, binary number) First bit Second bit Third bit Fourth bit Fifth bit Sixth bit Seventh bit Number of bits with...

At Big Time University (BTU) students are allowed to purchase two basketball tickets for each home game. Each ticket contains the date of the game, and the seat information, such as section, row, and...

For a data mining classification technique the validation data set lift charts are shown below. What confidence in the model would you express given this evidence?

Can someone please help me make this run? I don't understand why it is not //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Can someone help make this java file run? The code is probable the main issue I am having //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Please help with this. Text below BCS 101 - Programming Concepts and Problem Solving This course will provide an introduction to programming logic and problem solving techniques using different...

Can you write an essay? CASE: SM-219 DATE: 02/06/14 BASWARE IN 2013: TRANSITION TO SOFTWARE AS A SERVICE The technology transition is a complicated and difficult task, but the end is in sight....

I want you to summerize these 7 items. !Please be different from other answers! !Please get a little quick! Thanks. You should summarize the 7 items in the photo. Max 125 words! reading 1....

Address the interaction of laws and new technologies and how they have evolved each other in recent years based on the below article... BIG DATA "Privacy Versus Progress" : A Necessary Sacrifice, By...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Read the case study Ethical issues in selling and advertising and answer the question: What objections might be presented to this theory?

Choose the pattern for the following argument. Some wild cards are not hearts since no jacks are wild cards andsome jacks are hearts. Question 17 options: Some W are not H. No J are W. Some J are H....

Which of the following has a lower fine dollar amount limit than the others? a . Willful failure to file return, supply information, or pay taxes b . Willful failure to collect or pay tax c . Attempt...

Safety programs may accomplish their purposes in two primary ways: one focusing on unsafe employee actions and the other on unsafe working conditions. Which areas of Wandas proposal was she directing...

The concentration of sugar (glucose, C6H12O6) in human blood ranges from about 80 mg/100 mL before meals to 120 mg/100 mL after eating. Find the molarity of glucose in blood before and after eating.

An aqueous solution of antifreeze contains 6.067 M ethylene glycol (HOCH2CH2OH, FM 62.07) and has a density of 1.046 g/mL. (a) Find the mass of 1.000 L of this solution and the number of grams of...

Harvard Prep Shops, a national clothing chain, had sales of $300 million last year. The business has a steady net profit margin of 20 percent and a dividend payout ratio of 25 percent. The balance...

00 901 Bupe UV XL Maboval OS SRUH asnou e ng 100 CZG'ICS SMOLOGY bebom u AMD 4 saop yon mou soud Sul Answer format: Currency: Round to 2 decimal places jo je SUUR SE PO UL sreak 9 10 jouled Ayuomayew...

2018 2019 Partial Balance Sheets as of December 31, 2018 and 2019 2018 2019 Assets Liabilities and Owners' Equity Current assets $ 3,106 $ 3,312 Current liabilities 14,005 14,506 Net fixed assets...