The Excel Apostle

The Excel Apostle Data: General data related task: Data analysis/ Mathematics

THE 'WATU WASOMEE KWAO' DEBATE: TRIBALISM OR ACCOUNTABILITY IN SCHOOL PLACEMENTS?Analysis of comments from an online pos...
07/01/2026

THE 'WATU WASOMEE KWAO' DEBATE: TRIBALISM OR ACCOUNTABILITY IN SCHOOL PLACEMENTS?

Analysis of comments from an online post by Ndungu Nyoro reveals that;
✅ 65.4% of respondents support the locals-first idea in national school admissions.
Main reasons cited by supporters:
>Accountability & devolution:
“We built these schools—leaders must serve locals.”
Quota logic:
>Reserve ~50–60% for qualified local learners (common proposals: 50%, 60%, 70%, even up to 80%).
>Practicality:
Nearer schools reduce transport, safety, and cost burdens.

✅23.1% of respondents are Opposing the idea and maintain that "Keep National Schools Truly National
Main reasons cited by opponents:
>Meritocracy:
“Placement should be based on marks and qualification, not locality.”
>National cohesion & exposure:
“National schools must reflect unity and diversity—students from all regions.”
>Risk of tribalism:
“Localizing admissions is backward and promotes tribalism.”

11.5% have posed Unresolved questions
>Who counts as “local”? especially in big cities?

CONCLUSION
Supporters frame it as fairness and accountability, while opponents see it as a threat to equity and national unity. The unresolved question remains: How to balance local empowerment with merit and integration?
Data Source; Social media post by; Ndungu Nyoro
Data Compiled; https://docs.google.com/spreadsheets/d/1OVNXGaE7BfXkQ45zhDIen0OyPCuAIR75x2IHjG6OHnM/edit?usp=sharing

KENYANS’ REACTION TO ATWOLI’S ENDORSEMENT (JAN 6, 2026)From a sample size of 719 online reactions, 637/719 or (88.6%) re...
07/01/2026

KENYANS’ REACTION TO ATWOLI’S ENDORSEMENT (JAN 6, 2026)

From a sample size of 719 online reactions,
637/719 or (88.6%) respondents strongly opposed the endorsement of Francis Atwoli for another term as COTU Secretary General.
Main Reasons for Opposition:
>Leadership longevity concerns: Frequent mentions of “forever term,” “till death,” and comparisons to long-serving African leaders like Museveni and Mugabe.
>Youth unemployment: Calls for generational change and opportunities for younger professionals.
>Perceived corruption: Allegations of bribery and lack of democratic processes in endorsements.

46/719 or 6.4% of comments expressed confidence in Atwoli’s experience and continuity, congratulating him and emphasizing stability.

Around 5% of comments were unrelated (memes, jokes, or promotional content).

CONCLUSION
The reaction was heavily skewed toward opposition, signaling strong public sentiment against prolonged tenure and a desire for leadership renewal and transparency in trade union governance.
Source of Data; Social media online post by Kenyans.co.ke
Data Compiled; https://docs.google.com/spreadsheets/d/1tVnl6Z_poFsmpeYKpBvzlCeZWq_MwfPpycJNzh1jsNg/edit?usp=sharing

RANKING OF AFRICAN COUNTRIES BY ENGLISH PROFICIENCYAnglophone countries lead English proficiency in Africa. Zimbabwe and...
07/01/2026

RANKING OF AFRICAN COUNTRIES BY ENGLISH PROFICIENCY

Anglophone countries lead English proficiency in Africa. Zimbabwe and South Africa (13) rank highest, followed by Kenya (19). Zambia, Nigeria, and Ghana sit mid-table, while Uganda underperforms. Morocco, Tunisia, and Ethiopia rank lowest, reflecting education systems less centered on English. Overall, strong English policy correlates with better global competitiveness.

Source of data; 2025 EF English Proficiency Index (EF EPI) rankings; https://www.ef.com/wwen/epi/?utm_source=chatgpt.com

