Internet Access Services Index Methodology in the Consumer Price Index

Warning View the most recent version.

Archived Content

Information identified as archived is provided for reference, research or recordkeeping purposes. It is not subject to the Government of Canada Web Standards and has not been altered or updated since it was archived. Please "contact us" to request a format other than those available.

Release date: August 7, 2018

1. Introduction

Residential Internet access is a high-technology service. As such, its calculation requires methods that are not typically applied to other components of the CPI. This paper describes the methodology that Statistics Canada has adopted to measure the price change of residential Internet access services.

2. Background

The Internet access services aggregate is a component of the Communications aggregate. It accounts for 28% of the Communications aggregate in the 2015 basket. Conceptually, the Internet access services index covers all Internet access services to a residence. However, the prices of wireless plans to the home are not collected. With 4% of Canadian residential subscriptions in 2016 (Canadian Radio-television and Telecommunications Commission [CRTC] 2017a), they do not represent an important part of the market.

3. Data Collection

Data for the Internet access services index is collected by price evaluators in Statistics Canada’s Head Office from the websites of the Internet Service Providers (ISP)s. Residential internet access is marketed and sold in a similar manner across Canada. A monthly subscription to a plan from an ISP allows a consumer to access the Internet.

Prices are collected on a provincial basis from all ISPs with at least a 10% market share by revenue. This ensures a coverage of 75% of the market in each province. Market shares are sourced from the Annual Survey of Telecommunications, conducted jointly by Statistics Canada and the CRTC, and are updated annually.

Only wired, broadband (non-dialup) plans are priced. For the purposes of this index, a plan is defined by its ISP, download speed, upload speed and usage cap. These characteristics are recorded for each selected plan when it is priced and are also used to identify a plan across time.

Each pricing month, the price evaluator selects and records the price and characteristics of a plan at every available download speed for each ISP. The collected price corresponds to the regular, unbundled, price of the plan. If there are several plans with the same download speed, only one of them is selected, based on the price evaluator’s judgment of which one is the most representative plan. As long as a plan remains available it will continue to be priced.

When a new download speed is offered, the price evaluator immediately selects and prices a plan corresponding to this new download speed. This means that new plans can “enter” the sample even without a corresponding “exit”. In the same way, a plan can exit the sample without a corresponding entry. However, in the case of an exit, the price evaluator will select and price a new plan with the same download speed from the same ISP, if possible. The dynamic nature of entries and exits means that the sample size is not fixed and that it will adjust automatically in response to the introduction of new plans and the discontinuation of older plans. This is necessary due to the high churn rate; at the ISP level, on average 15.1% of plans exited the sample on a quarterly basis between the first quarters of 2016 and 2018. Figure 1 graphically represents the difference between entries and exits.

Figure 1 Entries, Exits and Continuities

Description for Figure 1

Figure 1 graphically represents the difference between entries and exits using a Venn diagram of Entries, Exits and Continuities. There are two circles that overlap to create an intersection in the middle. Left circle represents Exits that were collected in previous month (T0). The circle on the right represents Entries that are collected in current month (T1). The intersection in the middle represents Continuities that are collected in both current month (T1) and previous month (T0).

4. Weighting by Download Speed

 As described in Section 3, prices corresponding to the full range of available download speeds are collected every period from each ISP. This is done to ensure that new plans enter the sample immediately and to combat sample deterioration. It would not be reasonable to accord the same weight to both a newly introduced, high-speed, plan and a plan with a more representative download speed. It is, therefore, important to weight plans below the ISP level to help ensure that the index reflects the price changes experienced by consumers. Ideally plans would by weighted by their revenue or expenditure share but at this time expenditure data at the individual plan level is unavailable. In absence of external quantity or expenditure data at individual plan level, plans are weighted based on their observed download speed. This is done based on the distribution of the available download speeds within an ISP.

The plans of a given ISP, l, in a given period, t, are assigned a weight vector, q l t* MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGXbWdamaaDaaaleaapeGaamiBaaWdaeaapeGaaiikaiaadsha caGGQaGaaiykaaaakiaacYcaaaa@3B12@ , such that the weighted sum of their download speeds equals their median download speed. The weight vector q l t* MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGXbWdamaaDaaaleaapeGaamiBaaWdaeaapeGaaiikaiaadsha caGGQaGaaiykaaaakiaacYcaaaa@3B12@  can be regarded as a vector of quantity shares. This approach assumes that the distribution of available download speeds is reflective of consumer demand. There is a wide body of research that supports the conclusion that the purchasing decisions of consumers can be strongly influenced by “anchors”. While some studies have shown that completely arbitrary anchors such as Social Security Numbers can be effective (Ariely, Loewenstein & Prelec 2003), there is evidence that the presentation of similar products with extreme yet plausible prices is a more effective anchoring mechanism (Kishna, Wagner & Yoon 2006)(Sugden, Zheng & Zizzo 2013).

In addition to the constraint that the weighted sum of download speeds is equal to the median download speed, weights are assigned such that their variance is minimized. This ensures that weights are spread out as evenly as possible, rather than simply assigning all weights to the fastest and slowest plans. Combined with the constraint that the weights sum to one, this minimization of variance is equivalent to minimizing the squared difference between the generated weights and a vector of equal weights, given the constraint that the weighted average download speed equals the median download speed.

The generation of weight vector q l t* MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGXbWdamaaDaaaleaapeGaamiBaaWdaeaapeGaaiikaiaadsha caGGQaGaaiykaaaakiaacYcaaaa@3B12@ can be formulated as the solution to the following minimization problem. Defining a l t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGHbWdamaaDaaaleaapeGaamiBaaWdaeaapeGaamiDaaaaaaa@3841@  as the median download speed of ISP l in period t, sil as the download speed of plan i from ISP l and n MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaGaamOBaaaa@35D8@  as the number of available plans:

