Get documents about "Large Square Template - Excel
W
Description
Large Square Template document sample
Document Sample
Input up to 20 values of a random variable X below
X Confidence Interval
Column1 1-alpha
t= #NUM!
Mean #DIV/0! Lower Upper
Standard Error #DIV/0! Limit Limit
Median #NUM! #DIV/0! #DIV/0!
Mode #N/A
Standard Deviation #DIV/0!
Sample Variance #DIV/0!
Kurtosis #DIV/0!
Skewness #DIV/0!
Range 0
Minimum 0
Maximum 0
Sum 0
Count 0
Large -Sample Test for a Mean
alpha:
alpha / 2: 0.00%
n:
x-bar:
µo
σ
Test Statistic (TS) z = (x-bar - µo)/[σ/sqrt(n)] = 0.00 = Z TS #DIV/0!
#DIV/0!
for σ known or n ≥ 30
p-value (1 tail) = #DIV/0!
p-value (2 tail) = #DIV/0!
t-critical(1-tail) = 10000000.000
t-critical(2-tail) = 10000000.000
Test of a mean of a population when n is small
df: -1
alpha =
alpha / 2 = 0.00%
n=
x-bar
µo =
s=
Test Statistic (TS) t = (x-bar - mu)/ [s/sqrt(n)] = 0.00 = t TS = #####
#DIV/0!
for σ unknown and n < 30
p-value (2-tail) = #DIV/0!
p-value (1-tail) = #DIV/0!
t-critical (2-tail) = #NUM!
t-critical (1-tail) = #NUM!
Large -Sample Test for a Proportion (p238)
(Where po is a specified proportion value)
alpha =
alpha / 2 = 0.00%
n=
No of successes =
po =
(1-po) = 1
p-hat = #DIV/0!
Test Statistic (TS) z= p-hat-po = #DIV/0! = #DIV/0!
√po(1 - p)/n #DIV/0!
p - value(1-tail) = #DIV/0!
p - value(2-tail) = #DIV/0!
T-crit (1-tail) = ######
T-crit (2-tail) = ######
Two sample z-test Template
n1 = n2 =
x-bar1 = x-bar2 =
s1 = s2 =
tobs = #DIV/0!
p-value(1) = #DIV/0!
p-value(2) = #DIV/0!
alpha = 1.00%
t-crit (1-tail) = 2.326
t-crit (2-tail) = 2.576
Large -Sample Test for difference between 2 Population Proportion
1 2
Sample size n = p - hat (pooled) = (x1 + x2)/(n1 + n2) = 0/ 0
No. Successes (x)= = #####
p-hats = #DIV/0! #DIV/0!
z= p1 - p2 = #DIV/0! = Z TS = #####
√ p(1-p) (1/n1 + 1/n2) #DIV/0!
alpha =
alpha/2 = 0.00%
p-value (1 tail) = #DIV/0!
p-value (2 tail) = #DIV/0!
t-critical (1-tail) = ########
t-critical (2-tail) = ########
Two sample t-test Template for BUSN 5760
F-test for sigma1 = sigma2
n1 = n2 = -1 Fobs Fc
x-bar1 = x-bar2 = -1 #DIV/0! #NUM!
s1 = s2 =
sp = 0
tobs = #DIV/0!
p-value(1) #DIV/0!
p-value(2) #DIV/0!
alpha =
t-crit (1-tail) = #NUM!
t-crit (2-tail) = #NUM!
Chi-square Template
Allows one to calculate the Chi-square statistic for an mxn cell contingency table
no. of rows = 0 (b/w 2 and 6) alpha =
no. of columns = 0 (b/w 2 and 5)
Observed counts
Dems Reps Inds Col 4 Col 5
Good 0
Bad 0
No Opinion 0
Row4 0
Row5 0
Row6 0
0 0 0 0 0 0
Expected counts
Col 1 Col 2 Col 3 Col 4 Col 5
Row1 1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
Row2 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
Row3 3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
Row4 4 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
Row5 5 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
Row6 6 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
0 0 0 0 0 0
Col 1 Col 2 Col 3 Col 4 Col 5
1 0 0 0 0 0 0
2 0 0 0 0 0 0
3 0 0 0 0 0 0
4 0 0 0 0 0 0
5 0 0 0 0 0 0
6 0 0 0 0 0 0
0 0 0 0 0 0
Chi-sq observed = 0
Chi-sq(crit) = #NUM!
p-value = 1
Decision: #NUM!
Titles Columns
Rows Dems Reps Inds
Good
Bad
No Opinion
ANOVA Template for BUSN 5760
Number of Treatment Levels (up to 7) = 0
1 2 3 4 5 6 7
n
x-bar
s
SSwg i 0.0000 0.0000 0.0000 0.0000
Total SSwg 0.00
MSwg #DIV/0! (Standard error within groups) = #DIV/0! 0
#DIV/0!
X-barT #DIV/0! #DIV/0!
SSbg #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
TSSbg #DIV/0!
MSbg #DIV/0! **You may enter whatever you want to the right
alpha = of column H. The small 3X10 calculator pad to
the right may be used to calculate the number
Fobs #DIV/0! of observations, the mean of the samples, and
Fc #NUM! their standard deviations for samples of ten or
p-value = #DIV/0! less.
Decision: #DIV/0!
0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Pop 1 Pop 2 Pop 3
Can one conclude that the population means differ? [Let α = .01]
2 Given the data below calculate the OLS regression line for Y on X.
X Y
10 46
12 40
13 36
15 29
15 24
Simple regression Template for BUSN 5760 #DIV/0!
#DIV/0!
Number of observations (up to 20) = 0
Obs X Y X-Xbar (x) Y-Ybar (y) xy x^2 Y-hat e-hat e-hat^2 y^2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
#### #### 0 0 0 0 0 0 0 0 0
SSE SST
b-hat = #DIV/0! R^2 = #DIV/0!
a-hat = #DIV/0! r= #DIV/0!
Y-hat = #DIV/0! + #DIV/0! X F(obs) = #DIV/0!
t(obs) = #DIV/0!
se = 0 F(prob) = #DIV/0!
OLS Regression Line sb-hat = #DIV/0!
4 α= tobs = #DIV/0!
3.5 tc (2-tail)= #NUM!
3 tc (1-tail)= #NUM!
2.5
2
Y
1.5 t-prob (2-tail) = #DIV/0!
1 t-prob (1-tail) = #DIV/0!
0.5
0
10 11 12 13 14 15
X
