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)(x1), 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

1. Use Microsoft Excel to produce Analysis of Variance table for the multiple linear regression and state the model.
2. At a = 0. 05 test whether the model generated in (a) is fit or not.
3. Calculate the 95% confidence interval for the coefficient value for newspapers.
4. Interpret the value of R² gathered in (a).
5. Based on your answer in (b), draw a conclusion on the linear relationship between literacy rate and the three factors.