Excel 2010 Statistics 03: Calculations, Formulas, Functions, Math & Comparative Operators

Download Excel File: people.highline.edu/mgirvin/A...
Download pdf file: people.highline.edu/mgirvin/A...
Learn all about making calculations in excel with Formulas and Functions:
1. Math operators
2. Comparative operators
3. Calculating Formulas
4. Functions like: SUM, AVERAGE, MODE.SNGL, STEV.P, COUNTIF, COUNTIFS
5. Learn how to put comparative operators in double quotes to use in COUNTIF and COUNTIFS functions
6. Learn how to join comparative operator with Number in COUNTIFS formula
7. Text Formulas
8. Logical Formulas
9. Keyboard for SUM: Alt + =
10. Keyboard to jump to bottom of range: Ctrl + Arrow
11. Keyboard to highlight range: Ctrl + Shift + Arrow
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.

[@excelisfun]

Not so much a king, but just a guy having fun with Excel.

[@williewill037]

This is video is a blessing, I'm failing stats but now that I found this video I can turn my grades around positive. Stay tuned!!

[@excelisfun]

You are welcome! I am glad that the videos help!

[@excelisfun]

I am glad that the videos help!

[@VSP4591]

Dear Mike, I have to tell you that when I discovered Excel is Fun I was, and still I am, very grateful for what you are doing. I was looking for years for a consistent manual on Excel (I am from Romania) and I did not find. Bless you. Victor Platon

[@FizzlyFiz579-_-]

I can't find the words to express my gratitude, you are really something!!!!!! Thank you so much and God bless you for the good deeds...

[@excelisfun]

I am glad that you like it!

[@thaddreplogle9033]

I have only watched the first three videos so far, but they are very well made. You give a huge amount of information in a short time, yet they are still easy to follow. I will definitely recommend these videos to other students in my statistics class. Thank you for contributing to my education.

[@daniplastikable]

This is excellent, thank you. You have somehow made Excel funny. Congratulations.

[@excelisfun]

No. I just post my classes for free online so you can watch.

[@excelisfun]

@rvalluri1 , I am glad that you liked it!!

[@gmsshoukhin1272]

it starts with huge gratitude and thanks to you. i have watched some of your videos that teach me a lot of things. hope God always helps you!

[@excelisfun]

You are welcome!

[@excelisfun]

@worldfamous945 , You are welcome!

[@excelisfun]

You are welcome!!

[@keishawatson3252]

This is definitely helping me. Thanks a billion. KO

[@respiumd4584]

thanks so much for the very informative video tutorials; way to go !

[@sewfunfitness]

Your videos are awesome! Thank you!

[@excelisfun]

The .S have a denominator that is sample size minus 1. .P is just sample size.
Sample data divided by just the count underestimates.
What minus one does: 10/5 = 2, but 10/(5-1) = 2.5

[@alimamysesay7360]

Grateful to have received such a excellent tutorial this is making me proficient in Excel and other programmes. Thanks abundantly.

[@excelisfun]

+Alimamy Sesay You are welcome!

[@SBN1402]

Thank you for the videos

[@rvalluri1]

This is an awesome video, good job

[@RoudiMansi]

Awesome! Thank u so much

[@worldfamous945]

THANK YOU !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@LearNation]

Burrrrrrrrret, Thank you sir.

[@rvalluri1]

Thank you for replying.

[@nareshboda8396]

Thank u so much

[@MrPcwojtek]

Hi quick question I`m sort of struggling with my own project it is a pain to work on it without quick computing help and I was recommended to Excel but I cant find by myself anything helpful among 1000 of other videos about statistic and function . My project is basically working with groups of numbers for example
A1 (1,3,5) A2(2,4,6) A3(1,2,3,4,5,6,7,8,9,10)
and I would need to do something like this
[(A1 + A2)-A3]=7,8,9,10
=> [(1,3,5) +(2,4,6,)] -(1,2,3,4,5,6,7,8,9,10) =7,8,9,10
Pleas let me know if anything like that is possible in excel and where to look for it that would be very helpful for me and let me continue work much faster with way less mistakes.
Thanks

[@1234saiwa]

Hi, Mike, What are the difference between STDEV.S and STDEV.P? I understand that one is for sample and the other is for population. I tested them by giving the same range of data for both functions, and they give different results. What are the logic behinds this?

[@yomamaonutube]

very helpful! thanks!

[@excelisfun]

+yomamaonutube You are welcome!

[@fffppp8762]

which file is the one you used in the video ??

[@fffppp8762]

I found it

[@excelisfun]

Almost nothing in the statistics series is in the book. The book is a Basic Excel Book.

[@sethveenbaas4563]

You keep referring to a class, what class is it? Is that something everyone can join?

[@daniplastikable]

(...especially because you sound just like Ross from Friends)

[@ismailismaili0071]

I LOVE YOU SO MUCH YOU HELPED ME A LOT WITH MY JOB THANK YOU AND I HOPE IF I CAN GET YOUR EMAIL

[@cougarintexas]

fix your typing "formula" LOL

[@excelisfun]

I am glad that the videos help!

[@excelisfun]

You are welcome!

[@excelisfun]

You are welcome!