Skip to content

Mission 5 - Non-Linear Regressions

Estimated time for completing this mission: 10 mins

Learning Objective

Further exploring the capabilities of regression in LOGIBLOX using prepared Dataset.

Scenario

In the previous mission you created a linear regression model, i.e. of first degree in the input variables. Now you feel that you should improve the accuracy of the regression model and graph.

Know-How Refresh

Aiming for better accuracy can be achieved by changing the degree of the regression. The higher the degree the more curvy the regression curve will be, and thus the better it can fit the data.

BLOX used in this mission:

  • Basics/Start
  • MyData/FinalData
  • Database/ First Rows
  • Database/Group By
  • AI/Regression Model
  • Charts/Chart Dataset
  • Charts/Multi Chart
  • Basics/Display

startBlox

BLOX used for this mission

Data

In this mission we will use the prepared dataset from the previous section.

If you can not create it, here is a link for the dataset FinalData.xlsx

How To Guide

Please refer to the Navigation Guide to perform the steps below

  1. You will be working in the same logic sheet as in the previous mission
  2. Now copy the logic from the previous mission
  3. Next in the "Regression Model" BLOX try out different polynomial degrees to see how the accuracy changes (Remember, that higher "Exponential Degree" makes the regression line more curvy, which in many cases could lead to better accuracy)

Results and Summary

startBlox

Final logic composition

startBlox

Linear regression with 200 rows with fifth power exponential (accuracy: 18%)

Now you should see the regression in the "Display" BLOX, representing the regression calculated based on the provided data.

Well done! Now let's move on to the next mission!