Calculate medal shares for total medals won

Assignment Help Microeconomics
Reference no: EM13183554

 Q1. Import the MS Excel "RESTAT Olympic Data" set and  produce the standard descriptive statistics for the dataset.

 Q2. The variable labels simply repeat the variable names.   Relabel the variables so it's clear what each represents.  Pay particular attention to the dummy variables.

  Q3. Calculate medal shares for total medals won, for each country,  by year. The medal share for country in a year is the proportion of the
  total number of medals awarded in that year's Olympics that is awarded to  the country. To calculate the medal shares, first use an egen function to  calculate the total number of medals won in each Olympic year. Then you can  generate the yearly medal shares for each country. Label the new variable  appropriately.

  Q4. Use the tabstat command to check that your calculation of the  new medal share variable is correct. Tabulate the the total medals won and  the medal share by year.  Include the the following statistics: the number of observations, the sum, the minimum, the maximum, and the mean.

    Q5. For the the new medal share variable, the sum of the country shares of medals won should be one for each year. State ithat this is true for your new share variable.  (This is the main check that you have defined the new variable properly.)


  Q6. In the 1960 Olympics, how many medals were awarded in total? What was the maximum number of medals won by any country? What was that country's share (proportion) of medals won?

  Q7. In the paper, the researchers indicate that GDP per capita is  a key explanatory variable for a country's performance in the Olympics.
  Create a new variable that shows GDP per capita for all observations, by  dividing gdp by population. Name and label this variable appropriately.

  Q8. Create a dummy variable for whether or not each country won  any medals at each Olympics. Do not include observations for which the
 country's medals won is missing. Name and label this variable appropriately.

  Q9. To check this calculation, calculate the standard summary  statistics for total medals won, by the categories of your new dummy variable. The calculation should confirm that for the zero category of the dummy variable,  no medals were won. Does it? What was the average number of medals won,  for those countries that won medals?

  Q10. Run a regression that estimates the probability that a country  won any medals.The dependent variable should be your dummy variable for whether a country  won any medals. The independent variables should include your gdp per capita variable and dummy variables for each Olympic year. To get these year dummies,create them using the i. prefix with the year variable.

  Q11. What percent of the variation in the dependent variable does the  regression explain?

  Q12. In the above regression, is the coefficient of the gdp per capita  variable statistically significant at the 5% level? Are the coefficients of
  any of the year dummy variables significantly different from zero?  If so, which ones? Explain all of this in terms of the t-statistics.

  Q13. Calculate the mean gdp per capita in 1996 (a standard summarize command will do this). You will use this calculation in the remainder of the  quiz.

  Q14. What is the estimated probability that a country with this gdp  per capita won a medal in 1996? You may calculate this "by hand" using
  the stata display command. In any case, show the calculation by using the  relevant coefficients of the regression equation and the relevant values of  the right hand side variables.

  Q15. Now run a similar regression with total medals won as the dependent variable and the same variables on the right hand side as in the

  model above.
  Q16. In the above regression, is the coefficient of the gdp per capita  variable significantly different from zero at the 5% level?
  Are the coefficients of any of the year dummy variables statistically  significantly different from zero? If so, which ones? Explain all this in
  terms of the p-values.

  Q17. What is the estimated number of medals that a country with the average gdp per capita estimated above would have won in 1996? You may  calculate this "by hand" using the Stata display command. In any case, show  the calculation by using the relevant coefficients of the regression equation  and the relevant values of the right-hand side variables.

  Q18. Now estimate the same regression as just above, but including only the countries that actually won medals in each year.

 

  Q19. In the above regression, is the coefficient of the gdp per capita variable statistically significant at the 5% level?
  Are the coefficients of any of the year dummy variables statistically significant? If so, which ones?

  Q20. What is the estimated number of medals that a country with the average gdp per capita estimated above won in 1996? You may calculate this  "by hand" using the stata display command. In any case, show the calculation  by using the relevant coefficients of the regression equation and the relevant  values of the right hand side variables.

  Q21. Compare the estimated number of medals won in this regression with the number estimated in the regression above (Q17).
  Does the answer make sense; why or why not?

Reference no: EM13183554

Questions Cloud

Compute the density of the water : The mass of the empty beaker was 27.430g. After the water was added, the beaker had a mass of 37.416g. Calculate the density of the water.
Calculate polks manufacturing cost per unit : Assuming the company uses variable costing, calculate Polk's manufacturing cost per unit for 2012 and the parts of this question must be completed in order. This part will be available when you complete the part above.
State the gas mixture produced by the decomposition : What volume of CO2 would be produced each day? Suppose the gas mixture produced by the decomposition is trapped in a container at 17 degree celcius
Compute the pressure of the gas mixture : Calculate the pressure of the gas mixture and the partial pressure of each constituent gas if the mixture is in a 11.0 L vessel at 27 degree celsius
Calculate medal shares for total medals won : Calculate medal shares for total medals won, for each country,  by year. The medal share for country in a year is the proportion of the   total number of medals awarded in that year's Olympics that is awarded to  the country. To calculate the me..
Carbon monoxide reacts completely with o : Carbon Monoxide at a pressure of 720 mmhg reacts completely with O2 at a pressure of 360 mmhg in a sealed vessel to produce
Explain the water layer into the octanol layer : The log P value for nicotine is 1.09. If 20 mL of 0.10 g/mL nicotine solution in water is extracted with 20 mL of octanol, how much nicotine is removed from the water layer into the octanol layer?
Record the treasury stock transactions in t accounts : What is the reasoning behind treating the purchase of treasury stock as a reduction in stockholders' equity as opposed to treating it as an investment asset?
Find out the composition of the fuel : a fuel oil is composed of C10H22 and C12H26 when the fuel oil ios burned with 20% excess air the ratio of water to CO2 is found to be 1.088.

Reviews

Write a Review

 

Microeconomics Questions & Answers

  Compare and contrast the ethos of foxconn

Employees at Foxconn factories described in the e-Activity worked more hours than allowed under Chinese labor laws. Yet the violation of these standards is widespread in manufacturing and the demanding treatment of workers is commonly accepted. Co..

  What advice do you give lindenwood valley

Lindenwood Valley believes the Massachusetts statute violates the U.S. Constitution by denying it due process of law. Lindenwood Valley also claims that the Massachusetts statute should be struck down because it violates the Commerce Clause. The..

  Analyse a range of current economic issues

Analyse a range of current economic issues and problems and develop and communicate economic arguments in a variety of forms.

  Game theory and rival strategies

Illustrate out the term game theory? describe it with the situation in which game theory is applicable, along with any description of the two rival's strategies.

  When the price discrimination occurs

Price discrimination occurs when a.the supply of the product is elastic b.a product's average cost is greater than its average revenue c.a product's average cost is less than its average revenue d.differences in a product's price reflect differences ..

  Define marketing strategy emphasizing mass media advertising

An order written by the exporter instructing the importer, or their agent, to pay a specified amount of money at a specified time is a:  Note Payable, Draft, Promissory Note, Check.

  Effect of events on market

What will be the effect of the following events on the market for French wine and the quantity consumed? Distinguish between the short-run and the long-run impact.

  Determining total cost problem-cost per unit

Company A plans to produce 300,000 units next year, the production budget is: Compute the total cost and cost per unit when the unit production is changed to 315,000 units.

  Find the cournot solution for the market price

Find the Cournot solution for the market price and output of mineral water and illustrate with a simple graph and the marginal revenue function facing a monopolist is given by: MR = 200-20Q Demonstrate that firms A and B have an incentive to coopera..

  Estimating optimal output and profit level

Assume that the technology of producing widgets is that every company entering the market has the same total cost curve, as follows; TC=1000+5Q+0.1Q^2

  Determine the market conditions

The production processes are interchangeable, and production can be adjusted depending on market conditions. The demand for both products is highly elastic in terms of price elasticity, and customers perceive the two products as close substitutes f..

  Find the equilibrium price and equilibrium quantity

Assume that the demand and supply curves for eggs for the United States are given through the following equations:

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