Studies have found a positive association between education and information technology and computer (ITC) skill. An Indonesian social researcher would like to investigate this relationship. She collects the following data from the website of Statistics Indonesia (www.bps.go.id). Education refers to the mean years of schooling of population aged 15 years and above in 2021 and ITC skill is the percentage of population aged 15-59 years with information technology and computer skill in 2021. In the excel file data_uas.xls, the TIK worksheet shows the data collected by the researcher.
a. Use Excel to estimate the model: ITC = Po + B₁Education + ε. Present the Excel output
b. Is the sign on the slope as expected? Explain.
c. Write down the estimated regression equation!
d. Suppose the mean years of schooling of population aged 15 years and above is 12.8 years. What is the expected percentage of population aged 15-59 years with information technology and computer skill?
