Facebook Photoshop Templates

Click here for the updated template (May 2015) or continue reading


 

These templates will help you customize your Facebook profile or Facebook pages. Useful to have a picture-in-picture effect, a profile picture that completes the cover page photo, a profile picture that extends the cover photo or multiple profile pictures embedded within the cover page.

click on the images to download the Photoshop files (PSD) in Zip format. Tutorials coming soon.

Profile Template

facebook_profile_template-201305

Page Template

20130529-facebook-page-template

MS Excel Tutorial (first draft)

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

Download PDF file

Is there a correlation between Women on Facebook and democracy?

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
Score

5.05

7.88

8.11

1.71

3.78

4.56

2.58

7.74

9.73

8.21

9.08

Gender
Gap

0.603

0.6984

0.7373

0.5731

0.632

0.5975

0.6392

0.6729

0.8159

0.7433

0.7381

 

Results:

democracy-ratio

Ratio / Democracy

Ratio / Gender Gap

R (Correlation coefficient)

0.95071

0.832496

R2 (coefficient of determination)

0.9039

0.693

ggg

 

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)…

Facebook Lebanese population

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

population

Lebanese Facebook population by age:

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

maritalstatus

Create a simple Twitter Follow

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):