1 of 7

# of Cram Schools in Area

vs

Acceptance Rate to Top-Tier Univ.

Chae Lee

​

2 of 7

Hypothesis

© 2017 Udacity. All rights reserved.

# of cram schools in area affects to the acceptance rate to Top-Tier university.

​

** The raw data is from South Korea, and Top-Tier university in Korea is Seoul National University (SNU).

2

3 of 7

Data Cleaning & Evaluation

© 2017 Udacity. All rights reserved.

Original dataset

  1. Number of cram schools in each county (2015 - 2017)
  2. College enrollment / employment / others rates after graduating high school (2018)
  3. Number of students enrolled in Seoul National University by High School (2018)

Refined dataset

Total graduates, college enrollment, employments, others by area(county)

Average number of cram schools from 2015 - 2017 (the years affected to students who graduated on 2018)

Enrollment for Seoul National University (SNU) by area(county)

​

Total 231 Areas, 476,123 Students.

Refining dataset to get useful data for my hypothesis

3

4 of 7

Data Cleaning & Evaluation

Technology used for this step

© 2017 Udacity. All rights reserved.

Utilized VBA for getting the data�1. Get number of students enrolled in SNU by high school

2. From 1, get the area of the high school and find the area and add the number of enrollment.

3. Merge 2 with the dataset containing information about graduates college enrollment / employments / others rate.

** Since the original dataset contains state and county separately, I merged them into one cell ahead of processing the dataset utilized VBA.

4

5 of 7

Conclusion

I wasn’t able to find a strong correlation between # of cram schools in area and acceptance rate to Top-Tier university.

© 2017 Udacity. All rights reserved.

As we can see from the graphs, I cannot find a strong correlation between # of cram schools in area and acceptance rate to Top-Tier University (SNU) - R^2 only 0.1309.

​

Also, it looked like there is a stronger correlation between college enrollment and # of cram schools in area than vs top-tier university enrollment rate - R^2 is 0.3111.

5

6 of 7

Group Photo

© 2017 Udacity. All rights reserved.

6

Thank you

7 of 7

Works Cited

© 2017 Udacity. All rights reserved.

  • KOrea Statistical Information Service, # of cram schools by area; 07/02/2018; http://kosis.kr/statHtml/statHtml.do?orgId=101&tblId=DT_1PE101&vw_cd=MT_ZTITLE&list_id=&seqNo=&lang_mode=ko&language=kor&obj_var_id=&itm_id=&conn_path=K2
  • KOrea Statistical Information Service, College Enrollment / Employment / Others Rates for High School Graduates; 07/02/18; http://kosis.kr/statisticsList/statisticsListIndex.do?menuId=M_01_01&vwcd=MT_ZTITLE&parmTabId=M_01_01&parentId=O.1;O1.2;334_33409.3;334_33409_008.4;#334_33409_008.4
  • Chosun Newspaper, Enrollment to SNU by High School; 07/02/18; http://image.chosun.com/appetizer//2018_HIGH.pdf

7