Multiple Linear Regression using Excel Data Analysis Toolpak

Поділитися
Вставка
  • Опубліковано 17 жов 2024

КОМЕНТАРІ • 33

  • @BonokaiGBGOULD
    @BonokaiGBGOULD 4 роки тому +1

    Thank you so very much too sir. Let me also say as others have requested and given your consideration, panel regression, logistic regression and hypothesis testing will be a great addition to the library. Thanks again. Great content.

  • @AFFarms444
    @AFFarms444 4 роки тому

    Thank you so very much sir. As others have requested and given your consideration, panel regression, logistic regression and hypothesis testing will be a great addition to the library. Thanks again. Great content.

  • @fliyaliyanaify
    @fliyaliyanaify 9 років тому +3

    how can i get all the dataset related to multiple linear regression with many parameters ?

  • @feyisalemessa2201
    @feyisalemessa2201 2 роки тому

    Very appreciated!! but how to make a report of the output of parameter estimates using Mean plus or minus Standard error ..thank you

  • @hawk77y
    @hawk77y 6 років тому

    this is great! How to you deal with missing data in this particular case? I am getting LINEST() function error. I have a 0 to 10 rating scale and blanks is for Don't know answer. Should I use the code 99

    • @LearnanalyticsIn
      @LearnanalyticsIn  6 років тому +1

      hawk77y replacing with mean or median is the best option. 999 will be an extreme outlier and make regression irrelevant.

  • @sharonzaw5482
    @sharonzaw5482 3 роки тому

    where can we find this type of dataset? Different one

  • @gokari1989
    @gokari1989 8 років тому +1

    i am unable to find logistic regression model ,can u upload a video with Interpretation on one case study

  • @RiyazPatanwala
    @RiyazPatanwala 10 років тому

    If we have multiple models (where proxies are added/removed) and a variable which had significant relationship in one becomes insignificant in other, then what should we interpret? how do we report such variable in report?

    • @LearnanalyticsIn
      @LearnanalyticsIn  10 років тому

      Interactions/collinearity effects are happening - you would need to know the data background and reason. Switch to SPSS or Statistica to do factorial designs on the dataset.

  • @mukulsute2038
    @mukulsute2038 4 роки тому

    Can we optimize the dependant variable?

  • @abhinaykumar3754
    @abhinaykumar3754 9 років тому

    As you mentioned that the model is of the form a1x1+a2x2+...an xn. But you didn't select the option "constant is zero'. So, if I wish to get model with a constant term (i.e. y = a0 + a1x1+ a2x2 + ...), then what changes do I need to make?

  • @katarinahrobonova4685
    @katarinahrobonova4685 3 роки тому +1

    Please, could you tell me how to remove excel error: Regression - Input range must be a contiguous reference. Thank you.

    • @rajputankit6032
      @rajputankit6032 3 роки тому

      Hi if you add space in before and after in your data after that you will not receive messages

    • @ZahidKhan-gq1lz
      @ZahidKhan-gq1lz 3 роки тому

      Email me I will guide you researchscholar80@gmail.com

  • @soumyaranjanbehera1371
    @soumyaranjanbehera1371 6 років тому

    what is your prediction in this particular model

  • @rakshit250819901
    @rakshit250819901 9 років тому

    Howcome the model is linear and not non linear ... i suppose if we plot the yi's and xi's it should form a non linear model ..
    can you provide me with the data set for the car sales? .. the link given below isnt working.

    • @LearnanalyticsIn
      @LearnanalyticsIn  9 років тому

      the model will be generated in the form of a1x1+a2x2+a3x2+.....AnXn, therefore a linear equation in N-dimensions. You can use non-linear transforms such as logs or exponents, but estimates are generated using OLS and assume linearity.

    • @LearnanalyticsIn
      @LearnanalyticsIn  9 років тому

      I checked the link,it is working. you should be able to download the file.

  • @dianacruz9352
    @dianacruz9352 3 роки тому

    can u please let me how to find the kind of database

  • @EugeniaAsante
    @EugeniaAsante 7 років тому +1

    Hi, can you do a video on how to run a panel regression in excel. please..

  • @chillmama4610
    @chillmama4610 9 років тому

    This link is not working could anyone help me out

  • @edgardogonzalez5226
    @edgardogonzalez5226 3 роки тому

    you're a God. Gracias!

  • @willrieger
    @willrieger 10 років тому

    How do you select the entire column so fast?

    • @LearnanalyticsIn
      @LearnanalyticsIn  10 років тому

      Select the first cell on the top, press shift down and hold, then press End and press the down key (one after the other).

  • @hiteshkekre8514
    @hiteshkekre8514 6 років тому +1

    Nice explanation.

  • @mohithreddy2722
    @mohithreddy2722 3 роки тому

    multiple linear regression is not allowing

  • @subhasisdas1706
    @subhasisdas1706 7 років тому

    can i get a data for practice

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

    Removes high P variables

  • @kumeraterefa6358
    @kumeraterefa6358 2 роки тому

    please work this question and send in my email.
    develop a trip generation question and calculate all the statisticals to check the validity of the equation using the data given in the table
    (multiple linear regression try it using Microsoft Excel)

  • @SvenKrevchenko
    @SvenKrevchenko 7 років тому

    Thank you bossman.

  • @mohammadahsan6342
    @mohammadahsan6342 7 років тому

    thank you sir

  • @patriksulla194
    @patriksulla194 7 років тому

    thanks a lot