( 1 )    q l t* = argmin q il i=1 n ( q il 1 n ) 2 MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaqadaWdaeaapeGaaGymaaGaayjkaiaawMcaaiaadghapaWaa0ba aSqaa8qacaWGSbaapaqaa8qacaWG0bGaaiOkaaaak8aacqGH9aqpda WfqaqaaiaadggacaWGYbGaam4zaiaad2gacaWGPbGaamOBaaWcbaGa aeyCaiaabMgacaqGSbaabeaakmaaqadabaWaaeWaaeaapeGaamyCa8 aadaWgaaWcbaWdbiaadMgacaWGSbaapaqabaGcpeGaeyOeI0YaaSaa a8aabaWdbiaaigdaa8aabaWdbiaad6gaaaaapaGaayjkaiaawMcaam aaCaaaleqabaGaaGOmaaaaaeaacaWGPbGaeyypa0JaaGymaaqaaiaa d6gaa0GaeyyeIuoaaaa@538A@

subject to:

i=1 n q il * s il =  a l t ; MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaWaaabmaeaaqa aaaaaaaaWdbiaadghapaWaaSbaaSqaa8qacaWGPbGaamiBaaWdaeqa aOWdbiaacQcacaWGZbWdamaaBaaaleaapeGaamyAaiaadYgaa8aabe aak8qacqGH9aqpcaGGGcGaamyya8aadaqhaaWcbaWdbiaadYgaa8aa baWdbiaadshaaaGcpaGaai4oaaWcbaWdbiaadMgacqGH9aqpcaaIXa aapaqaa8qacaWGUbaan8aacqGHris5aaaa@4867@

i=1 n q il = 1; MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaWaaabmaeaaqa aaaaaaaaWdbiaadghapaWaaSbaaSqaa8qacaWGPbGaamiBaaWdaeqa aOWdbiabg2da9iaacckapaGaaGymaiaacUdaaSqaa8qacaWGPbGaey ypa0JaaGymaaWdaeaapeGaamOBaaqdpaGaeyyeIuoaaaa@41E3@

and q il 0 MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbbjxAHX garmWu51MyVXgaruWqHXwAIjxAaebbnrfifHhDYfgasaacH8qrps0l bba9q8WrFD0xHaVhbbf9v8qqaqFr0xc9pk0xbba9q8WqFfea0=yr0R Yxir=Jbba9q8aq0=yq=He9q8qqQ8frFve9Fve9Ff0dmeaabaqaaiaa caGaaeqabaWaamaaeaaakeaaieGaqaaaaaaaaaWdbiaa=fhapaWaaS baaSqaa8qacaWFPbGaa8hBaaWdaeqaaOGaaGjbVlabgwMiZkaaysW7 caaIWaaaaa@399F@

Since weight vector q l t* MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGXbWdamaaDaaaleaapeGaamiBaaWdaeaapeGaamiDaiaacQca aaaaaa@38FE@ is treated as a vector of quantity shares, the corresponding vector of expenditure shares, v l t* , MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWG2bWdamaaDaaaleaapeGaamiBaaWdaeaapeGaamiDaiaacQca aaGccaGGSaaaaa@39BD@ is obtained by multiplying these quantity shares by their respective prices and subsequently dividing by their sum so that:

( 2 )    v il t* = q il t* * p il t i=1 n q il t* * p il t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaqadaWdaeaapeGaaGOmaaGaayjkaiaawMcaaiaacckacaGGGcGa aiiOaiaadAhapaWaa0baaSqaa8qacaWGPbGaamiBaaWdaeaapeGaam iDaiaacQcaaaGccqGH9aqpdaWcaaWdaeaapeGaamyCa8aadaqhaaWc baWdbiaadMgacaWGSbaapaqaa8qacaWG0bGaaiOkaaaakiaacQcaca WGWbWdamaaDaaaleaapeGaamyAaiaadYgaa8aabaWdbiaadshaaaaa k8aabaWdbmaavadabeWcpaqaa8qacaWGPbGaeyypa0JaaGymaaWdae aapeGaamOBaaqdpaqaa8qacqGHris5aaGccaWGXbWdamaaDaaaleaa peGaamyAaiaadYgaa8aabaWdbiaadshacaGGQaaaaOGaaiOkaiaadc hapaWaa0baaSqaa8qacaWGPbGaamiBaaWdaeaapeGaamiDaaaaaaaa aa@5AEA@

Figure 2 Estimated Distribution of Weights by Normalized Download Speed for Selected Provinces in February 2018

Data table for Figure 2

Figure 2 shows a table with four graphs of the results of this estimation procedure for selected provinces in February 2018.

Estimated weights are plotted against download speeds; download speeds have been normalized by dividing by the maximum download speed from the same ISP. Plans from the same ISP are joined by lines to help distinguish plans from different ISPs.

The 4 graphs are of British Columbia, Nova Scotia, Ontario and Quebec. All show a negative relationship between download speed and weight. This relationship also tends to be linear, except for two kinks, one in Ontario and one in Quebec.

Data table for Figure 2
Table summary
This table displays the results of Data table for Figure 2 Ratio of download speed to maximum download speed
and Estimated weight as a share (appearing as column headers).
Ratio of download speed to maximum download speed
Estimated weight as a share
British Columbia
Plans from ISP 0 1.00 0.30
0.50 0.34
0.10 0.37
Plans from ISP 1 1.00 0.13
0.50 0.24
0.17 0.31
0.10 0.32
Nova Scotia
Plans from ISP 0 1.00 0.06
0.30 0.28
0.15 0.32
0.10 0.34
Plans from ISP 1 1.00 0.06
0.32 0.27
0.16 0.32
0.11 0.34
Ontario
Plans from ISP 0 1.00 0.01
0.30 0.16
0.15 0.19
0.05 0.21
0.03 0.22
0.00 0.22
Plans from ISP 1 1.00 0.00
0.36 0.06
0.25 0.10
0.12 0.15
0.06 0.17
0.04 0.17
0.04 0.17
0.02 0.18
Plans from ISP 2 1.00 0.00
0.50 0.11
0.15 0.20
0.06 0.22
0.03 0.23
0.01 0.24
Quebec
Plans from ISP 0 1.00 0.00
0.30 0.04
0.15 0.13
0.05 0.19
0.03 0.21
0.02 0.21
0.00 0.22
Plans from ISP 1 1.00 0.01
0.21 0.17
0.13 0.19
0.03 0.21
0.01 0.21
0.01 0.21

