Manuals/calci/ZTESTTWOSAMPLEFORMEANS - Revision history

Devika: /* Examples */

2020-09-07T09:46:45Z

Examples

Devika: /* See Also */

2018-12-06T20:58:05Z

Devika at 22:33, 10 August 2018

2018-08-10T22:33:49Z

Devika at 20:14, 13 June 2018

2018-06-13T20:14:24Z

Devika: /* Description */

2017-03-23T19:14:15Z

Description

Devika at 19:12, 23 March 2017

2017-03-23T19:12:29Z

Devika: Created page with "ztest"

2017-03-22T19:18:04Z

Created page with "ztest"

New page

ztest

@@ Line 88: / Line 88: @@
 | 10 || 110.02
 |}
-#=ZTESTTWOSAMPLEFORMEANS(A1:A18,B1:B19,641.8474654,630.283176,0,0.5)
+#=ZTESTTWOSAMPLEFORMEANS(A1:A19,B1:B19,641.8474654,630.283176,0,0.5)
 {| class="wikitable"
@@ Line 115: / Line 115: @@
 |z CRITICAL TWO-TAIL||	0.6744897501960817
 |}
 ==Related Videos==

← Older revision		Revision as of 20:58, 6 December 2018
Line 116:		Line 116:
	\|}		\|}

		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|v=QWM-RiSB1To\|280\|center\|ZTESTTWOSAMPLEFORMEANS}}

	==See Also==		==See Also==

