Kardi Teknomo
Kardi Teknomo Kardi Teknomo Kardi Teknomo
   
 
Research
Publications
Tutorials
Resume
Personal
Resources
Contact

 

Visit Tutorials below:
Adaptive Learning from Histogram
Adjacency matrix
Analytic Hierarchy Process (AHP)
ArcGIS tutorial
Arithmetic Mean
Bayes Theorem
Bootstrap Sampling
Bray Curtis Distance
Break Even Point
Chebyshev Distance
City Block Distance
Conditional Probability
Continued Fraction
Data Analysis from Questionnaire
Data Revival from Statistics
Decimal to Rational
Decision tree
Difference equations
Digital Root
Discriminant analysis
Divisibility
Eigen Value using Excel
Euclidean Distance
Euler Integration
Euler Number
Excel Iteration
Excel Macro
Excel Tutorial
Feasibility Study
Financial Analysis
Generalized Inverse
Generalized Mean
Geometric Mean
Ginger Bread Man and Chaos
Graph Theory
Growth Model
Hamming Distance
Harmonic Mean
Hierarchical Clustering
Independent Events
Incident matrix
Jaccard Coefficient
Kernel basis function
Kernel Regression
k-Means clustering
K Nearest Neighbor
LAN Connections Switch
Learning from data
Lehmer Mean
Linear Algebra
Logarithm Rules
Mahalanobis Distance
Market Basket Analysis
Mean Absolute Deviation
Mean and Average
Mean, median, mode
Minkowski Distance
Minkowski Mean
Monte Carlo Simulation
Multi Agent System
Multicriteria decision making
Mutivariate Distance
Newton Raphson
Non-Linear Transformation
Normalization Index
Normalized Rank
Ordinary Differential Equation
Page Rank
Palindrome
PI
Power rules
Prime Factor
Prime Number
Q Learning
Quadratic Function
Queueing Theory
Rank Reversal
Recursive Statistics
Regression Model
Reinforcement Learning
Root of Polynomial
Runge-Kutta
Scenario Analysis
Sierpinski gasket
Sieve of Erastosthenes
Similarity and Distance
Solving System Equation
Standard deviation
String Distance
Summation Tricks
Support Vector Machines
System dynamic
Time Average
Tower of Hanoi
Variance
Vedic Square
Visual Basic (VB) tutorial
What If Analysis

Regression Model Using Microsoft Excel

by Kardi Teknomo

Share this: Google+

<| Next>

This tutorial is an introduction to regression model using MS Excel. You will learn how to model you data, find the best-fit model and use graph, functions and Add Ins wizard in MS excel to automate the regression. You will also learn how to solve regression using generalized inverse matrix. You may download the spreadsheet example of this tutorial here.

Using Microsoft Excel, you have at least five methods to compute linear regression

Using Excel function
Using Data Analysis Add Ins
Using MS Excel Graph trend Analysis
Using MS Excel matrix function
Using MS Excel Spreadsheet for manual computation

Excel function is very handy. If your data change dynamically, the result of regression will change immediately. Data analysis has advantage to compute the statistical criteria such as R square, ANOVA and t statistics plus probability plots of outlier. Excel Graph trend analysis is very good for plotting the graph of linear and several non-linear models (exponential, logarithm, power and polynomial), the update is also dynamic according to your data change.

Using matrix formulation and MS excel matrix function you may learn how to compute regression in matrix model. Together with using spreadsheet for manual computation, both methods have educational advantage to explain the formula of regression.

Click any topics below to enter the tutorial:

What is regression model?
How can we be sure that the best line is linear?
Hand Calculation Example of Linear Regression
Using MS Excel Function for Linear Regression Analysis
Using MS Excel Data Analysis Add-Ins for Linear Regression
Using MS Excel Graph Trend Analysis
Generalizes Inverse Matrix to Solve Regression Problem
Ordinary Least Square Method

See also: Data analysis from Questionnaire, Learning from Data, Kernel regression, Nonlinear Transformation

<| Next>

Rate this tutorial

Share and save this tutorial
Add to: Del.icio.us  Add to: Digg  Add to: StumbleUpon   Add to: Reddit   Add to: Slashdot   Add to: Technorati   Add to: Netscape   Add to: Newsvine   Add to: Mr. Wong Add to: Webnews Add to: Icio Add to: Folkd Add to: Yigg Add to: Linkarena Add to: Simpy Add to: Furl Add to: Yahoo Add to: Google Add to: Blinklist Add to: Blogmarks Add to: Diigo Add to: Blinkbits Add to: Ma.Gnolia Information

Preferable reference for this tutorial is

Teknomo, Kardi. Regression Model using Microsoft Excel. http:\\people.revoledu.com\kardi\ tutorial\Regression\

 

This tutorial is copyrighted.




 
© 2006 Kardi Teknomo. All Rights Reserved.
Designed by CNV Media