The weight generation procedure generally results in a reduced weight being assigned to the faster plans. This is because ISPs usually offer a range of download speeds that increase in an exponential fashionNote 1. However, average download is constrained to equal median speed in a linear fashion. This means that any weight that is assigned to a faster plan results in a disproportionate shift of the average download speed, a shift that has to be compensated by increasing the weight of a slower plan. Figure 2 provides a graphical representation of the results of this estimation procedure for selected provinces in February 2018. Estimated weights are plotted against download speeds; download speeds have been normalized by dividing by the maximum download speed from the same ISP. One can readily observe a negative relationship between download speed and weight. This relationship also tends to be linear, except for two kinks, one in Ontario and one in Quebec. In both cases, the fastest plan has received a minimal weight that is very close to zero. Overall, the results of weight generation procedure are more plausible than the alternative of assigning all plans an equal weight.

5. Hedonic Adjustment of Entries and Exits

For products that undergo rapid technological change and an associated churn in models, the matched model breaks down and can lead to substantial bias (Silver & Heravi, 2005). This problem applies to Internet access plans since an average of 15.1% of plans exit the sample each quarter. This high churn rate can be explained by both improved technology such as increasing download speeds as well as marketing tactics of the ISPs. Under such conditions, hedonic methods can be applied to account for price change that would be missed under the matched model approach (Triplett, 2004).

A benefit of this application of hedonics is that it is easier for CPI analysts to interpret and explain due to its similarity to other methods of quality adjustment employed in the CPI.

5.1 Regression Functional Form

A regression is estimated every collection period on the same sample from which the index is calculated. This means that the plans from the two periods are pooled in the same regression. As a result, the estimated coefficients of the characteristics are constrained to be the same between the two periods. Given that all plans were observed in two adjacent quarter, this would seem to be a reasonable restriction.

Least squares are used to solve for the B vector of parameters in the following formulation:

( 3 )   ln p i t =B X i t + ε i MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaqadaWdaeaapeGaaG4maaGaayjkaiaawMcaaiaacckacaGGGcGa aiiOaiGacYgacaGGUbGaamiCa8aadaqhaaWcbaWdbiaadMgaa8aaba WdbiaadshaaaGccqGH9aqpcaWGcbaccaGae8xXICTaamiwa8aadaqh aaWcbaWdbiaadMgaa8aabaWdbiaadshaaaGccqGHRaWkcqaH1oqzpa WaaSbaaSqaa8qacaWGPbaapaqabaaaaa@4B30@

where p i t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGWbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaaaaa@384C@  is the price of plan i from period t, ε i MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacqaH1oqzpaWaaSbaaSqaa8qacaWGPbaapaqabaaaaa@37F4@  is a random error term with an expected value of zero and Xi is plan i’s vector of characteristics.

There are a limited number of ISPs providing service to a given residence, and it is assumed that a consumer will not change residences simply to change ISPs. It is therefore readily apparent that there is no Canada-wide market for Internet access services. Ideally separate regressions would be run or dummies included for each ISP. However, in this case there would be too few observations to estimate the relationship between prices and characteristics with much confidence. Instead, all plans from current and previous period are pooled together for one regression.

The regression is weighted in order to ensure that all combinations of characteristics and prices are accorded their proper importance. The results of the optimization model, as specified in equations (1) and (2), are used to assign a regression weight to each plan. The model is constrained so that, for both periods, all providers within a given province are equally weighted and each of the ten provinces receives an equal weight. If a particular plan is not available in a given period, this is equivalent to it having no weight in the regression for that period. Plans from the three territories are excluded from the regression because they are not representative of the overall Canadian market and should not influence the adjustment of plans in the provinces. However, plans from the territories are still subject to same adjustment procedure as the plans from the provinces.

5.2 Adjustment Procedure

Once the regression model has been estimated and the coefficients estimated, the missing prices of entering and exiting plans are calculated. This is done by applying an adjustment factor to the predicted price from the regression. The adjustment is necessary since the hedonic regression is constrained to hold characteristics coefficients constant across the two-time periods. Thus, the missing of price of plan i in period t from ISP l is calculated as:

( 4 )    p il t = e β ^ X il t × A il t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaqadaWdaeaapeGaaGinaaGaayjkaiaawMcaaiaacckacaGGGcGa aiiOaiaadchapaWaa0baaSqaa8qacaWGPbGaamiBaaWdaeaapeGaam iDaaaakiabg2da9iaadwgapaWaaWbaaSqabeaapeGafqOSdi2dayaa jaaccaWdbiab=vSixlaadIfapaWaa0baaWqaa8qacaWGPbGaamiBaa WdaeaapeGaamiDaaaaaaGccqGHxdaTcaWGbbWdamaaDaaaleaapeGa amyAaiaadYgaa8aabaWdbiaadshaaaaaaa@4FBE@

Here β ^ MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacuaHYoGypaGbaKaaaaa@36C5@  is the vector of characteristic coefficients estimated from the regression; note the lack of time subscript, t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWG0bGaaiilaaaa@36AE@ , on the β MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacqaHYoGyaaa@36A6@ vector of coefficients. X il t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGybWdamaaDaaaleaapeGaamyAaiaadYgaa8aabaWdbiaadsha aaaaaa@3925@ is the missing plan’s vector of characteristic while A il t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGbbWdamaaDaaaleaapeGaamyAaiaadYgaa8aabaWdbiaadsha aaaaaa@390E@  is the adjustment factor calculated from the plans available in period t from ISP l that are most similar to the missing plan. Having noted that the adjustment procedure only considers plans from the same ISP, henceforth the ISP subscript l will be dropped for legibility reasons.

