- Видео 15
- Просмотров 609 279
FordhamStats
Добавлен 26 апр 2010
Fordham Stats - Title Page
Look at the description in each video to get the link to d/l the workbook and follow along!
Download the Excel Workbook at:
docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI
Download the Stats Notes at:
docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3MhRfj-HDlqNGNhNDc2ZWUtOTg4MS00OWFlLTk4NjgtMmE0OGIyYTkxNDRh&hl=en&authkey=CPizo4IN
Download the Excel Workbook at:
docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI
Download the Stats Notes at:
docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3MhRfj-HDlqNGNhNDc2ZWUtOTg4MS00OWFlLTk4NjgtMmE0OGIyYTkxNDRh&hl=en&authkey=CPizo4IN
Просмотров: 1 916
Видео
Excel Techniques - 14 - Multiple Regression.avi
Просмотров 59 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 Multiple Regression... a lot more X... (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3MhRfj-HDlqNGNh...
Excel Techniques - 13 - Regression.avi
Просмотров 10 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 Regression! Remember, X dataset is the one that that affects Y dataset, make sure you choose correctly! (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.googl...
Excel Techniques - 12 - ANOVA - Two Factor with Replication.avi
Просмотров 213 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 ANOVA - Two (or more) Factor with replication (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3MhRfj-H...
Excel Techniques - 11 - ANOVA - Two Factor without Replication.avi
Просмотров 110 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 ANOVA - Two (or more) Factor without replication (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3MhRf...
Excel Techniques - 10 - ANOVA - Single Factor.avi
Просмотров 49 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 ANOVA - Single Factor (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3MhRfj-HDlqNGNhNDc2ZWUtOTg4MS00O...
Excel Techniques - 09 - t-Test - Two Sample.avi
Просмотров 31 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 t-Test: Two Sample, regular two sample t-Test of two different samples. (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&ch...
Excel Techniques - 08 - t-Test - Paired Two Sample.avi
Просмотров 55 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 t-Test: Paired Two Sample, used in a Before & After situation! (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true...
Excel Techniques - 07 - t-Test - One Sample.avi
Просмотров 25 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 t-Test One Sample, trick Excel by using a t-Test Two sample and just dummy the second sample with the same data! (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: d...
Excel Techniques - 06 - Correlation Coefficient.avi
Просмотров 31 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 Correlation Coefficients are simple to do, and is a good "starter" technique. (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explo...
Excel Techniques - 05 - Histograms.avi
Просмотров 5 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 What and how to do a Histogram (must use those Bins in Excel) (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true&...
Excel Techniques - 04 - Descriptive Statistics.avi
Просмотров 6 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 Going over Descriptive Statistics. (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3MhRfj-HDlqNGNhNDc2...
Excel Techniques - 03 - In Cell Functions - Part 2.avi
Просмотров 3,4 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 Introduction Covering the Z-Score (=STANDARDIZE) function, and how to use the $ signs to lock cell references to view Z-Score of the data set easier. (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CP...
Excel Techniques - 02 - In Cell Functions - Part 1.avi
Просмотров 4,1 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 Introduction Covering a few basic in cell functions. (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B3...
Excel Techniques - 01 - Introduction.avi
Просмотров 5 тыс.14 лет назад
Excel Techniques for Statistics DGGB 6820 - Summer 2010 Introduction Video to show you the spreadsheet, as well as how to access the Data Analysis function in Excel 2007 (Please be aware that the audio is a little out of sync) Download the Excel Workbook at: docs.google.com/leaf?id=0B3MhRfj-HDlqNTA0NDhmYWMtN2I5My00ZTJkLWJiNjYtZTE2MjEyMmU5NDZl&hl=en&authkey=CPaHl8kI Download the Stats Notes at: ...
How to access the work sheet?
Thank you soo much!! I didn't know why ANOVA wasn't working and now I know it was due to one mistake I did... I will see the previous video to know how to interpret F crit :)
You saved my life 😂
So what are we testing for? What is the null and what is the alternative? Does it make a difference that Rows were no a significant p value, but the Columns did have a significant p value? How does that work with the null and alternative hypothesis, whatever they are?
thank you for the help
statistisignifcaldiffernce
Drill Sergeants are Army. Drill Instructors are Marine Corps just letting you know before someone bites your head off 😊
thanks
Hello Sir. Awesome explanation. I have a question, however, since you singled out some factors as to why there's a significant difference in the interaction. Is it statistically safe to assume using the descriptive statistics without having to run a post hoc anova to conclude this or that factors is/are the reason/s for the significant difference? Thanks.
what if the numbers of people per group are different?
git it, so I should drink 1 beer and 1 coffee, and take 8 hours of sleep to get a GPA 4.0
Updated Link for the files: drive.google.com/drive/folders/1RhvgyrFg0h-XUi5m_j09rIH_M-MVrerq?usp=sharing
Thank you so much
<3 amazing! thank you very much!!
bad mic
Lol that tiny roast in the conclusion
I did everything you said but it comes up with an error message "this input contains non numeric data". I did click labels, I did highlight as you did, not sure why it won't do it for me. Help?
When you select blank cells (samples with different number of data points), the non-numeric data error pops up.
excellent video. so simple and effective. Covered in under 7 mins what an entire classroom session of 1 hour didn't
Once again (see my comment on 11, "without replication"), this analysis is not appropriate for these data as you have described them because each row has values that are related by coming from one individual. You need a repeated measures analysis with recruit as the subject.
Your analysis is inappropriate for the data. This test assumes that all the values are equally independent of one another, but in fact you have scores for SQ, RQ and TQ that all come from the same individual and are related to one another. This is a repeated measure of a subject. You can see this is true by scrambling the order of, say, the TQ values--you will get the same statistical result from the two-way ANOVA, whereas if the test were appropriate for a repeated measure on a subject you would get a different statistical result. This error is on many videos on youtube. I see now that weakside made the same comment below.
Except that weakside advocated for one-way ANOVA, which is also inappropriate for the same reasons.
cool video! nice !
Thank you for your video! :)
thank you الله يرحم ليك الوالدين
Very nice set of videos, thank you!
Excellent video, thanks! Just one question, is it possible to have negative T- Critical Values? If the answer is yes, we do have to look at their absolute value (just like we do when t-statistic value is negative)?
Thanks for the videos and explanations. I guess this test can also be done with the z.test fonction.
Thank you very much, it helped me a lot with my homework!
Can we do a tukey test to compare between the subjects to see who is the best among them ?
Hi what is error how is it computed ? Can we use tukey test for columns.?
The design of this data file suggests this is a ONE-WAY ANOVA with 3 levels (tests 1-3). If each person takes each test, then test is a repeated ('replicated') factor. Differences between tests should not be tested as if it is a 'non-replicated' factor because it is theoretically not true and you lose power to detect differences when you treat them as if different groups of people were taking each test. Testing for differences between individuals is NOT sound practice, as each persone would have to be treated as a factor, or perhaps a factor of 'person' with six levels. This whole example is very botched in my opinion.
Truth. It's a poor demo that he should revise.
Thanks!
Very old video but still relevant. Thank you for posting this, I only needed to write a short interpretation of my results and this was great for helping me get my head around it.
Good explanation! I really appreciate the help!
Thanks for the video ! ;)
Question. Why we selected "Unequal Variances" (not "equal" variances)? Thanks in advance
You can know by doing f test
hey how do you find SSE what is the formula?
Thanks a lot! It helped me a lot!
The name is "two factor" because every number is associated with two factors. If it was three, we would have to write it 3D.
What if those recruits were tested again in all 3 tests to see if they have improved (say for example after 2 weeks), giving you 3 pairs of before-and-after scores? What test should you use if they improved in any of those performances?
it's called a repeated measures anova (2 x 3) for before and after (2) and 3 tests per individual.
No sound :(
Thank gosh you speak clearly!
Awesome explanation! I realize this video is a bit old but the content has not changed and it helped me understand the problem very well! Thank you!!!
superb bro..ty
THANK YOU!! I´m sooo HAPPY! Totally agree with Arizona Smith!!
ohhh yeahhhh.....saw your mms video last night..it was great....especially the missionary position
Thank you for your documents and videos. They're very cool. Thanks again.
Hi guys, I hope you can help me solve this problem. I want to verify the independence of two factor without replication, can i use '' ANOVA - Two Factor without replication'' ? and how? In this example, I can verify the independence of factor " Recruit " and "Score", its relationship to the result. Thanks a lot!
Thank you very much
Thank you a billion time for all the wonderful work you made in those videos. I went through all your videos. They helped me so much. I have taken more than one stat course, your videos are the only ones made me understand the basics of statistics. Thank you very much again.
This was so AWESOME! Thank you for explaining this so well! Very helpful for my class.
Thanks, this was helpful.