• LOGIN
  • No products in the cart.

Excel Analytics - Linear Regression Analysis in MS Excel

4.7( 9 REVIEWS )
1 STUDENTS

Overview

Are you looking to enhance your linear regression analysis proficiency to help boost your career prospects? Building a satisfying career can be a lifelong process but if you want to gain a competitive edge in your job search, look no further!

With this Excel Analytics – Linear Regression Analysis in MS Excel course, you will build the solid foundation you need to kickstart a successful career in the linear regression analysis industry.

The course covers the essential things you need to know to boost your career within the linear regression analysis. It provides you with the ability to improve your earning potential.

Covering everything you need to know to boost your career within linear regression analysis, this industry recognised certification includes 25 comprehensive bite-sized modules that you can learn in your own time, pace and environment. Complete your course and earn your qualification in just 2 hours 31 minutes with dedicated online support you can trust and rely on.


Why Learn With Queen Mary Academy?

  • 50,000+ students worldwide
  • Start a new career or advance your current one & land your dream job
  • Most in-demand skills for today’s job market
  • Award-winning Customer Support
  • Partnered with biggest accreditors in the world

Benefits You Will Gain

  • No hidden fees.
  • 24/7 access to the Learning Portal.
  • Receive the UK and globally recognised certificate on completion of the course.
  • Qualified tutor support and exceptional customer service.
  • Access the Learning Portal whenever you want 
  • Learn from industry-leading experts.

Who is this course for?

Whether you are looking to enhance your employment prospects, boost your CV with essential skills or climb the career ladder to a higher position, this Excel Analytics – Linear Regression Analysis in MS Excel course will work as an initial step towards earning an internationally-recognised qualification that could prove invaluable for your career.

This Excel Analytics – Linear Regression Analysis in MS Excel course has been designed for learners who are looking to gain the skills and credentials to fast track a fulfilling career in linear regression analysis.


Entry Requirement

The Excel Analytics – Linear Regression Analysis in MS Excel course is for learners of all levels, with no specific enrolment requirements; all you need is the commitment to learn, knowledge of the English language, and basic numeracy and IT skills. Students must be over the age of 16.


Certification

Once you have successfully completed the Excel Analytics – Linear Regression Analysis in MS Excel course, you will receive an accredited certificate from Queen Mary Academy as validation of your new skills. Certification is available in PDF format, at the cost of £12, or a hard copy can be sent via post at the cost of £27.


Career path

On successful completion of the Excel Analytics – Linear Regression Analysis in MS Excel course, learners will have the knowledge, skills and credentials to enter the relevant job market, with the confidence to explore a wide range of industry-related professions. Students will be able to add this qualification to their CV/resume, giving them a head start in their chosen field.

 

Course Curriculum

Getting Data Ready for Regression Model
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
Creating Multiple Linear Regression model 00:07:00
The F – statistic 00:08:00
Interpreting results of Categorical variables 00:05:00
Creating Multiple Linear Regression model 00:07:00
Excel: Running Linear Regression using Solver 00:08:00
What-if analysis
Transportation Problem in Excel using Goal Seek 00:12:00
Order Your Certificate Now

Course Reviews

4.7

4.7
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Excel Analytics - Linear Regression Analysis in MS Excel
TAKE THIS COURSE

Instructors

1 STUDENTS ENROLLED

14 Days Money Back Guarantee

© Queenmary Academy. All rights reserved.
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
course