Please help Excel AssignmentAfter reading the excel tutorial under documents, answer the following questions in an excelspreadsheet. Submit the spreadsheet to assignments in your lab section on Blackboard uponcompletion.1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3,Molarity HNO3, AYg M and St. dev M) in Excel:0.025 L HNO;Vol NaOH (mL)(0.09876 M)Moles NaOHMoles HNO3Molarity HNO3Trial 123.51Trial 222.95Trial 322.82Trial 423.23Average MSt. dev M 2. In one of the experiments this semester we will need to create a graph, find the best-fitslope for the data and determine how well the data fits the best-fit line. We will preparesolutions with known concentrations (mol/L) and measure the absorbance of each solution.We will use an instrument that measures how much light a compound absorbs at a specificwavelength (color). Copy the data in the table below in excel and create a scatter plot ofabsorbance versus concentration. Make sure the plot has the following features:y axis showing absorbance, x axis showing concentration in ppmplot created a separate sheet in the workbookproper títlelabeled axessensible scales on the axesno gridlinea colorless background to the plotsolid green squares as data markersa line of best fit (trendline) which passes through the originset y intercept to zerothe equation of the line and R? value to the four decimal placesConcentration (parts per million, ppm)Absorbance200.736150.556100.7020.20620.0843. Based off your R? value, make a statement about the quality of data. In other words, howwell does your data fit a linear relationship?

Hii there, As there are multiple question posted. we are answering first question. If you need…

Excel Assignment After reading the excel tutorial under documents, answer the following questions in an excel spreadsheet. Submit the spreadsheet to assignments in your lab section on Blackboard upon completion. 1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3, Molarity HNO3, AYg M and St. dev M) in Excel: 0.025 L HNO, Vol NaOH (mL) (0.09876 M) Moles NaOH Moles HNO, Molarity HNO, Trial 1 23.51 Trial 2 22.95 Trial 3 22.82 Trial 4 23.23 Average M St. dev M

Excel Assignment After reading the excel tutorial under documents, answer the following questions in an excel spreadsheet. Submit the spreadsheet to assignments in your lab section on Blackboard upon completion. 1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3, Molarity HNO3, AYg M and St. dev M) in Excel: 0.025 L HNO, Vol NaOH (mL) (0.09876 M) Moles NaOH Moles HNO, Molarity HNO, Trial 1 23.51 Trial 2 22.95 Trial 3 22.82 Trial 4 23.23 Average M St. dev M

Introductory Chemistry: A Foundation

9th Edition

ISBN:9781337399425

Author:Steven S. Zumdahl, Donald J. DeCoste

Publisher:Steven S. Zumdahl, Donald J. DeCoste

Chapter9: Chemical Quantities

Section: Chapter Questions

Problem 62QAP: An air bag is deployed by utilizing the following re tion the nitrogen gas produced inflates the air...

See similar textbooks

Similar questions

