Literacy rate is a reflection of the educational facilities and quality of education available in...

Literacy rate is a reflection of the educational facilities and quality of education available in a country, and mass communication plays a large part in the educational process. In an effort to relate the literacy rate of a country to various mass communication factors, a researcher has proposed to relate literacy rate (y) to the following variables: number of daily newspaper copies (per 1000 population)(x)), number of radios (per 1000 population)(x2), and number of TV sets (per 1000 population)(x3). Table 3 shows the data for a sample of 10 countries. Table 3 Radios TV sets Country Malaysia Singapore Newspapers 280 Literacy Rate 0.98 266 228 142 230 201 0.93 Vietnam 10 114 2 0.25 Brunei 391 313 227 0.99 Thailand 86 329 82 0.79 17 42 11 0.72 Cambodia Myanmar 21 49 16 0.32 Indonesia 314 1695 472 0.99 333 430 185 0.99 Philippines Laos 91 182 89 0.82 a) Use Microsoft Excel to produce Analysis of Variance table for the multiple linear regression and state the model. b) At a = 0.05 test whether the model generated in (a) is fit or not. c) Calculate the 95% confidence interval for the coefficient value for newspapers. d) Interpret the value of R gathered in (a). e) Based on your answer in 6), draw a conclusion on the linear relationship between literacy rate and the three factors.