Regression

-

                                                Regression
Ins statistical modeling, regression analysis is a set of statistical processes for estimating the relationships among variables. It includes many techniques for modeling and analyzing several variables, when the focus is on the relationship between a dependent variable and one or more independent variables (or 'predictors'). More specifically, regression analysis helps one understand how the typical value of the dependent variable (or 'criterion variable') changes when any one of the independent variables is varied, while the other independent variables are held fixed.

·                 Regression analysis is widely used for prediction and forecasting
·          Regression analysis can be used to infer causal effect relationships between the independent and dependent           variables. However this can lead to illusions or false relationships, so caution is advisable.

 Types of Regression
The two basic types of regression are linear regression and multiple linear regression, although there are non-linear regression methods for more complicated data and analysis. Linear regression uses one independent variable to explain or predict the outcome of the dependent variable Y, while multiple regression uses two or more independent variables to predict the outcome.
Regression can help finance and investment professionals as well as professionals in other businesses. Regression can help predict sales for a company based on weather, previous sales, GDP growth or other conditions. The capital asset pricing model (CAPM) is an often-used regression model in finance for pricing assets and discovering costs of capital. The general form of each type of regression is;
·         Linear Regression: Y = a + bX
·         Multiple Regression: Y = a + b1X1 + b2X2 + b3X3 + ... + btXt + u
Where:
Y = the variable that you are trying to predict (dependent variable)
X = the variable that you are using to predict Y (independent variable




Linear regression Microsoft excel; steps
Step 1; install the data analysis Toolpak
Step 2; type your data in two columns in excel. For example, type your x data into column A and your y data in column B. do not leave any blank cell between your entries.
Step 3; click data analysis tab on excel toolbar.
Step 4; click regression in the pop up window and then click ok.
Step 5; select your input x range by selecting the data in the worksheet or typing the location in your data into x range box. For example, if your x data is in A2 through A10 then type A2:A10 in to the x output range box.
Step 6; selecting your input y range box by selecting the data in the worksheet or typing the location in your data into y range box.
Step 7; select your location where you are want your output range to go by selecting to the data in to the worksheet or typing the location of where you want your data go in the output range box.
Step 8; click ok excel will calculate linear regression and populate your worksheet with the result.
 





Comments

Post a Comment

Popular posts from this blog

TEACHER EDUCATION AND NEW EDUCATION POLICY

-
TEACHER EDUCATION Teacher education is vital in creating a pool of schoolteachers that will shape the next generation. Teacher preparation is an activity that requires multidisciplinary perspectives and knowledge, formation of dispositions and values, and development of practice under the best mentors. Teachers must be grounded in Indian values, languages, knowledge, ethos, and traditions including tribal traditions, while also being well-versed in the latest advances in education and pedagogy. According to the Justice J. S. Verma Commission (2012) constituted by the Supreme Court, a majority of stand-alone TEIs - over 10,000 in number are not even attempting serious teacher education but are essentially selling degrees for a price. Regulatory efforts so far have neither been able to curb the malpractices in the system, nor enforce basic standards for quality, and in fact have had the negative effect of curbing the growth of excellence and innovation in the sector. The sector and i...
Read more

AREAS OF PHILOSOPHY

-
AREAS OF PHILOSOPHY Metaphysics Metaphysics is the branch of philosophy that considers the physical universe and the nature of ultimate reality. It asks questions like, what is real? What is the origin of the world? What is beyond the stars? Your consideration of reality as an external creation or an internal construct can influence your metaphysical beliefs and perspectives and your teaching. Regardless of your definition of reality, the exploration and categorization of the physical universe form the foundation of several school subjects. Epistemology Epistemology is the branch of philosophy that considers how people come to learn what they know. Derived from the Greek word episteme, meaning knowledge or understanding, epistemology refers to the nature and origin of knowledge and truth. Epistemology proposes that there are four main bases of knowledge: divine revelation, experience, logic and reason, and intuition. These influence how teaching, learning, and understanding c...
Read more

INTERDISCIPLINARY NATURE OF EDUCATION

-
INTERDISCIPLINARY NATURE OF EDUCATION Philosophy and Education Human life cannot properly be understood without philosophy. Life and education are inseparably connected. One cannot be separated from the other. Hence, life has a philosophical base and so education also has a philosophical base. Philosophy furnishes the goals of life and education gives the means to achieve those goals. Man is the common subject of both philosophy and education. Philosophy and education are interrelated, interdependent, identical and inseparable from each other. Every philosopher has an educational outlook and every educator has a philosophy of life. The truths and principle established by philosophy are applied in the conduct of education process. Philosophy exercises tremendous influence on education in all its aspects—aims, curriculum, methods, teachers, textbooks, administration, discipline, evaluation etc. There is no aspect of education, which is not influenced and determined by philoso...
Read more