This worksheet enables hands-on reliability analysis, and reproduces the results of the seven c
5 of the Low and Tang (2004) paper. For quick hands-on: Click Tools\Scenarios, select a case, c
then "Close", followed by Tools\Solve
Dr. Bob's Handy-Dandy Reliability Calculator
Probability That A Specified Number of Failures Will Occur In A Given
Time/Cycle Interval For A Single System - (Mission Failure Prob (1)
This tool computes the probability that a specified number of failures w
CONSECUTIVE PAIRWISE ANALYSIS OF TRIALS FOR RELIABILITY
Hover cursor for citation:
Hover cursor for updates:
This spreadsheet calculates reliability statistics for consecutive pairs of trials and for the means of these statistics wh
Welcome to the FMEA Worksheet
This spreadsheet can be used to
1. Identify potential failure modes and their impact on product reliability.
2. Rank the potential defects to establish priority - The highest RPN value items deserve the most atte
In accordance with Appendix C of Mil-HDBK-189 [Reference 1] the AMSAA model is designed for tracking the reliabi
and not across test phases and assumes that based on the failures and test time within a test phase, the cumulative
log-log scale. This
DESIGN VERIFICATION PLAN AND REPORT
Specification & Method
& test method used
& Test Method
ATION PLAN AND REPORT
Provide a brief desription
of each test.
Copy Search Results from Downloaded Spreedsheet into Row 11 below
Early Life Failure Rate
MTBF / FIT
Early Life Failure Rate
This spreadsheet provides test statistics for 4 different correlation comparisons.
Each worksheet provides details about the test, including when to use the test and where to find more information.
Different cells on each sheet are in different colors. Th
Reliability of Simple and Complex Systems
For the samples shown in the workbook:
Insert values only in those cells with
The calculated values are in cells with
Dr Carl Betterton
This spreadsheet is provided "as is" without warranties of any kind, either expressed or implied.
When to use this spreadsheet
1) This spreadsheet performs a Weibull reliability analysis. Up to 100 data points can be evaluated. The
analysis techniques in
Significance Tests to Compare Two Independent Cronbach Alpha Values
(Spreadsheet prepared by Hoi K. Suen, Penn State University, 2009. Contact [email protected])
Use the Feldt Test on the left for large samples; use the Fisher-Bonett test on the right for s
2 x 2 chi-square
MENDEL: CHI-SQUARE TEST FOR STANDARD (NON-LINKED) GENETIC L
Published in: Montoliu L. Transgenic Res. 2012 Jun;21(3):677-81. Epub 2011 Aug 19.
NON-MENDELIAN = The observed distribution of frequencies does not follow the expected Mendelian ratio, differenc
Bryant-Satorra (2012) Scaled Difference Chi-Square Test for LISREL 8
(see next sheet for scaled difference test for LISREL 9, EQS, or Mplus)
Min Fit ML chi-square (T1)
NTWLS chi-square (T2)
NTWLS SB chi-square (T3)
c: scale correction factor (T2/T3)
(4 X 2) Chi-square test
(5 X 2) Chi-square test
(7 X 2) Chi-square test
This spreadsheet performs the chi-square test of independence for up to 10 columns and 50 rows.
It comes with the data on apolipoprotein B and coronary artery disease (CAD) from http:/udel.edu/~mc
To use the spreadsheet, replace the CAD numbers with your
Module 12: Chi-Square test and McNemar Chi-Square test
McNemar Chi-square test for paired data from Table 5-12 in text
All examples have a worksheet to practice on and a worksheet with the c
This spreadsheet performs the chi-square test of goodness-of-fit for up to 20 categories.
It comes with the pea data from http:/www.biostathandbook.com/chigof.html entered as an example.
To use it, replace the pea data with your observed numbers in column
Context: Chi-square Test for Goodness-of-Fit
Enter the hypothesized percentages in the cells above. You can use from 2 to 12 categories.
Degrees of Freedom
Decision about Ho
Intro to ConfidenceIntervals.xls
This workbook demonstrates how confidence intervals work.
The first two sheets, UniformCI and NormalCI implement the procedure for creating a confidence interval
and demonstrate how confidence intervals cover.
Here are the
Chapter 4: Sampling and Statistical Inference
1. Define a sampling plan. What is the purpose of using a sampling plan?
A sampling plan is a description of the approach that will be used to obtain samples from a population
prior to any data collection acti
AEA_DifTPAB_v04.xls spreadsheet has been designed by AEA Energy & Environment to assist Diffusion Tube users in calculating the
Precision and Accuracy (Bias) of their co-location studies. It also helps in adjusting diffusion tube results usin
Statistical Details of Sample Size Calculator
Deciding how many questionnaires you need to send out is a combination of the following factors:
The level of accuracy you require in your results.
The likely response rate.
The size of the population
for Public Health
March 2008 - updated February 2014
Commonly used public health statistics and
their confidence intervals
This spreadsheet provides Excel formul for calculating the more
common types of statistic used within public health