Question: Please solve correctly using excel & pay attention to the sig figs There is a Canvas AUDIO tutorial available for this problem. This question requires

Please solve correctly using excel & pay attention to the sig figs

There is a Canvas AUDIO tutorial available for this problem. This question requires the use of a spread sheet (Excel) to calculate the LINEST uncertainty in the Linear Least Squares best fit line, and the associated unknown sample. You'll be reproduci Figure 4-13 in the 7th Addition of Harris. The instructions for using LINEST are on the previous page. Here are mass spectrometric signals for methane in Hz. CH4 (vol %): 0 0.062 0.122 0.245 0.4860.971 1.921 Signal (mv): 9.1 47.595.6 193.8 387.5 812.5 1671.9 Construct a calibration curve: (a) Subtract the blank value (9.1) from all other values (this means that your first data point will be 0,0). Then use the LINEST calculation of least squares to find the slope and intercept and their uncertainties. slope + intercept + (b) Replicate measurements of an unknown gave 152.1, 151.3, 153.9, and 153.7 mv, and a blank gave 8.5, 9.4, 10.6, and 8.4 mv. Subtract the average blank from the average unknown to find the average corrected signal for the unknown. (c) Find the concentration of the unknown and its uncertainty. vol%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Problem ID 18326536 Mass Spectrometric Calibration via LINEST in Excel Given Data Calibration Data C... 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 Accounting Questions!

Please solve it correctly with the right number of sig fig. I also upload table 8-1 for you to use There is a Canvas AUDIO tutorial available for this problem. Neglecting activities, calculate the pH...

Please find the assignment on page 30 of the attached file(unit outline), which is: Task 2 - Research Focused Project - 25% I need $4000 words for this research paper. Please Use Academic journal...

Please use this template providedto solve project 3 which has 3 parts on separate worksheets. You must use excel cell referencing in all of your calculations and use the data analysis tool...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

KINGS OWN INSTITUTE* Success in Higher Education ICT106 DATA COMMUNICATIONS AND NETWORKS T223 Page 1 of 18 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD ABN: 72 132 629 979 CRICOS 03171A...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Complete the Porters Five Forces Worksheet, based on Procter and Gamble. Industry force Strength Provide a justifying your determination with examples High Medium Low Example x This is why I believe...

On its website (Figure 18), a company promises to deposit cash into a customers bank account within 24 hours. In small groups, discuss tactics this company uses to persuade its audience. How do you...

You bought your home for $ 1 5 0 , 0 0 0 and sold it 5 years later for $ 3 0 0 , 0 0 0 . Which of the following accurately describes the tax consequentes of this transaction? You will owe $ 0 tax on...

what will be the result of the following code? int [ ] x = { 0 , 1 , 2 , 3 , 4 , 5 } ;