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

想跟我一起當同學嗎?
點入左圖,報名去吧!