Online Communication and Marketing Consultant
Contents
The basics. 1
Filling Cells. 1
Basic Equations. 1
Equation Priorities. 1
Range Formulas. 2
Logical Operators. 2
Conditions (IF) 2
Formatting cells. 3
Conditional Formatting. 3
Building Charts. 9
Quick Customization. 10
Databases in Excel 18
Creating a Pivot Chart 30
Abstract: We compare the democracy score and the gender ratio of different countries on Facebook and find a very strong correlation between the percentage of women on Facebook and democracy.
We use the gender data provided by the Facebook ads system for 11 countries: Lebanon, France, USA, KSA, Kuwait, Egypt, UAE, Italy, Sweden, UK and Canada.
|
Lebanon |
France |
USA |
KSA |
Kuwait |
Egypt |
|
|
ALL |
1,522,960 |
25,349,340 |
158,828,500 |
5,350,020 |
790,460 |
14,020,540 |
|
F |
669,360 |
12,911,360 |
82,757,620 |
1,484,560 |
261,280 |
4,980,720 |
|
M |
822,760 |
12,157,220 |
71,055,220 |
3,857,020 |
524,180 |
8,971,500 |
|
Not Specified |
30,840 |
280,760 |
5,015,660 |
8,440 |
5,000 |
68,320 |
|
UAE |
Italy |
Sweden |
UK |
Canada |
|
|
ALL |
3,423,360 |
23,332,320 |
4,738,280 |
31,164,520 |
17,783,580 |
|
F |
1,087,500 |
10,907,020 |
2,386,680 |
15,915,120 |
9,346,580 |
|
M |
2,313,380 |
12,301,860 |
2,279,840 |
14,664,860 |
7,996,760 |
|
Not Specified |
22,480 |
123,440 |
71,760 |
584,540 |
440,240 |
We then determine the Women/Men ratio for each country:
|
W/M |
Leb. |
Fr. |
USA |
KSA |
Kuwait |
Egypt |
UAE |
Italy |
Sweden |
UK |
Canada |
|
Rank |
7 |
4 |
2 |
11 |
9 |
8 |
10 |
6 |
5 |
3 |
1 |
|
Ratio |
0.81 |
1.06 |
1.164 |
0.38 |
0.49 |
0.55 |
0.47 |
0.88 |
1.04 |
1.08 |
1.168 |
The democracy index is retrieved from The Democracy Index 2012 from The Economist Intelligence Unit (https://www.eiu.com/public/topical_report.aspx?campaignid=DemocracyIndex12) and gender gap indexes (2012) from The Global Gender Gap Report (Hausmann, Tyson & Zahidi, 2012) from the World Economic Forum (http://www.weforum.org/issues/global-gender-gap)
|
Leb. |
Fr. |
USA |
KSA |
Kuwait |
Egypt |
UAE |
Italy |
Sweden |
UK |
Canada |
|
|
Democracy |
5.05 |
7.88 |
8.11 |
1.71 |
3.78 |
4.56 |
2.58 |
7.74 |
9.73 |
8.21 |
9.08 |
|
Gender |
0.603 |
0.6984 |
0.7373 |
0.5731 |
0.632 |
0.5975 |
0.6392 |
0.6729 |
0.8159 |
0.7433 |
0.7381 |
Results:
|
Ratio / Democracy |
Ratio / Gender Gap |
|
| R (Correlation coefficient) |
0.95071 |
0.832496 |
| R2 (coefficient of determination) |
0.9039 |
0.693 |
There is a very strong positive linear correlation (R) and a high coefficient of determination between the gender ratio and the democracy score.
The coefficient of determination is high, yet lower (70% certainty) when comparing gender ratio on Facebook and the gender gap.
It would be nice to include more countries to this exercise (when I have more time)…
The below data was extracted from Facebook using the Facebook advertising tools.
It has been compiled on May 2013.
It is important to mention that the penetration ratio of the Lebanese population on Facebook is 116% the number of connected people. So, it is safe to assume that an important number of Facebook Lebanese profiles are fake and that some Lebanese are using multiple profiles.
Lebanese Facebook population by Age and sex:
|
Age |
||||||||
| Total |
13-17 |
18-24 |
25-34 |
35-44 |
45-54 |
55-64 |
65+ |
|
|
ALL |
1,522,960 |
189,920 |
503,460 |
455,160 |
215,220 |
104,240 |
34,840 |
22,480 |
|
Women |
669,360 |
89,100 |
225,800 |
195,500 |
91,820 |
44,360 |
14,540 |
8,260 |
|
Men |
822,760 |
100,580 |
271,560 |
246,380 |
115,620 |
56,360 |
19,040 |
13,200 |
|
Not Specified |
30,840 |
240 |
6,100 |
13,280 |
7,780 |
3,520 |
1,260 |
1,020 |
Lebanese Facebook population by age:
Lebanese Facebook population by marital status:
|
Single |
In a relationship |
Married |
Engaged |
Not Specified |
|
|
Men |
158,000 |
37,200 |
74,360 |
16,380 |
529,160 |
|
Women |
111,920 |
31,160 |
105,340 |
20,980 |
394,240 |
This is a good method to create a follow button that can be integrated almost anywhere: website, WordPress blog, other blogs or sites.
If you don’t want to read the full article, this is the iframe based code. Just replace “nasrimessarra” with your twitter username:
<iframe allowtransparency=”true” frameborder=”0″ scrolling=”no” src=”//platform.twitter.com/widgets/follow_button.html?screen_name=nasrimessarra” style=”width:300px; height:20px;”></iframe>
The javascript code is:
<a href=”https://twitter.com/nasrimessarra” data-show-count=”false” data-lang=”en”>Follow @nasrimessarra</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”);</script>
For the full article, follow this link: https://dev.twitter.com/docs/follow-button
Sample (Javascript):
Follow @nasrimessarra