Porisma

Worked solution

Recover a missing price index and choose the prediction direction

The consumer price index measures average price changes in a fixed basket of consumption goods and services commonly purchased by resident households over time. It is commonly used as a measure of consumer price inflation. In the 2013 Singapore household expenditure survey, housing and food made up about half of the average monthly expenditure of an average household.

The table shows housing and food price indices from 2005 to 2012, with 2005 as the base period (index 100). For example, food index 104.6 in 2007 means average food prices increased by 4.6% from 2005 to 2007.

YearHousing price index xxFood price index yy
2005100100
2006100.7101.6
2007102.3104.6
2008116.8112.6
2009123.1115.2
2010124.3116.8
2011missing120.3
2012148123.1

(i) Show that the missing housing price index for 2011 is 136 (nearest integer), given the regression of yy on xx is y=54.271+0.48363xy=54.271+0.48363x, correct to 5 significant figures.

(ii) Draw the scatter diagram, labelling the axes clearly. Comment on the suitability of the linear model.

(iii) Estimate the housing price index in 2016 when the food price index is 134.6. Find an appropriate regression equation for yy and x\sqrt{x} and use it for the estimate. Explain why this estimate might not be reliable.

(iv) Find the product moment correlation coefficient between yy and x\sqrt{x}.

(v) It would be convenient to tabulate x/100x/100 and y/100y/100 instead. Without further calculations, explain whether the correlation between x/100\sqrt{x/100} and y/100y/100 differs from (iv).

[2017/MJC/II/9]

CJC · Discussion · Question 7

(i) Use the mean point, not the single missing observation

Answer

x2011=136x_{2011}=136 (nearest integer).

A regression line passes through (xˉ,yˉ)(\bar x,\bar y); it need not pass through every observation. The seven known housing indices sum to 815.2 and all eight food indices sum to 894.2. Write the missing housing value as hh. Then

894.28=54.271+0.48363815.2+h8.\begin{aligned}&\frac{894.2}{8}\\ & =54.271\\ &{}+0.48363\frac{815.2+h}{8}.\end{aligned}

Hence h=136.0065008…h=136.0065008\ldots, which rounds to 136. The supplied coefficients are rounded to five significant figures; this recovery is correspondingly approximate. Substituting only the 2011 food value into the line would incorrectly assume zero residual for that observation. Use the requested recovered integer for the remaining parts.

How did this part go?

(ii) Inspect the original price-index scatter

Answer

The original scatter is increasing but shows curvature; a straight line is only an approximation.

Plot housing index xx horizontally and food index yy vertically, retaining all eight pairs and using 136 for 2011. The gradient appears to decrease as housing index rises. This curved pattern makes a single linear model less suitable than the high positive association alone might suggest. The comparison diagram also shows the transformed variables used in (iii).

How did this part go?

(iii) Predict the housing index from food index

Answer

x=0.0896y+0.860\sqrt{x}=0.0896y+0.860; estimated housing index x=167x=167.

The known predictor is food index yy and the desired response is x\sqrt{x}. Fit x\sqrt{x} on yy, rather than algebraically reversing the regression of yy on x\sqrt{x}. Retaining full precision gives x=a+by\sqrt{x}=a+by, where

a=0.8599870849633415,b=0.08963124264600579.\begin{aligned}a&=0.8599870849633415,\\b&=0.08963124264600579.\end{aligned}

The printed rounded equation is x=0.0896y+0.860\sqrt{x}=0.0896y+0.860. Using the retained coefficients,

x=(a+134.6b)2=167.0388835…≈167.\begin{aligned}&x\\ & =(a+134.6b)^2\\ & =167.0388835\ldots\approx167.\end{aligned}

The input 134.6 exceeds the observed food-index range 100–123.1, so this is extrapolation. The observations cover 2005–2012, while the target is 2016; the relationship may change over time. The positive transformed relationship does not guarantee a reliable future prediction.

How did this part go?

(iv) Correlate food index with the square root of housing index

Answer

r=0.979r=0.979 (3 s.f.).

Keeping all eight pairings and the recovered 136 gives r=0.9788756402…r=0.9788756402\ldots, matching the printed key 0.979. This is correlation between yy and x\sqrt{x}, not between the original xx and yy.

How did this part go?

(v) Apply invariance under positive rescaling

Answer

The coefficient is unchanged: r=0.979r=0.979 to 3 s.f.

Since x>0x>0, x/100=x/10\sqrt{x/100}=\sqrt{x}/10. The new variables are therefore the old transformed variables multiplied by the positive constants 1/101/10 and 1/1001/100. Positive rescaling changes their units but leaves their correlation unchanged; no recalculation is needed.

How did this part go?

Compare your sketch

Expand diagram

Use the scrollbars or arrow keys to inspect details.

Eight housing/food index pairs, including the recovered 2011 housing index 136. First panel plots housing against food. Second plots food horizontally and square-root housing vertically with the appropriate regression for housing prediction. No additional observations are invented.
Eight housing/food index pairs, including the recovered 2011 housing index 136. First panel plots housing against food. Second plots food horizontally and square-root housing vertically with the appropriate regression for housing prediction. No additional observations are invented.
Eight housing/food index pairs, including the recovered 2011 housing index 136. First panel plots housing against food. Second plots food horizontally and square-root housing vertically with the appropriate regression for housing prediction. No additional observations are invented.

Solution notes

All five printed asks, eight years and paired indices, missing entry, five-significant-figure given regression and printed key retained. Missing index recovered from the mean point; complete working and two scatter panels authored. Prediction uses regression of square-root housing on food. No printed marks.