Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information Download files: people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:21) What Is / Are Statistics? Define Statistics 2. (02:42) Descriptive Statistics and Inferential Statistics 3. (05:00) Collect, analyze and present raw data on Yahoo Stock Price: Search the internet, download, create formulas and crate a Chart and present the information in a useful way. 4. (06:05) Get Data from finance.yahoo.com/ 5. (06:43) Copy and paste data from internet into an Excel spreadsheet. Learn about Paste Special, Text 6. (07:28) Download a “.csv” file. “.csv” and “.txt” file types (file extensions) are text files. When you open them, they look like Excel, but it is not. We can copy and paste into a real Excel file. Text files are common files types that allow raw data to be transferred from one system to another. Text files are intermediate steps between the original Database and your Excel Spreadhseet. 7. (07:46) Control Panel, Folder Options, View Tab, Uncheck “Hide extensions for known file types” 8. (08:47) Highlight whole table keyboard is Ctrl + * 9. (09:50) Calculate maximum stock price with MAX function, minimum stock price with MIN and Mean using the AVERAGE function. 10. (11:30) Keyboard shortcuts for highlighting ranges that are not next to each other (noncontiguous ranges): Ctrl + Mouse Click 11. (12:15) Create Line Chart from Historical Data 12. (13:58) Page Setup 13. (17:52) Example of Inferential Statistics
i watched over 20 videos today! i just want to tell you YOU SAVED MY LIFE! you explain everything so clearly and in depth .i never thought id understand and/or like excel but i love it! THANK YOU!
I started three years back knowing nothing about excel. I have watched and practiced most of them. And guess what, now I am as good as you are in excel. lol Thanks for all the videos!
A faster way to print the same range: select H1:N11, Ctrl + P, under Settings click Print Active Sheets and select Print Selection instead, then all the way down click No Scaling and select Fit Sheet on One Page instead.
Nice! I just put in practice this knowledge to one of my stocks. My results were: Max 385 Min 15.8 Mean 166.3496202 I should it sold last week :/ Seriously, I really love this channel so much :) Thanks Mike for the awesome video!!!
thank you for brilliant series lessons, hope to meet you in the real life to see your generosity and invite you a coffee. If you travel in Vietnam. Let me know :)
Hi first i want to tell you that i am really thanked of you, even though i am a Spanish speaker i have got all your videos you are a genious! and i would like inquire you a question... do you have any videos about VBA programming? Greetings from Mexico!
+JoshMr07 Hi Josh: Michael is using Excel b/c it is his within his expertise. We are benefiting from his teaching skills to help with homework and professional tasks and it is working just fine for us. If you know anyone who explain R and teach it as him please share. Thank you.
Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:21) What Is / Are Statistics? Define Statistics
2. (02:42) Descriptive Statistics and Inferential Statistics
3. (05:00) Collect, analyze and present raw data on Yahoo Stock Price: Search the internet, download, create formulas and crate a Chart and present the information in a useful way.
4. (06:05) Get Data from finance.yahoo.com/
5. (06:43) Copy and paste data from internet into an Excel spreadsheet. Learn about Paste Special, Text
6. (07:28) Download a “.csv” file. “.csv” and “.txt” file types (file extensions) are text files. When you open them, they look like Excel, but it is not. We can copy and paste into a real Excel file. Text files are common files types that allow raw data to be transferred from one system to another. Text files are intermediate steps between the original Database and your Excel Spreadhseet.
7. (07:46) Control Panel, Folder Options, View Tab, Uncheck “Hide extensions for known file types”
8. (08:47) Highlight whole table keyboard is Ctrl + *
9. (09:50) Calculate maximum stock price with MAX function, minimum stock price with MIN and Mean using the AVERAGE function.
10. (11:30) Keyboard shortcuts for highlighting ranges that are not next to each other (noncontiguous ranges): Ctrl + Mouse Click
11. (12:15) Create Line Chart from Historical Data
12. (13:58) Page Setup
13. (17:52) Example of Inferential Statistics
i watched over 20 videos today! i just want to tell you YOU SAVED MY LIFE! you explain everything so clearly and in depth .i never thought id understand and/or like excel but i love it! THANK YOU!
You are welcome! That is why I post: to help! :) P.S, I love Excel too!!
I started three years back knowing nothing about excel. I have watched and practiced most of them. And guess what, now I am as good as you are in excel. lol
Thanks for all the videos!
You are welcome!
I hope you continue to upload more of your lectures. I am relying on your very insightful instruction to land me an internship!
Thanks for the video Mike...a nice refresher intro into the statistic world...
OMG its Excel Christmas thank you as always.
You are welcome!
Great videos, I like all those handy infos you throw once in a while like shortcuts and that kind of stuff thank you so much,
You are welcome!
Great!
Glad you like it!
A faster way to print the same range: select H1:N11, Ctrl + P, under Settings click Print Active Sheets and select Print Selection instead, then all the way down click No Scaling and select Fit Sheet on One Page instead.
Excellent. Thank you
This was by far the best material I have ever seen.
I need the same quality of material for MS project, can you direct me
Thanks!
Hi ExcellsFun...thank thanks thanks...I am using Excel 2007...how will I use the power query function in this case
Nice! I just put in practice this knowledge to one of my stocks. My results were:
Max 385
Min 15.8
Mean 166.3496202
I should it sold last week :/
Seriously, I really love this channel so much :) Thanks Mike for the awesome video!!!
Nice!!!! Stocks are fun!?!?!
Investing is my hobby 🤪🤑😍
Rad!!!
Actually, you are awesome!!! I'm learning so much from your channel.
Thank you, Doris!!!!! I am happy that the stuff I post is rad for you : )
Thanks Mike!!
Anyone here in 2019
2020
Late 2020
Can u please add direct excel sheet link in the video the way u did in first video...I am not able to find using the link u have provided here
Did you find the file?
thank you for brilliant series lessons, hope to meet you in the real life to see your generosity and invite you a coffee. If you travel in Vietnam. Let me know :)
Thank you very much sir.
You are welcome!!!
Hi first i want to tell you that i am really thanked of you, even though i am a Spanish speaker i have got all your videos you are a genious! and i would like inquire you a question... do you have any videos about VBA programming?
Greetings from Mexico!
I am sorry but I do not.
@Julio. You might consider ExcelVBAisFun channel to learn about VBA (macros). Or do a search "Excel VBA" in UA-cam.
i will ,thanks Kevin Lehrbass
Julio Luna Moreno , ExcelVBAisFun channel!! Thanks for the hot tip, Kevin Lehrbass !!!
Check out Wise Owl VBA
why are you using Excel??? won't R be better in everything.
+JoshMr07 Hi Josh: Michael is using Excel b/c it is his within his expertise. We are benefiting from his teaching skills to help with homework and professional tasks and it is working just fine for us. If you know anyone who explain R and teach it as him please share. Thank you.