PUBLIC REACTIONS AS HE RUTO PROPOSES DEATH BY HANGING LAW FOR DRUG TRAFFICKERSFrom a sample size of 281 annotated tones,...
04/01/2026

PUBLIC REACTIONS AS HE RUTO PROPOSES DEATH BY HANGING LAW FOR DRUG TRAFFICKERS

From a sample size of 281 annotated tones, the sentiment distribution shows that:
> Most Respondents (202 → 71.9%) are Negative/Against the proposal. They have expressed criticism, hostility, sarcasm or distrust. They are concerned about fairness, misuse and ignoring corruption.
>17% of the respondents are Neutral
These responses were largely conditional, questioning or factual, showing a wait‑and‑see attitude dependent on legal clarity and equal application.
>Positive (32 → 11.4%)
A small group offered support, mainly valuing a tough stance on crime

OVERAL SUMMARY.
Across reactions, corruption is mentioned as a central concern. Many argue that: corruption is a larger and more systemic national threat than drug trafficking and call upon the president William Samoei Ruto to introduce the death penalty to address corruption also. The public perceives the policy as incomplete unless corruption is equally targeted.
Source of Data; Public sentiments from a post by Kenyans.co.ke
Compiled Sentiments; https://docs.google.com/spreadsheets/d/1VzEUCkcdMXXltdRgNcSdZb_dBtWvcRekmK730xLbbsc/edit?usp=sharing

03/01/2026

EARLY VISUALIZATION

Charles Minard’s 1869 chart showing Napoleon Bonaparte’s 1812 Russian campaign of his army and their movements.
Minard’s chart is considered “probably the best statistical graphic ever drawn.”

WHY IS IT CONSIDERED THE BEST?
The visualization depicts Napoleon’s army departing the Polish-Russian border. It’s a bitter and cold winter. You can see the trajectory of the march and the geography of the landscape such as rivers. There is a thick band that illustrates the size of his army at specific geographic points during their advance and retreat. It displays six types of data in two dimensions:

The number of Napoleon’s troops
The distance traveled
The temperature
Latitude and longitude
Direction of travel
Location relative to specific dates without making mention of Napoleon

Source: Wikipedia for Charles Joseph Minard

EARLY VISUALIZATIONCharles Minard’s 1869 chart showing Napoleon Bonaparte’s 1812 Russian campaign of his army and their ...
03/01/2026

EARLY VISUALIZATION

Charles Minard’s 1869 chart showing Napoleon Bonaparte’s 1812 Russian campaign of his army and their movements.
Minard’s chart is considered “probably the best statistical graphic ever drawn.”

WHY IS IT CONSIDERED THE BEST?
The visualization depicts Napoleon’s army departing the Polish-Russian border. It’s a bitter and cold winter. You can see the trajectory of the march and the geography of the landscape such as rivers. There is a thick band that illustrates the size of his army at specific geographic points during their advance and retreat. It displays six types of data in two dimensions:

The number of Napoleon’s troops
The distance traveled
The temperature
Latitude and longitude
Direction of travel
Location relative to specific dates without making mention of Napoleon

Source: Wikipedia for Charles Joseph Minard

31/12/2025
ANALYSIS OF PUBLIC REACTIONS AS FORMER ENERGY BOSS, CHARLES KETER, DECLARES INTEREST FOR KERICHO GOVERNARSHIP SEAT.1. Ma...
31/12/2025

ANALYSIS OF PUBLIC REACTIONS AS FORMER ENERGY BOSS, CHARLES KETER, DECLARES INTEREST FOR KERICHO GOVERNARSHIP SEAT.

