Regression in Excel

preview_player
Показать описание
This video explains how to perform a regression in Microsoft Excel. Regression examples with one independent variable and two independent variables are demonstrated.
Рекомендации по теме
Комментарии
Автор

In my head, regression is the process of estimating the relationship among the variables, taking into account all of the factors that influence it. I think at this point I was prepared to lear something more complex than just one IV, and this video delivered that. I think that this is a practical application because a lot of studied "in real life" have more than one.I think this video had good information about the R squared and multiple R.

jhoward
Автор

This video did well with explaining what regression looks like in Excel. Sometimes I feel like I like Excel better, but sometimes I feel like I like SPSS better, but I was happy to see the examples from this video and how it all worked.

rebeccameece
Автор

8 years and still a masterpiece, thanks a lot for your valuable time. Note that this add-on in Excel support up to 16 independent (X) variables for calculations and 1 (Y).

Mohamed.GadAllah
Автор

Regression is something that is used to estimate the relationship between variables. This video was done very nicely and explains how regression is depicted in this manner.

toniettemorda
Автор

Dr. Grande- This video on Regression was helpful to understand while using Excel. It is especially helpful to understand what the best statistical analysis would be and the definition of regression.

amandavalentino
Автор

This is helpful.  I have chosen a factorial MANCOVA for my research design and it's difficult to know whether a multiple regression would be better.  Watching this process unfold in this video is very helpful.

carolkirby
Автор

The example that you used about exam scores made this video very clear. Also I wasn't expecting the output to be as specific. It included how many points (.2) a student could gain for the amount of additional time studied. I thought there would be a correlation, but not that exact. Thank you for the video.

tamarabakergibbons
Автор

I like how you explained regression and how it is used to explain or estimate the relationship between variables. I think that excel is easier to understand and this is a good reference video.

katherinebeck
Автор

Regression was something that I wanted more info on after reading the text, especially since I am thinking of using regression in my research proposal. This was a good resource for me and will help with my understanding of the different variables and coefficients.

alexdeloach
Автор

With this video, I understood that regression simply predicts an outcome based upon the relationship of the dependent variable and the independent variable. This is a nice tool to be able to use with multiple IVs in order to see the different outcomes on the data.

melissaclendaniel
Автор

I appreciated the examples. The graphs and tables were a nice touch. I learn more about Excel each time I watch a video. It serves as a great tool.

Mjthfdj
Автор

This is really useful in predicting the value of dependent variable ( test score) based on the independent variable ( minutes of study or pre-test). I really liked that you could change the value of the dependent variable and see the value of the independent variable and how one dv can affect the score more than another .

ariadnaaguero-roman
Автор

It was helpful to have the formula for regression explained. I needed a refresher on this concept and this video using excel provided a thorough take on this.

chelseydavis
Автор

I really enjoyed that there were many examples to help us better understand regression and how to do it in Excel. It was very easy to follow and made me feel more comfortable about using Excel.

reneemendez
Автор

Since I will be using a regression in my proposal this video was helpful in understanding why that would be the best statistical analysis to use

briannagoitiandia
Автор

Excel seems to be easier to navigate as compared to SPSS. Dr. Grande gave an excellent explanation regarding regression. The examples provided served as an great method in deepening understanding of the key terms and functions.

ashleydorsey
Автор

This video was easy to follow. With regression there are alot of variables; alot of predictors that could affect the outcome.  Again there are alot of steps but Dr Grande explains them well.

michellerobinson
Автор

This video helped me to understand regression and I like the final exam/practice exam/minutes of study example.  It helps us to better grasp these concepts when we can relate to the variables.

kimberlykelly
Автор

I really thought there were a couple of great things in this video that helped me to better understand regressions. The first was Dr. Grande's explanation of what the r squared means and what the multiple r tells you. I also found seeing the two examples to be very helpful as well. I think it was especially helpful to see how to do a regression with multiple IV's.

mandabear
Автор

This video serves as a good reminder of the purpose of the regression statistic. The example of the IV (study time) and DV (score) could be particularly useful for students desiring to improve their knowledge and grades.

wandamixon