Confidence Interval Estimate for the Mean (s Known)
Population Standard Deviation
Standard Error of the Mean
Interval Half Width
Interval Lower Limit
Interval Upper Limit
Comparing chi-square results
Enter data in highlighted cells
chi-square for homogeneity
Hypothesis test for the Mean using the t-distribution
Significance level =
Sample mean =
Sample SD =
Sample size =
Test statistic =
Two tailed test
Lower critical value
Upper critical value
Inferences about Linear Regression
This worksheet illustrates several inferential procedures you can perform after doing a regression on a sample of (x,y) data.
Instructions: Enter your data in columns A and B you can have up to 500 data points. The sampl
This spreadsheet performs a linear regression on up to 1000 pairs of observations.
For more information, see http:/udel.edu/~mcdonald/statregression.html.
It comes with the bird data from that web page entered as an example.
To use the spreadsheet, replac
FORECASTS, ERROR MEASURES, AND CONFIDENCE INTERVALS
MEAN MODEL (p=1)
FCST ERROR ABS ERR
Number of data poin
Intro to ChiSquareDist.xls
This workbook demonstrates the c2 (chi-square) distribution.
As its name clearly implies, the distribution is defined by squaring. What's squared? A normally distributed random variabl
If you take a standard normally distributed
Spreadsheet operations for r x c Contingency Tables:
Formulas for row and column sums for a Contingency Table can be set up by
(I) entering a formula for a single row sum, for example `Sum(b24:f24)' in cell h24
(ii) higlighting the cell with the formula
Anderson-Darling Normality Test Calculator
2005 Kevin Otto
Please freely distribute and modify, but properly reference and maintain this contact information in the sheet.
Mann-Kendall Test and Sen's Slope Estimates for the Trend of Annual Data
Version 1.0 Freeware
Copyright Finnish Meteorological Institute 2002
This MSExcel template is developed for detecting and estimating trend in time series of annual value
Dr. Johnathan Mun.
All Rights Reserved.
This sample model illustrates how to use Risk Simulator (Enterprise Simulator) for:
1. Running a Statistical Analysis on your data
Table 6.7. Chi-square calculations
(a) Calculation of chi-square test of association for american beech and soil cover type 2
sum i (observed i - expected i) 2 / expected i
a = (a + b) (a +
Chi-Square Goodness of Fit Test (Assuming Equal Expected)
Roll a 1
Roll a 2
Roll a 3
Roll a 4
Roll a 5
Roll a 6
Level of Signif
This spreadsheet performs the chi-square test of goodness-of-fit for up to 20 categories.
It comes with the pea data from http:/udel.edu/~mcdonald/statchigof.html entered as an example.
To use it, replace the pea data with your observed numbers in column
Essentials of Biostatistics in Public Health
Lisa M. Sullivan
This Excel workbook contains 2 worksheets to conduct the chi-square goodness of fit test and the chi-square test of
independence for categorical and ordinal outcomes using the formulas and proc
Chi-Square difference test
You just need to fill in B4, C4, B5, & C5 (ie, the cells on a white background)
Model 1 should be more constrained than model 0
Chi-Square Test for Goodness-of-Fit
Brown Maroon Black
The ADBUDG Model
For Use with the ADBUDG Excel Spreadsheet
The ADBUDG model can be used to project the market share and contribution effects of
advertising programs. It was first described in the business literature in 1970 by John Little. It
seeks to des
Version 4.1 5/9/00
Regression with Prediction Intervals
Johnson Graduate School of Management
Ithaca NY 14853
This spreadsheet is intended for teaching purposes
ANALYSIS OF VALIDITY BY LINEAR REGRESSION
Hover cursor for citation:
Hover cursor for updates:
Data shown are body fat (%BM) for DEXA estimate (Y) vs Bod-Pod estimate (X), read from Fig. 1 of Sardinha et al.
Replace the numbers in blue. Descript
This spreadsheet is provided "as is" without warranties of any kind, either expressed or implied.
When to use this spreadsheet
1) This spreadsheet allows the user to perform a complete 3 factor, full factorial Design of Experiments (DOE). Three factors ca
AAPL Beta Estimation Page 1 of 22
This page shows the reformatted Excel regression output and graph of the line of best fit. The last tab
of the spreadsheet shows how to convert price and index data into the returns used in this analysis.
Conjoint Analysis is used by marketers to tell which product attributes of a product are most important to a consume
and to what degree is each important to the consumer.
Step 1 - Make a list of product attributes
to be evaluated by cons
Jednofaktorov analza rozptylu
Dvojfaktorov analza rozptylu
Skromn firma sa rozhoduje, v ktorej asti mesta postav nov predaju potravn. Do vahy prichdzaj tri
mon miesta (A, B, C). Jedn
CALCULATING THE RELIABILITY INTRACLASS CORRELATION COEFFICIENT AND ITS CONFIDENCE
Reference: Hopkins WG (2009). Calculating the reliability intraclass correlation coefficient and its confidence limits (Exc
The ICC here is the one that gives the same value