Calculate the pair-wise correlation coefficients between Exports and each of the other variables. Test the statistical significance of each correlation coefficient.

The relationship between firm exports, size, productivity and skill/capital intensity (Excel)

Maximum project length: 3,000 words

The relationship between firm exports, size, productivity and skill/capital intensity

Firm-level exports are potentially affected by a number of factors including the size of a firm, its productivity as well as the skill and capital intensity of its production technology.

The objective of this project is to establish whether size, productivity, skill intensity and capital intensity are determinants of firm exports in a cross-section of firms.

The data below contains information, covering a sample of 60 firms, on firm exports (Exports), a commonly used measure of firm size and in particular the number of employees of the firm (Empl), a measure of the productivity of the firm (Prod), as well as a measure of the skill intensity (Skill) and capital intensity (Capit) of the firm. Exports are measured in million pounds while productivity is measured as the ratio of the value of sales to the value of inputs used. Skill intensity is measured as the average number of years of schooling of the employees while capital intensity is measured as the ratio between the capital stock of a firm in million pounds and the number of employees.

Describe the data, using summary statistics and graphs, as appropriate.

Calculate the pair-wise correlation coefficients between Exports and each of the other variables. Test the statistical significance of each correlation coefficient.

Consider the two variables Skill and Capit. Compute the pairwise correlation of the two variables and test the significance of the correlation coefficient.

Consider again the two variables Skill and Capit and test the null hypothesis that the two variables have equal variance.