Regression Analysis with MS Excel

Поділитися
Вставка
  • Опубліковано 23 бер 2019
  • Learn a simple technique to carry out simple regression analysis in MS Excel and WPS Spreadsheet. An easy method to calculate intercept and beta coefficient or slope

КОМЕНТАРІ • 16

  • @randyzeroth4098
    @randyzeroth4098 Рік тому +4

    Excellent video for doing regression analysis, especially for those studying Managerial Accounting.

  • @hamnamariyam8242
    @hamnamariyam8242 Рік тому +2

    Thankyou Sir. It's Really helpful

  • @aslhanaslhan1092
    @aslhanaslhan1092 2 місяці тому +1

    Hello I did linear regression, but my teacher did not accept it because the number of steps in the formula was low. How can I increase it?

  • @arantanishilugun1128
    @arantanishilugun1128 Рік тому

    What should be considered first while calculating intercept if Age is Y and X is life satisfaction?

  • @nktrendings816
    @nktrendings816 3 місяці тому +1

    Nice Sir

  • @willisaw135
    @willisaw135 5 років тому +1

    Hello, Can you help me? I'm trying to use add ins with the Data Analysis and it's not there. I need help please. For my Essential Mathematics homework

    • @atiqrehman8767
      @atiqrehman8767  5 років тому

      I will upload a video shortly to guide you

    • @willisaw135
      @willisaw135 5 років тому +1

      @@atiqrehman8767 thank you.

    • @Wrc650
      @Wrc650 9 місяців тому

      ​@@atiqrehman8767hi sir i hve a concept that I want to apply at my work on predictive analysis for revenue recognition .. can i connect via email?

  • @abhisheksahni6409
    @abhisheksahni6409 Рік тому

    And what if the sign is not negative b(Beta coefficient or slope is 0.001251887 and a=Intercept = 2.735081178, Here we will plus or minus? Y-B OR Y+B? PLZ?

    • @your_kgirl
      @your_kgirl Рік тому

      Same Value I got, so Did you plus or Minus?

    • @abhisheksahni6409
      @abhisheksahni6409 Рік тому +1

      @@your_kgirl plus as here we don’t hve minus

  • @abhisheksahni6409
    @abhisheksahni6409 Рік тому

    Dear sir, can you help in this: - ( Can i apply same method in this? Help Please.) Using MS-EXCEL show the Regression model, consider ‘Instagram followers’ as
    dependent variable and ‘no f post per day’ as an independent variable. Write the
    interpretation of EXCEL Tables. Write the conclusion on the fitting of your model also. no of
    followers :- no of post
    per day 439 2
    340 1
    315 4
    444 5
    377 2
    456 5
    495 2
    304 2
    401 5
    305 5
    338 4
    348 2
    402 1
    395 5

    • @sayammehta1007
      @sayammehta1007 Рік тому +1

      distance MBA from nmims sem 2 Decision science question no. 2😂

    • @abhisheksahni6409
      @abhisheksahni6409 Рік тому

      @@sayammehta1007 Yes 🙌🏻🤣

    • @shikhagarg8183
      @shikhagarg8183 Рік тому

      Hi Guys, I’m also pursuing distance MBA from NMIMS. Could you help me please? 😅