Advertisements   
   

Using Excel for Linear Regression

Advertisements   
   

 Using Excel for Linear Regression   Free Tutorial Download

Prerequisites

  • Basic familiarity with Excel

Description

Regression is an important statistical tool. Using regression, we can detect and quantify relationships within a data set. For example, you have a data set of truck distances driven and stops made. Using this information, we can construct an equation which allows prediction of duration given distance number of stops. This would be of great use to anyone having to give out quotes.

I show you how to check whether your regression actually works and how accurate it is.

Advertisements   
   

Indicator or ‘dummy’ variables are an important source of information, and I show you how to convert textual data into dummy variables for inclusion in the regression analysis. We know how long repair jobs take and months since last service. Does including information about whether the job was electrical or mechanical make predicted repair time any more accurate?

Sales go up at certain seasons: being able to measure those increases and predict them is highly useful.

We also cover elasticity, a topic often missed out in regression courses. Using elasticity, we can predict the effect on sales volume in precent of a percent change in selling price.

I provide detailed explanations and provide the datasets so that you can follow along.

The pace of the course is measured and step by step, each section building on the last. The datasets I use in the examples are included so that you can run your own regressions and compare results.

Who is this course for?

  • Beginning statisticians

Using Excel for Linear Regression, Free Tutorials Download

 

Download  Using Excel for Linear Regression  Free

Go to Download Tutorials Page Go to HomePage Tutorials

Password : freetuts.download

Author: Ho Quang Dai

I am Ho Quang Dai, from Vietnam – A country that loves peace. I share completely free courses from major academic websites around the world. Hope to bring free knowledge to everyone who can’t afford to buy


Related Courses

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments

Report Link Die

Please provide the most detailed information, we will re-upload as soon as possible