Manuals/calci/MULTIPLEREGRESSIONANALYSIS - Revision history

Devika at 19:19, 13 June 2018

2018-06-13T19:19:56Z

Jayaram at 07:32, 13 March 2017

2017-03-13T07:32:06Z

Devika: /* Examples */

2017-01-16T20:47:50Z

Examples

Devika: /* Examples */

2015-10-27T05:43:45Z

Examples

Devika: /* Examples */

2015-10-27T05:43:24Z

Examples

Devika: /* Examples */

2015-10-27T05:42:26Z

Examples

Swapna at 20:01, 18 July 2015

2015-07-18T20:01:27Z

Devika at 15:49, 12 May 2015

2015-05-12T15:49:22Z

Devika at 05:10, 8 May 2014

2014-05-08T05:10:15Z

Devika: /* Description */

2014-05-05T09:19:21Z

Description

@@ Line 1: / Line 1: @@
-<div style="font-size:25px">'''MULTIPLEREGRESSIONANALYSIS(yRange,xRange,ConfidenceLevel,LogicalValue)'''</div><br/>
+<div style="font-size:25px">'''MULTIPLEREGRESSIONANALYSIS(yRange,xRange,ConfidenceLevel,NewTableFlag)'''</div><br/>
 *<math>yRange</math> is the array of y-values.
 *<math>xrange</math> is the array of x-values.
 *<math>ConfidenceLevel</math> is the value betwen 0 and 1.
-*<math>LogicalValue</math> is either TRUE or FALSE.
+*<math>NewTableFlag</math> is either TRUE or FALSE.
 ==Description==

← Older revision		Revision as of 07:32, 13 March 2017
Line 139:		Line 139:
	==References==		==References==
	*[http://cameron.econ.ucdavis.edu/excel/ex61multipleregression.html Documentation of Excel for Multiple Regression Analysis]		*[http://cameron.econ.ucdavis.edu/excel/ex61multipleregression.html Documentation of Excel for Multiple Regression Analysis]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 69: / Line 69: @@
 |}
 *=MULTIPLEREGRESSIONANALYSIS(A1:A8,B1:C8,0.05,TRUE)
 ==Related Videos==

@@ Line 41: / Line 41: @@
 ! !! A !! B !! C
 |-
 | '''AGE''' || '''CHOLESTROL LEVEL''' ||'''SUGAR LEVEL'''
 |-

@@ Line 41: / Line 41: @@
 ! !! A !! B !! C
 |-
 | '''AGE''' || '''CHOLESTROL LEVEL''' ||'''SUGAR LEVEL'''
 |-
-!2
+!1
 | 58 || 189 || 136
 |-
-!3
+!2
 | 69 || 235 || 149
 |-
-!4
+!3
 | 43 ||198 || 165
 |-
-!5
+!4
 | 39 ||137 ||140
 |-
-!6
+!5
 | 63 || 178 || 162
 |-
-! 7
+!6
 | 52 || 160 || 152
 |-
-! 8
+! 7
 | 47 || 198 || 142
 |-
-! 9
+! 8
 | 31 || 183 || 129
 |}
-*=MULTIPLEREGRESSIONANALYSIS(A1:A9,B1:C9,0.05,TRUE)
+*=MULTIPLEREGRESSIONANALYSIS(A1:A8,B1:C8,0.05,TRUE)
 ==Related Videos==

← Older revision		Revision as of 20:01, 18 July 2015
Line 69:		Line 69:
	\|}		\|}

		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|SG-tokYEgX0\|280\|center\|Multiple Linear Regression}}

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

← Older revision		Revision as of 15:49, 12 May 2015
Line 68:		Line 68:
	\| 31 \|\| 183 \|\| 129		\| 31 \|\| 183 \|\| 129
	\|}		\|}
		+
		+
		+	==See Also==
		+	*[[Manuals/calci/LEVENESTEST\| LEVENESTEST]]
		+	*[[Manuals/calci/SIGNTEST\| SIGNTEST]]
		+	*[[Manuals/calci/MOODSMEDIANTEST\| MOODSMEDIANTEST]]
		+
		+	==References==
		+	*[http://cameron.econ.ucdavis.edu/excel/ex61multipleregression.html Documentation of Excel for Multiple Regression Analysis]

@@ Line 11: / Line 11: @@
 . Simple Regression.
 . Multiple Regression.
-*1.Simple Regression:(x_1,Y_1)(x_2,Y_2).......(x_n,Y_n).
+*1.'''Simple Regression''':<math>(x_1,Y_1)(x_2,Y_2).......(x_n,Y_n)</math>.
-*2.Multiple regression:((x1)_1,(x2)_1,(x3)_1.....(xK)_1,Y_1)
+*2.'''Multiple regression''':<math>({(x1)}_1,{(x2)}_1,{(x3)}_1.....{(xK)}_1,Y_1)
-                   ((x1)_2,(x2)_2,(x3)_2....(xK)_2,Y_2).......
+                                   ({(x1)}_2,{(x2)}_2,{(x3)}_2....{(xK)}_2,Y_2).......
-                 ((x1)_n,(x2)_n,(x3)_n.....(xK)_n,Y_n).
+                                   ({(x1)}_n,{(x2)}_n,{(x3)}_n....{(xK)}_n,Y_n)</math>.
 *The only difference between Simple Regression and Multiple Regression is there where one preditor or many.
 *i.e., The difference is depending of the x-value.
@@ Line 20: / Line 20: @@
 *The Predictor x is indicated as the "Independent Variable" .
 *The output of a Regression statistics is of the form :
-*Simple Regression Y(cap)=b_0+b_1x.
+*Simple Regression:<math>\hat Y = b_0+b_1x</math>.
-*Multiple Regression Y(cap)=b_0+b_1(x1)+b_2(x2)+......+b_K(xK).
+*Multiple Regression:<math>\hat Y = b_0+b_1(x1)+b_2(x2)+......+b_K(xK)</math>.
 *This analysis give the result in three table values.
 .Regression statistics table.
 .ANOVA table.
 .Residual output.
-.Regression statistics :  It contains multiple R, R Square, Adjusted  R Square,  Standard Error and observations. R square gives the fittness of the data with the regression line.
+*1.'''Regression statistics''' :  It contains multiple R, R Square, Adjusted  R Square,  Standard Error and observations. R square gives the fittness of the data with the regression line.
 *That value is closer to 1 is  the better the regression line  fits the data.
 *Standard Error refers to the estimated standard deviation of the error term.
 *It is called the standard error of the regression.
-*2.ANOVA table:  ANOVA is the analysis of variance. This table splits in to two components which is Residual and Regression.
+*2.'''ANOVA table''':  ANOVA is the analysis of variance. This table splits in to two components which is Residual and Regression.
 *Also this table gives the probability, T stat, significance of F and P for the each and every set of the data points.
-*3. Residual output: The residuals show you how far away the actual data points are fom the predicted data points.
+*3.'''Residual output''': The residuals show you how far away the actual data points are fom the predicted data points.
 *This table is displaying the values of Predicted data, Standard Residuals and Percentile value of the Y-value.