Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Excel의 데이터 집계
- 통계 함수
- 요점
- 소계
- 피벗 테이블
데이터 관계 분석
- 정규 분포
- 설명 Statistics
- 선형 상관
- 회귀 분석
- 공분산
시간에 따른 데이터 분석
- 추세/회귀선
- 선형, 대수, 다항식, 거듭제곱, 지수, 이동 평균 평활화
- 계절 변동 분석
인구 비교
- 평균에 대한 신뢰구간
- 모집단 평균에 관한 가설 검정
- 두 모집단의 평균 차이
- ANOVA: 분산 분석
- Go 이산형 무작위 변수에 대한 적합도 검정
- 독립성 테스트: 분할표
- 두 모집단의 분산에 관한 검정 가설
Forecasting
- 외삽법
Requirements
참가자는 Excel 및 Statistics의 기본 사항에 익숙해야 합니다.
14 Hours
회원 평가 (3)
1. Clear theoretical explanation of concepts and alternatives to problem solving. 2. Practical examples where concepts are, and can be applied. 3. I learnt skills that I can use in my job, which will make some of my work easier 4. It will definitely bring some innovation into some of the reports I prepare for different Committees.
Sindiso Ndlovu - Export Credit insurance corporation
Course - Excel For Statistical Data Analysis
Steve was willing to answer every questions and worked diligently to address any individual concerns or technical issues as they arose in the class. He also did a great job of presenting the technical details in a way that made it less intimidating to even the least tech savvy people in the room. Personally, learning about some useful shortcuts in Excel that I didn't know about will certainly improve my overall workflow when using Excel in the future! I am so appreciative of those little details that I was exposed to during the two-day training.
Alan Gonzalez - Queens College, CUNY
Course - Excel For Statistical Data Analysis
The fact he had dif excel and data sheets with exercises for us to do.
