Chapter1자료와통계학
블룸버그비즈니스위크-NEWYORK,NEWYORK················4
1경영및경제분야에서의활용············································5
1.회계············································································5
2.재무············································································6
3.마케팅········································································6
4.생산운영관리·································································6
5.경제············································································6
6.정보시스템···································································7
2자료·················································································7
1.원소,변수,관측값·························································7
2.측정을위한척도····························································9
3.범주형자료와양적자료················································10
4.횡단면자료와시계열자료··············································10
3자료의출처····································································13
1.현존하는자료······························································13
2.관측연구····································································15
3.실험··········································································15
4.시간과비용이슈··························································16
5.자료수집오류·····························································16
4기술통계········································································16
5통계적추론····································································18
6엑셀을활용한통계분석···················································20
1.데이터세트와엑셀워크시트···········································20
2.통계분석에서의엑셀활용···············································21
7애널리틱스·····································································22
8빅데이터와데이터마이닝················································23
9통계분석을위한윤리적지침···········································24
요점정리···································································26
보충문제···································································26
Chapter2기술통계:표와그래프를이용한표현
콜게이트-NEWYORK,NEWYORK·····································34
1범주형자료요약·····························································35
1.도수분포표·································································35
2.상대도수분포표와백분율도수분포표·································36
3.엑셀을활용한도수분포표,상대도수분포표,백분율도수분포표작성·········································································37
4.막대그래프와원그래프··················································38
5.엑셀을활용한막대그래프작성········································40
연습문제···································································42
2양적자료요약································································44
1.도수분포표·································································44
2.상대도수분포표와백분율도수분포표·································46
3.엑셀을활용한도수분포표작성········································46
4.점그래프····································································48
5.히스토그램·································································49
6.엑셀을활용한히스토그램작성········································50
7.누적도수분포·······························································52
8.줄기-잎그림·······························································53
연습문제···································································56
3표를이용한두변수자료요약·········································59
1.교차표······································································59
2.엑셀피봇테이블을활용한교차표작성······························61
3.심슨의역설································································63
연습문제···································································64
4그래프를이용한두변수자료요약···································66
1.산점도와추세선···························································66
2.엑셀을활용한산점도와추세선작성·································68
3.묶은막대그래프와누적막대그래프·································70
4.엑셀을활용한묶은막대그래프와누적막대그래프작성·········72
연습문제···································································73
5자료시각화:효과적인자료시각화방안··························75
1.효과적인그래프표현방법··············································75
2.그래프표현형식선택···················································76
3.데이터대시보드···························································77
4.자료시각화사례:신시내티동물원과식물원······················78
요점정리···································································80
보충문제···································································81
사례연구1.펠리칸스토어·············································84
사례연구2.영화개봉···················································85
Ch
