аЯрЁБс>ўџ *ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџ-  !"#$%&'()ўџџџўџџџ,ўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РFАтьЂ?Ъ+РWorkbookџџџџџџџџCOSummaryInformation(џџџџаDocumentSummaryInformation8џџџџџџџџџџџџ ЊЭСсАСт\pOwner BАaР=œЏМ=xZxвCalibri1м?МвCalibri1м4МвCalibri1м4вCalibri1м МвCalibri1м вCalibri1мвCalibri1мМвCalibri1м вCalibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)Є0.0рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р рѕџ Р р Р рѕџ ДŸ рѕџ Д­ рѕџ ДЊ рѕџ ДЎ рѕџ Д› рѕџ ДЏ рѕџ ДЌ рѕџ Д рѕџ Д‹ рѕџ ДЎ рѕџ ДЌ рѕџ ДГ рѕџ Дž рѕџ Д рѕџ Д‹ рѕџ ДЄ рѕџ ДБ рѕџ ДД рѕџ ДО рѕџ ДŠ рѕџ ДЙ рѕџ ДЄ рѕџ ДБ рѕџ ДЕ рѕџ Д­ рѕџ ”— — – рѕџ ”ffППЗ р +ѕџ јР р )ѕџ јР р ,ѕџ јР р *ѕџ јР рѕџ єР рѕџ ДЊ р ѕџ дPР р ѕџ дP Р р ѕџ д Р р ѕџ єР рѕџ ”— — Џ рѕџ д`Р рѕџ ДЋ р ѕџ œ  š рѕџ ”ПП– р ѕџ јР р ѕџ єР рѕџ дa>Р рѕџ єР р Р р Р р Р р Р рЄ Р ||CЉoэ‹}-}; 00\);_(*}A}1 00\);_(*;_(@_) }A}2 00\);_(*џ?;_(@_) }A}3 00\);_(*23;_(@_) }-}4 00\);_(*}A}0 aџ00\);_(*ЦяЮџ;_(@_) }A}( œџ00\);_(*џЧЮџ;_(@_) }A}7 œeџ00\);_(*џыœџ;_(@_) }‘}5 ??vџ00\);_(*џЬ™џ;_(@_) џ џ џ џ}‘}9 ???џ00\);_(*ђђђџ;_(@_) ???џ ???џ ???џ ???џ}‘}) њ}џ00\);_(*ђђђџ;_(@_) џ џ џ џ}A}6 њ}џ00\);_(*џ€џ;_(@_) }‘}* 00\);_(*ЅЅЅџ;_(@_) ???џ ???џ ???џ ???џ}-}= џџ00\);_(*}x}8џџЬџ00\);_(*ВВВџЅЅЅџ;_(ВВВџ???џ ВВВџ???џ ВВВџ???џ}-}/ џ00\);_(*}U}< 00\);_(*;_( }A}" 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*ЬL;_(}A} 00\);_(*23;_(}A}# 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*ЬL;_(}A} 00\);_(*23;_(}A}$ 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*ЬL;_(}A} 00\);_(*23;_(}A}% 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*ЬL;_(}A} 00\);_(*23;_(}A}& 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*ЬL;_(}A}  00\);_(*23;_(}A}' 00\);_(* ;_(}A} 00\);_(*ef ;_(}A} 00\);_(*ЬL ;_(}A}! 00\);_(*23 ;_(“ 20% - Accent1’M’џ 20% - Accent1 efлхёџ џ%“ 20% - Accent2’M’"џ 20% - Accent2 efђнмџ џ%“ 20% - Accent3’M’&џ 20% - Accent3 efъёнџ џ%“ 20% - Accent4’M’*џ 20% - Accent4 efхрьџ џ%“ 20% - Accent5’M’.џ 20% - Accent5 efлюѓџ џ%“ 20% - Accent6’M’2џ 20% - Accent6  ef§щйџ џ%“ 40% - Accent1’M’џ 40% - Accent1 ЬLИЬфџ џ%“ 40% - Accent2’M’#џ 40% - Accent2 ЬLцЙИџ џ%“ 40% - Accent3’M’'џ 40% - Accent3 ЬLзфМџ џ%“ 40% - Accent4’M’+џ 40% - Accent4 ЬLЬРкџ џ%“ 40% - Accent5’M’/џ 40% - Accent5 ЬLЖншџ џ%“ 40% - Accent6’M’3џ 40% - Accent6  ЬLќеДџ џ%“ 60% - Accent1’M’ џ 60% - Accent1 23•Гзџ џџџџ%“ 60% - Accent2’M’$џ 60% - Accent2 23й—•џ џџџџ%“ 60% - Accent3’M’(џ 60% - Accent3 23Тжšџ џџџџ%“ 60% - Accent4’M’,џ 60% - Accent4 23ВЁЧџ џџџџ%“ 60% - Accent5’M’0џ 60% - Accent5 23“Энџ џџџџ%“! 60% - Accent6’M’4џ 60% - Accent6  23њРџ џџџџ%“ "Accent1’A’џAccent1 OНџ џџџџ%“ #Accent2’A’!џAccent2 РPMџ џџџџ%“ $Accent3’A’%џAccent3 ›ЛYџ џџџџ%“ %Accent4’A’)џAccent4 €dЂџ џџџџ%“ &Accent5’A’-џAccent5 KЌЦџ џџџџ%“ 'Accent6’A’1џAccent6  ї–Fџ џџџџ%“(Bad’9’џBad џџЧЮџ џœџ%“) Calculation’’џ Calculation џђђђџ џњ}џ%џџџџџџ џџ“* Check Cell’’џ Check Cell џЅЅЅџ џџџџ%џ???џџ???џџ???џ џ???џ“+€џ’ ’џComma“,€џ’(’џ Comma [0]“-€џ’&’џCurrency“.€џ’.’џ Currency [0]“/Explanatory Text’G’5џExplanatory Text џџ%“ 0Good’;’џGood џЦяЮџ џaџ%“1 Heading 1’G’џ Heading 1 I}џ%OНџ“2 Heading 2’G’џ Heading 2 I}џ%џ?ЈРоџ“3 Heading 3’G’џ Heading 3 I}џ%23•Гзџ“4 Heading 4’9’џ Heading 4 I}џ%“ 5Input’u’џInput џџЬ™џ џ??vџ%џџџџџџ џџ“6 Linked Cell’K’џ Linked Cell џњ}џ%џџ€џ“ 7Neutral’A’џNeutral џџыœџ џœeџ%“€џ’"’џNormal“ 8Note’b’ џNote џџџЬџџВВВџџВВВџџВВВџ џВВВџ“ 9Output’w’џOutput џђђђџ џ???џ%џ???џџ???џџ???џ џ???џ“:€џ’$’џPercent“ ;Title’1’џTitle I}џ%“ <Total’M’џTotal џ%OНџOНџ“= Warning Text’?’ џ Warning Text џџџ%ŽXŽTableStyleMedium9PivotStyleLight16`…0Sheet1…#LSheet2…ГMSheet3ššЃЃŒССыыf№^№S №ПA†AР@ХA@ё  їќ k1k2k3 Respondent number average ce1e2e3sum etc m=unknown popbig e-(average unknown/average c)*total population /(sum of c for each person)/numbe of respondents(sum of c for each person)e4k4Tm=number of people in the unknown-size population reported to be known by respondentWk2=number of people in the 2nd known-size population reported to be known by respondentWk3=number of people in the 3rd known-size population reported to be known by respondentWk4=number of people in the 4th known-size population reported to be known by respondent/e1=actual size of the 1st known-size population/e2=actual size of the 2nd known-size population/e3=actual size of the 3rd known-size population/e4=actual size of the 4th known-size populationGt=size of total population within which the subpopulations are embedded8READ THIS COMMENT. RIGHT CLICK AND SELECT 'EDIT COMMENT'Wk1=number of people in the 1st known-size population reported to be known by respondent\We want to back-estimate network size c, and then estimate e for the unknown-size population#m(sum)=sum of known pops for each rџ"ќ* :+JЩ+й‡-—cc––Bх››ŒŒ ЊЭС Н5?  dќЉёвMbP?_*+‚€%џСƒ„&ш?'ш?(№?)№?MЂGluttony 6MP printerмФSяъ odXXLetterPRIVт0''''№Ф\K\K=&}џ№SMTJрHP LaserJet 6P/6MP PostScriptJCLResolution600dpiJCLEconomodeOffPageSizeLetterPageRegionInputSlotLowerHPHalftonePrinterDefaultSmoothingMediumЁ"dXXр?р?œ&œU} ’} } ’@} $ џџџџџџџџџ џ џ џ џџџџ@@џџџџџџџџ§ §  § § § § A§ § @ §  § § § § A§  Н*№?@@@#@џ %РР(BЎn’кb@џDРDD Н$>аsAрџ@HBApяA`~і@ # RH(Aў % Р РDН*@№?@№?@"@џМ -ќРџРB…Ѕ[Gl@џМLџРDD Н*@№?@@№?@џBЎn’кb@џН*@@№?@№?@џB Ќе*Wўe@Р§Н*@@@@@џB’W=УЌ"Y@џН*@№?№?№?@џB’W=УЌ"I@џН*@@№?@@№?"@џB…Ѕ[Gl@џ§ # @ џ %РРD#,@џ %РР#,@џ %РР#*@џ %РР#@џ %РР#€E@џ %РР#Bж6-Lу@џ %РР§ ! ’$I’$Iђ?џ DРDР§ § § § ?§ A§ § § § A§ § § !Bѕа|:щLc@џ DРDР§ §  § (@•5eMAџD РDРDР§ ?з8ьєФаЇlllll-%3,ьЮ№Ю№№Ж№( № №№~Ђ № Ѓ №<€€Щ…‹ПXPƒP?П№2 гP-Е№]4@€ЩРщ :?яlD“5™ыƒSŽ|ь №Ж < Network Scale-Up Method, Using the Back Estimation Method This is a spreadsheet showing how to estimate the size of uncountable populations, using the back estimation method. Here, only 7 respondents are involved for illustration. Column A shows the respondent numbers. Column B shows the number of people each respondent claims to know in the unknown-size population. The unknown-size population is called m in the back-estimation formula. Columns C, D, E, and F are the number of people the respondent claims to know in each of the known-size populations. Thus, cells C2-C8 are the number of people the respondent claims to know in the first known-size population; cells D2-D8 are the number of people the respondent claims to know in the second known-size population; and so on. Row 9 shows the total number of people reported to be known by all respondents in the unknown-size and known-size populations. Cell B9 is the total number reported known, across all respondents, in the unknown-size population. Cells C9-F9 are the total number reported known, across all respondents, in the known-size populations. Column G is the sum of people the respondent reports knowing in all the known-size populations. Thus, cell G2=the sum of C2-F2; cell G3 is the sum of C3-F3; and so on. Cell I2 is the number of people in the total population (the city or country within which the known-size and the unknown-size populations are embedded). Cells J2-M2 are the statistics (the actual sizes) for the known-size populations. Cell N2 is the sum of the statistics for the known-size populations. Column H is the scale-up estimate of c (the total size of the individual social network) for each respondent. It is G2(I2)/N2. These data give us what we need to estimate the size of the unknown-size population. First, add the numbers in column H to get the sum of c (network size) across the respondents in the study (shown in H9). Second, divide the sum of c by the number of respondents (in this case, 7) to get the average c (shown in A26). Third, total the number of number of people the respondents claim to know in the unknown-size population (shown in B9). Fourth, divide this total by the number of respondents (here, 7). This gives us the average number of people in the unknown population that respondents claim to know (shown in B10). Finally, divide this number by the average network size (shown in A26) and multiply the result by the total population (I2). The result is shown in cell C29. Note that the number in C29 is slightly different from the number you will get if you follow the directions here and do the calculation by hand. This is because the numbers in column H and in cell A26 are rounded to one decimal place. The calculation done by this Excel sheet is based on the exact numbers in all of the cells. < џH. Russell Bernardn>Ж@Ru‹‹Ru"""я7ggџџџџD ЊЭС 5M  dќЉёвMbP?_*+‚€%џСƒ„&ш?'ш?(№?)№?Ё"џџр?р?thœ&œU>Ж@‹‹я7ggџџџџD ЊЭС ХN  dќЉёвMbP?_*+‚€%џСƒ„&ш?'ш?(№?)№?Ё"џџр?р?œ&œU>Ж@‹‹я7ggџџџџD ўџџџўџџџ ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџр…ŸђљOhЋ‘+'Гй0 @HXh € Œ˜фchrismOwnerMicrosoft Excel@?@Œ‹\Щ@юdЂ?ЪўџеЭеœ.“—+,љЎ0р PXl t|„Œ ” Нф UF - BEBR Sheet1Sheet2Sheet3  Worksheetsўџ џџџџ РF&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.8є9ВqCompObjџџџџџџџџџџџџ rџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