Cademy logoCademy Marketplace

Course Images

Linear Regression Analysis in Microsoft Excel

Linear Regression Analysis in Microsoft Excel

By Study Plex

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • All levels

Description

Recognised Accreditation

This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.

The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.

What is CPD?

Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements.

Benefits of CPD

  • Improve your employment prospects
  • Boost your job satisfaction
  • Promotes career advancement
  • Enhances your CV
  • Provides you with a competitive edge in the job market
  • Demonstrate your dedication
  • Showcases your professional capabilities

What is IPHM?

The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill.

Benefits of IPHM

  • It will help you establish a positive reputation in your chosen field
  • You can join a network and community of successful therapists that are dedicated to providing excellent care to their client
  • You can flaunt this accreditation in your CV
  • It is a worldwide recognised accreditation

What is Quality Licence Scheme?

This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.

Benefits of Quality License Scheme

  • Certificate is valuable
  • Provides a competitive edge in your career
  • It will make your CV stand out

Course Curriculum

Getting Data Ready for Regression Model
Transportation Problem in Excel using Goal Seek 00:12:00
Gathering Business Knowledge 00:03:00
Data Exploration 00:03:00
The Data and the Data Dictionary 00:07:00
Univariate analysis and EDD 00:03:00
Discriptive Data Analytics in Excel 00:10:00
Outlier Treatment 00:04:00
Identifying and Treating Outliers in Excel 00:04:00
Missing Value Imputation 00:03:00
Identifying and Treating missing values in Excel 00:04:00
Variable Transformation in Excel 00:03:00
Dummy variable creation: Handling qualitative data 00:04:00
Dummy Variable Creation in Excel 00:07:00
Correlation Analysis 00:09:00
Creating Correlation Matrix in Excel 00:08:00
Creating Regression Model
The Problem Statement 00:01:00
Basic Equations and Ordinary Least Squares (OLS) method 00:08:00
Assessing accuracy of predicted coefficients 00:14:00
Assessing Model Accuracy: RSE and R squared 00:07:00
Creating Simple Linear Regression model 00:02:00
Multiple Linear Regression 00:05:00
The F - statistic 00:08:00
Interpreting results of Categorical variables 00:05:00
Creating Multiple Linear Regression model 00:07:00
What-if analysis
Excel: Running Linear Regression using Solver 00:08:00
Assessment
Assessment - Linear Regression Analysis In MS Excel 00:10:00
Certificate of Achievement
Certificate of Achievement 00:00:00
Get Your Insurance Now
Get Your Insurance Now 00:00:00
Feedback
Feedback 00:00:00

About The Provider

Study Plex
Study Plex
Birmingham
Study Plex is a company focused on providing a range of learning and development opportunities, to entertain and educate our learner base through the use of modern learning technology.
Read more about Study Plex

Tags

Reviews

+ Add Review