# Question: The file P11 62 xlsx has somewhat old data on several countries

The file P11_62.xlsx has (somewhat old) data on several countries. The variables are listed here.

• Country: name of country

• GNPCapita: GNP per capita

• PopGrowth: average annual percentage change in population, 1980–1990

• Calorie: daily per capita calorie content of food used for domestic consumption

• LifeExp: average life expectancy of newborn given current mortality conditions

• Fertility: births per woman given current fertility rates

With data such as these, cause and effect are difficult to determine. For example, does low LifeExp cause GNPCapita to be low, or vice versa? Therefore, the purpose of this problem is to experiment with the following sets of dependent and explanatory variables. In each case, look at scatterplots (and use economic reasoning) to find and estimate the best form of the equation, using only linear and logarithmic variables. Then interpret precisely what each equation is saying.

a. Dependent: LifeExp; Explanatories: Calorie, Fertility

b. Dependent: LifeExp; Explanatories: GNPCapita, PopGrowth

c. Dependent: GNPCapita; Explanatories: PopGrowth, Calorie, Fertility

• Country: name of country

• GNPCapita: GNP per capita

• PopGrowth: average annual percentage change in population, 1980–1990

• Calorie: daily per capita calorie content of food used for domestic consumption

• LifeExp: average life expectancy of newborn given current mortality conditions

• Fertility: births per woman given current fertility rates

With data such as these, cause and effect are difficult to determine. For example, does low LifeExp cause GNPCapita to be low, or vice versa? Therefore, the purpose of this problem is to experiment with the following sets of dependent and explanatory variables. In each case, look at scatterplots (and use economic reasoning) to find and estimate the best form of the equation, using only linear and logarithmic variables. Then interpret precisely what each equation is saying.

a. Dependent: LifeExp; Explanatories: Calorie, Fertility

b. Dependent: LifeExp; Explanatories: GNPCapita, PopGrowth

c. Dependent: GNPCapita; Explanatories: PopGrowth, Calorie, Fertility

**View Solution:**## Answer to relevant Questions

Suppose that an economist has been able to gather data on the relationship between demand and price for a particular product. After analyzing scatter plots and using economic theory, the economist decides to estimate an ...Danielson Electronics manufactures color television sets for sale in a highly competitive marketplace. Recently Ron Thomas, the marketing manager of Danielson Electronics, has been complaining that the company is losing ...The file P03_65.xlsx contains basketball data on all NBA teams for five seasons. The SRS (simple rating system) variable is a measure of how good a team is in any given year. a. Given the explanation of SRS, it makes sense ...The quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank are recorded in the file P12_04.xlsx. Perform a runs test and find a few autocorrelations to determine whether this ...The file P12_13.xlsx contains quarterly data on GDP. a. Look at a time series plot of GDP. Does it suggest a linear relationship; an exponential relationship?b. Use regression to estimate a linear relationship between GDP ...Post your question