The selection of the most similar plans is fully automated. The download speed of plan i, s i MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamyAaaWdaeqaaaaa@3745@ , compared to the download speeds of all plans available from ISP l in period t, the set S l t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGtbWdamaaDaaaleaapeGaamiBaaWdaeaapeGaamiDaaaaaaa@3832@ . If plan i’s download speed is either higher or lower than any other plan, i.e.:

(5)        or  s i < argmin s S l t ( s )       s i > argmax s S l t ( s ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcqaaaaaaaaaWdbe aadaqfWaqabKaaGfaacaaMe8UaaGjbVlaaysW7caaMe8UaaGjbVlaa b+gacaqG1bGaaeiiaiaadohapaWaaSbaaeaapeGaamyAaaWdaeqaa8 qacqGH8aappaWaaCbeaeaapeGaaeyyaiaabkhacaqGNbGaaeyBaiaa bMgacaqGUbaapaqaa8qacaWGZbGaeyicI4Saam4ua8aadaqhaaqaa8 qacaWGSbaapaqaa8qacaWG0baaaaWdaeqaa8qadaqadaWdaeaapeGa am4CaaGaayjkaiaawMcaaaqaaiaaysW7caaMe8UaaGjbVlaaysW7ca aMe8Uaam4Ca8aadaWgaaqaa8qacaWGPbaapaqabaWdbiabg6da+8aa daWfqaqaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyyaiaabIhaa8 aabaWdbiaadohacqGHiiIZcaWGtbWdamaaDaaabaWdbiaadYgaa8aa baWdbiaadshaaaaapaqabaWdbmaabmaapaqaa8qacaWGZbaacaGLOa GaayzkaaaaneaacaqGOaGaaeynaiaabMcaaaaaaa@6D31@

then the following equation holds:

( 6 )    A i t = p j t e β ^ X j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcqaaaaaaaaaWdbe aacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaakiab g2da9maalaaapaqaa8qacaWGWbWdamaaDaaaleaapeGaamOAaaWdae aapeGaamiDaaaaaOWdaeaapeGaamyza8aadaahaaWcbeqaa8qacuaH YoGypaGbaKaaiiaapeGae8xXICTaamiwa8aadaWgaaadbaWdbiaadQ gaa8aabeaaaaaaaaaa@4448@

Here p j t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGWbWdamaaDaaaleaapeGaamOAaaWdaeaapeGaamiDaaaaaaa@384D@  is the price of the plan from ISP l available in period t with the closest speed to plan i’s. This corresponds to Cases 1 and 2 in Table 1. The above calculation also applies if s jl = s il MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbbjxAHX garmWu51MyVXgaruWqHXwAIjxAaebbnrfifHhDYfgasaacH8qrps0l bba9q8WrFD0xHaVhbbf9v8qqaqFr0xc9pk0xbba9q8WqFfea0=yr0R Yxir=Jbba9q8aq0=yq=He9q8qqQ8frFve9Fve9Ff0dmeaabiqaciaa caGaaeqabaWaamaaeaaakeaaqaaaaaaaaaWdbiaadohapaWaaSbaaS qaa8qacaWGQbGaamiBaaWdaeqaaOWdbiabg2da9iaadohapaWaaSba aSqaa8qacaWGPbGaamiBaaWdaeqaaaaa@3854@ , i.e. when there is a plan from ISP l in period t with a download speed exactly equal to the download speed of the missing plan i. This corresponds to Case 3 in Table 1. If none of these conditions are satisfied, then A i t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaaaaa@381D@  is calculated as:

( 7 )    A i t = ( p k t e β ^ X k ) 0.5 × ( p j t e β ^ X j ) 0.5 MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcqaaaaaaaaaWdbe aacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaakiab g2da9maabmaapaqaa8qadaWcaaWdaeaapeGaamiCa8aadaqhaaWcba WdbiaadUgaa8aabaWdbiaadshaaaaak8aabaWdbiaadwgapaWaaWba aSqabeaapeGafqOSdi2dayaajaaccaWdbiab=vSixlaadIfapaWaaS baaWqaa8qacaWGRbaapaqabaaaaaaaaOWdbiaawIcacaGLPaaapaWa aWbaaSqabeaapeGaaGimaiaac6cacaaI1aaaaOGaey41aq7aaeWaa8 aabaWdbmaalaaapaqaa8qacaWGWbWdamaaDaaaleaapeGaamOAaaWd aeaapeGaamiDaaaaaOWdaeaapeGaamyza8aadaahaaWcbeqaa8qacu aHYoGypaGbaKaapeGae8xXICTaamiwa8aadaWgaaadbaWdbiaadQga a8aabeaaaaaaaaGcpeGaayjkaiaawMcaa8aadaahaaWcbeqaa8qaca aIWaGaaiOlaiaaiwdaaaaaaa@59ED@

In this case, the adjustment factor is based on the price of two different plans, j and k, both available from ISP l in period t. Their download speeds, s j MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamOAaaWdaeqaaaaa@3746@  and s k MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaam4AaaWdaeqaaaaa@3747@ ,  bound the download speed of plan i, such that s k > s i > s j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbbjxAHX garmWu51MyVXgaruWqHXwAIjxAaebbnrfifHhDYfgasaacH8qrps0l bba9q8WrFD0xHaVhbbf9v8qqaqFr0xc9pk0xbba9q8WqFfea0=yr0R Yxir=Jbba9q8aq0=yq=He9q8qqQ8frFve9Fve9Ff0dmeaabaqaaiaa caGaaeqabaWaamaaeaaakeaaieGaqaaaaaaaaaWdbiaa=nhapaWaaS baaSqaa8qacaWFRbaapaqabaGcpeGaeyyzImRaa83Ca8aadaWgaaWc baWdbiaa=Lgaa8aabeaak8qacqGHLjYScaWFZbWdamaaBaaaleaape Gaa8NAaaWdaeqaaaaa@3B43@ . In addition, s j MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamOAaaWdaeqaaaaa@3746@  and s k MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaam4AaaWdaeqaaaaa@3747@ satisfy the following conditions:

(8) s j = argmax s S l t ;  s i >s ( s i s ) s k = argmin s S l t ;s> s i ( s  s i ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaqfWaqabKaaGfaacaaMe8UaaGjbVlaaysW7caaMe8UaaGjbVlaa dohak8aadaWgaaqcbawaa8qacaWGQbaapaqabaqcaa2dbiabg2da9O WdamaaxabajaaybaWdbiaabggacaqGYbGaae4zaiaab2gacaqGHbGa aeiEaaqcba2daeaapeGaam4CaiabgIGiolaadofal8aadaqhaaqcca waa8qacaWGSbaapaqaa8qacaWG0baaaKqaGjaacUdacaGGGcGaam4C aSWdamaaBaaajiaybaWdbiaadMgaa8aabeaajeaypeGaeyOpa4Jaam 4CaaWdaeqaaOWdbmaabmaajaaypaqaa8qacaWGZbGcpaWaaSbaaKqa GfaapeGaamyAaaWdaeqaaKaaG9qacqGHsislcaWGZbaacaGLOaGaay zkaaaabaGaaGjbVlaaysW7caaMe8UaaGjbVlaaysW7caWGZbGcpaWa aSbaaKqaGfaapeGaam4AaaWdaeqaaKaaG9qacqGH9aqpk8aadaWfqa qcaawaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyAaiaab6gaaKqa G9aabaWdbiaadohacqGHiiIZcaWGtbWcpaWaa0baaKGaGfaapeGaam iBaaWdaeaapeGaamiDaaaajeaycaGG7aGaam4Caiabg6da+iaadoha l8aadaWgaaqccawaa8qacaWGPbaapaqabaaajeaybeaak8qadaqada qcaa2daeaapeGaam4CaiabgkHiTiaacckacaWGZbGcpaWaaSbaaKqa GfaapeGaamyAaaWdaeqaaaqcaa2dbiaawIcacaGLPaaaa0qaaiaabI cacaqG4aGaaeykaaaaaaa@86D3@

In other words, plan k is the plan offered by ISP l in period t with a download speed that is faster than s i MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamyAaaWdaeqaaaaa@3745@ , but by a minimal amount. Plan j is the plan offered by ISP l in period t plan that is slower than s i MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamyAaaWdaeqaaaaa@3745@ , but by minimal amount. The different methods of calculating the adjustment factor A i t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaaaaa@381D@ are summarized in Table 1, while Tables 2-5 provide examples (entries and exits are shaded).

Table 1
Table summary
This table displays the results of Table 1. The information is grouped by Case (appearing as row headers), Condition, Calculation of and Where (appearing as column headers).
Case Condition Calculation of A i l t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFbbWdamaaDaaaleaapeGaa8xAaiaa=Xgaa8aabaWdbiaa =rhaaaaaaa@390B@ Where
1 s i argmax s S l t ( s ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamyAaaWdaeqaaOWdbiabgwMiZ+aa daWfqaqaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyyaiaabIhaaS WdaeaapeGaam4CaiabgIGiolaadofapaWaa0baaWqaa8qacaWGSbaa paqaa8qacaWG0baaaaWcpaqabaGcpeWaaeWaa8aabaWdbiaadohaai aawIcacaGLPaaaaaa@47AD@ The missing plan has a download speed that is higher than or equal to the download speed of any plan offered in period t, the period for which the plan is missing A i t = p j t e β ^ X j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaakiab g2da9maalaaapaqaa8qacaWGWbWdamaaDaaaleaapeGaamOAaaWdae aapeGaamiDaaaaaOWdaeaapeGaamyza8aadaahaaWcbeqaa8qacuaH YoGypaGbaKaaiiaapeGae8xXICTaamiwa8aadaWgaaadbaWdbiaadQ gaa8aabeaaaaaaaaaa@4448@ = p j t e β ^ X j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacqGH9aqpcaWGWbWdamaaDaaaleaapeGaamOAaaWdaeaapeGaamiD aaaakiaadwgapaWaaWbaaSqabeaapeGaeyOeI0IafqOSdi2dayaaja accaWdbiab=vSixlaadIfapaWaaSbaaWqaa8qacaWGQbaapaqabaaa aaaa@41C5@ s j = argmax s S l t ( s ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamOAaaWdaeqaaOWdbiabg2da98aa daWfqaqaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyyaiaabIhaaS WdaeaapeGaam4CaiabgIGiolaadofapaWaa0baaWqaa8qacaWGSbaa paqaa8qacaWG0baaaaWcpaqabaGcpeWaaeWaa8aabaWdbiaadohaai aawIcacaGLPaaaaaa@46EE@
2 s i argmin s S l t ( s ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamyAaaWdaeqaaOWdbiabgwMiZ+aa daWfqaqaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyyaiaabIhaaS WdaeaapeGaam4CaiabgIGiolaadofapaWaa0baaWqaa8qacaWGSbaa paqaa8qacaWG0baaaaWcpaqabaGcpeWaaeWaa8aabaWdbiaadohaai aawIcacaGLPaaaaaa@47AD@ The missing plan has a download speed that is lower than or equal to the download speed of any plan offered in period t, the period for which the plan is missing A i t = p j t e β ^ X j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaakiab g2da9maalaaapaqaa8qacaWGWbWdamaaDaaaleaapeGaamOAaaWdae aapeGaamiDaaaaaOWdaeaapeGaamyza8aadaahaaWcbeqaa8qacuaH YoGypaGbaKaaiiaapeGae8xXICTaamiwa8aadaWgaaadbaWdbiaadQ gaa8aabeaaaaaaaaaa@4448@ = p j t e β ^ X j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacqGH9aqpcaWGWbWdamaaDaaaleaapeGaamOAaaWdaeaapeGaamiD aaaakiaadwgapaWaaWbaaSqabeaapeGaeyOeI0IafqOSdi2dayaaja accaWdbiab=vSixlaadIfapaWaaSbaaWqaa8qacaWGQbaapaqabaaa aaaa@41C5@ s j = argmax s S l t ( s ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamOAaaWdaeqaaOWdbiabg2da98aa daWfqaqaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyyaiaabIhaaS WdaeaapeGaam4CaiabgIGiolaadofapaWaa0baaWqaa8qacaWGSbaa paqaa8qacaWG0baaaaWcpaqabaGcpeWaaeWaa8aabaWdbiaadohaai aawIcacaGLPaaaaaa@46EE@
3 s i = s j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamyAaaWdaeqaaOWdbiabg2da9iaa dohapaWaaSbaaSqaa8qacaWGQbaapaqabaaaaa@3AA7@ The missing plan has a download speed that is exactly equal to the download speed of a plan offered in period t, the period for which the plan is missing A i t = p j t e β ^ X j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaakiab g2da9maalaaapaqaa8qacaWGWbWdamaaDaaaleaapeGaamOAaaWdae aapeGaamiDaaaaaOWdaeaapeGaamyza8aadaahaaWcbeqaa8qacuaH YoGypaGbaKaaiiaapeGae8xXICTaamiwa8aadaWgaaadbaWdbiaadQ gaa8aabeaaaaaaaaaa@4448@ = p j t e β ^ X j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacqGH9aqpcaWGWbWdamaaDaaaleaapeGaamOAaaWdaeaapeGaamiD aaaakiaadwgapaWaaWbaaSqabeaapeGaeyOeI0IafqOSdi2dayaaja accaWdbiab=vSixlaadIfapaWaaSbaaWqaa8qacaWGQbaapaqabaaa aaaa@41C5@ s j S l t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamOAaaWdaeqaaOWdbiabgIGiolaa dofapaWaa0baaSqaa8qacaWGSbaapaqaa8qacaWG0baaaaaa@3C12@
4 Else
There are two plans offered in period t with download speeds that bound the download speed of the missing plan
A i t = ( p k t e β ^ X k ) 0.5 × ( p j t e β ^ X j ) 0.5 MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGbbWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaaaakiab g2da9maabmaapaqaa8qadaWcaaWdaeaapeGaamiCa8aadaqhaaWcba WdbiaadUgaa8aabaWdbiaadshaaaaak8aabaWdbiaadwgapaWaaWba aSqabeaapeGafqOSdi2dayaajaaccaWdbiab=vSixlaadIfapaWaaS baaWqaa8qacaWGRbaapaqabaaaaaaaaOWdbiaawIcacaGLPaaapaWa aWbaaSqabeaapeGaaGimaiaac6cacaaI1aaaaOGaey41aq7aaeWaa8 aabaWdbmaalaaapaqaa8qacaWGWbWdamaaDaaaleaapeGaamOAaaWd aeaapeGaamiDaaaaaOWdaeaapeGaamyza8aadaahaaWcbeqaa8qacu aHYoGypaGbaKaapeGae8xXICTaamiwa8aadaWgaaadbaWdbiaadQga a8aabeaaaaaaaaGcpeGaayjkaiaawMcaa8aadaahaaWcbeqaa8qaca aIWaGaaiOlaiaaiwdaaaaaaa@59ED@ s k > s i > s j MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaam4AaaWdaeqaaOWdbiabg6da+iaa dohapaWaaSbaaSqaa8qacaWGPbaapaqabaGcpeGaeyOpa4Jaam4Ca8 aadaWgaaWcbaWdbiaadQgaa8aabeaaaaa@3E0D@
s k = argmin s S l t ( s s i ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaam4AaaWdaeqaaOWdbiabg2da98aa daWfqaqaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyAaiaab6gaaS WdaeaapeGaam4CaiabgIGiolaadofapaWaa0baaWqaa8qacaWGSbaa paqaa8qacaWG0baaaaWcpaqabaGcpeWaaeWaa8aabaWdbiaadohacq GHsislcaWGZbWdamaaBaaaleaapeGaamyAaaWdaeqaaaGcpeGaayjk aiaawMcaaaaa@4A34@
s j = argmax s S l t ( s i s ) MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWGZbWdamaaBaaaleaapeGaamOAaaWdaeqaaOWdbiabg2da98aa daWfqaqaa8qacaqGHbGaaeOCaiaabEgacaqGTbGaaeyyaiaabIhaaS WdaeaapeGaam4CaiabgIGiolaadofapaWaa0baaWqaa8qacaWGSbaa paqaa8qacaWG0baaaaWcpaqabaGcpeWaaeWaa8aabaWdbiaadohapa WaaSbaaSqaa8qacaWGPbaapaqabaGcpeGaeyOeI0Iaam4CaaGaayjk aiaawMcaaaaa@4A35@
Table 2
Case #1 - Entry
Table summary
This table displays the results of Case #1 - Entry. The information is grouped by Period (appearing as row headers), Download Speed, Upload Speed, Cap, Actual Price, equation, Calculation, Adjusted Price, Missing Period and Relative (appearing as column headers).
Period Download Speed Upload Speed Cap Actual Price e ln p ^ MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFLbWdamaaCaaaleqabaWaaecaaeaapeGaciiBaiaac6ga caWFWbaapaGaayPadaaaaaaa@39EA@ A t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFbbWdamaaCaaaleqabaWdbiaa=rhaaaaaaa@3715@ Calculation Adjusted Price Missing Period Relative
T 40 4 250 $99.95 $76.11 99.95/76.11
=
1.3132
1.3132
X
86.46
$113.54 T 107.95/113.54
=
0.9508
T+1
Entry
80 8 250 $107.95 $86.46
Table 3
Case #2 - Exit
Table summary
This table displays the results of Case #2 - Exit. The information is grouped by Period (appearing as row headers), Download Speed, Upload Speed, Cap, Actual Price, equation, Calculation, Adjusted Price, Missing Period and Relative (appearing as column headers).
Period Download Speed Upload Speed Cap Actual Price e ln p ^ MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFLbWdamaaCaaaleqabaWaaecaaeaapeGaciiBaiaac6ga caWFWbaapaGaayPadaaaaaaa@39EA@ A t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFbbWdamaaCaaaleqabaWdbiaa=rhaaaaaaa@3715@ Calculation Adjusted Price Missing Period Relative
T
Exit
6 1 100 $55.00 $48.84 60.00/59.24
=
1.0128
48.84
X
1.0128
$49.47 T+1 49.47/55.00
=
0.8995
T+1 15 1 150 $60.00 $59.25
Table 4
Case #3 - Entry
Table summary
This table displays the results of Case #3 - Entry. The information is grouped by Period (appearing as row headers), Download Speed, Upload Speed, Cap, Actual Price, equation, Calculation, Adjusted Price, Missing Period and Relative (appearing as column headers).
Period Download Speed Upload Speed Cap Actual Price e ln p ^ MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFLbWdamaaCaaaleqabaWaaecaaeaapeGaciiBaiaac6ga caWFWbaapaGaayPadaaaaaaa@39EA@ A t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFbbWdamaaCaaaleqabaWdbiaa=rhaaaaaaa@3715@ Calculation Adjusted Price Missing Period Relative
T 5 1 20 $46.95 $39.92 46.95/39.92
=
1.1761
1.1761
X
43.23
$49.67 T 46.95/49.67
=
0.9452
T+1
Entry
5 1 40 $46.95 $43.23
Table 5
Case #4 - Exit
Table summary
This table displays the results of Case #4 - Exit. The information is grouped by Period (appearing as row headers), Download Speed, Upload Speed, Cap, Actual Price, equation, Calculation, Adjusted Price, Missing Period and Relative (appearing as column headers).
Period Download Speed Upload Speed Cap Actual Price e ln p ^ MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFLbWdamaaCaaaleqabaWaaecaaeaapeGaciiBaiaac6ga caWFWbaapaGaayPadaaaaaaa@39EA@ A t MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaacbmaeaaaaaa aaa8qacaWFbbWdamaaCaaaleqabaWdbiaa=rhaaaaaaa@3715@ Calculation Adjusted Price Missing Period Relative
T
Exit
35 3 120 $67.99 $67.78 (69.99/75.65)0.5
x
(61.99/62.91)0.5
=
0.9548
67.78
x
0.9548
$64.72 T+1 64.72/67.99
=
0.9519
T+1 60 10 120 $69.99 $75.65
T+1 30 5 70 $61.99 $62.91

6. Aggregation

Provincial and territorial elementary price indexes are calculated in a two-stage fashion. In the first stage, plan level price relatives are aggregated to produce ISP level price movements. The price movements of all plans, whether continuing, entering or exiting, are included in the calculation, after applying the hedonic adjustment procedure described in Section 5. These price movements are weighted with an average of the estimated weight vectors v t MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbbjxAHX garmWu51MyVXgaruWqHXwAIjxAaebbnrfifHhDYfgasaacH8qrps0l bba9q8WrFD0xHaVhbbf9v8qqaqFr0xc9pk0xbba9q8WqFfea0=yr0R Yxir=Jbba9q8aq0=yq=He9q8qqQ8frFve9Fve9Ff0dmeGabaqaaiaa caGaaeqabaWaamaaeaaakeaaqaaaaaaaaaWdbmaavacabeWcbeqaai aadshaa0qaaiaadAhaaaaaaa@3318@ and v t1 MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbbjxAHX garmWu51MyVXgaruWqHXwAIjxAaebbnrfifHhDYfgasaacH8qrps0l bba9q8WrFD0xHaVhbbf9v8qqaqFr0xc9pk0xbba9q8WqFfea0=yr0R Yxir=Jbba9q8aq0=yq=He9q8qqQ8frFve9Fve9Ff0dmeGabaqaaiaa caGaaeqabaWaamaaeaaakeaaqaaaaaaaaaWdbmaavacabeWcbeqaai aadshacqGHsislcaaIXaaaneaacaWG2baaaaaa@34C0@ , from equation (2) in Section 4. If a plan is not available in certain period due to entering or exiting the sample, it receives a weight of zero in that period. For example, if plan i has entered the sample in period t, then v i t1 MathType@MTEF@5@5@+= feaagKart1ev2aaatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qacaWG2bWdamaaDaaaleaapeGaamyAaaWdaeaapeGaamiDaiabgkHi Tiaaigdaaaaaaa@39FA@  will equal zero. This aggregation to the ISP level movement resembles a chained Tornquist-Thiel index. The following equations show the calculation of price change for ISP l:

( 9 )    I l t1:t = i ( p il t p il t1 ) v il t1 + v il t 2 MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcqaaaaaaaaaWdbe aacaWGjbWdamaaDaaaleaapeGaamiBaaWdaeaapeGaamiDaiabgkHi TiaaigdacaGG6aGaamiDaaaakiabg2da9maawafabeWcpaqaa8qaca WGPbaabeqdpaqaa8qacqGHpis1aaGcdaqadaWdaeaapeWaaSaaa8aa baWdbiaadchapaWaa0baaSqaa8qacaWGPbGaamiBaaWdaeaapeGaam iDaaaaaOWdaeaapeGaamiCa8aadaqhaaWcbaWdbiaadMgacaWGSbaa paqaa8qacaWG0bGaeyOeI0IaaGymaaaaaaaakiaawIcacaGLPaaapa WaaWbaaSqabeaapeWaaSaaa8aabaWdbiaadAhapaWaa0baaWqaa8qa caWGPbGaamiBaaWdaeaapeGaamiDaiabgkHiTiaaigdaaaWccqGHRa WkcaWG2bWdamaaDaaameaapeGaamyAaiaadYgaa8aabaWdbiaadsha aaaal8aabaWdbiaaikdaaaaaaaaa@587D@

Where:

i v il t1 =1;  i v il t =1 MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaGfqbqabSWdaeaapeGaamyAaaqab0WdaeaapeGaeyyeIuoaaOGa amODa8aadaqhaaWcbaWdbiaadMgacaWGSbaapaqaa8qacaWG0bGaey OeI0IaaGymaaaakiabg2da9iaaigdacaGG7aGaaiiOamaawafabeWc paqaa8qacaWGPbaabeqdpaqaa8qacqGHris5aaGccaWG2bWdamaaDa aaleaapeGaamyAaiaadYgaa8aabaWdbiaadshaaaGccqGH9aqpcaaI Xaaaaa@4B65@

In the second stage, provincial and territorial elementary price indexes are calculated as the weighted geometric mean of the ISP specific price movements. The weight vector, w, contains the per ISP shares of residential internet access revenues from the most recent Annual Survey of Telecommunications. As described in Section 2, these weights are updated on an annual basis. Aggregation of price movements using a geometric mean with fixed weights is generally known as the geometric Young (ILO et al., 2004). The following equations show the calculation of price change for a given province.

( 10 )   I t1:t = l ( I l t1:t ) w l MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaqadaWdaeaapeGaaGymaiaaicdaaiaawIcacaGLPaaacaGGGcGa aiiOaiaadMeapaWaaWbaaSqabeaapeGaamiDaiabgkHiTiaaigdaca GG6aGaamiDaaaakiabg2da9maawafabeWcpaqaa8qacaWGSbaabeqd paqaa8qacqGHpis1aaGcdaqadaWdaeaapeGaamysa8aadaqhaaWcba WdbiaadYgaa8aabaWdbiaadshacqGHsislcaaIXaGaaiOoaiaadsha aaaakiaawIcacaGLPaaapaWaaWbaaSqabeaapeGaam4Da8aadaWgaa adbaWdbiaadYgaa8aabeaaaaaaaa@4F07@

Where:

l w l =1 MathType@MTEF@5@5@+= feaagKart1ev2aqatCvAUfeBSjuyZL2yd9gzLbvyNv2CaerbuLwBLn hiov2DGi1BTfMBaeXatLxBI9gBaerbd9wDYLwzYbItLDharqqtubsr 4rNCHbGeaGqiFu0Jc9qqqrpepC0xbbL8F4rqqrFfFv0dg9Wqpe0dar pepeuf0xe9q8qiYRWFGCk9vi=dbvc9s8vr0db9Ff0dbbG8Fq0Jfr=x fr=xfbpdbaqaaeGaciGaaiaabeqaamaabaabaaGcbaaeaaaaaaaaa8 qadaGfqbqabSWdaeaapeGaamiBaaqab0WdaeaapeGaeyyeIuoaaOGa am4Da8aadaWgaaWcbaWdbiaadYgaa8aabeaak8qacqGH9aqpcaaIXa aaaa@3C8C@

7. Conclusion

This paper has covered the methods adopted in the calculation of the Internet access services component of the Canadian CPI. Hedonic adjustment of entering and exiting plans as well as estimation of plan level weights are key features of the adopted methodology. Statistics Canada is continually engaged in efforts to improve the Consumer Price Index program. Access to timely administrative data directly from telecommunications companies could greatly benefit the Internet access services index.

8. Additional Information

More information about the concepts and use of the Consumer Price Index (CPI) is available in The Canadian Consumer Price Index Reference Paper (Catalogue number 62-553-X).

Two videos, "An Overview of Canada's Consumer Price Index (CPI)" and "The Consumer Price Index and Your Experience of Price Change," are available on Statistics Canada's YouTube channel.

Contact information

For more information, or to enquire about the concepts or methods, contact us (toll-free 1-800-263-1136514-283-8300STATCAN.infostats-infostats.STATCAN@canada.ca)

References

Analoui, F., & Kharmai, A. (2003). Strategic management in small and medium enterprises. Cengage Learning EMEA.

Ariely, D., Loewenstein, G., & Prelec, D. (2003). “Coherent arbitrariness”: Stable demand curves without stable preferences. The Quarterly Journal of Economics118(1), 73-106.

Canadian Radio-Television and Telecommunications Commission. (n.d.). Internet - Our Role: Retrieved from https://crtc.gc.ca/eng/internet/role.htm.

Canadian Radio-Television and Telecommunications Commission. (2017a). 2017 Communications Monitoring Report: Retrieved from https://crtc.gc.ca/eng/publications/reports/policymonitoring/2017/index.htm.

Canadian Radio-Television and Telecommunications Commission. (2017b). Telecom Regulatory Policy CRTC 2017-104: Retrieved from https://crtc.gc.ca/eng/archive/2017/2017-104.htm.

Krishna, A., Wagner, M., Yoon, C., & Adaval, R. (2006). Effects of Extreme‐Priced Products on Consumer Reservation Prices. Journal of Consumer Psychology16(2), 176-190.

OECD/Eurostat. (2014). Eurostat-OECD Methodological Guide for Developing Producer Price Indices for Services: Second Edition: OECD Publishing.

Silver, M., & Heravi, S. (2002). Why the CPI matched models method may fail us: results from an hedonic and matched experiment using scanner data." European Central Bank (ECB) Working Paper 144.

Silver, M., & Heravi, S. (2005). A failure in the measurement of inflation: Results from a hedonic and matched experiment using scanner data. Journal of Business & Economic Statistics23(3), 269-281.

Statistics Canada. (n.d). A Revision of the Methodology of the Internet Access Services Component of the Consumer Price Index beginning with the March 2008 CPI. Retrieved from http://www23.statcan.gc.ca/imdb-bmdi/document/2301_D40_T9_V1-eng.pdf

Statistics Canada. (2015a). The Canadian Consumer Price Index Reference Paper: Catalogue No. 62-553-X.

Statistics Canada. (2015b, November 18). Consumer Price Index, November 2015. Retrieved from https://www.statcan.gc.ca/daily-quotidien/151218/dq151218b-eng.htm
Sugden, R., Zheng, J., & Zizzo, D.J. (2013). Not all anchors are created equal. Journal of Economic Psychology, 39, 21-31.

Triplett, J. (2004). Handbook on Hedonic Indexes and Quality Adjustments in Price Indexes: Special Application to Information Technology Products: OECD Publishing.

Note


Date modified: