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

Country

Newspapers

Radios

TV sets

Literacy Rate

Malaysia

280

266

228

0.98

Singapore

142

230

201

0.93

Vietnam

10

114

2

0.25

Brunei

391

313

227

0.99

Thailand

86

329

82

0.79

Cambodia

17

42

11

0.72

Myanmar

21

49

16

0.32

Indonesia

314

1695

472

0.99

Philippines

333

430

185

0.99

Laos

91

182

89

0.82

  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 R2 gathered in (a).
  5. Based on your answer in (b), draw a conclusion on the linear relationship between literacy rate and the three factors.

Solved
STATISTICS 1 Answer chegg chegg