This training will equip you a set of practical statistical analysis techniques in two days. It includes (i) easy-to-understand theoretical background; (ii) how to operate Excel; (iii)detailed hand calculation using only addition, subtraction, division and multiplication (+, -, ÷, x), and (iv) how to read thesis papers in professional journals (economics, sociology, education, evaluation, etc.). Maybe you will surprise because you think “Is it possible using only Excel and simple hand-calculation?”. You can see the participants survey results posted below and those make you understand and become in confidence about our achievement.
The course consists of: (i) presentation of actual examples of Impact Evaluation based on five basic designs; (ii) calculation of means (averages), etc., (iii) t-test (judgement of two sample means), (iv)chi-square test (judgement of “yes” and “no” ratio), and (iv) regression analysis (Y=aX+b, using several variables). Surprisingly enough, those will be presented not only by Excel operation but also by hand-calculation even for regression analysis! It is rare opportunity and you can experience the actual calculation procedures behind the Excel program.
Then, you will practice the latest analysis methods for impact evaluation: (i) the difference in difference (DID), (ii) propensity score matching (PSM), and (iii) instrumental variable (IV). Surprisingly enough again, those will be presented not only by Excel operation but by hand-calculation. It is very rare opportunity in the world and you can experience the actual calculation procedures behind the STATA/SPSS programs.
Lastly, an individual counseling session will be held for those who are facing statistical issues, including research method selection, thesis writing, dissertation writing, and any general inquiries of statistical analysis. If you would like to join individual consultation, please contact us in advance.
A certificate of achievement will be awarded for those who complete the 3 days training.
Certificate of Completion (English, instructor-signed)is awarded after an attendant submit the sheet recording his/her attendance. You can easily add it with your resume by PDF format you generate by yourself.
※ The word in the title , “professional”, is the same meaning of differentiation of Academic School/Professional School in American Universities.
※Program (time table) is available Here.
Ex-post survey results are downloadable, here.
| Date | Date：2024 August 26 (Mon) 9:30-12:30 for a half-day presentation26 (Mon) 13:30-16:30, 28 (Wed) 9:30-17:30, 30 (Fri) 9:30-17:30 (Japan Time (JST)) |
|---|---|
| Venue | Zoom. You can access anywhere in the world. Lectures will be video-recorded. Participants can access and watch those videos (in one week after the workshop) |
| Language | English. (Instructors are Ph.D. holders from American universities). |
| Host | IDCJ Evaluation Department |
| Number of participants | Max 30 (Minimum Attendants for implementation:10 people) |
| Prerequisites |
(1) You should be able to implement addition, subtraction, multiplication, division (+, –, ÷, ×). (2) You should have experience in using Microsoft Excel: (i) You should be able to input numbers smoothly. (ii) You should have experience in using “Auto-sum” icon. (3) You should be able to prepare and bring a Windows OS personal computer (Mac OS is acceptable) Note: “Excel Mobile for Tablet” is not acceptable because its version does not have Analysis Tools. |
| Necessary items to bring |
(i) A Windows OS personal computer (It is preferable that CPU is Core-i5 or faster). (ii) A monitor or another personal computer (Its screen size should larger than 12 inch). (iii) Writing tools (a pen or pencil, a high-light pen and an eraser) (iv) A hand calculator (Smartphone is acceptable). |
| Register | Please fill-in the Google Form. (Please fill your physical address for those who want to receive a package of printed version of textbooks.) Google forms Contact: Ryo SASAKI (sasaki.ryo (a) idcj.or.jp) Due date: August 16 (Fri), 2024. |
| Fee | JPY39,000 (tax included) for full three days participation: |
| Text | A set of softcopy of texts will be distributed in advance in PDF format. In addition, the set of hardcopy of texts will be sent in advance to the residents in Japan who wish to receive them. |
| Instructor | Ryo SASAKI, Ph.D.in Evaluation, Western Michigan University (USA) Keiichi TAKAKI, Ph.D. in Sociology, Stanford University (USA) |
| Contact | Ryo SASAKI (sasaki.ryo(a)idcj.or.jp) |