How to Run a Multiple Regression in Excel 2007

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

КОМЕНТАРІ • 35

  • @165489able
    @165489able 12 років тому +1

    who ever you are, you are doing a great thing for humanity:)

  • @briannawurtsmith4347
    @briannawurtsmith4347 10 років тому +1

    Even though this is no longer the latest version of Excel, I still found the video to be very helpful in understanding the analyses I'm looking at today. Thanks for making this!

  • @chenjidanceteam
    @chenjidanceteam 11 років тому

    Thanks a lot!!! Totally forgot how to do it after college. You did a great job! Clear and not too slow! Thanks! Just what i need for the current project!

  • @olgasfw
    @olgasfw 11 років тому

    thank you so much! after watching this video, I was able to run multiple regressions on the dataset i had to evaluate for my stat class. most importantly, I now better understand the model and what the values in the summary mean in relation to the variables.

  • @sunisury
    @sunisury 12 років тому

    Thank you!!..it was very useful and easy to understand the way you explain it

  • @whuang1995
    @whuang1995 12 років тому

    THANK YOU! You saved me in my AP stat class!

  • @WillWolfrick
    @WillWolfrick 12 років тому

    Thank you very much for the video buddy, it actually saved me in my Economics Class! Tnx!

  • @DNAblues
    @DNAblues 13 років тому

    very clear presentation. Thank you.

  • @Yohasakura2005
    @Yohasakura2005 12 років тому

    Dear ProfTDub
    Which video shows you that equation can be graphed in a 3 dimensions?

  • @erfanm5276
    @erfanm5276 11 років тому +4

    could you please explain how to run non linear multiple regression using excel

  • @ProfTDub
    @ProfTDub  12 років тому

    Hello. I'm sorry, it looks like I never did make a video showing how to the 3-D graph. Here are steps to do it, though. I hope it helps.
    To make a 3-D graph in Excel…
    1) Make a grid of fitted values over the range of potential X-values
    for each of two quantitative X-variables.
    2) Highlight the grid values, including the margin values.
    3) Go to Insert --> Other Charts --> Surface
    4) Edit the Graph by adding axis labels, rescaling the axes to
    remove excess empty space, etc.

  • @aliwolf430
    @aliwolf430 12 років тому

    Thank you! Helped a lot!

  • @Theisland1000
    @Theisland1000 12 років тому

    Thank you that was very helpful.

  • @ProfTDub
    @ProfTDub  12 років тому

    click on the Office Button in the top left corner, click on the “Excel Options” button in the lower left, click on “Add-Ins”, click on “Analysis ToolPak”, click “Go”, check Analysis ToolPak, then click “OK”.

  • @sasamuraki
    @sasamuraki 13 років тому

    thank you very much Professor..

  • @black-catmusic3619
    @black-catmusic3619 7 років тому

    can you run multiple regression using the outcome of the z-scores?

  • @MISHKANA30
    @MISHKANA30 12 років тому

    I can't find the data analysis thing in d data tab in my excel 2007!...

  • @tuysty91
    @tuysty91 13 років тому

    any chance you know how to make a regression macro in excel 2011?

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

    I have no "Data Analysis" in my excel 2007 :'( What should i do ? please help

  • @TheTambourinist
    @TheTambourinist 11 років тому

    could you please post a link to the first video? i cant find it.

  • @ProfTDub
    @ProfTDub  11 років тому

    Hi. -sorry, I didn't call it a multiple regression video. It's called "How to Make a Scatterplot Matrix in Excel" and it's available on my site with all the others. It's a preliminary video to doing multiple regression.

  • @suvro1
    @suvro1 11 років тому

    where is the 1st video. could you please send me the link. thanks

  • @MISHKANA30
    @MISHKANA30 12 років тому

    Okay, got it! It worked! Thank You! :)

  • @radio_nowhere
    @radio_nowhere 12 років тому

    where is the first video? cant locate it!

  • @vaceem1983
    @vaceem1983 12 років тому

    Thanks alot sir ,,,,,,,

  • @SameerRazaKhan792
    @SameerRazaKhan792 12 років тому

    Just Amazing!!!

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

    How to Run a exponential or logarithmic Multiple Regression in Excel 2007?

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

    Thanks a a lot !!!

  • @nkdafnis
    @nkdafnis 13 років тому

    thank you!

  • @MiniShagz
    @MiniShagz 12 років тому

    Thanks!!! It is not intuitive that Excel does MULTIPLE regression given the options.

  • @MrAnimefreak10101
    @MrAnimefreak10101 12 років тому

    WTF Why don't I have data analysis to the right of my screen?

  • @nigam308
    @nigam308 11 років тому

    excellent u save my ass....more thn thank you man....

  • @RicardoTorresdeAcha
    @RicardoTorresdeAcha 12 років тому

    You need to activate the Data Analysis add-in /watch?v=-ubtpQJ1smI

  • @BoerHenkForever
    @BoerHenkForever 11 років тому

    yeaah budy