• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Linear Regression Analysis in Microsoft Excel

Linear Regression Analysis in Microsoft Excel

  • 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