Create a scatterplot with age on the horizontal axis

Assignment Help Macroeconomics
Reference no: EM13117147

Problem 1. The file the natural log of the average 1989 prices (logprice) of Bordeaux wines for the vintages 1952 to 1989. (vintage) . the age of each vintage is given by the variable age. These data were part of an analysis of Bordeaux wine by economists OrleyAshenfelter and David Ashmore of princeton university. On the computing of the data, some observations became Not available, NA. Clear those up by deleting them, but the couple that are in between observations, just do the average between the two adjacent observations.

a. create a scatterplot with age on the horizontal axis and the log of price on the vertical axis. Do older wines tend to sell for more than younger wines? Does an older wine always sell for more than a younger wine?

b estimate the relationship logprice = a +b(age)

c. estimate the relationship logprice = a + b(vintage) how does the estimated coefficient on vintage compare with the estimated coefficient of age. Why do the intercepts differ as they do?

d. tell me if the intercepts of each equation and estimates of the slopes are statistically significant. (you can use the rule of 2)

Problem 2. The file contain the natural log of the quantity of white zinfandale (LNQWZ) and the natural log of the own price of white zinfandale (LNPWZ) as well as the natural log of the price of other varieties of wines (LNPCH, LNPM, and LNPCS) It additionally includes a time variable called time, and the level data on quantity and prices which you wont be using this time.

a. copy the data from ch 5 data set into a new excel file that you create and run a regression of the data that has already been converted to logs for you in th form lnqwz = a + b*lnpwz + c*lnpch + d*lnpm +e*lnpcs+f*time+g*peak.

b. from the regression output, identify which of the explanatory variables are statistically significant. what does it mean for a variable to be statistically significant.

c. report the R-squared and provide me with the correct interpretation of this number. what information does it tell me?also report the adjusted R-squared of the regression. why is it necessary to report an adjusted R-quared?

d. from the regression output, tell me what the price elasticity of demand and cross price elasticities of demand are and interpret those numbers. that is, are the goods substitutes compliments and so on using what you learned in your previous lessons and keeping in mind the interpretation of the coefficients as per the discussion in the appendix. Don't forget to use the information about statistical significance from part b to conclude whether goods are related or not related.

f. Identify whether there is a trend that we can identify from the data regarding wine sales. hint, use the coefficient for the time variable to make your assessment. is this trend statistically significant?

Download:- Data file.rar

Reference no: EM13117147

Questions Cloud

What is your best option for increasing the rate of reaction : Consider a situation in which the enzyme is operating at optimum temperature and pH, and has been saturated with substrate. What is your best option for increasing the rate of the reaction?
Estimate standard deviation of the x distribution : Estimate the standard deviation of the x distribution. (Hint: Review the empirical rule and SD approximations). What is the probability that a healthy 10-week-old kitten will weigh less than 14 oz?
What is the concentration of hydroxide ions : At 25 c the ion product of water, Kw is 1.9 x 10^-14. What is the concentration of hydroxide ions in a solution where the concentration of hydrogen is found to be 5.0 x 10^-15 mol dm^-3.
Compose a business report : Compose a business report describing what the Federal Reserve Board does to combat inflation when the economy is bad. Include a table, chart, or graph.
Create a scatterplot with age on the horizontal axis : Create a scatterplot with age on the horizontal axis and the log of price on the vertical axis. Do older wines tend to sell for more than younger wines? Does an older wine always sell for more than a younger wine?
What is the concentration of ethylene glycol : Equal masses of water and ethylene glycol are mixed. What is the concentration of ethylene glycol in units of molality? The molar mass of water and ethylene glycol are 18.02 g/mol and 62.07 g/mol, respectively.
Foreign corporate tax rate : Suppose England raised its corporate tax rate by 1 percentage point from 40% to 41%. How would this increase affect the economics of a U.S.-U.K. foreign expansion project?
Probability three cars will arrive in ten -second period : An averageof 2 cars arrive at a highway tollgate every 10 seconds. If this rate is approximated by a Poisson process, what is the probability that exactly 3 cars will arrive in a 10-second period?
Benefits of international capital markets : What are some benefits of the international capital markets? does borrowing a portfolio of currencies offer any possible advantages over the borrowing of a single foreign currency?

Reviews

Write a Review

Macroeconomics Questions & Answers

  Discussion on merger consideration

With lower values for gasoline than a couple of years before will Americans start spending again? If they do, what will they spend the savings on Vacations?

  Current event article which relates to government

Associate a current event article which relates to government regulations or antitrust activities.

  Illustrate what is the elasticity of demand for the product

Illustrate what is the elasticity of demand for the product that is produced by the company.

  Elucidate the difference among a monopoly and an oligopoly

Elucidate the difference among a monopoly and an oligopoly, the welfare effects of monopoly, cost advantages that create monopolies, government actions that create monopolies, and government actions that reduce market power.

  Government needs to raise their revenue they usually decide

Explain why do you think that whenever the government needs to raise their revenue they usually decide to increase the tax on items such as gas

  Significance of time trend and seasonality

Additionally, several other configurations were also estimated. The results are shown on the following pages.  Based on this data, answer the following questions. Comment on the significance of time trend and seasonality.

  Describe the idea of trade offs cost also benefit analysis

Describe the idea of trade offs cost also benefit analysis when answering the above question.

  Assume both the spot rates unexpectedly shift downward

Assume both the spot rates unexpectedly shift downward by 1%. What is the price of a forward contract otherwise identical to yours.

  Calculation of average daily monthly balance

Assume that you never carry cash. Your paycheck of $1,000 per month is deposited directly into your checking account on the 1st day of the month,

  Effects on the demand curve

The demand for a shake at a Juice Shop can be described by the equation: Q=1000-240P+80N, where Q denotes the number of shakes sold every day,

  Utilize supply and demand analysis equilibrium price

Utilize supply and demand analysis to explain why the equilibrium price of apples will rise and the equilibrium quantity will fall if an excise tax is levied on apples.

  As a trader of a commercial bank explain how would

As a trader of a commercial bank explain how would I invest $1 million and earn risk free return by engaging in covered interest arbitage.

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