<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Unnamed: 0</th>
      <th>Unnamed: 1</th>
      <th>AJAYI  CROWTHER  UNIVERSITY, OYO, NIGERIA</th>
      <th>Unnamed: 3</th>
      <th>Unnamed: 4</th>
      <th>Unnamed: 5</th>
      <th>Unnamed: 6</th>
      <th>Unnamed: 7</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>1</th>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>2</th>
      <td>NaN</td>
      <td>FACULTY</td>
      <td>SOCIAL SCIENCES</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>SEMESTER</td>
      <td>NaN</td>
      <td>FIRST</td>
    </tr>
    <tr>
      <th>3</th>
      <td>NaN</td>
      <td>DEPARTMENT</td>
      <td>ECONOMICS</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>SESSION</td>
      <td>NaN</td>
      <td>2023/2024</td>
    </tr>
    <tr>
      <th>4</th>
      <td>NaN</td>
      <td>PROGRAMME</td>
      <td>B.Sc. ECONOMICS</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>LEVEL</td>
      <td>NaN</td>
      <td>100</td>
    </tr>
  </tbody>
</table>
</div>

  Unnamed: 0  Unnamed: 1 AJAYI  CROWTHER  UNIVERSITY, OYO, NIGERIA Unnamed: 3  \
0        NaN         NaN                                       NaN        NaN   
1        NaN         NaN                                       NaN        NaN   
2        NaN     FACULTY                           SOCIAL SCIENCES        NaN   
3        NaN  DEPARTMENT                                 ECONOMICS        NaN   
4        NaN   PROGRAMME                           B.Sc. ECONOMICS        NaN   

  Unnamed: 4 Unnamed: 5 Unnamed: 6 Unnamed: 7  
0        NaN        NaN        NaN        NaN  
1        NaN        NaN        NaN        NaN  
2        NaN   SEMESTER        NaN      FIRST  
3        NaN    SESSION        NaN  2023/2024  
4        NaN      LEVEL        NaN        100  

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>S/N</th>
      <th>Matric No</th>
      <th>Name</th>
      <th>Unnamed: 3</th>
      <th>CA</th>
      <th>Exam</th>
      <th>Total</th>
      <th>Grade</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>0.3</td>
      <td>0.7</td>
      <td>100.0</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>1</th>
      <td>1.0</td>
      <td>23EDO5001</td>
      <td>IDOWU</td>
      <td>Olanike Tolani</td>
      <td>22</td>
      <td>39</td>
      <td>61.0</td>
      <td>B</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2.0</td>
      <td>23SO5001</td>
      <td>ADEGBILE</td>
      <td>David Darasimi</td>
      <td>25</td>
      <td>26</td>
      <td>51.0</td>
      <td>C</td>
    </tr>
    <tr>
      <th>3</th>
      <td>3.0</td>
      <td>23SO5005</td>
      <td>AKINRINDE</td>
      <td>Hossanah Oluwaferanmi</td>
      <td>24</td>
      <td>26</td>
      <td>50.0</td>
      <td>C</td>
    </tr>
    <tr>
      <th>4</th>
      <td>4.0</td>
      <td>23SO5006</td>
      <td>AKINSEYE</td>
      <td>Inioluwa Ajibola</td>
      <td>24</td>
      <td>36</td>
      <td>60.0</td>
      <td>B</td>
    </tr>
  </tbody>
</table>
</div>

   S/N  Matric No        Name             Unnamed: 3   CA Exam  Total Grade
0  NaN        NaN         NaN                    NaN  0.3  0.7  100.0   NaN
1  1.0  23EDO5001       IDOWU         Olanike Tolani   22   39   61.0     B
2  2.0   23SO5001    ADEGBILE         David Darasimi   25   26   51.0     C
3  3.0   23SO5005  AKINRINDE   Hossanah Oluwaferanmi   24   26   50.0     C
4  4.0   23SO5006    AKINSEYE       Inioluwa Ajibola   24   36   60.0     B

('Pearson correlation coefficient: -0.678',
 'p-value: 2.756e-03',
 'Reject the null hypothesis: There is a statistically significant correlation between CA scores and Total scores.')

Exploring Student Academic Records in 100 LEVEL Excel File

What is the distribution of data in the file?

Test the hypothesis that there is no statistically significant correlation between CA scores and Total scores for the students

Hypothesis Test Summary