Using the information below, use Excel and show the equation on how to solve for each:  #3: The data below was generated to assess the precision of an analytical balance using a NIST-certified 10.0000 g calibration mass.  Use it to compute the mean, standard deviation, upper and lower warning limits, and upper and lower action limits. Be sure to keep at least one guard digit in your calculations, and report the results to the correct number of significant figures.

Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question

Using the information below, use Excel and show the equation on how to solve for each: 

#3: The data below was generated to assess the precision of an analytical balance using a NIST-certified 10.0000 g calibration mass. 

Use it to compute the mean, standard deviation, upper and lower warning limits, and upper and lower action limits. Be sure to keep at least one guard digit in your calculations, and report the results to the correct number of significant figures.

 

Question 3 - test set data for computing mean, standard deviation, and warning/action limits
Replicate
Mass (g)
Mean
Standard Deviation
1
23456789
10
10.0000
10.0001
9.9999
10.0000
9.9998
9.9999
10.0001
10.0000
10.0002
10.0000
Warning/Action Limits
Transcribed Image Text:Question 3 - test set data for computing mean, standard deviation, and warning/action limits Replicate Mass (g) Mean Standard Deviation 1 23456789 10 10.0000 10.0001 9.9999 10.0000 9.9998 9.9999 10.0001 10.0000 10.0002 10.0000 Warning/Action Limits
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Pressure and stress
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning