Construct the tables of descriptive statistics

Assignment Help Basic Statistics
Reference no: EM131299749

Research Methods Assignment

You are a researcher working for the Finance Ministry of a developing country. Your boss, the Minister of Finance has been asked to make recommendations to a government committee that has been charged with formulating a medium-term strategy for raising the country's Gross Domestic Product (GDP) per capita over the period 2016 to 2026.

Special funding has been earmarked by the government for policy measures to support this strategy. At its previous meeting, the committee decided that this funding should be devoted to a policy measure that will produce an immediate increase the country's rate of enrolment in secondary education. It is estimated that if this proposal is implemented, the secondary school enrolment rate (expressed as a percentage of the secondary school age population) will increase immediately by about 10%, from the current figure of 35% to an estimated 45%.

Since the previous meeting of the committee, however, the country has experienced a financial crisis. Senior representatives from the banks have been lobbying furiously for financial support to enable the banks to continue lending, in an attempt to avert a full-scale economic recession. They have argued that by providing emergency financial support now, the government can prevent the banks from shrinking their balance sheets; and maintaining a strong and vibrant banking sector is essential if the country is to achieve the targeted growth in its GDP per capita over the medium term. Emergency financial support would prevent a squeeze on bank lending which, in the absence of support, would reduce the ratio of private credit by deposit money banks and other financial institutions to GDP from the current figure of 0.3, to an estimated figure of 0.2.

You have been asked by the Minister of Finance to investigate the empirical evidence as to whether the funding would be spent more effectively on boosting secondary school education, or on bailing out the banking sector. You can recall an empirical model that addresses exactly this type of question, which was presented in a series of tutorials/workshops in which you participated during your time as a masters student at the University. You are concerned, however, that the data that were used in this exercise are out-of-date, and you have decided that it would be a good idea to update the data and re-estimate the model accordingly.

In order to complete this task, you have been assigned the following electronic resources:

1. A link to the University of Groningen Growth and Development Centre website, from which you can download 'Penn tables' data on the following variables:

Population (in millions)

Expenditure-side real GDP at current PPPs (in mil. 2011US$)

https://www.rug.nl/ggdc/productivity/pwt/

2. An Excel file indicators.xlsx, in which can be found data for 75 countries on the other variables to be used in the model (see below).

You intend to estimate the model using data for these 75 countries, which are listed below, under the continents/regions by which they are classified in the Penn tables:

Africa:

Benin, Botswana, Chad, Ethiopa, Ghana, Guinea-Bissau, Kenya, Lesotho, Malawi, Mauritius, Mozambique, Namibia, Seychelles, South Africa, Swaziland, Togo, Uganda, Zimbabwe

Asia:

Bahrain, Bangladesh, Bhutan, Cambodia, Georgia, Israel, Jordan, Kazakhstan, Kuwait, Laos, Malaysia, Maldives, Oman, South Korea (also known as Korea Republic), Syria, Turkey

Europe:

Albania, Bulgaria, Croatia, Cyprus, Denmark, Estonia, Finland, France, Greece, Hungary, Iceland, Ireland, Italy, Lithuania, Luxembourg, Malta, Moldova, Norway, Poland, Portugal, Slovenia, Spain, Sweden, Switzerland, United Kingdom

North America and Caribbean:

Aruba, Barbados, Belize, Dominica, Dominican Republic, Guatemala, Jamaica, Mexico, Panama, St Lucia, St Vincent and the Grenadines, United States

South America:

Argentina, Ecuador, Peru, Venezuela

The specification of the empirical model is as follows:

dlypci = β1 + β2lypc00i + β3lsecedi + β4govgdpi + β5openi+ β6crediti + ui

where:

ypc00 = expenditure-side real GDP per capita at current PPPs in 2000 (US$, 2011 prices)

ypc10 = expenditure-side real GDP per capita at current PPPs in 2010 (US$, 2011 prices)

dlypc = ln(ypc10) - ln(ypc00)

lypc00 = ln(ypc00)

seced = percentage of secondary school-age population enrolled at secondary school in 2000

lseced = ln(seced)

govgdp = share of government consumption in GDP in 2000

open = openness = share of (exports+imports) in GDP in 2000

credit = ratio of private credit by deposit money banks and other financial institutions to GDP in 2000

In 2016, your country's data are as follows: GDP per capita (in 2011 US$) = 2450, share of (exports+imports) in GDP = 0.3, share of government consumption in GDP = 0.18, percentage of secondary school age population enrolled at secondary school = 35%, ratio of private credit by deposit money banks and other financial institutions to GDP = 0.3.

 Your tasks are as follows:

1. Using the electronic resources, compile the required data for the 75 countries in an Excel spreadsheet (each row should represent a country and each column should contain the data for one variable).

2. Read the compiled data into Stata, and construct the tables of descriptive statistics that are shown below.

Table 1: Sample summary statistics for all countries

 

Mean

Standard deviation

Minimum

value

Maximum

Value

dlypc

 

 

 

 

ypc00

 

 

 

 

open

 

 

 

 

govgdp

 

 

 

 

seced

 

 

 

 

credit

 

 

 

 

Table 2: Sample means by continent/region

 

Africa

Asia

Europe

N America & Caribbean

S America

All countries

dlypc

 

 

 

 

 

 

ypc00

 

 

 

 

 

 

open

 

 

 

 

 

 

govgdp

 

 

 

 

 

 

seced

 

 

 

 

 

 

credit

 

 

 

 

 

 

Table 3: Sample correlation coefficients for all countries

 

dlypc

ypc00

open

govgdp

seced

credit

ypc00

 

-

-

-

-

-

open

 

 

-

-

-

-

govgdp

 

 

 

-

-

-

seced

 

 

 

 

-

-

credit

 

 

 

 

 

-

Provide a brief interpretation/commentary (a few sentences) on these summary statistics.

(Hint: For Table 2, use the Data Editor to create a new variable that codes each country according to continent/region. Then use the summarize command to generate summary statistics for countries within each continent/region).

3. Estimate the empirical model. Test the following null and alternative hypotheses using a significance level of 0.05:

(i) H02= β3= β4= β5= β6=0 against H1: βj≠0 for at least one j ∈ (2...6).

(ii) H0: β2=0 against H0: β2≠0.

(iii) H0: β3=0 against H0: β3>0.

(iv) H0: β6=0 against H0: β6≠0.

Provide a brief interpretation/commentary (a couple of sentences each) on the results of these hypothesis tests.

4. You are aware that estimation results for any regression model are sensitive to the presence of 'outlier' observations. You are aware that a rule-of-thumb remedy for an outlier problem is to create a 0-1 dummy variable for any 'outlier' observation with a residual larger than three times the standard error of the regression. Investigate whether there are any outlier observations in the data you have used to estimate your model. If there is an outlier observation, create a 0-1 dummy variable for this observation, and re-estimate the model.

(Hint: To set up a dummy variable, use the generate command to create a new variable equal to zero on all observations, then use the Data Editor to change the required observation from 0 to 1).

5. Assume that your country's growth in GDP per capita for the period 2016 to 2026 will be in line with the patterns suggested by your model for the period 2000 to 2010.

If the policy objective is to increase growth in GDP per capita over the period 2016 to 2026, formulate your advice to the Finance Minister on the question as to whether the special funding would be better spent on boosting enrolment in secondary education, or on bailing out the banking sector.

What is your estimated (logarithmic) rate of growth in GDP per capita for the period 2016 to 2026 if your policy recommendation is accepted?

(Hint: Compare the fitted values of the dependent variable obtained by substituting the values of the covariates into the fitted regression equation: firstly, if the special funding is used to boost enrolment in secondary education and the banking sector is permitted to reduce lending; and secondly, if the special funding is used instead to prevent any reduction in lending, and there is no boost to enrolment in secondary education).

Attachment:- Research Methods Assignment.rar

Reference no: EM131299749

Questions Cloud

