Photo by Sabri Tuzcu on Unsplash

Treehouse: Beginning Data Analysis

September 11, 2018

對數字我有不同的鍾愛，我記不住買這個東西要多少錢，那種數字，但是對數據會影響決定的數字是很感興趣的，從溫哥華工作一個月回來，對心裡那份自卑感更重，對自己沒有文筆，沒有設計美感，沒有創意，更沒有速度，好多挫敗。也許可以專注一點還有點興趣的東西，往數據分析和表格，好好努力吧！就從Treehouse的這系列課程開始吧！

Course 1: Spreadsheet Basics

September 11, 2018

  1. Introducing Spreadsheets
  2. Getting Started With Spreadsheet
  3. Spreadsheet Functions & shortcuts
  4. Spreadsheet Best Practices
  5. Build a Spreadsheet

這些大部份都是已經知道的常識，很快複習一下。

  • Import csv to Google Sheet: File > Import > Upload > Import Location: Choose Append (附加/附上）to current sheet / Separate Type: Choose Detect automatically

Course 2: Data Analysis Basics

September 23, 2018

  1. Introducing Data Analysis
    • Dataset: A collection of data
    • Cognitive bias 認知偏見
    • CSV: Comma Separated Values
  2. Getting to Know Your Data
    • Summarize Date: Maximum, Minimum, Range (=max(…..), =min(…..), Range=max-min)
    • Shortcut key: Command + Shit +DownArrow 全選以下全部
    • Summarize Dat: Mean, Median, Mode
    • Mean=Average: One problem with avrages is that they’re easily influenced by outliers (離群）”=mean(….)”
    • Median=the middle value in a data set “=median(….)”
    • Mode=the most frequent value in the data set “=mode(….)
    • Q: A classroom had the following distribution of grades: 30 As, 10 Bs, 8 Cs, and 2 Ds.  What was the median grades? A: A
    • Σ (Σ) Standard Deviation (標準偏差）”=stdev(….)”
  3. The Data Analysis Process

想跟我一起當同學嗎？
點入左圖，報名去吧！