[ FreeCourseWeb.com ] Using Excel for Linear Regression
Download More Courses Visit and Support Us -->> https://FreeCourseWeb.com
Created by Stephen Peplow | Last updated 3/2021
Duration: 1h 50m | 12 sections | 13 lectures | Video: 1280x720, 44 KHz | 888 MB
Genre: eLearning | Language: English + Sub
How to quantify relationships within data using Excel
What you'll learn
Use Excel to quantify relationships within data
Requirements
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 quotations.\n\nI show you how to check whether your regression actually works and how accurate it is. \n\nIndicator 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? \n\nSales go up at certain seasons: being able to measure those increases and predict them is highly useful. \n\nWe 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. \n\nI provide detailed explanations and provide the datasets so that you can follow along. \n\nThe 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 this course is for:Beginning statisticians
Use Winrar to Extract. And use a shorter path when extracting, such as C: drive
ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)
Download More Courses Visit and Support Us -->> https://FreeCourseWeb.com
Get More Tutorials and Support Us -->> https://DevCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
