Information + instructions Some information about our dataset and term definitions The attached is a hypothetical dataset containing subscription data for all customers who first joined ClassPass in...

1 answer below ยป
On excel sheet


Information + instructions Some information about our dataset and term definitions The attached is a hypothetical dataset containing subscription data for all customers who first joined ClassPass in February 2016. ClassPass is a consumer-facing monthly subscription with recur billing (e.g., we automatically charge you every month until you request to cancel). A customer's "bill date" is set when he/she first joins ClassPass. For example, if a customer joins on February 11th, that customer's "bill date" is the 11th of the month. We first charge that customer on February 11th for the service period February 11th-March 10th. We charge that customer again on March 11th for the service period March 11th-April 10th, unless the customer has requested to cancel. Each record in the dataset is a unique "subscription month" for a single customer; if a customer remains a ClassPass member for nine months, that customer appears in the data nine times. A new record is created in the data table at the moment when we charge a customer for the coming month. For example, when we charge a customer on March 11th for the service period of March 11th-April 10th, the record covering that subscription month will not appear in the data table until March 11th. A customer can request to cancel ClassPass at any time by logging into ClassPass and clicking "I'd like to cancel my membership." When a customer requests to cancel, we still consider him/her an active customer until the end of the current subscription month; we consider that customer's "time of churn" to be the last day of that subscription month, since that is the last day on which we are providing service to that customer. In the attached table, the "cancellation request" field includes the date of any request to cancel made during the subscription month. If the field is "NULL", you can assume that the customer did not request to cancel during that month (or, if the subscription period is still ongoing as of the date that the data was pulled, that the customer has not yet requested to cancel). We define "churn rate" as number of customers who churned in any defined time period, divided by the number of active customers at the beginning of that time period. Questions 1. How many of the customers in the attached data set were still active ClassPass customers on June 9th, 2016? 2. What was the April 2016 churn rate of the customers in the attached dataset? 3. If you had to make a prediction, how many customers in the attached dataset will churn in the month of October? 4. Are there any trends you can see in how churn differs by any customer attributes (e.g., city, length of time on CP)? If so, do you have any ideas for what ClassPass could do to improve churn among those customers? Guidelines for completing the exercise 1. Please start a new sheet in this table for your answers; you can format it however you'd like. 2. We recommend that you "show your work" (either in your answers table, in the "Dataset" tab, or any other tabs you choose to create) -- it helps us see how you think! 3. Please upload your completed test to Greenhouse via the link provided. 4. We recommend that you do not use pivot tables. Dataset Data pulled/refreshed on:10/15/16 Unique User IDSubscription Month Start DateSubscription Month End DateCancellation Request DateCity ID 102145512/1/162/29/16NULL2 102436322/1/162/29/16NULL3 108175432/1/162/29/16NULL2 109717382/1/162/29/16NULL2 115258542/1/162/29/16NULL1 237439842/1/162/29/162/1/162 119773182/1/162/29/16NULL3 120624542/1/162/29/16NULL2 121363872/1/162/29/16NULL2 122226862/1/162/29/16NULL1 123045152/1/162/29/16NULL1 125607792/1/162/29/16NULL3 128202722/1/162/29/16NULL3 131326952/1/162/29/16NULL1 134514402/1/162/29/16NULL3 134770162/1/162/29/16NULL1 135643522/1/162/29/16NULL2 136832272/1/162/29/16NULL1 147294782/1/162/29/16NULL2 148816272/1/162/29/16NULL1 382509182/3/163/2/162/3/162 150175142/1/162/29/16NULL3 498094462/3/163/2/162/6/162 153572732/1/162/29/16NULL2 154469122/1/162/29/16NULL1 160994792/1/162/29/16NULL3 162869972/1/162/29/16NULL2 169357462/1/162/29/16NULL1 169517362/1/162/29/16NULL1 170054802/1/162/29/16NULL3 171691752/1/162/29/16NULL3 353193522/4/163/3/162/6/163 180472582/1/162/29/16NULL2 180545952/1/162/29/16NULL3 184545662/1/162/29/16NULL2 186666292/1/162/29/16NULL2 186743052/1/162/29/16NULL3 362203392/7/163/6/162/7/163 188540682/1/162/29/16NULL2 190335262/1/162/29/16NULL3 190781062/1/162/29/16NULL3 195075702/3/163/2/162/8/161 108916692/4/163/3/162/8/161 196137562/1/162/29/16NULL3 196861782/1/162/29/16NULL2 199888772/1/162/29/16NULL2 208923772/1/162/29/16NULL2 209209692/1/162/29/16NULL3 211320622/1/162/29/162/9/162 211835412/1/162/29/16NULL3 214326402/1/162/29/16NULL2 214723262/1/162/29/16NULL3 214887712/1/162/29/16NULL3 219057542/1/162/29/16NULL3 219875052/1/162/29/16NULL1 219931102/1/162/29/16NULL1 220830682/1/162/29/16NULL2 222822332/1/162/29/16NULL2 224351412/1/162/29/16NULL2 226830652/1/162/29/16NULL1 229951512/1/162/29/16NULL2 233885422/1/162/29/16NULL1 234018882/1/162/29/16NULL3 234551912/1/162/29/16NULL3 382080142/6/163/5/162/9/163 238412362/1/162/29/16NULL3 238517572/1/162/29/16NULL1 487557522/7/163/6/162/9/163 244803782/1/162/29/16NULL1 246027252/1/162/29/16NULL3 248317192/1/162/29/16NULL3 258788902/1/162/29/16NULL2 262681022/1/162/29/16NULL3 262896282/1/162/29/16NULL3 267328632/1/162/29/16NULL3 268859872/1/162/29/16NULL1 269106822/1/162/29/16NULL2 269708292/1/162/29/16NULL1 275502152/1/162/29/16NULL3 276225912/1/162/29/16NULL2 276642592/1/162/29/16NULL3 151495372/2/163/1/162/10/162 281840892/1/162/29/16NULL1 282946012/1/162/29/16NULL1 284439342/1/162/29/16NULL2 285003922/1/162/29/16NULL1 285086292/1/162/29/16NULL1 288092622/1/162/29/16NULL2 288600962/1/162/29/16NULL1 290997412/1/162/29/16NULL1 154745822/5/163/4/162/10/163 292322772/1/162/29/16NULL1 292663822/1/162/29/16NULL3 293482802/1/162/29/16NULL1 294206982/1/162/29/16NULL3 302477392/1/162/29/16NULL3 305549882/1/162/29/16NULL3 312553712/1/162/29/16NULL2 313844692/1/162/29/16NULL3 316055562/1/162/29/16NULL2 316448172/1/162/29/16NULL2 318195392/1/162/29/16NULL2 318797982/1/162/29/16NULL1 321009942/1/162/29/16NULL3 212932552/6/163/5/162/10/163 329245992/1/162/29/16NULL1 330296042/1/162/29/16NULL3 330884392/1/162/29/16NULL2 331768742/1/162/29/16NULL2 331781202/1/162/29/16NULL1 332639372/1/162/29/16NULL3 334683812/1/162/29/16NULL1 335283662/1/162/29/16NULL3 218940152/9/163/8/162/10/163 337110572/1/162/29/16NULL3 419939052/1/162/29/162/11/162 193308912/2/163/1/162/11/161 346470602/1/162/29/16NULL1 346654072/1/162/29/16NULL2 347310712/1/162/29/16NULL1 223812932/5/163/4/162/11/163 358791922/1/162/29/16NULL3 144834482/6/163/5/162/11/162 363099062/1/162/29/16NULL2 363795882/1/162/29/16NULL2 371323812/1/162/29/16NULL2 371570142/1/162/29/16NULL3 372562682/1/162/29/16NULL1 373428182/1/162/29/16NULL1 376606282/1/162/29/16NULL2 378476862/1/162/29/16NULL1 379292712/1/162/29/16NULL1 381721762/1/162/29/16NULL1 385567002/1/162/29/16NULL1 388437042/1/162/29/16NULL2 390407072/1/162/29/16NULL3 394567632/1/162/29/16NULL1 394719902/1/162/29/16NULL1 397665292/1/162/29/16NULL3 399457302/1/162/29/16NULL3 400854492/1/162/29/16NULL3 402132102/1/162/29/16NULL3 402140532/1/162/29/16NULL2 402610592/1/162/29/16NULL3 403546712/1/162/29/16NULL3 405638672/1/162/29/16NULL1 411045722/1/162/29/16NULL2 412991762/1/162/29/16NULL2 416075812/1/162/29/16NULL2 497163572/1/162/29/162/12/163 424645082/1/162/29/16NULL1 273824292/3/163/2/162/12/162 440193582/5/163/4/162/12/162 431548412/1/162/29/16NULL1 431675522/1/162/29/16NULL3 432898162/1/162/29/16NULL1 439292382/1/162/29/16NULL1 441507902/1/162/29/16NULL3 446527562/1/162/29/16NULL2 447861412/1/162/29/16NULL3 448914672/1/162/29/16NULL3 449168032/1/162/29/16NULL1 451354862/1/162/29/16NULL3 453856382/1/162/29/16NULL2 462748622/1/162/29/16NULL3 465467912/1/162/29/16NULL1 466370112/1/162/29/16NULL1 470107272/1/162/29/16NULL2 471730302/1/162/29/16NULL3 474457272/1/162/29/16NULL3 478869752/1/162/29/16NULL2 483477552/1/162/29/16NULL2 484355802/1/162/29/16NULL3 484683642/1/162/29/16NULL2 484960262/1/162/29/16NULL2 485500592/1/162/29/16NULL3 119527362/6/163/5/162/12/161 486330832/1/162/29/16NULL1 492146262/1/162/29/16NULL1 274379482/8/163/7/162/12/163 100683622/2/163/1/16NULL3 109879762/2/163/1/16NULL3 112356702/2/163/1/16NULL2 114698162/2/163/1/16NULL1 121136812/2/163/1/16NULL3 124614622/2/163/1/16NULL3 126214602/2/163/1/16NULL2 128935492/2/163/1/16NULL2 129788892/2/163/1/16NULL3 130177322/2/163/1/16NULL1 277861862/10/163/9/162/12/163 134914912/2/163/1/16NULL1 135505122/2/163/1/16NULL1 138204532/2/163/1/16NULL3 141926002/2/163/1/16NULL1 235536092/12/163/11/162/12/162 179008662/4/163/3/162/13/163 173113012/7/163/6/162/13/163 149655002/2/163/1/16NULL2 133765532/13/163/12/162/13/162 153826932/2/163/1/16NULL1 158750692/2/163/1/16NULL3 176402062/10/163/9/162/14/161 163695442/2/163/1/16NULL3 165314042/2/163/1/16NULL3 167877062/2/163/1/16NULL1 168409402/2/163/1/16NULL2 168555182/2/163/1/16NULL3 174284902/2/163/1/16NULL1 174580992/2/163/1/16NULL2 304468122/6/163/5/162/15/161 182372122/2/163/1/16NULL3 184218232/2/163/1/16NULL3 184225912/2/163/1/16NULL2 185455332/2/163/1/16NULL2 188062802/2/163/1/16NULL1 189392542/2/163/1/16NULL2 189497242/2/163/1/16NULL1 191938672/2/163/1/16NULL1 454061262/9/163/8/162/15/163 200059072/2/163/1/16NULL3 200908932/2/163/1/16NULL2 205679202/2/163/1/16NULL2 208166092/2/163/1/16NULL2 156897732/4/163/3/162/16/162 405862712/5/163/4/162/16/162 216214882/2/163/1/16NULL2 216256772/2/163/1/16NULL2 224209162/2/163/1/16NULL2 224442072/2/163/1/16NULL1 229028342/2/163/1/16NULL1 234862592/2/163/1/16NULL1 236113612/2/163/1/16NULL1 236576052/2/163/1/16NULL3 236845722/2/163/1/16NULL1 241405042/2/163/1/16NULL1 242625462/2/163/1/16NULL3 243770032/2/163/1/16NULL3 244459982/2/163/1/16NULL2 245139972/2/163/1/16NULL1 245353302/2/163/1/16NULL3 245550992/2/163/1/16NULL3 249376902/2/163/1/16NULL3 251707302/2/163/1/16NULL1 254926442/2/163/1/16NULL2 255956042/2/163/1/16NULL2 257059642/2/163/1/16NULL3 260037192/2/163/1/16NULL2 260167402/2/163/1/16NULL1 263053642/2/163/1/16NULL3 264771462/2/163/1/16NULL2 267808162/2/163/1/16NULL1 269106912/2/163/1/16NULL1 271049382/2/163/1/16NULL3 276923902/2/163/1/16NULL3 280237652/2/163/1/16NULL2 281308292/2/163/1/16NULL1 436741662/6/163/5/162/16/162 284901022/2/163/1/16NULL3 286924632/2/163/1/16NULL1 291544142/2/163/1/16NULL2 292029142/2/163/1/16NULL3 292507122/2/163/1/16NULL3 296640602/2/163/1/16NULL2 298041462/2/163/1/16NULL2 298946872/2/163/1/16NULL1 303787022/2/163/1/16NULL2 315457602/9/163/8/162/16/162 307328252/2/163/1/16NULL3 413289812/16/163/15/162/16/161 310797372/2/163/1/16NULL3 311192372/2/163/1/16NULL2 311819502/2/163/1/16NULL2 314305102/2/163/1/16NULL2 314409042/2/163/1/16NULL2 321174012/2/163/1/16NULL1 321688722/2/163/1/16NULL2 322632372/2/163/1/16NULL1 324798142/2/163/1/16NULL1 326634712/2/163/1/16NULL1 427769002/1/162/29/162/17/162 331726042/2/163/1/16NULL3 332724752/2/163/1/16NULL3 336018022/2/163/1/16NULL1 336023472/2/163/1/16NULL3 289780592/4/163/3/162/17/163 337802582/2/163/1/16NULL3 341273712/2/163/1/16NULL3 343646912/2/163/1/16NULL2 345995262/2/163/1/16NULL1 349206112/2/163/1/16NULL2 353556092/2/163/1/16NULL3 354457452/2/163/1/16NULL1 361657272/2/163/1/16NULL3 362217502/2/163/1/16NULL3 364129092/2/163/1/16NULL3 365142612/2/163/1/16NULL1 368714222/2/163/1/16NULL1 372480622/2/163/1/16NULL2 375777732/2/163/1/16NULL3 376904822/2/163/1/16NULL1 379077672/2/163/1/16NULL2 380321512/2/163/1/16NULL3 384704942/2/163/1/16NULL2 386135752/2/163/1/16NULL3 242259782/5/163/4/162/17/162 387686372/2/163/1/16NULL3 388097402/2/163/1/16NULL3 389389312/2/163/1/16NULL3 389404762/2/163/1/16NULL1 398398582/2/163/1/16NULL2 404086702/2/163/1/16NULL3 404425842/2/163/1/16NULL1 406241062/2/163/1/16NULL2 406620972/2/163/1/16NULL2 384725322/7/163/6/162/17/161 410173792/2/163/1/16NULL3 420016972/2/163/1/16NULL3 420497342/2/163/1/16NULL1 422806822/2/163/1/16NULL1 425458692/2/163/1/16NULL3 427616952/2/163/1/16NULL3 325663172/8/163/7/162/17/163 433529132/2/163/1/16NULL3 437390252/2/163/1/16NULL2 438273222/2/163/1/16NULL2 438602422/2/163/1/16NULL3 441580882/2/163/1/16NULL2 443103292/2/163/1/16NULL1 444706902/2/163/1/16NULL3 446941192/2/163/1/16NULL3 234550872/10/163/9/162/17/161 448410062/2/163/1/16NULL1 450310262/2/163/1/16NULL3 451395812/2/163/1/16NULL2 455029722/2/163/1/16NULL1 457411612/2/163/1/16NULL1 458881422/2/163/1/16NULL3 463626232/2/163/1/16NULL2 464421732/2/163/1/16NULL3 328270022/1/162/29/162/18/163 472214932/2/163/1/16NULL1 473441532/2/163/1/16NULL3 476666542/2/163/1/16NULL2 479927102/2/163/1/16NULL3 481084172/2/163/1/16NULL1 481512322/2/163/1/16NULL1 484093522/2/163/1/16NULL3 486118112/2/163/1/16NULL2 487530762/2/163/1/16NULL2 487716542/2/163/1/16NULL1 489005672/2/163/1/16NULL1 489854082/2/163/1/16NULL1 493993562/2/163/1/16NULL2 496191752/2/163/1/16NULL3 498924542/2/163/1/16NULL2 104884262/3/163/2/16NULL1 105012602/3/163/2/16NULL1 106790492/3/163/2/16NULL1 111852752/3/163/2/16NULL3 115180722/3/163/2/16NULL2 120146222/3/163/2/16NULL2 149455262/2/163/1/162/18/163 125560012/3/163/2/16NULL1 130136402/3/163/2/16NULL2 132129572/3/163/2/16NULL2 207879182/4/163/3/162/18/163 312371892/4/163/3/162/18/163 132995572/3/163/2/16NULL2 140440342/3/163/2/16NULL1 143850872/3/163/2/16NULL2 144210612/3/163/2/16NULL2 146242922/3/163/2/16NULL3 148990692/3/163/2/16NULL1 149672052/3/163/2/16NULL3 151803762/3/163/2/16NULL1 154589652/3/163/2/16NULL1 155070752/3/163/2/16NULL3 156485512/3/163/2/16NULL1 158323562/3/163/2/16NULL2 159290372/3/163/2/16NULL3 207827122/5/163/4/162/18/163 172744122/3/163/2/16NULL1 174270112/3/163/2/16NULL2 175750942/3/163/2/16NULL2 180777722/3/163/2/16NULL3 181928052/3/163/2/16NULL2 136974852/9/163/8/162/18/162 186464082/3/163/2/16NULL2 155743212/9/163/8/162/18/163 190068842/3/163/2/16NULL2 190779552/3/163/2/16NULL3 191379682/3/163/2/16NULL2 226923502/9/163/8/162/18/161 198295202/3/163/2/16NULL3 417109962/14/163/13/162/18/161 199944802/3/163/2/16NULL3 201710782/3/163/2/16NULL3 201991042/3/163/2/16NULL2 202543832/3/163/2/16NULL1 204846982/3/163/2/16NULL3 209381862/3/163/2/16NULL2 211528222/3/163/2/16NULL3 213229732/3/163/2/16NULL3 213480332/3/163/2/16NULL1 213940832/3/163/2/16NULL1 216232662/3/163/2/16NULL2 216376232/3/163/2/16NULL3 219574022/3/163/2/16NULL2 220273882/3/163/2/16NULL2 222182152/3/163/2/16NULL1 222421202/3/163/2/16NULL3 229891522/3/163/2/16NULL3 229902322/3/163/2/16NULL3 229928042/3/163/2/16NULL1 230776092/3/163/2/16NULL3 234146662/3/163/2/16NULL3 234508702/3/163/2/16NULL2 237129252/3/163/2/16NULL2 239115532/3/163/2/16NULL2 240027592/3/163/2/16NULL2 242209592/3/163/2/16NULL2 243105352/3/163/2/16NULL2 246396202/3/163/2/16NULL2 249260082/3/163/2/16NULL1 253193062/3/163/2/16NULL3 260605592/3/163/2/16NULL3 201290402/15/163/14/162/18/163 271283882/3/163/2/16NULL1 133975812/17/163/16/162/18/161 275019652/3/163/2/16NULL2 275959912/3/163/2/16NULL3 280883072/3/163/2/16NULL1 286070772/3/163/2/16NULL1 287881622/3/163/2/16NULL3 291537782/3/163/2/16NULL2 294849322/3/163/2/16NULL3 295498122/3/163/2/16NULL1 298646882/3/163/2/16NULL3 298880542/3/163/2/16NULL2 303098372/3/163/2/16NULL2 304096852/3/163/2/16NULL1 304435022/3/163/2/16NULL3 305297522/3/163/2/16NULL3 306083622/3/163/2/16NULL1 306808862/3/163/2/16NULL2 307415682/3/163/2/16NULL1 309334622/3/163/2/16NULL2 309514442/3/163/2/16NULL2 309747522/3/163/2/16NULL2 310663162/3/163/2/16NULL1 314511142/3/163/2/16NULL3 316710242/3/163/2/16NULL2 317772772/3/163/2/16NULL2 318327162/3/163/2/16NULL2 463106922/10/163/9/162/19/162 320648142/3/163/2/16NULL2 322461422/3/163/2/16NULL3 325625712/3/163/2/16NULL1 327485742/3/163/2/16NULL3 327580042/3/163/2/16NULL3 270963362/15/163/14/162/19/162 329755782/3/163/2/16NULL1 329866422/3/163/2/16NULL1 331524032/3/163/2/16NULL1 227235452/19/163/18/162/19/163 339338452/3/163/2/16NULL3 343655042/3/163/2/16NULL1 344391282/3/163/2/16NULL2 345714332/3/163/2/16NULL1 347655122/3/163/2/16NULL2 124464222/3/163/2/162/20/161 349019382/3/163/2/16NULL3 349442842/3/163/2/16NULL1 349524682/3/163/2/16NULL1 351498872/3/163/2/16NULL1 279869312/5/163/4/162/20/162 357609892/3/163/2/16NULL3 360334752/3/163/2/16NULL2 361058792/3/163/2/16NULL2 361809342/3/163/2/16NULL2 363596812/3/163/2/16NULL3 364651342/3/163/2/16NULL3 366672162/3/163/2/16NULL1 367454572/3/163/2/16NULL1 368123932/3/163/2/16NULL1 376099742/3/163/2/16NULL3 176347402/9/163/8/162/20/163 377481332/3/163/2/16NULL3 324924322/16/163/15/162/20/161 384448662/3/163/2/16NULL3 493257782/16/163/15/162/20/162 387970092/3/163/2/16NULL3 388400522/3/163/2/16NULL1 388910082/3/163/2/16NULL3 391194232/3/163/2/16NULL2 394866462/3/163/2/16NULL1 395923702/3/163/2/16NULL1 397157302/3/163/2/16NULL3 400288152/3/163/2/16NULL3 256372292/20/163/19/162/20/162 408262212/3/163/2/16NULL3 411793852/3/163/2/16NULL3 413107332/3/163/2/16NULL1 415206412/3/163/2/16NULL2 151710142/1/162/29/162/21/163 417274682/3/163/2/16NULL2 420259432/3/163/2/16NULL1 495848252/4/163/3/162/21/161 422414372/3/163/2/16NULL3 319449752/5/163/4/162/21/161 423196702/3/163/2/16NULL1 424206752/3/163/2/16NULL2 424981122/3/163/2/16NULL1 425231672/3/163/2/16NULL2 425831872/3/163/2/16NULL2 430254372/3/163/2/16NULL1 430776662/3/163/2/16NULL3 431020582/3/163/2/16NULL1 434427042/3/163/2/16NULL1 435191802/3/163/2/16NULL2 436381532/3/163/2/16NULL2 437029002/3/163/2/16NULL1 438109792/3/163/2/16NULL2 438377482/3/163/2/16NULL2 440790042/3/163/2/16NULL1 441096812/3/163/2/16NULL1 445436162/3/163/2/16NULL1 445668152/3/163/2/16NULL2 445712412/3/163/2/16NULL1 449117422/3/163/2/16NULL2 451431142/3/163/2/16NULL3 453024032/3/163/2/16NULL3 456037542/3/163/2/16NULL1 456398472/3/163/2/16NULL1 456515102/3/163/2/16NULL3 463805752/3/163/2/16NULL1 464235892/3/163/2/16NULL3 466517072/3/163/2/16NULL3 466956912/3/163/2/16NULL3 472240062/3/163/2/16NULL2 472357452/3/163/2/16NULL3 474799552/3/163/2/16NULL2 479729722/3/163/2/16NULL2 480676402/3/163/2/16NULL2 480924062/3/163/2/16NULL1 481197052/3/163/2/16NULL2 482024232/3/163/2/16NULL3 483379172/3/163/2/16NULL3 485757402/3/163/2/16NULL1 148348072/7/163/6/162/21/163 489337172/3/163/2/16NULL3 489470342/3/163/2/16NULL1 489932542/3/163/2/16NULL3 491457742/3/163/2/16NULL2 495271852/3/163/2/16NULL3 495636402/3/163/2/16NULL2 497330792/3/163/2/16NULL3 410837552/7/163/6/162/21/163 100522162/4/163/3/16NULL3 105274242/4/163/3/16NULL2 106425722/4/163/3/16NULL1 107197692/4/163/3/16NULL2 458021722/10/163/9/162/21/161 109320602/4/163/3/16NULL1 117262822/4/163/3/16NULL1 119711892/4/163/3/16NULL1 122198362/4/163/3/16NULL3 124073402/4/163/3/16NULL1 125667702/4/163/3/16NULL1 129459972/4/163/3/16NULL1 134001882/4/163/3/16NULL3 155325462/11/163/10/162/21/163 136225792/4/163/3/16NULL1 136494062/4/163/3/16NULL2 138154622/4/163/3/16NULL1 139347322/4/163/3/16NULL3 145716042/4/163/3/16NULL3 147243852/4/163/3/16NULL3 147706202/4/163/3/16NULL2 149028042/4/163/3/16NULL1 150488062/4/163/3/16NULL2 153177692/4/163/3/16NULL3 154140562/4/163/3/16NULL2 294959202/13/163/12/162/21/162 486514002/14/163/13/162/21/162 162306582/4/163/3/16NULL2 164185272/4/163/3/16NULL2 164502862/4/163/3/16NULL2 165075542/4/163/3/16NULL3 165175292/4/163/3/16NULL1 190798392/1/162/29/162/22/163 174871962/4/163/3/16NULL2 174893582/4/163/3/16NULL1 175709302/4/163/3/16NULL1 175936102/4/163/3/16NULL3 176055512/4/163/3/16NULL2 192156352/1/162/29/162/22/163 280112552/1/162/29/162/22/163 180885782/4/163/3/16NULL1 182583732/4/163/3/16NULL1 185175602/4/163/3/16NULL1 187525032/4/163/3/16NULL1 187995102/4/163/3/16NULL3 189627562/4/163/3/16NULL1 192448482/4/163/3/16NULL2 199738132/4/163/3/16NULL1 206214702/4/163/3/16NULL2 486286972/1/162/29/162/22/163 210512832/4/163/3/16NULL2 214563562/4/163/3/16NULL1 215156462/4/163/3/16NULL3 304253492/2/163/1/162/22/162 221447402/4/163/3/16NULL1 222060142/4/163/3/16NULL2 225400712/4/163/3/16NULL1 227106022/4/163/3/16NULL2 227829782/4/163/3/16NULL1 230400562/4/163/3/16NULL2 232418032/4/163/3/16NULL3 109284992/10/163/9/162/22/162 242543842/4/163/3/16NULL1 244892752/4/163/3/16NULL3 244994762/4/163/3/16NULL3 247534632/4/163/3/16NULL3 247853212/4/163/3/16NULL3 254962062/4/163/3/16NULL3 256730432/4/163/3/16NULL2 256926962/4/163/3/16NULL3 257252982/4/163/3/16NULL1 259592922/4/163/3/16NULL3 263958442/4/163/3/16NULL2 269448112/4/163/3/16NULL2 270208852/4/163/3/16NULL2 270577822/4/163/3/16NULL1 272695682/4/163/3/16NULL2 273578432/4/163/3/16NULL2 276751762/4/163/3/16NULL1 279224542/4/163/3/16NULL3 280952952/4/163/3/16NULL3 281514732/4/163/3/16NULL3 284294822/4/163/3/16NULL3 287206422/4/163/3/16NULL3 287433542/4/163/3/16NULL3 287477162/4/163/3/16NULL2 289358392/4/163/3/16NULL2 241262222/13/163/12/162/22/162 289698862/4/163/3/16NULL3 198712922/21/163/20/162/22/161 290526122/4/163/3/16NULL1 292333412/4/163/3/16NULL2 294373572/4/163/3/16NULL3 299726402/4/163/3/16NULL1 301389742/4/163/3/16NULL1 304587672/4/163/3/16NULL3 306027092/4/163/3/16NULL2 307119822/4/163/3/16NULL1 309922482/4/163/3/16NULL2 309936382/4/163/3/16NULL2 335402512/1/162/29/162/23/161 318175742/4/163/3/16NULL2 310719662/2/163/1/162/23/162 322624462/4/163/3/16NULL2 327033482/4/163/3/16NULL3 447698002/2/163/1/162/23/163 328154602/4/163/3/16NULL1 328949072/4/163/3/16NULL1 330309962/4/163/3/16NULL3 331280632/4/163/3/16NULL3 332288422/4/163/3/16NULL1 333943942/4/163/3/16NULL3 336857672/4/163/3/16NULL3 339882892/4/163/3/16NULL3 342379252/4/163/3/16NULL2 343020282/4/163/3/16NULL2 345704022/4/163/3/16NULL1 350486342/4/163/3/16NULL1 351257422/4/163/3/16NULL2 351270022/4/163/3/16NULL3 327353232/4/163/3/162/23/163 357921082/4/163/3/16NULL3 359236922/4/163/3/16NULL3 363150812/4/163/3/16NULL1 366188492/4/163/3/16NULL3 366773622/4/163/3/16NULL2 368273592/4/163/3/16NULL1 377072722/4/163/3/16NULL2 377949292/4/163/3/16NULL1 379767732/4/163/3/16NULL3 381200622/4/163/3/16NULL1 382083602/4/163/3/16NULL1 390380472/4/163/3/16NULL2 392509232/4/163/3/16NULL2 399152722/4/163/3/16NULL3 403666602/4/163/3/16NULL3 405687972/4/163/3/16NULL3 406643312/4/163/3/16NULL1 407069732/4/163/3/16NULL3 407146202/4/163/3/16NULL3 408911632/4/163/3/16NULL2 411614402/4/163/3/16NULL3 411801982/4/163/3/16NULL2 419318572/4/163/3/16NULL1 422363882/4/163/3/16NULL3 428172942/4/163/3/16NULL1 430729512/4/163/3/16NULL1 433588482/4/163/3/16NULL3 433594692/4/163/3/16NULL1 433729082/4/163/3/16NULL2 434357772/4/163/3/16NULL1 434740332/4/163/3/16NULL3 440044472/4/163/3/16NULL1 441580342/4/163/3/16NULL2 445644442/4/163/3/16NULL3 449871892/4/163/3/16NULL3 454967632/4/163/3/16NULL1 458219322/4/163/3/16NULL1 460627422/4/163/3/16NULL3 461487362/4/163/3/16NULL1 463394802/4/163/3/16NULL2 466289342/4/163/3/16NULL3 477088772/4/163/3/16NULL3 478464012/4/163/3/16NULL1 479112382/4/163/3/16NULL1 480251292/4/163/3/16NULL2 484571642/4/163/3/16NULL3 485970032/4/163/3/16NULL1 486604002/4/163/3/16NULL1 486975042/4/163/3/16NULL2 487030982/4/163/3/16NULL3 487173572/4/163/3/16NULL3 495036002/4/163/3/16NULL3 135002432/6/163/5/162/23/162 495985832/4/163/3/16NULL2 499122892/4/163/3/16NULL1 135275802/7/163/6/162/23/161 102237442/5/163/4/16NULL1 102966002/5/163/4/16NULL2 107260852/5/163/4/16NULL2 107617712/5/163/4/16NULL3 110083982/5/163/4/16NULL3 434424542/10/163/9/162/23/162 111421752/5/163/4/16NULL1 111501002/5/163/4/16NULL3 113436372/5/163/4/16NULL3 117473042/5/163/4/16NULL1 132461642/5/163/4/16NULL3 135409062/5/163/4/16NULL2 135603632/5/163/4/16NULL3 146816382/5/163/4/16NULL1 316671532/16/163/15/162/23/163 151821332/5/163/4/16NULL3 153208782/5/163/4/16NULL3 220931042/17/163/16/162/23/162 157040092/5/163/4/16NULL3 157806722/5/163/4/16NULL3 158711402/5/163/4/16NULL2 160179192/5/163/4/16NULL2 166329462/5/163/4/16NULL2 168471982/5/163/4/16NULL2 169389402/5/163/4/16NULL2 171088352/5/163/4/16NULL3 187624662/18/163/17/162/23/163 171110342/5/163/4/16NULL2 171391722/5/163/4/16NULL3 172675242/5/163/4/16NULL2 173589732/5/163/4/16NULL1 176019032/5/163/4/16NULL1 178294702/5/163/4/16NULL3 223339072/23/163/22/162/23/163 185886432/5/163/4/16NULL2 190215392/5/163/4/16NULL3 191523172/5/163/4/16NULL1 192757432/5/163/4/16NULL2 201556992/5/163/4/16NULL2 202017192/5/163/4/16NULL2 202243562/5/163/4/16NULL2 203857952/5/163/4/16NULL1 117397592/1/162/29/162/24/163 210898062/5/163/4/16NULL2 215179482/5/163/4/16NULL3 149763072/1/162/29/162/24/163 219578102/5/163/4/16NULL2 188311512/1/162/29/162/24/161 226159562/5/163/4/16NULL1 226702272/5/163/4/16NULL1 229709752/5/163/4/16NULL1 232232842/5/163/4/16NULL1 149193822/2/163/1/162/24/162 242973672/5/163/4/16NULL1 387428612/3/163/2/162/24/161 252246232/5/163/4/16NULL3 252950412/5/163/4/16NULL3 255887652/5/163/4/16NULL3 256016082/5/163/4/16NULL3 256522152/5/163/4/16NULL2 258631142/5/163/4/16NULL2 261013092/5/163/4/16NULL1 261341562/5/163/4/16NULL3 261486362/5/163/4/16NULL3 264398292/5/163/4/16NULL3 330871602/7/163/6/162/24/161 271851572/5/163/4/16NULL2 274611192/5/163/4/16NULL1 399014352/7/163/6/162/24/162 283762982/5/163/4/16NULL2 286179652/5/163/4/16NULL2 287678362/5/163/4/16NULL1 288735222/5/163/4/16NULL2 290692382/5/163/4/16NULL2 292432002/5/163/4/16NULL2 297393972/5/163/4/16NULL1 299923632/5/163/4/16NULL2 300579842/5/163/4/16NULL3 301165402/5/163/4/16NULL2 301533522/5/163/4/16NULL2 306267532/5/163/4/16NULL1 309931972/5/163/4/16NULL3 313174562/5/163/4/16NULL2 315543362/5/163/4/16NULL1 316784812/5/163/4/16NULL3 318578572/5/163/4/16NULL2 207214242/8/163/7/162/24/162 322436032/5/163/4/16NULL1 322560072/5/163/4/16NULL3 327311622/5/163/4/16NULL3 329636592/5/163/4/16NULL3 329970602/5/163/4/16NULL1 338021742/5/163/4/16NULL1 339848452/5/163/4/16NULL2 342015242/5/163/4/16NULL3 342162882/5/163/4/16NULL1 342289632/5/163/4/16NULL1 342502042/5/163/4/16NULL2 346179542/5/163/4/16NULL3 346720982/5/163/4/16NULL1 348363472/5/163/4/16NULL2 350117952/5/163/4/16NULL1 352248812/5/163/4/16NULL2 353502612/5/163/4/16NULL3 358465782/5/163/4/16NULL2 368069552/5/163/4/16NULL1 368917972/5/163/4/16NULL1 373978692/5/163/4/16NULL2 242773152/1/162/29/162/25/162 343427862/1/162/29/162/25/162 132275382/2/163/1/162/25/163 180586992/2/163/1/162/25/161 385754282/5/163/4/16NULL2 386592832/5/163/4/16NULL3 386826082/5/163/4/16NULL2 387757052/5/163/4/16NULL3 388018982/5/163/4/16NULL2 389036432/5/163/4/16NULL2 390089982/5/163/4/16NULL1 391453862/5/163/4/16NULL3 392969572/5/163/4/16NULL3 394195982/5/163/4/16NULL1 211664432/2/163/1/162/25/163 406655682/5/163/4/16NULL3 336434592/2/163/1/162/25/161 419664042/5/163/4/16NULL2 420789802/5/163/4/16NULL2 431405962/5/163/4/16NULL3 435103722/5/163/4/16NULL3 436858702/5/163/4/16NULL3 437616322/5/163/4/16NULL1 437895742/5/163/4/16NULL1 132147232/3/163/2/162/25/162 441425322/5/163/4/16NULL1 441439032/5/163/4/16NULL3 442915412/5/163/4/16NULL2 444835942/5/163/4/16NULL3 445466772/5/163/4/16NULL1 177334132/4/163/3/162/25/162 449278922/5/163/4/16NULL1 449458462/5/163/4/16NULL1 454507672/5/163/4/16NULL1 456727912/5/163/4/16NULL3 459117522/5/163/4/16NULL3 464682642/5/163/4/16NULL3 465421762/5/163/4/16NULL3 467375312/5/163/4/16NULL2 467555142/5/163/4/16NULL2 467859742/5/163/4/16NULL2 470075242/5/163/4/16NULL1 473559012/5/163/4/16NULL3 474226302/5/163/4/16NULL2 474292662/5/163/4/16NULL1 476954162/5/163/4/16NULL3 482217312/5/163/4/16NULL1 484015202/5/163/4/16NULL2 485764672/5/163/4/16NULL1 488087482/5/163/4/16NULL1 491616532/5/163/4/16NULL1 494748622/5/163/4/16NULL2 495529352/5/163/4/16NULL2 495802502/5/163/4/16NULL3 495938532/5/163/4/16NULL2 496919682/5/163/4/16NULL2 498178922/5/163/4/16NULL2 498372752/5/163/4/16NULL3 101802792/6/163/5/16NULL3 104385422/6/163/5/16NULL2 111106892/6/163/5/16NULL1 111365122/6/163/5/16NULL2 111432662/6/163/5/16NULL2 117360602/6/163/5/16NULL2 207404932/6/163/5/162/25/162 119586932/6/163/5/16NULL3 121546122/6/163/5/16NULL1 125578962/6/163/5/16NULL2 125709962/6/163/5/16NULL1 127036852/6/163/5/16NULL3 128201412/6/163/5/16NULL1 130168242/6/163/5/16NULL3 131683342/6/163/5/16NULL1 134217762/6/163/5/16NULL2 166386812/7/163/6/162/25/163 308615662/8/163/7/162/25/161 137263732/6/163/5/16NULL2 138702182/6/163/5/16NULL3 139865702/6/163/5/16NULL3 141414712/6/163/5/16NULL2 489972712/8/163/7/162/25/162 144892402/6/163/5/16NULL1 146593262/6/163/5/16NULL3 146704512/6/163/5/16NULL1 455989812/12/163/11/162/25/162 150369152/6/163/5/16NULL1 159764292/13/163/12/162/25/162 151379312/6/163/5/16NULL1 155311002/6/163/5/16NULL1 168080822/6/163/5/16NULL3 172339932/6/163/5/16NULL2 172695472/6/163/5/16NULL2 173657482/6/163/5/16NULL3 174926252/6/163/5/16NULL3 176059052/6/163/5/16NULL2 178418002/6/163/5/16NULL3 179928062/6/163/5/16NULL3 180837162/6/163/5/16NULL3 182458792/6/163/5/16NULL3 191643942/6/163/5/16NULL1 198017692/6/163/5/16NULL2 306795502/19/163/18/162/25/161 199197082/6/163/5/16NULL2 291084062/1/162/29/162/26/161 210799322/6/163/5/16NULL1 424725622/1/162/29/162/26/162 213229762/6/163/5/16NULL1 214436322/6/163/5/16NULL2 216553922/6/163/5/16NULL1 217502942/6/163/5/16NULL2 221028062/6/163/5/16NULL2 222033562/6/163/5/16NULL2 228448742/6/163/5/16NULL2 231093972/6/163/5/16NULL1 234168952/6/163/5/16NULL1 234701762/6/163/5/16NULL2 235406172/6/163/5/16NULL1 236927732/6/163/5/16NULL1 237118552/6/163/5/16NULL3 237469082/6/163/5/16NULL3 238109102/6/163/5/16NULL3 240796052/6/163/5/16NULL2 242984362/6/163/5/16NULL1 245096652/6/163/5/16NULL2 245841932/6/163/5/16NULL1 246241752/6/163/5/16NULL2 248504032/6/163/5/16NULL1 250327022/6/163/5/16NULL2 250409462/6/163/5/16NULL3 254359622/6/163/5/16NULL2 254584882/6/163/5/16NULL1 259110652/6/163/5/16NULL2 167009122/3/163/2/162/26/163 265241782/6/163/5/16NULL2 266159022/6/163/5/16NULL2 275170062/6/163/5/16NULL3 280053832/6/163/5/16NULL1 282878702/6/163/5/16NULL1 283139152/6/163/5/16NULL2 283954322/6/163/5/16NULL3 284846592/6/163/5/16NULL3 291240972/6/163/5/16NULL2 298167852/6/163/5/16NULL3 300635132/6/163/5/16NULL2 303263422/6/163/5/16NULL3 420475452/3/163/2/162/26/162 307109382/6/163/5/16NULL2 310737302/6/163/5/16NULL1 311138182/6/163/5/16NULL1 313028122/6/163/5/16NULL1 313722522/6/163/5/16NULL2 314546962/6/163/5/16NULL2 319212092/6/163/5/16NULL2 319478392/6/163/5/16NULL3 323812902/6/163/5/16NULL1 325548322/6/163/5/16NULL1 328070802/6/163/5/16NULL2 328821442/6/163/5/16NULL2 486127042/3/163/2/162/26/161 331605562/6/163/5/16NULL3 332321182/6/163/5/16NULL2 340418472/6/163/5/16NULL2 342274332/6/163/5/16NULL1 342396792/6/163/5/16NULL1 343528472/6/163/5/16NULL1 345372742/6/163/5/16NULL1 345761172/6/163/5/16NULL3 348676062/6/163/5/16NULL3 350330462/6/163/5/16NULL2 216396062/4/163/3/162/26/162 353671692/6/163/5/16NULL2 355737652/6/163/5/16NULL1 355795122/6/163/5/16NULL1 357667572/6/163/5/16NULL1 358742202/6/163/5/16NULL1 361701302/6/163/5/16NULL2 362874402/6/163/5/16NULL1 366933852/6/163/5/16NULL2 371902692/6/163/5/16NULL2 372143752/6/163/5/16NULL2 373914442/6/163/5/16NULL3 328890042/6/163/5/162/26/163 374625662/6/163/5/16NULL3 375863582/6/163/5/16NULL2 378082272/6/163/5/16NULL2 378556782/6/163/5/16NULL3 379820382/6/163/5/16NULL1 381506912/6/163/5/16NULL1 381836672/6/163/5/16NULL3 189580212/7/163/6/162/26/163 382128672/6/163/5/16NULL3 382808812/6/163/5/16NULL3 348613642/9/163/8/162/26/161 383930442/6/163/5/16NULL1 388114132/10/163/9/162/26/162 385738412/6/163/5/16NULL3 387802792/6/163/5/16NULL2 387845472/6/163/5/16NULL1 389460912/6/163/5/16NULL2 390745942/6/163/5/16NULL3 392582232/6/163/5/16NULL2 393948332/6/163/5/16NULL3 398121372/6/163/5/16NULL3 402669762/6/163/5/16NULL1 403566052/6/163/5/16NULL3 404246372/6/163/5/16NULL2 407949662/6/163/5/16NULL3 329534612/11/163/10/162/26/162 411712692/6/163/5/16NULL1 414507482/6/163/5/16NULL3 416780382/6/163/5/16NULL3 418959132/6/163/5/16NULL1 421549552/6/163/5/16NULL2 426802902/6/163/5/16NULL1 427439892/6/163/5/16NULL3 428951722/6/163/5/16NULL1 429267882/6/163/5/16NULL1 431052812/6/163/5/16NULL3 435767912/6/163/5/16NULL1 436384512/6/163/5/16NULL3 311091372/16/163/15/162/26/161 438198792/6/163/5/16NULL3 438869492/6/163/5/16NULL1 337717652/1/162/29/162/27/161 441723332/6/163/5/16NULL1 442058052/6/163/5/16NULL1 442854132/6/163/5/16NULL2 443386082/6/163/5/16NULL1 443455582/6/163/5/16NULL1 451059232/6/163/5/16NULL3 453602852/6/163/5/16NULL3 458784692/6/163/5/16NULL1 463848362/6/163/5/16NULL1 466175952/6/163/5/16NULL3 466926812/6/163/5/16NULL3 467012772/6/163/5/16NULL1 472052402/6/163/5/16NULL2 473791682/6/163/5/16NULL1 476287472/6/163/5/16NULL1 356390902/1/162/29/162/27/163 481300222/6/163/5/16NULL3 386410132/2/163/1/162/27/163 491278292/6/163/5/16NULL2 100563782/7/163/6/16NULL1 101347932/7/163/6/16NULL1 101699202/7/163/6/16NULL1 103209352/7/163/6/16NULL1 105116292/7/163/6/16NULL2 114705002/7/163/6/16NULL1 115752952/7/163/6/16NULL3 116389702/7/163/6/16NULL1 116996612/7/163/6/16NULL1 122485742/7/163/6/16NULL2 122660162/7/163/6/16NULL3 123563892/7/163/6/16NULL1 126610502/7/163/6/16NULL3 130840942/7/163/6/16NULL3 134137302/7/163/6/16NULL3 407681782/2/163/1/162/27/161 135537142/7/163/6/16NULL3 136790822/7/163/6/16NULL1 138666092/7/163/6/16NULL1 139455152/7/163/6/16NULL2 142721572/7/163/6/16NULL2 433262842/2/163/1/162/27/162 149163282/7/163/6/16NULL2 149520442/7/163/6/16NULL3 149841032/7/163/6/16NULL2 154697152/7/163/6/16NULL3 155585922/7/163/6/16NULL3 328200552/3/163/2/162/27/161 159464982/7/163/6/16NULL3 164475972/7/163/6/16NULL3 376872912/3/163/2/162/27/161 168949242/7/163/6/16NULL2 405703352/3/163/2/162/27/162 173618422/7/163/6/16NULL1 177370782/7/163/6/16NULL1 416727192/3/163/2/162/27/163 179398252/7/163/6/16NULL2 181019082/7/163/6/16NULL1 111202522/5/163/4/162/27/161 186899722/7/163/6/16NULL3 351099472/6/163/5/162/27/163 191394052/7/163/6/16NULL3 192345382/7/163/6/16NULL1 194498692/7/163/6/16NULL3 195788582/7/163/6/16NULL3 196417922/7/163/6/16NULL3 196653902/7/163/6/16NULL1 197335202/7/163/6/16NULL2 438961962/6/163/5/162/27/161 203175492/7/163/6/16NULL1 204952462/7/163/6/16NULL2 205197042/7/163/6/16NULL1 205283412/7/163/6/16NULL2 209627092/7/163/6/16NULL3 212603802/7/163/6/16NULL2 213696342/7/163/6/16NULL2 213874622/7/163/6/16NULL2 219671332/7/163/6/16NULL2 222533672/7/163/6/16NULL3 227892782/7/163/6/16NULL1 228732042/7/163/6/16NULL3 230839962/7/163/6/16NULL3 233951922/7/163/6/16NULL1 237966712/7/163/6/16NULL1 238010992/7/163/6/16NULL3 480018502/6/163/5/162/27/161 245097212/7/163/6/16NULL1 245337892/7/163/6/16NULL1 248976082/7/163/6/16NULL1 253276342/7/163/6/16NULL2 257718042/7/163/6/16NULL2 257756762/7/163/6/16NULL1 258672752/7/163/6/16NULL2 262457952/7/163/6/16NULL2 266051922/7/163/6/16NULL1 288411062/7/163/6/162/27/162 273265622/7/163/6/16NULL1 274220952/7/163/6/16NULL3 279342072/7/163/6/16NULL3 410858742/8/163/7/162/27/163 283821252/7/163/6/16NULL3 156474802/10/163/9/162/27/161 289160952/7/163/6/16NULL3 295488232/7/163/6/16NULL1 295508912/7/163/6/16NULL2 191308012/10/163/9/162/27/163 305125762/7/163/6/16NULL3 305433842/7/163/6/16NULL3 306488632/7/163/6/16NULL3 309755292/7/163/6/16NULL2 311572072/7/163/6/16NULL1 311827522/7/163/6/16NULL2 312227132/7/163/6/16NULL2 318436282/7/163/6/16NULL2 322916972/7/163/6/16NULL1 324316962/7/163/6/16NULL2 327417142/7/163/6/16NULL2 328119962/7/163/6/16NULL2 329401322/7/163/6/16NULL3 223863152/13/163/12/162/27/163 435493872/17/163/16/162/27/163 331458872/7/163/6/16NULL2 334460382/7/163/6/16NULL2 196114922/20/163/19/162/27/163 336052052/7/163/6/16NULL1 344282062/7/163/6/16NULL1 346013012/7/163/6/16NULL2 347168842/7/163/6/16NULL3 349203512/7/163/6/16NULL1 349568592/7/163/6/16NULL3 355589822/7/163/6/16NULL1 359106672/7/163/6/16NULL3 130750772/23/163/22/162/27/163 363841382/7/163/6/16NULL1 143643402/2/163/1/162/28/163 372027482/7/163/6/16NULL2 376726222/7/163/6/16NULL1 378443272/7/163/6/16NULL3 208790492/2/163/1/162/28/161 380878482/7/163/6/16NULL2 381763642/7/163/6/16NULL1 384564502/7/163/6/16NULL1 327896232/2/163/1/162/28/163 385365692/7/163/6/16NULL3 385627382/7/163/6/16NULL3 389245672/7/163/6/16NULL3 397978032/7/163/6/16NULL3 467545742/2/163/1/162/28/161 400723412/7/163/6/16NULL1 401340252/7/163/6/16NULL1 401728742/7/163/6/16NULL3 403703412/7/163/6/16NULL1 404774492/7/163/6/16NULL3 407204172/7/163/6/16NULL2 408893182/7/163/6/16NULL2 409767542/7/163/6/16NULL1 199268722/3/163/2/162/28/163 410877852/7/163/6/16NULL3 413042782/7/163/6/16NULL2 415454842/7/163/6/16NULL2 417394542/7/163/6/16NULL3 422075602/7/163/6/16NULL2 422108362/7/163/6/16NULL3 422650182/7/163/6/16NULL3 422840492/7/163/6/16NULL1 423446762/7/163/6/16NULL3 424701922/7/163/6/16NULL1 429034852/7/163/6/16NULL3 432747482/7/163/6/16NULL1 433163242/7/163/6/16NULL2 435375522/7/163/6/16NULL1 436858092/7/163/6/16NULL1 438213552/7/163/6/16NULL1 439045062/7/163/6/16NULL3 440147672/7/163/6/16NULL3 441980022/7/163/6/16NULL2 267992382/3/163/2/162/28/161 445671222/7/163/6/16NULL3 448413892/7/163/6/16NULL1 347976852/3/163/2/162/28/162 453948792/7/163/6/16NULL2 455708022/7/163/6/16NULL1 462118472/7/163/6/16NULL3 463814752/7/163/6/16NULL3 466797082/7/163/6/16NULL3 467896222/7/163/6/16NULL3 468083592/7/163/6/16NULL3 473431852/7/163/6/16NULL3 474143612/7/163/6/16NULL2 136030812/4/163/3/162/28/161 484218552/7/163/6/16NULL3 487090922/7/163/6/16NULL3 157530102/4/163/3/162/28/161 494148112/7/163/6/16NULL2 494761462/7/163/6/16NULL3 101914452/8/163/7/16NULL2 106954322/8/163/7/16NULL1 108861182/8/163/7/16NULL1 100936642/5/163/4/162/28/161 115503422/8/163/7/16NULL1 115619942/8/163/7/16NULL3 385104462/5/163/4/162/28/161 120053682/8/163/7/16NULL2 121036222/8/163/7/16NULL3 121338102/8/163/7/16NULL2 123015492/8/163/7/16NULL1 409897572/5/163/4/162/28/163 126502302/8/163/7/16NULL1 409120562/6/163/5/162/28/162 134356352/8/163/7/16NULL3 450356552/7/163/6/162/28/161 141116162/8/163/7/16NULL3 144084922/8/163/7/16NULL1 144477562/8/163/7/16NULL2 144790202/8/163/7/16NULL2 144900952/8/163/7/16NULL1 152606312/8/163/7/16NULL2 153901172/8/163/7/16NULL1 155302602/8/163/7/16NULL2 156799942/8/163/7/16NULL1 157255082/8/163/7/16NULL3 160975812/8/163/7/16NULL2 162292172/8/163/7/16NULL1 483930272/7/163/6/162/28/162 163168112/8/163/7/16NULL3 417295602/9/163/8/162/28/163 170258692/8/163/7/16NULL2 177627402/8/163/7/16NULL3 181868292/8/163/7/16NULL2 183109912/8/163/7/16NULL1 183711652/8/163/7/16NULL2 186019762/8/163/7/16NULL1 186578482/8/163/7/16NULL1 194461702/8/163/7/16NULL2 195684702/8/163/7/16NULL2 198495102/8/163/7/16NULL1 392184042/10/163/9/162/28/161 199955232/8/163/7/16NULL1 487521802/10/163/9/162/28/161 204426312/8/163/7/16NULL2 331269092/11/163/10/162/28/162 210066692/8/163/7/16NULL1 213416222/8/163/7/16NULL2 180286542/14/163/13/162/28/161 216933412/8/163/7/16NULL3 217074272/8/163/7/16NULL2 217284552/8/163/7/16NULL3 226383332/8/163/7/16NULL1 227600662/8/163/7/16NULL1 234012762/8/163/7/16NULL3 237317482/8/163/7/16NULL3 240458892/8/163/7/16NULL1 242362602/8/163/7/16NULL2 243168852/8/163/7/16NULL3 244651002/8/163/7/16NULL1 248653862/8/163/7/16NULL1 249357872/8/163/7/16NULL2 249796472/8/163/7/16NULL3 250971482/8/163/7/16NULL2 255693082/8/163/7/16NULL2 107155582/16/163/15/162/28/161 263016612/8/163/7/16NULL1 263288182/8/163/7/16NULL2 264995852/8/163/7/16NULL1 270736182/8/163/7/16NULL1 271037072/8/163/7/16NULL1 273629182/8/163/7/16NULL2 204018932/16/163/15/162/28/161 478867182/18/163/17/162/28/163 280387442/8/163/7/16NULL1 284198882/8/163/7/16NULL1 285806982/8/163/7/16NULL2 287316152/8/163/7/16NULL3 218136982/28/163/27/162/28/163 294120382/8/163/7/16NULL3 296521002/8/163/7/16NULL3 298155242/8/163/7/16NULL2 300935182/8/163/7/16NULL2 302128032/8/163/7/16NULL1 302864222/8/163/7/16NULL3 304539052/8/163/7/16NULL1 305459392/8/163/7/16NULL1 305973422/8/163/7/16NULL3 306275862/8/163/7/16NULL2 307587452/8/163/7/16NULL2 177904502/1/162/29/162/29/161 309988672/8/163/7/16NULL3 311214202/8/163/7/16NULL1 318301332/8/163/7/16NULL1 322700842/8/163/7/16NULL3 360561482/1/162/29/162/29/162 325263952/8/163/7/16NULL1 282956452/2/163/1/162/29/161 328144722/8/163/7/16NULL1 339154762/8/163/7/16NULL3 339535522/8/163/7/16NULL2 344760742/8/163/7/16NULL2 346729632/8/163/7/16NULL2 347860972/8/163/7/16NULL3 132743542/3/163/2/162/29/162 352231432/8/163/7/16NULL2 353472612/8/163/7/16NULL1 354687492/8/163/7/16NULL2 357973362/8/163/7/16NULL2 185100282/3/163/2/162/29/163 364588382/8/163/7/16NULL1 368272282/8/163/7/16NULL3 369167782/8/163/7/16NULL2 370247412/8/163/7/16NULL3 371647482/8/163/7/16NULL2 373209342/8/163/7/16NULL3 376584532/8/163/7/16NULL2
fpaexceltest-cjyanvre.xlsx
Answered Same DayNov 04, 2021

Answer To: Information + instructions Some information about our dataset and term definitions The attached is a...

Mohd answered on Nov 05 2021
117 Votes
Information + instructions
        Some information about our dataset and term definitions
        The attached is a hypothetical dataset containing subscription data for all customers who first joined ClassPass in February 2016.
        ClassPass is a consumer-facing monthly subscription with recur billing (e.g., we automatically charge you every month until you request to cancel).
        A customer's "bill date" is set when he/she first joins ClassPass. For example, if a customer joins on February 11th, that customer's "bill date" is the 11th of the month. We first charge that customer on February 11th for the service period February 11th-March 10th. We charge that customer again on March 11th for the service period March 11th-April 10th, unless the customer has requested to cancel.
        Each record in the dataset is a unique "subscription month" for a single customer; if a customer remains a ClassPass member for nine months, that customer appears in the data nine times.
        A new record is created in the data table at the moment when we charge a customer for the coming month. For example, when we charge a customer on March 11th for the service period of March 11th-April 10th, the record covering that subscription month will not appear in the data table until March 11th.
        A customer can request to cancel ClassPass at any time by logging into ClassPass and clicking "I'd like to cancel my membership." When a customer requests to cancel, we still consider him/her an active customer until the end of the current subscription month; we consider that customer's "time of churn" to be the last day of that subscription month, since that is the last day on which we are providing service to that customer.
        In the attached table, the "cancellation request" field includes the date of any request to cancel made during the subscription month. If the field is "NULL", you can assume that the customer did not request to cancel during that month (or, if the subscription period is still ongoing as of the date that the data was pulled, that the customer has not yet requested to cancel).
        We define "churn rate" as number of customers who churned in any defined time period, divided by the number of active customers at the beginning of that time period.
        Questions
        1. How many of the customers in the attached data set were still active ClassPass customers on June 9th, 2016?
        2. What was the April 2016 churn rate of the customers in the attached dataset?
        3. If you had to make a prediction, how many customers in the attached dataset will churn in the month of October?
        4. Are there any trends you can see in how churn differs by any customer attributes (e.g., city, length of time on CP)? If so, do you have any ideas for what ClassPass could do to improve churn among those customers?
        Guidelines for completing the exercise
        1. Please start a new sheet in this table for your answers; you can format it however you'd like.
        2. We recommend that you "show your work" (either in your answers table, in the "Dataset" tab, or any other tabs you choose to create) -- it helps us see how you think!
        3. Please upload your completed test to Greenhouse via the link provided.
        4. We recommend that you do not use pivot tables.
Q4
    Cancellation Request Date    (Multiple Items)
    Row Labels    Count of Cancellation Request Date
    Feb    620
    Mar    469
    Apr    356
    May    228
    Jun    193
    Jul    163
    Aug    152
    Sep    99
    Oct    13
    Grand Total    2293
Total    Feb    Mar    Apr    May    Jun    Jul    Aug    Sep    Oct    620    469    356    228    193    163    152    99    13    
Q2
    Data pulled/refreshed on:    10/15/16                    Q.2        Churn Rate
                            Active customers    28618    1.51%
    Unique User ID    Subscription Month Start Date    Subscription Month End Date    Cancellation Request Date    City ID        cancellation    432
    10214551    2/1/16    2/29/16    NULL    2
    10243632    2/1/16    2/29/16    NULL    3
    10817543    2/1/16    2/29/16    NULL    2
    10971738    2/1/16    2/29/16    NULL    2        Active...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?