ECO220Y1 Lecture Notes - Lecture 4: Histogram, Data Analysis, Particulates

44 views5 pages

18 May 2018

School

Department

Course

Professor

For unlimited access to Class Notes, a Class+ subscription is required.

Module A.2: Histograms and Descriptive Statistics

B) Data tab → [Data analysis] → [Descriptive Statistics]

C) When making histograms using the default histogram feature on Excel, you don’t have as

much flexibility in terms of customizing your histogram.

- Select manuf_share column, hold [Command] + [Shift] + ↓

find more resources at oneclass.com

Unlock document

This preview shows pages 1-2 of the document.
Unlock all 5 pages and 3 million more documents.

Already have an account? Log in

D) Data tab → Data analysis → Histogram → Input range → Column J (manuf_share)

Format the histogram: Change gap width to 0%, make border black

F) Go to Manufacturing Share Histogram Worksheet

Data tab → Data analysis → Histogram

To adjust decimal places, select the manuf_share column → Format tab (at the top) → Cells

→ Number → 1 decimal place

find more resources at oneclass.com

Unlock document

This preview shows pages 1-2 of the document.
Unlock all 5 pages and 3 million more documents.

Already have an account? Log in

jimmm and 37654 others unlocked

Get access