Treehouse: Beginning Data Analysis FOOD BAKING COOKING TECH SOFTWARE WEBSITE DIGITAL MARKETING LIFE Living Insight Sports Shopping Camping Menu FOOD BAKING COOKING TECH SOFTWARE WEBSITE DIGITAL MARKETING LIFE Living Insight Sports Shopping Camping Photo by Sabri Tuzcu on Unsplash Treehouse: Beginning Data Analysis September 11, 2018 對數字我有不同的鍾愛,我記不住買這個東西要多少錢,那種數字,但是對數據會影響決定的數字是很感興趣的,從溫哥華工作一個月回來,對心裡那份自卑感更重,對自己沒有文筆,沒有設計美感,沒有創意,更沒有速度,好多挫敗。也許可以專注一點還有點興趣的東西,往數據分析和表格,好好努力吧!就從Treehouse的這系列課程開始吧! Course 1: Spreadsheet Basics September 11, 2018 Introducing SpreadsheetsGetting Started With SpreadsheetSpreadsheet Functions & shortcutsSpreadsheet Best PracticesBuild 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 Introducing Data AnalysisDataset: A collection of dataCognitive bias 認知偏見CSV: Comma Separated ValuesGetting to Know Your DataSummarize Date: Maximum, Minimum, Range (=max(…..), =min(…..), Range=max-min)Shortcut key: Command + Shit +DownArrow 全選以下全部Summarize Dat: Mean, Median, ModeMean=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(….)”The Data Analysis Process 想跟我一起當同學嗎?點入左圖,報名去吧!