Sample_Excel_error_calculations

# Sample_Excel_error_calculations - ) ( T- T true )/ n / T...

This preview shows page 1. Sign up to view the full content.

Example Problem in Excel - Errors and Uncertainties J. M. Cimbala T 22.15 0.05 -0.03 22.22 0.12 0.04 22.09 -0.01 -0.09 22.21 0.11 0.03 22.18 0.08 0 22.24 0.14 0.06 6 (number of data points in this sample) 22.18 (average of all readings) 22.1 (known) bias error = 0.08 MBE = 0 MBE = 0.37 % (I multiplied by 100 to convert to percent) Basic statistics for this data set: Column1 Mean 22.18 Standard Error 0.02 Median 22.2 Mode #N/A Standard Deviation 0.05 Sample Variance 0 Kurtosis 0.36 Skewness -0.95 Range 0.15 Minimum 22.09 Maximum 22.24 Sum 133.09 Count 6 T - T true T - T avg n = T avg = T true = ( T avg - T true
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ) ( T- T true )/ n / T true In Office 2003, use Tools-Data Analysis-Descriptive Statistics . If you do not have an option for Data Analysis, Tools-Add Ins-Analysis ToolPak-OK . In Office 2007, use the Data tab-Data Analysis-Descriptive Statistics . If you do not have an option for Data Analysis, Office Button-Excel Options-Add Ins-Analysis ToolPak-Go-OK . In either case, highlight the temperature values above (cells A5 through A10) and select Summary Statistics ....
View Full Document

## This note was uploaded on 07/23/2008 for the course ME 345 taught by Professor Staff during the Spring '08 term at Pennsylvania State University, University Park.

Ask a homework question - tutors are online