1. Majority of reactions are Positive (~52.4%)
This shows that more than half of the commenters expressed approval, excitement, or support for the announced comeback bid.
2.About a third are Negative ( ~27.9%)
A significant portion expresses concerns, dissatisfaction, or outright criticism; Past grievances tied to leadership performance.
Fears of political recycling. Criticism of perceived arrogance, clan/constituency imbalance, or previous administrative records.
3. Neutral comments (~11.6%)
General observations IE
Philosophical statements (“God’s time is best”).
Analytical or informational takes (mentioning political dynamics, relationships, constituency distribution).
4. Promotional/Spam content (~8.2%)
These are unrelated to the political announcement

OVERAL SUMMARY
The sentiment pattern suggests that the comeback announcement for Charles Keter is strong enough to excite a clear majority, but also contentious enough to energize critics. The reactions mirror a politically competitive environment in Kericho, where: Supporters see the bid as a revival, a chance for renewed leadership.
Opponents view it as a step backward, preferring continuity with the current leadership of Dr. Mutai Erick Kipkoech or alternative candidates.

Data Source; From post by NTV Kenya
Compiled raw data Link; https://docs.google.com/spreadsheets/d/12OqQ9Ibv8WpAgg2QEkG-6CpMFI9mPakNZKCR6i50j5Y/edit?usp=sharing

30/12/2025

Most significant Events in Kenya 2025

According to the Infotrak survey, Kenyans identified the following as the most significant events of 2025:>Death of ODM ...
30/12/2025

According to the Infotrak survey, Kenyans identified the following as the most significant events of 2025:
>Death of ODM Party Leader Raila Odinga – 30%
This was the single most mentioned event, standing out far ahead of all others.
>Gen Z Protests – 12%
Youth-led demonstrations were seen as a major national moment.
>Rising Cost of Living – 11%
Economic pressures remained a top concern for many households.
>Politics & Governance Issues – 8%
General political developments and governance matters were also highlighted.
>Abductions and Killings – 6%
Security concerns featured among the key issues noted by respondents.
Data By
Data Visualized By;

30/12/2025

LEADERS OR DELEARS-PUBLIC REACTIONS

PUBLIC REACTION ANALYSIS ON REMARKS, "WE DON'T HAVE LEADERS, WE HAVE DEALERS IN GOVERNMENT..." BY MP SIFUNAFrom a sample...
30/12/2025

PUBLIC REACTION ANALYSIS ON REMARKS, "WE DON'T HAVE LEADERS, WE HAVE DEALERS IN GOVERNMENT..." BY MP SIFUNA

From a sample size of 1,045; the public response the above statement are;

❗ 1. Negative Reactions (51.87%)
Many respondents flipped the message back on the Sifuna (“you too”). A significant portion sees the statement as hypocrisy. Some express anger or frustration, feeling the message is unhelpful, divisive, or insincere; whether the messenger is different from those being criticized. This is the largest category, containing tones like Accusatory, Critical, Sarcastic, Dismissive, Mocking, Cynical, Skeptical, Aggressive, etc.

✅ 2. Positive Response (34.35%)
This group see the statement as bold, honest, or necessary.
This group perceives the message as speaking on behalf of ordinary citizens.
I
📘 3. Neutral / Informational (6.22%)
These reactions contain tones like Neutral, Corrective, Suggestive, Analytical, Informative, Factual, and Observational. This people are simply trying to establish accuracy, evidence (e.g., definitions of government roles).

🟣 4. Other (7.56%)
These comments don't neatly fit into support or opposition—they reflect side conversations, humor, distraction, or unrelated political positioning.

Data Source; obtained from a post by KKenyans.co.ke
Raw data Compiled on the attached link; https://docs.google.com/spreadsheets/d/1IqlXncU9To0urpXPsEMIVxudC6LznZb_fKWvjidL6CM/edit?usp=sharing

Address

Maragwa

Website

Alerts

Be the first to know and let us send you an email when The Excel Apostle posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Practice

Send a message to The Excel Apostle:

Share

Share on Facebook Share on Twitter Share on LinkedIn
Share on Pinterest Share on Reddit Share via Email
Share on WhatsApp Share on Instagram Share on Telegram