Basic Statistical Templates – 2 Sample F-Test and CI (Compare 2 Standard Deviations) Example Click SigmaXL > Templates & Calculators > Basic Statistical Templates > 2 Sample F-Test and CI (Compare 2 Standard Deviations) to access the
template.
Notes
Enter summarized Sample Data, Null Hypothesis and Confidence Level in cells with yellow highlight. Do not modify any other part of this worksheet.
Select Alternative Hypothesis using drop-down.
This calculator will automatically detect the version of Excel and use the appropriate statistical functions.
The F-test for two sample standard deviations/variances assumes that samples are normally distributed.
Define, Measure, Analyze, Improve, Control
Simulate, Optimize, Realize
Web Demos
Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim Click here to view some now!
Facebook
X
LinkedIn
YouTube