How should estate plan documents be maintained : Durable Power of Attorney. What is a durable power of attorney for health care? Why is it needed even if you have a living will?
Calculate the contribution margins for the two companies : Calculate the contribution margins for the two companies.-  Calculate the break-even point for each firm, in dollars and in units.
Write the equations for the d-flipflop : Given the following sequence(0,10,11,6,1,3,14,5,13,12,2,9,8,7,15,4), write the equations for the D-Flipflop A, D-Flipflop B, D-Flipflop C, and D-Flipflop D. The states are designated as ABCD, where A is the most significant and D is the least sig..
Discuss the presenter’s ethics by not telling the full story : Discuss the presenter's ethics by not telling the full story. Keep in mind that what the presenter says is true, but does not reveal the whole truth.
Construct the tables of descriptive statistics : Using the electronic resources, compile the required data for the 75 countries in an Excel spreadsheet (each row should represent a country and each column should contain the data for one variable). Read the compiled data into Stata, and construct ..
What would be the impact on total fund balance : ACC 410 week 3 quiz 2 - Why would a government be more likely than a not-for-profit organization to integrate its budget into its accounting system and what would be the impact on total fund balance for Year 2?
Fran virtual fruit stand : Fran's Virtual Fruit Stand is an online store that sells several types of dried fruit. Based on the needs of Fran's Virtual Fruit stand, you must design a flowchart using Visual Logic. The flowchart must also be a fully functional program which fo..
What elements comprise their capital structure : Using the annual financial statements and other research, explain the stock structure of Ford Motors Company. What elements comprise their capital structure?
Optimize performance analyzing traffic : Most network IDS tools are designed to optimize performance analyzing traffic using a variety of protocols specific to TCP/IP wired networks. Describe at least two intrusion detection scenarios where specialized types of monitoring and analysis ar..

Reviews

len1299749

12/3/2016 6:53:06 AM

Need editable MS Word format. Need best quality as he would like to work with the same expert for all further assignments. You are required to submit a concise written report. Marks will be awarded for accuracy in the construction of the data set and in the conduct of the estimations and hypothesis tests, and for careful presentation of estimation and hypothesis test results using a format similar to what you will find in textbooks or journal articles. Stata output may be submitted as an appendix. Marks will be lost if you submit Stata output only, without bothering to write up the results in a suitable format. You are not required to submit your data, either in Excel or in Stata format. If you wish, you may work together with other students; but your final written submission must be prepared individually, and must be your own work.

Write a Review

Basic Statistics Questions & Answers

  Find probability to get red gumballs

Balls that have been thoroughly mixed. Sue and Jim, each, purchased one gumball. What is the likelihood both Sue and Jim get red gumballs?

  T-test for dependent samples

Big Time Software Co. has developed a new version of it XD-3 software. They want to determine if the new version of XD-3 is faster then the old version.

  It is reasonable to model the number of winter storms in a

it is reasonable to model the number of winter storms in a season as with a poisson random variable. suppose that in a

  Expected number of defective units produced

At a significance level of .05, the management wants to perform a hypothesis test to determine whether the quality of items produced appears to be independent of the production process used. Calculate the expected number of defective units produce..

  Compute time needed for five simulated maintenance checks

Using random numbers of 0.1567, 0.9823, 0.3419, 0.5572 and 0.7758, compute the time required for each of five simulated maintenance checks of the airplane's landing gear.

  Determining standard normal distribution probabilities

Carry your intermediate computations to at least four decimal places. Round your answer to at least two decimal places.

  Use the regression line above to estimate the net earnings

in a recent survey concerning company sales and net earnings 15 companies responded. data analysis was computed letting

  Amount of concentration in chemicals

Chandra has 5 liters of a 24% solution of sodium hydroxide in a container. What is the amount and concentration of sodium hydroxide solution she must add to this in order to end up with 8 liters of 27% solution?

  Find the number of customers

Find the number of customers n such that the probability that the orders of all n customers can be processed in less than 2.5 hours is approximately .025. Please help with this question.

  A certain drug causes kidney damage in 1 of the patients

a certain drug causes kidney damage in 1 of the patients. suppose that the drug is to be tested on n patients and let e

  State the appropriate null and alternative hypotheses in

reconsider the previous problem about the age of a college students mother when the student was born. now suppose you

  Fitting of simple linear regression equation

Fitting of simple linear regression equation - Given the student population for a school district over the past few years, find the prediction equation for this data.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd