How to Calculate Multi Linear Regression in Anaplan?

Options
ankurgupta
ankurgupta
in Academy Discussions

Hi team,

Could you please help me to know how to do Multi-Linear regression?

Answers

  • Dikshant
    Dikshant
    edited August 2023
    Options

    @ankurgupta

    Can you explain more on MLR. What is your exact use case?

  • ankurgupta
    ankurgupta
    Options

    Sure, I want to develop a Linear regression model to predict the Aluminum price based on input factors such as Fed Rate,Brent Crude Futures ($/Barrel),Coking Coal (CNY),Natural Gas,USD/CNY,EUR/USD,US inflation Rate (%),Primary Aluminium Production (Thousand MT),Baltic Dry Index.

    image.png

    I have historical data for all the factors with me. Could you guys help me to find the way to develop the linear regression equation in Anaplan ?

    @Dikshant

  • pyrypeura
    pyrypeura
    Options

    MLR in Anaplan can be quite demanding on understanding statistical calculations for one to be able to build. Here is an article on how to do MLR manually https://www.statology.org/multiple-linear-regression-by-hand/ . You would need to build something replicating this logic in Anaplan.

  • ankurgupta
    ankurgupta
    Options

    @pyrypeura

    In the given Link https://www.statology.org/multiple-linear-regression-by-hand/ It has explained the concept with two input variable. in case of more than 2 variable what would be the approach.

Categories