@@ Line 5: / Line 5: @@
 *<math>Alpha</math> is the significance level.
 *<math>NewTableFlag</math> is the logical value.
 ==Description==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ZTESTTWOSAMPLEFORMEANS (Array1,Array2,KnownVariance1,KnownVariance2,HypothesizedMeanDifference,Alpha,NewTableFlag)'''</div><br/>
+<div style="font-size:20px">'''ZTESTTWOSAMPLEFORMEANS (Array1,Array2,KnownVariance1,KnownVariance2,HypothesizedMeanDifference,Alpha,NewTableFlag)'''</div><br/>
 *<math>Array1</math> and  <math>Array2</math>  are  array of values.
 *<math>KnownVariance1</math>  and <math>KnownVariance2</math>  are value of variances.

@@ Line 13: / Line 13: @@
 .Both populations are normally distributed or both sample sizes are large enough that the means are normally distributed.
 *In <math> ZTESTTWOSAMPLEFORMEANS(Array1,Array2,KnownVariance1,KnownVariance2,HypothesizedMeanDifference,Alpha,NewTableFlag)</math>,<math> Array1 </math> and <math>Array2</math> are the set of values,<math>KnownVariance1</math> is the variance of <math>Array1</math>,<math>KnownVariance2</math> is the variance of <math>Array2</math>.
-*<math> HypothesizedMeanDifference </math>  is the Hypothesized Mean Difference. If testing is for equal means,then <math>md = 0</math>.
+*<math> HypothesizedMeanDifference </math>  is the Hypothesized Mean Difference. If testing is for equal means,then <math>Hypothesized mean difference  = 0</math>.
 *<math>Alpha</math> is the significance level which ranges from 0 to 1.
 *<math>NewTableFlag</math> is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.

← Older revision		Revision as of 19:12, 23 March 2017
Line 1:		Line 1:
−	~~ztest~~	+	<div style="font-size:30px">'''ZTESTTWOSAMPLEFORMEANS (Array1,Array2,KnownVariance1,KnownVariance2,HypothesizedMeanDifference,Alpha,NewTableFlag)'''</div><br/>
		+	*<math>Array1</math> and <math>Array2</math> are array of values.
		+	*<math>KnownVariance1</math> and <math>KnownVariance2</math> are value of variances.
		+	*<math>HypothesizedMeanDifference</math> is the Hypothesized Mean Difference.
		+	*<math>Alpha</math> is the significance level.
		+	*<math>NewTableFlag</math> 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 <math> ZTESTTWOSAMPLEFORMEANS(Array1,Array2,KnownVariance1,KnownVariance2,HypothesizedMeanDifference,Alpha,NewTableFlag)</math>,<math> Array1 </math> and <math>Array2</math> are the set of values,<math>KnownVariance1</math> is the variance of <math>Array1</math>,<math>KnownVariance2</math> is the variance of <math>Array2</math>.
		+	*<math> HypothesizedMeanDifference </math> is the Hypothesized Mean Difference. If testing is for equal means,then <math>md = 0</math>.
		+	*<math>Alpha</math> is the significance level which ranges from 0 to 1.
		+	*<math>NewTableFlag</math> is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.
		+	*Suppose we are omitted the <math>lv</math> value it will consider the value as FALSE.
		+	*ZTEST two sample for means is calculated by:<math> z=\frac{\bar{x_1}-\bar{x_2}-\Delta}{\sqrt{\frac{\sigma_1^2}{n_1}+\frac{\sigma_2^2}{n_2}}}</math>
		+	where <math>\bar{x_1}</math> and <math>\bar{x_2}</math> are average of two samples, <math>\Delta</math> is the Hypothesized Mean Difference between two means of the population. <math>\sigma_1</math> and <math>\sigma_2</math> are the standard deviation of two population. <math>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
		+
		+	==Examples==
		+	#'''Example 1'''
		+	{\| class="wikitable"
		+	\|+Spreadsheet
		+	\|-
		+	! !! A !! B
		+	\|-
		+	! 1
		+	\| 70.25 \|\| 90.02
		+	\|-
		+	! 2
		+	\| 82.87 \|\| 89.45
		+	\|-
		+	! 3
		+	\| 90.17 \|\| 70.89
		+	\|-
		+	! 4
		+	\| 45.55 \|\| 107.91
		+	\|-
		+	! 5
		+	\| 51.98 \|\| 59.09
		+	\|-
		+	! 6
		+	\| 21.28 \|\| 45.03
		+	\|-
		+	! 7
		+	\| 39.04 \|\| 56.08
		+	\|-
		+	! 8
		+	\| 40.47 \|\| 91
		+	\|-
		+	! 9
		+	\| 30.02 \|\| 40.41
		+	\|-
		+	! 10
		+	\| 100.05 \|\| 29.04
		+	\|-
		+	! 11
		+	\| 86.1 \|\| 37.79
		+	\|-
		+	! 12
		+	\| 72.49 \|\| 41.07
		+	\|-
		+	! 13
		+	\| 29.54 \|\| 52.04
		+	\|-
		+	! 14
		+	\| 38.76 \|\| 60.78
		+	\|-
		+	! 15
		+	\| 47.01 \|\| 66.06
		+	\|-
		+	! 16
		+	\| 50.65 \|\| 78.01
		+	\|-
		+	! 17
		+	\| 55.91 \|\| 41.22
		+	\|-
		+	! 18
		+	\| 102.7 \|\| 33.99
		+	\|-
		+	! 19
		+	\| 10 \|\| 110.02
		+	\|}
		+	#=ZTESTTWOSAMPLEFORMEANS(A1:A18,B1:B19,641.8474654,630.283176,0,0.5)
		+
		+	{\| class="wikitable"
		+	\|+Result
		+	\|-
		+	\|+z-TEST: TWO SAMPLE FOR MEANS
		+	\|-
		+	! !! VARIABLE1 !!VARIABLE2
		+	\|-
		+	\|MEAN \|\| 56.04421052631579\|\|63.152631578947364
		+	\|-
		+	\| KNOWN VARIANCE \|\| 641.8474654\|\|630.283176
		+	\|-
		+	\|OBSERVATIONS \|\|19\|\|19
		+	\|-
		+	\| HYPOTHESIZED MEAN DIFFERENCE \|\|0
		+	\|-
		+	\|z VALUE \|\|-0.8687285374505475
		+	\|-
		+	\| P(T<=+t) ONE-TAIL\|\| 0.1924981032229391
		+	\|-
		+	\|z CRITICAL ONE-TAIL \|\| 0
		+	\|-
		+	\|P(T<=t) TWO-TAIL \|\|0.3849962064458782
		+	\|-
		+	\|z CRITICAL TWO-TAIL\|\| 0.6744897501960817
		+	\|}
		+
		+
		+	==See Also==
		+	*[[Manuals/calci/ZTEST\| ZTEST]]
		+	*[[Manuals/calci/TTEST\| TTEST]]
		+	*[[Manuals/calci/TINV\| TINV]]
		+
		+	==References==
		+	*[http://www.cliffsnotes.com/math/statistics/univariate-inferential-tests/two-sample-z-test-for-comparing-two-means Ztest Comparing two means]