Course Work
Question 1: We would have the work on the data set phones.sav. Therefore, we hoped to glance at the information of the data at initial. After the reading, the data set consisted of the following 12 variables that all relates to the year 2010. They were shown in the variable name and the description in the below Table 1.001.
Table 1.001. The data set of phones.sav for year 2010
Variable name cell_subs fixed_line_subs GDP_percap pop_total pop_15_24 pop_15-59 pop_60plus area urbfrac comped tert_enrol tert_femfrac Description the number of cellular phone subscriptions the number of fixed-line telephone subscriptions the GDP per capita in US$ the total population (1000s) the population aged 15 to 24 (1000s) the population aged 15 to 59 (1000s) the population aged 60 and over (1000s) the total area of the country (in km ) the urban population as a fraction of the total the number of years of compulsory education the number of students in tertiary education the fraction of female students in tertiary education
2
From the above Table 1.001, we could define that pop_total, pop_15_24, pop_15-59 pop_60plus and urbfrac were related to population variables. On behalf of the education comped, tert_enrol and tert_femfrac meant the number of years of compulsory education, the total number of students as well as the fraction of female students in tertiary education respectively. The area merely defined as the total area of the country. The GDP_percap meant each people earned in the 2010. The fixed_line_subs was the variable related to the number of fixed-line telephone subscriptions. The cell_subs will be become the dependent variable for the forecast in the regression model. Then, we could look them at the variable View in the SPSS. At that time, we could find the column Missing and enter the Discrete missing values to be 0. After then, we turned back to the data view. We could find that there were 196 cases in this data file. Moreover, we knew that their sequences of
Table 1.001. The data set of phones.sav for year 2010
Variable name cell_subs fixed_line_subs GDP_percap pop_total pop_15_24 pop_15-59 pop_60plus area urbfrac comped tert_enrol tert_femfrac Description the number of cellular phone subscriptions the number of fixed-line telephone subscriptions the GDP per capita in US$ the total population (1000s) the population aged 15 to 24 (1000s) the population aged 15 to 59 (1000s) the population aged 60 and over (1000s) the total area of the country (in km ) the urban population as a fraction of the total the number of years of compulsory education the number of students in tertiary education the fraction of female students in tertiary education
2
From the above Table 1.001, we could define that pop_total, pop_15_24, pop_15-59 pop_60plus and urbfrac were related to population variables. On behalf of the education comped, tert_enrol and tert_femfrac meant the number of years of compulsory education, the total number of students as well as the fraction of female students in tertiary education respectively. The area merely defined as the total area of the country. The GDP_percap meant each people earned in the 2010. The fixed_line_subs was the variable related to the number of fixed-line telephone subscriptions. The cell_subs will be become the dependent variable for the forecast in the regression model. Then, we could look them at the variable View in the SPSS. At that time, we could find the column Missing and enter the Discrete missing values to be 0. After then, we turned back to the data view. We could find that there were 196 cases in this data file. Moreover, we knew that their sequences of