he production capacity for acrylonitrile (C3H3N)in the United States is over 2 billion pounds per year. Acrylonitrile, the building block tor acrylonitrile fibers and a variety of plastics, is produced from gaseous propylene, ammonia, and oxygen: :math>2C3H6(g)+2NH3(g)+3O22C3H3N(g)+6H2O(g) l type='a'> Assuming 100% yield, determine the mass of acrylonitrile which can be produced from the mixture below: l> Mass Reactant msp;5.23102g propylene td> msp;5.00102g ammonia td> msp;1.00103g oxygen td> i>What mass of water is formed from your mixture? Calculate the mass (in grams) of each reactant after the reaction is complete.
or each of the following reactions, give the balanced chemical equation for the reaction and state the meaning of the equation in terms of individual molecules and in terms of moles of molecules. msp;MnO2(s)+Al(s)Mn(s)+Al2O3(s) msp;B2O3(s)+CaF2(s)BF3(g)+CaO(s) msp;NO2(g)+H2O(l)HNO3(aq)+NO(g) msp;C6H2(g)+H2C6(g)H12(g)
Solid calcium carbide (CaC2)reacts with liquid water to produce acetylene gas (C2H2)and aqueous calcium hydroxide. l type='a'> Write the balanced equation for the reaction that is (occurring. including all phases. If a 100.0-g sample of calcium carbide (CaC2)is initially reacted with 50.0 g of water, which reactant is limiting? Prove that mass is conserved for the reactant amounts used in pan b.
A weighed sample of iron (Fe) is added to liquid bromine (Br2) and allowed to react completely. The reaction produces a single product, which can be isolated and weighed. The experiment was repeated a number of times with different masses of iron but with the same mass of bromine (see graph below). (a) What mass of Br2 is used when the reaction consumes 2.0 g of Fe? (b) What is the mole ratio of Br2 to Fe in the reaction? (c) What is the empirical formula of the product? (d) Write the balanced chemical equation tor the reaction of iron and bromine. (e) What is the name of the reaction product? (f) Which statement or statements best describe the experiments summarized by the graph? (i) When 1.00 g of Fe is added to the Br2, Fe is the limiting reagent. (ii) When 3.50 g of Fe is added to the Br2, there is an excess of Br2. (iii) When 2.50 g of Fe is added to the Br2, both reactanu are used up compietely. (iv) When 2.00 g of Fe is added to the Br2, 10.8 g of product is formed. The percent yield must therefore be 20.0%.
When potassium chlorate is subjected to high temperatures, it decomposes into potassium chloride and oxygen. (a) Write a balanced equation for the decomposition. (b) In this decomposition, the actual yield is 83.2%. If 198.5 g of oxygen are produced, how much potassium chlorate decomposed?
An air bag is deployed by utilizing the following re tion the nitrogen gas produced inflates the air bag): :math>2NaN3(s)2Na(s)+3N2(g) 10.5 g of NaN1 is decomposed, what theoretical mass of sodium should be produced? If only 2.84 g of sodium is actually collected, what is the percent yield?
On Easter Sunday, April 3, 1983, nitric acid spilled from a tank car near downtown Denver, Colorado. The spill was neutralized with sodium carbonate: 2HNO3(aq)+Na2CO3(aq)2NaNO3(aq)+H2O(l)+CO2(g) a. Calculate H for this reaction. Approximately 2.0 104 gal nitric acid was spilled. Assume that the acid was an aqueous solution containing 70.0% HNO3 by mass with a density of 1.42 glcm3. What mass of sodium carbonate was required for complete neutralization of the spill, and what quantity of heat was evolved? (Hf for NaNO3(aq) = 467 kJ/mol) b. According to The Denver Post for April 4, 1983, authorities feared that dangerous air pollution might occur during the neutralization. Considering the magnitude of H, what was their major concern?
Air Pollution Nitrogen monoxide, which is present in urban air pollution, immediately Converts to nitrogen dioxide as it reacts with oxygen. a. Write the balanced chemical equation for the formation of nitrogen dioxide from nitrogen monoxide. b. What mole ratio would you use to convert from moles of nitrogen monoxide to moles of nitrogen dioxide?
4.17 Phosgene is a highly toxic gas that has been used as a chemical weapon at times in the past. It is now used in the manufacture of polycarbonates, which are used to make phone cases and plastic eyeglass lenses. Phosgene is produced by the reaction, CO+Cl2COCl2 . Given an excess of carbon monoxide, what mass of chlorine gas must be reacted to form 4.5 g of phosgene?
A possible practical way to eliminate oxides of nitrogen(such as NO2 ) from automobile exhaust gases uses cyanuricacid, C3N3(OH)3 . When heated to the relatively lowtemperature of 625°F, cyanuric acid converts to gaseousisocyanic acid (HNCO). Isocyanic acid reacts with NO2 inthe exhaust to form nitrogen, carbon dioxide, and water,all of which are normal constituents of the air. (a) Write balanced equations for these two reactions. (b) If the process described earlier became practical, howmuch cyanuric acid (in kilograms) would be requiredto absorb the 1.71010kgNO2 generated annuallyin auto exhaust in the United States?
itamin B12 , cyancobalamin, is essential for human nutrition. Its molecular formula is C63H88CoN14O14P . A lack of this vita min in the diet can lead to anemia. Cyanocohalamin is the form of the vitamin found in vitamin supplements. l type='a'> What is the molar mass of cyanocobalamin to two decimal places? How many moles of cyanocohalamin molecules are present in 250 mg of cyanocobalamin? What is the mass of 0.60 mole of cyanocobalamin? How many atoms of hydrogen are in 1 .0 mole of cyanocobalamin? What is the mass of 1.0107 molecules of cyanocobalamin? What is the mass (in grams) of one molecule of cyanocobalamin?
How are the molecular mass and the molar mass of a compound similar and how are they different?