|
|
Line 25: |
Line 25: |
| and ar2 are array of values, and v2 , , and | | and ar2 are array of values, and v2 , , and |
| | | |
| + | ==Trial1== |
| | | |
− | | + | <math>\bar{x_1}</math> and <math> \bar{x1} </math> |
− | | |
− | | |
− | | |
− | <div id="6SpaceContent" class="zcontent" align="left"> | |
− | | |
− | '''ZTESTTWOSAMPLEFORMEANS('''Array1, Array2, Variance1, Variance2, Alpha, NewTableFlag)
| |
− | | |
− | where,
| |
− | | |
− | '''Array1 '''- Input range should be one block.
| |
− | | |
− | '''Array2 '''- Input range should be one block.
| |
− | | |
− | '''Variance1 '''- Input range should be one block.
| |
− | | |
− | '''Variance2 '''- Input range should be one block.
| |
− | | |
− | '''HypothesizeDiff '''- represents the Hypothesized Mean Difference.A value 0 indicates that sample means are hypothesized to be equal.
| |
− | | |
− | '''Alpha '''- represents the significance level and value in range 0 to 1.
| |
− | | |
− | ''' ''''''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.</div>
| |
− | ----
| |
− | <div id="1SpaceContent" class="zcontent" align="left">T-Test: Two Sample for unequal variances determines whether two sample means are distinct.</div>
| |
− | ----
| |
− | <div id="7SpaceContent" class="zcontent" align="left">
| |
− | | |
− | Lets see an example in (Column4Row5)
| |
− | | |
− | UNIQbb01b3076906c32b-nowiki-00000004-QINU
| |
− | | |
− | ZTESTTWOSAMPLESFORMEANS returns the result in new sheet(5Space).
| |
− | | |
− | UNIQbb01b3076906c32b-nowiki-00000005-QINU
| |
− | | |
− | ZTESTTWOSAMPLESFORMEANS returns the #ERROR(Alpha = -0.055).
| |
− | | |
− | </div>
| |
− | ----
| |
− | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
− | | |
− | Z-TEST : TWO SAMPLE FOR MEANS
| |
− | | |
− | </div></div>
| |
− | ----
| |
− | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
| |
− | ----
| |
− | <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
| |
− | ----
| |
− | <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
| |
− | ----
| |
− | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
| |
− | ----
| |
− | <div id="8SpaceContent" class="zcontent" align="left">
| |
− | | |
− | If the Alpha < 0 or Alpha >1, ZTESTTWOSAMPLEFORMEANS returns the #ERROR.
| |
− | | |
− | </div>
| |
− | ----
| |
− | <div id="2SpaceContent" class="zcontent" align="left">
| |
− | | |
− | {| id="TABLE3" class="SpreadSheet blue" | |
− | |- class="even"
| |
− | | class=" " |
| |
− | | Column1
| |
− | | Column2
| |
− | | class=" " | Column3
| |
− | | class=" SelectTD1 ChangeBGColor SelectTD1" |
| |
− | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>Column4 | |
− | |- class="odd"
| |
− | | class=" " | Row1
| |
− | | class=" " | 10
| |
− | | class=" " | 3
| |
− | | class=" " | 1
| |
− | | class=" " | 8
| |
− | |- class="even"
| |
− | | class=" " | Row2
| |
− | | class=" " | 7
| |
− | | class=" " | 8
| |
− | | class=" " | 2
| |
− | | class=" " | 9
| |
− | |- class="odd"
| |
− | | Row3
| |
− | | class=" " | 12
| |
− | | class=" " | 8
| |
− | | class=" " | 3
| |
− | | class=" " | 10
| |
− | |- class="even"
| |
− | | Row4
| |
− | | class=" " | 17
| |
− | | class=" " | 18
| |
− | | class=" " | 4
| |
− | | class=" " | 11
| |
− | |- class="odd"
| |
− | | class=" " | Row5
| |
− | | class=" " | 46
| |
− | | class=" " | 34
| |
− | | class=" SelectTD " |
| |
− | | class="sshl_f" | 5Space
| |
− | |- class="even"
| |
− | | Row6
| |
− | | class=" sshl_f" | 6
| |
− | | 7
| |
− | | class="sshl_f" | #ERROR
| |
− | | class=" " |
| |
− | |}
| |
− | | |
− | <div align="left">[[Image:calci1.gif]]</div></div>
| |
− | ----
| |
− | <div id="5SpaceContent" class="zcontent" align="left">
| |
− | | |
− | {| class="SpreadSheet blue" | |
− | |+ z-Test: Two Sample for Means<br />
| |
− | |- class="even"
| |
− | !
| |
− | ! Variable1
| |
− | ! Variable2
| |
− | |- class="odd"
| |
− | | Mean
| |
− | | 11.5
| |
− | | 9.25
| |
− | |- class="even"
| |
− | | Known Variance
| |
− | | 1,2,3,4
| |
− | | 8,9,10,11
| |
− | |- class="odd"
| |
− | | Observations
| |
− | | 4
| |
− | | 4
| |
− | |- class="even"
| |
− | | Hypothesized Mean Difference
| |
− | | 0
| |
− | |- class="odd"
| |
− | | z Value
| |
− | | NaN
| |
− | |- class="even"
| |
− | | P(T<=t) One-tail
| |
− | | 0
| |
− | |- class="odd"
| |
− | | z Critical One-tail
| |
− | | 1.6448536269514715
| |
− | |- class="even"
| |
− | | P(T<=t) Two-tail
| |
− | | 0
| |
− | |- class="odd"
| |
− | | z Critical Two-tail
| |
− | | 1.9599639845400536
| |
− | |}
| |
− | | |
− | </div> | |
− | ----
| |
ZTESTTWOSAMPLEFORMEANS(ar1,ar2,v1,v2,md,alpha,lv)
- and are array of values.
- and are value of variances.
- is the Hypothesized Mean Difference.
- is the significance level.
- is the logical value.
Description
- This function gives the z-test two sample for means.
- We can use this test when
1.The samples can be different sizes.
2.The two samples are independent.
3.Both populations are normally distributed or both sample sizes are large enough that the means are normally distributed.
- In , and are the set of values, is the variance of , is the variance of .
- is the Hypothesized Mean Difference. If testing is for equal means,then .
- is the significance level which ranges from 0 to 1.
- is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.
- Suppose we are omitted the value it will consider the value as FALSE.
- ZTEST two sample for means is calculated by:
where and Failed to parse (unknown function "\math"): {\displaystyle \bar{x_2}<\math> are average of two samples, <math>\Delta}
is the Hypothesized Mean Difference between two means of the population. and are the standard deviation of two population. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n_1 <\math> and <math> n_2 <\math> are the sizes of the samples. *This function will give the result as error when 1. any one of the argument is nonnumeric. 2. alpha>1 and ar2 are array of values, and v2 , , and ==Trial1== <math>\bar{x_1}}
and