Goal: A school wants to analyze how parental education level and test preparation courses would affect a student's academic performance?
Many students take admissions tests, and they encounter various difficulties. Understanding and analyzing student performance on those examinations is vital for schools to determine how they may contribute to improving it. The performance of students might fluctuate amongst groups and be impacted by a variety of circumstances. A deeper comprehension of these elements can aid the school in developing methods to raise student achievement.
![image](https://private-user-images.githubusercontent.com/146320825/271217557-912cf6b5-192f-49e2-ab64-e0f5f9cb23ba.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMjcxMjE3NTU3LTkxMmNmNmI1LTE5MmYtNDllMi1hYjY0LWUwZjVmOWNiMjNiYS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02N2NjN2UxMmFjYjg4NTdiMzcwZDM1OTBlYWM4MGYyMjdlZTA1MDUxYzY1NGE2NjQzYmIwNWE3Y2FiNzJjNzI3JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.rppr4oqz41BP842Bf4jmuaOTNxskkcwYAXOvprXpscs)
There are 1000 rows and 9 columns in this dataset. Since there were no null values in this dataset, no data imputation was utilized during data preprocessing.
Both categorical and numerical column types are used to display data about the students, including gender, test preparation courses taken, parental education level, lunch, race/ethnicity groups, and scores on the writing, reading, and math sections of the admission test.
We also have a feature-engineered column called Obtained Score, which is a score total. Students' scores in the various portions of the test as well as the overall score are provided in numerical columns. However, categorized columns are giving us some further information about their background and exam preparation that can aid in our research.
We have used many data analysis approaches, such as
- Data aggregation and Data summary procedures, to filter our dataset into subsets and aggregate it using either the mean, mode, or median.
- To do our data aggregation based on quartiles, we have conducted analysis using the Minimum, Maximum, and Range values of the numerical columns. We were able to do an inter-quartile range analysis using these quartiles to identify outliers in a dataset.
- In addition to putting Measures of Location and Measures of Spread into practice, we also performed data visualization analysis by creating scatter plots, bar plots, and correlation graphs from our dataset.
- Power BI is used a a Data Visualisation tools to compile the data and reports.
Here are some conclusions we were able to draw from the aforementioned analysis:
Female students were able to perform better than male students when comparing their overall performance on the admissions test based on Obtained Score. However, if we look at the individual results, we find that female students did not perform any better than male students in math. However, they performed better in writing and reading than the study's male participants.
![image](https://private-user-images.githubusercontent.com/146320825/271220086-a84f579d-975a-4c38-8221-ba039456e4cc.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMjcxMjIwMDg2LWE4NGY1NzlkLTk3NWEtNGMzOC04MjIxLWJhMDM5NDU2ZTRjYy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jMzc5ZDhmYjhkNGM1NjhkMjBkZjVhZDk3YjIwYWJmMDhjN2M2YWE3NGY5ODgzMGVlYjgxODdkZTdhOTdkNjUzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.yeF6gVXetQ3jGbyGjv2cGno4H0eawU1WDF7T-o4rJUc)
According to overall scores and section-by-section scores, all students who were able to finish the test preparation courses were performing relatively better than other students.
![image](https://private-user-images.githubusercontent.com/146320825/271220648-ceb79659-6179-4f1f-adb0-d7df212b7009.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMjcxMjIwNjQ4LWNlYjc5NjU5LTYxNzktNGYxZi1hZGIwLWQ3ZGYyMTJiNzAwOS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1kMGZkNTg5NjQ0NTlkMTUwODE4OTIxODkzZjQ4NTExMTE1NzI3ZjA3MzU0MmNjZDNhZDA5MmQzZTRlMmQ2MmU1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.GOOGB6X8LTw78-pLt8_jkbCUiGDD_qto1It_fGue-uk)
We summed up our analysis at Parental Education Level in order to help you comprehend the significance of your parents' educational background. In comparison to students whose parents had some college or some high school as their parental level of education, those whose parents had significantly higher levels of education, such as Masters or bachelors, were able to earn decent grades.
![image](https://private-user-images.githubusercontent.com/146320825/271222311-a50bb2ed-0d51-4f49-85c7-c2bb4fbdb144.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMjcxMjIyMzExLWE1MGJiMmVkLTBkNTEtNGY0OS04NWM3LWMyYmI0ZmJkYjE0NC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1lOTJjNmRkMmM1ZDhlMThhZTc1YThhOTFkODdiNThmYjY4NGFiYjM4NDU0YTVjZTBjYWE3OTk4ODc5YWZhMGNjJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.gMqPkSr0zx715hhvr8SrCoKP8_u-lF41m6eNnP5dpsw)
We have determined that students have struggled the most in the Math part compared to other sections based on the minimum, mean, and median scores in the Math portion.
![image](https://private-user-images.githubusercontent.com/146320825/271221337-0bc53d14-22fd-4981-ba0a-d639f5802ed6.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMjcxMjIxMzM3LTBiYzUzZDE0LTIyZmQtNDk4MS1iYTBhLWQ2MzlmNTgwMmVkNi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wNWU2NWM5ZmVmOWY2ZjY0YzkxZGFkNjkzZDg3NWJhZGVjYjdiZjA4YTlmZTRiYmE1YWFkMGEwYjkyZjI0NzZjJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.7DJBPAUjJ9ng70PnMl5CIJcKphmUKGLBaPpqHfBvxU0)
Using the Interquartile Range, we were able to pinpoint two students who scored below either the IQR minimum or the bottom bound of the data distribution.
![image](https://private-user-images.githubusercontent.com/146320825/329759119-f8d55252-26a4-4f24-b03d-bfacd81364fc.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMzI5NzU5MTE5LWY4ZDU1MjUyLTI2YTQtNGYyNC1iMDNkLWJmYWNkODEzNjRmYy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jNDhhZjY2NzIxNjIwMjdiMzc0MGRmYTA5NDIzOGFkMmU0MDkzZjQwMzRiNTdlNGI0NDVlODkxMGJmZDMyZGQxJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.lc6go20U4u3cVMmCqNpxyGAywbJQHtTdYI7EJhI6nsQ)
![image](https://private-user-images.githubusercontent.com/146320825/329759401-1d86f5cb-e59a-4c0c-9a7b-8f8ae08ee90f.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMzI5NzU5NDAxLTFkODZmNWNiLWU1OWEtNGMwYy05YTdiLThmOGFlMDhlZTkwZi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wYWRjYjBmOTRlYzliNWJkM2NmNDc3NjAyMDgzYjIxNWM3MDBiOGRmZmU1MTFlNzFiZjkyZDk5MWZjZjdiODI2JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.QTygTVLofV4yGkWzExe4ZjG29PRurw69da6qF3qFXYw)
- We now know that parents play a substantial part in a student's performance improvement. Parents who are educated, for instance, who hold a bachelor's or master's degree can better inspire and prepare their children for the admissions test. For parents who don't have a lot of education, schools can also set up extra help and training courses. so that these parents can inspire their kids and contribute more effectively to their achievement.
- According to the dataset analysis, students who have completed test preparation classes can do better on all of the admissions exam's sections and earn higher grades. So that students can perform better on tests, schools should push them to finish preparation courses that allow them to practice all portions conceptually and practically.
![image](https://private-user-images.githubusercontent.com/146320825/271222000-12c75db7-f6b9-4878-b914-08601d4ab821.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM2NzE0NTUsIm5iZiI6MTcyMzY3MTE1NSwicGF0aCI6Ii8xNDYzMjA4MjUvMjcxMjIyMDAwLTEyYzc1ZGI3LWY2YjktNDg3OC1iOTE0LTA4NjAxZDRhYjgyMS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNFQyMTMyMzVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1iY2Q1YjEwNDhiNGQ2MDI5OGY0NjQxY2NmZTAyODFlMzljZTFhN2E1MWZjYzJhOTIwNTI5YTM4N2Y4NWUyMmJiJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.WxMtxzsXCQgIzRbUagBuEYmoN39bb6kZDElM2JN15pI)