# Large Square Template - Excel

W
Description

Large Square Template document sample

Shared by:
Categories
-
Stats
views:
11
posted:
6/30/2011
language:
English
pages:
46
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
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
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

Other docs by txq96420
Lease Accounting in India
Landscaping Contract Documents
Laser Tags Template
Learn Bank Work