Data Analysis Project 

Click here to edit subtitle

DATA ANALYSIS 

Questions

   1. Which gender performs the greatest in mathematics?

   2. Which gender performs better on exams overall?

   3. Does completing a test preparation course improve the student’s exam grade?

   4. Which race/ethnic group performs best in reading and writing?

   5. What percentage of students scored a 90 or higher in all three subjects? 

   6. Do the educational levels of the parents affect the success of the student?

   7. Does a student’s lunch choices impact their test scores

     1. Which gender performs the greatest in mathematics?

         According to the dataset, the females outperform males in reading and writing by a staggering margin, however they are   
         outperformed by males in math by more than four percent. No clear relations were given to any of the other factors, and it would have been a 
         good idea to include data for whether or not they were involved in a school club or program. This would have provided another solid variable to 
         determine possible relations. 

      2. Which gender performs better on exams overall?


          After performing the calculations for question one, It was already clear that the females had a higher exam average overall, as the males were 

          only better at math. As the chart above demonstrates, the females scored, on average 4.3 percent higher than the males across all subjects. 

      3. Does completing a test preparation course improve the student’s exam grade?


         Based on the data above, taking a test preparation corse is indeed the correct choice in order to score higher on exams. It is particularly 

         effective for reading and writing, as a preparation corse in those two subjects adds ten percent onto the average of those you did not take the 

         course. The course does help in math, but unlike the other two, it only increased the math score average by five percent. 


    4.  Which race/ethnic group performs best in reading and writing?


         As shown in the chart above, group E outperformed every other group in reading and writing. The data that I analyzed had no clear pattern as to           why this was, however group E had a female majority, as well as a larger number of students overall. As shown in above charts, females excel 

         greatest at reading and writing. This could have helped increase the average and shown group E in a more favorable light. 

     5. What percentage of students scored a 90 or higher in all three subjects? What is the percentage of each gender?


         The data above shows the number of students that were able to achieve a 4.0 throughout all of their subjects. As demonstrated in the chart on 

         the left, out of all of the students, only twenty-one females and nine males achieved this, making the total three percent of examinees acquired a 

         4.0, as shown in the right chart. Most of these students had parents with advanced degree levels with only a few exceptions. 

     6. Do the educational levels of the parents affect the success of the student?


        As presented in the chart above, the parents level of education does indeed play a significant role. Each student's parents degree is listed above 

        as well as the student average. Those students who had parents with a Master's degree or higher scored 1.7% higher than those who had 

        parents with Bachelor's degrees. However despite the relatively predictable curve, it did come as a surprise that those who's parents did not 

        finish high school scored two percent higher than those who did. 

     7. Does a student’s lunch choices impact their test scores?


         After analyzing this data, it is clear that a standard lunch is indeed related to scoring higher on the exams. From what I learned in the data, there 

         is a bit of a correlation between what lunch the students eat and their parents level of education. For example, most of the students who ate a 

         standard lunch had parents possessing a bachelors degree and above. This could be a money related development and because the students 

         were less worried about saving money they did not pay attention to the cost of their lunch quite as much.