The last couple weeks I’ve played catch up on the Data Science lessons. I’m 51% through the course. So far the entirety of the statistics topics have been review which I’m very thankful for as they go by quickly. Honestly I can’t believe how much old statistics and math knowledge (that I rarely use) is still bouncing around in my head after all these years.
It was a very nice surprise to have remembered so much from a class I took probably 10 years ago. Pulling out my old statistics text book I can now see why. The image for this post is my old statistics book. Check out all those reference tabs…
Though I had initially planned to go back later and complete the optional sections – I went ahead and did a few to make sure I had a solid grasp of the concepts. That said, to finish the course in time I’d like to haul ass through the statistics lessons and get into the more interesting (at least to me) Python and SQL lessons. Interesting in the sense that I’ll hopefully be learning something new and also in line with programming (since I’m doing FEND as well)
Once things settle down and I’m finished with this challenge course as well as FEND I would very much like to go through all the topics and write about them in more detail. Especially using Excel data analysis functionality to calculate things like standard deviation and make pretty histograms.
My goal this week is to get through everything up to at least Control Flow.
Intro to Descriptive Statistics – Week 1
Intro to Research Methods – Week 1
PS 1A: Intro to Research Methods – Week 1
OPT PS 1B: Additional Practice – Week 6
Visualizing Data – Week 2
PA 2A: Visualizing Data – Week 2
OPT PS 2B: Additional Practice – Week 6
Google Spreadsheet Tutorial – Week 1
Central Tendency – Week 4
PS 3A: Central Tendency -Week 4
OPT PS 3B: Additional Practice – Week 6
Variability – Week 5
PS 4: Variability – Week 5
Standardizing – Week 6
PS 5A: Standardizing – Week 6
OPT PS 5B: Additional Practice (11% Complete)
Normal Distribution – Week 7
PS 6: Normal Distribution
Sampling Distributions
PS 7: Sampling Distributions
Advanced concepts: Python & SQL – Week 7
Why Python Programming – Week 7
Data Types & Operators (14% Complete)
Control Flow
Functions
Scripting
Basic SQL
SQL Joins
SQL Aggregations
SQL Subqueries & Temproary Tables
SQL Data Cleaning