<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>Age Group</th>
      <th>Frequency</th>
      <th>Percentage</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>51 years and above</td>
      <td>6</td>
      <td>40.000000</td>
    </tr>
    <tr>
      <th>1</th>
      <td>20-30 years</td>
      <td>4</td>
      <td>26.666667</td>
    </tr>
    <tr>
      <th>2</th>
      <td>41-50 years</td>
      <td>3</td>
      <td>20.000000</td>
    </tr>
    <tr>
      <th>3</th>
      <td>31-40 years</td>
      <td>2</td>
      <td>13.333333</td>
    </tr>
  </tbody>
</table>
</div>

            Age Group  Frequency  Percentage
0  51 years and above          6   40.000000
1         20-30 years          4   26.666667
2         41-50 years          3   20.000000
3         31-40 years          2   13.333333

<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>No</th>
      <th>Age</th>
      <th>Gender</th>
      <th>Marital status</th>
      <th>Educational level</th>
      <th>HIV Status</th>
      <th>Age Group</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>1</td>
      <td>54</td>
      <td>Male</td>
      <td>married</td>
      <td>secondary</td>
      <td>Negative</td>
      <td>51 years and above</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2</td>
      <td>52</td>
      <td>Female</td>
      <td>married</td>
      <td>secondary</td>
      <td>negative</td>
      <td>51 years and above</td>
    </tr>
    <tr>
      <th>2</th>
      <td>3</td>
      <td>42</td>
      <td>Female</td>
      <td>single</td>
      <td>tertiary</td>
      <td>negative</td>
      <td>41-50 years</td>
    </tr>
    <tr>
      <th>3</th>
      <td>4</td>
      <td>72</td>
      <td>Male</td>
      <td>divorce</td>
      <td>primary</td>
      <td>positive</td>
      <td>51 years and above</td>
    </tr>
    <tr>
      <th>4</th>
      <td>5</td>
      <td>36</td>
      <td>Male</td>
      <td>widower</td>
      <td>primary</td>
      <td>negative</td>
      <td>31-40 years</td>
    </tr>
    <tr>
      <th>5</th>
      <td>6</td>
      <td>63</td>
      <td>Female</td>
      <td>married</td>
      <td>tertiary</td>
      <td>negative</td>
      <td>51 years and above</td>
    </tr>
    <tr>
      <th>6</th>
      <td>7</td>
      <td>30</td>
      <td>Male</td>
      <td>married</td>
      <td>tertiary</td>
      <td>positive</td>
      <td>20-30 years</td>
    </tr>
    <tr>
      <th>7</th>
      <td>8</td>
      <td>25</td>
      <td>Female</td>
      <td>single</td>
      <td>non-formal</td>
      <td>positive</td>
      <td>20-30 years</td>
    </tr>
    <tr>
      <th>8</th>
      <td>9</td>
      <td>38</td>
      <td>Male</td>
      <td>single</td>
      <td>non-formal</td>
      <td>positive</td>
      <td>31-40 years</td>
    </tr>
    <tr>
      <th>9</th>
      <td>10</td>
      <td>42</td>
      <td>Female</td>
      <td>divorce</td>
      <td>secondary</td>
      <td>positive</td>
      <td>41-50 years</td>
    </tr>
    <tr>
      <th>10</th>
      <td>11</td>
      <td>20</td>
      <td>Male</td>
      <td>married</td>
      <td>primary</td>
      <td>negative</td>
      <td>20-30 years</td>
    </tr>
    <tr>
      <th>11</th>
      <td>12</td>
      <td>42</td>
      <td>Female</td>
      <td>single</td>
      <td>tertiary</td>
      <td>negative</td>
      <td>41-50 years</td>
    </tr>
    <tr>
      <th>12</th>
      <td>13</td>
      <td>20</td>
      <td>Male</td>
      <td>married</td>
      <td>tertiary</td>
      <td>positive</td>
      <td>20-30 years</td>
    </tr>
    <tr>
      <th>13</th>
      <td>14</td>
      <td>55</td>
      <td>Female</td>
      <td>widower</td>
      <td>non-formal</td>
      <td>positive</td>
      <td>51 years and above</td>
    </tr>
    <tr>
      <th>14</th>
      <td>15</td>
      <td>68</td>
      <td>Male</td>
      <td>married</td>
      <td>primary</td>
      <td>negative</td>
      <td>51 years and above</td>
    </tr>
  </tbody>
</table>
</div>

    No  Age  Gender Marital status Educational level HIV Status  \
0    1   54    Male        married         secondary   Negative   
1    2   52  Female        married         secondary   negative   
2    3   42  Female         single          tertiary   negative   
3    4   72    Male        divorce           primary   positive   
4    5   36    Male        widower           primary   negative   
5    6   63  Female        married          tertiary   negative   
6    7   30    Male        married          tertiary   positive   
7    8   25  Female         single        non-formal   positive   
8    9   38    Male         single        non-formal   positive   
9   10   42  Female        divorce         secondary   positive   
10  11   20    Male        married           primary   negative   
11  12   42  Female         single          tertiary   negative   
12  13   20    Male        married          tertiary   positive   
13  14   55  Female        widower        non-formal   positive   
14  15   68    Male        married           primary   negative   

             Age Group  
0   51 years and above  
1   51 years and above  
2          41-50 years  
3   51 years and above  
4          31-40 years  
5   51 years and above  
6          20-30 years  
7          20-30 years  
8          31-40 years  
9          41-50 years  
10         20-30 years  
11         41-50 years  
12         20-30 years  
13  51 years and above  
14  51 years and above  

(            Age Group  Frequency  Percentage
 0  51 years and above          6   40.000000
 1         20-30 years          4   26.666667
 2         41-50 years          3   20.000000
 3         31-40 years          2   13.333333,
    Gender  Frequency  Percentage
 0    Male          8   53.333333
 1  Female          7   46.666667,
   Marital Status  Frequency  Percentage
 0        married          7   46.666667
 1         single          4   26.666667
 2        divorce          2   13.333333
 3        widower          2   13.333333,
   Educational Level  Frequency  Percentage
 0          tertiary          5   33.333333
 1           primary          4   26.666667
 2         secondary          3   20.000000
 3        non-formal          3   20.000000)

Vizly: AI-powered data analysis

Age Group Distribution Analysis

What are the age group distributions?

"Analyze the given dataset of 15 respondents from Pamplap community using VIZLY. First, categorize respondents' ages into four groups: 20-30 years, 31-40 years, 41-50 years, and 51 years and above. Create a database from this categorized data.

Yes

Frequency and Percentage Distribution of Age Groups

Frequency and Percentage Distribution of Gender

Frequency and Percentage Distribution of Marital Status

Frequency and Percentage Distribution of Educational Levels

Age Group	Frequency	Percentage
51 years and above	6	40.00%
20-30 years	4	26.67%
41-50 years	3	20.00%
31-40 years	2	13.33%

Educational Level	Frequency	Percentage
tertiary	5	33.33%
primary	4	26.67%
secondary	3	20.00%
non-formal	3	20.00%