This video demonstrates how to conduct a one-way ANOVA (ANOVA: Single Factor) using Excel 2016 Data Analysis Tools. The assumptions for one-way ANOVA are tested using histogram and boxplot graphs.

Text Comments (21)
## Would you like to comment?

Priya Venkat (1 month ago)

in which scenario should i perform 1) anova singe factor 2) two factor with replica 3) two factor without replica

뀨뀨 (4 months ago)

Wow this video really helped me a lot.
But I just have a one problem. What do you mean by reject the null hypothesis? Does that mean that I can accept my hypothesis?

Venica Rios (10 months ago)

Good evening Dr. Grande. May i ask if how did you edit your video and what app did you used? How to take a video with the whole sheet? I'm a grade 9 student from the Philippines and it would be our project in research.Thank you very much!

Josh Barry (1 year ago)

What if no data was available for a certain variable. Can you put N/A?

XiulanArisu (1 year ago)

Very helpful, thank you.

Dr. Todd Grande (1 year ago)

You're welcome, thanks for watching -

David Forster (1 year ago)

Brilliant - thank you

Dr. Todd Grande (1 year ago)

You're welcome, thanks for watching -

Chris Adams (1 year ago)

thank you

Dr. Todd Grande (1 year ago)

You're welcome, thanks for watching -

Adrine S (2 years ago)

Hey, what about crontrol groups?

Dr. Todd Grande (2 years ago)

Even though there is no control group in this video, the underlying logic if there was a control group is identical.

Luke Snear (2 years ago)

This video alone has saved my entire degree.

jcpollex (1 month ago)

It's going to save mine too!

John Tegethoff (4 months ago)

Thank you for making this video!

Dr. Todd Grande (2 years ago)

I'm glad you found the video useful. Thanks for watching.

Rosa Sutton (2 years ago)

Interesting seeing the differences between SPSS and Excel. Easier to conduct an ANOVA in Excel, but more in depth in SPSS. Pros and cons.

Jessica Williams (2 years ago)

I find excel easier to use than SPSS, but I am a little disappointed that excel cannot comprehensively test all of the assumptions of ANOVA like SPSS can.

Elias Bensalem (2 years ago)

What if the assumption of homogeneity (Levene's test) was violated for a pretest? What alternative method can I use to compare a pretest mean score and postest mean score?

mrs tomaikuta (2 years ago)

sorry im new to ANOVA. if i get high P-value is it wrong? my P-value is in hundreds.

Dr. Todd Grande (2 years ago)

A p - value cannot exceed 1. There may be a miscalculation somewhere in the process.

Join YouTube for a free account, or sign in if you are already a member.

Uploading contracts to an online database should not take too long, and with the right solution, there should be a way to quickly drag and drop them into folders. Of course, the contract management team may want to give some thought as to how those folders are categorized. In some industries, it may make sense to classify them by agreement type, whereas in others they may need to be grouped by timeframe or date. It is obviously important to do what makes sense for your company and to ensure everyone understands the classification system that is instituted. With this sort of well-oiled system in place, it is a lot easier to keep a handle on things.

© 2019 How to start mobile phone business

Divide and Conquer. This is another area that is very industry-dependent, but it is highly unlikely that any company can afford to have an entire contract team devoted to managing one portfolio. More than likely, it is more realistic to divvy up the team and the contracts so that there is a leader for each relevant sphere. The entire team will obviously have to coordinate and communicate, but resources must be allocated in the most efficient manner possible. In turn, this will allow for several individuals to keep an eye on a smaller batch of contracts, thereby facilitating those periodic reviews. Outsource the Tedium to Technology.