Question

In: Statistics and Probability

You are in charge of pricing for a California wine company. Because nearly 90% of U.S....

You are in charge of pricing for a California wine company. Because nearly 90% of U.S. wines are produced in California, you think that California wines might be perceived differently from those produced in other states, thus affecting the price. You decide to see how both wine rating and whether or not the wine is from California affect the pricing of wines in the U.S.

For this question, you will need to download the Wine Rating Data and then use the data analysis tool pack in Excel to run a regression. Note that for the dummy variable, you will need to use an IF command to make that column.

https://arizona.grtep.com/core/uploadfiles/components/287971/files/Wine%20Rating%20Data.xlsx (Wine Data)

Run a regression to estimate the following equation.

Price = β0+β1Rating + β2California + β3(Rating×California) + ε

“California” is a dummy variable that equals 1 if the wine is from California. Round your answers to 2 decimal places.

Priceˆ= ________ + ________ Rating− _______ California+ _______ Rating∗California

What was the reported R2 of the model? Round your answer to 4 decimal place.

What would be the difference in predicted price of two wines that both have a rating of 93, but one is produced in California and one is produced in Oregon? Round your answers to 2 decimal places.

Hint, it might be helpful to write out the equation for when the California dummy variable equals 0 and then for when it equals 1 like we did in class for other dummy variables.

The California wine is $_______ higher than the Oregon wine.

Based on the model you estimated, at what rating do California wines become more expensive than wines from other states? Round your answers to 2 decimal places.

Solutions

Expert Solution

Regression Model

Regression Equation

Price = -215.62 + 2.78 * Rating – 67.33 * California + 0.86 * Rating * California

R Square of the model is 0.2368 or 23.68% ie only 23.68% of the variation in the dependent variable can be explained by the independent variables.

Difference in Price = -67.33 * (1-0) + 0.86 * 93 * (1-0) = -67.33 + 0.86 * 93 = 12.65

The California wine is $12.65 higher than the Oregon wine.

For all ratings, California wines become more expensive than wines from other states


Related Solutions

You are the financial analyst fir the firm named Sixties Wine that distributes California wine in...
You are the financial analyst fir the firm named Sixties Wine that distributes California wine in Italy.Your firm routinely hedges its exposure to the EUR In the past, the firm has used long position in EUR put options to accomplish its hedging objectives. Due to a change in market liquidity conditions, the firm finds that it is no longer possible to use EUR put options. One your colleague recommends that the firm use short posiions in call options on the...
Suppose that the U.S. government decides to charge wine consumers a tax. Before the tax, 40,000...
Suppose that the U.S. government decides to charge wine consumers a tax. Before the tax, 40,000 bottles of wine were sold every week at a price of $4 per bottle. After the tax, 35,000 bottles of wine are sold every week; consumers pay $6 per bottle (including the tax), and producers receive $3 per bottle. 1. The amount of tax on a bottle of wine is $_______ per bottle. Of this amount, the burden that falls on the consumers is...
A California wine company is committed to selling €3,400,000 of inventory in December 2020 to a...
A California wine company is committed to selling €3,400,000 of inventory in December 2020 to a customer based in Amsterdam. The US Company wants to protect itself against a decline in profit that would result from foreign exchange. The current futures price is $1.1220, how would it hedge? Sketch out the cash flows of the hedged position (in US$) assuming the following scenarios. A. St = F0 B. St = F0 - $0.12 C. St = F0 + $0.12
Suppose you are a U.S. based company and exports goods from the United Kingdom. In 90...
Suppose you are a U.S. based company and exports goods from the United Kingdom. In 90 days, you expect to receive payment for a shipment of goods from the UK worth 100,000 British pounds (settlement). The US risk free discrete rate is 2.6% and the UK risk free discrete rate is 4.0%, and the current FX spot rate is $1.23 per pound. A. You expect the UK pound currency to decrease against the US dollar over next 90 days. Please...
You are in charge of pricing tickets for an upcoming event at the outdoor amphitheater where...
You are in charge of pricing tickets for an upcoming event at the outdoor amphitheater where all seating is by general admission(no assigned seats). Demand for the event can be segmented into students and non-students. Student demand is Qst=10,000-100P. Non- student demand can be expressed as Qns=5000-10P. Your marginal cost per attendee is $10 and is constant. The capacity of the amphitheater is 5000. Since you can check for a student ID, you can charge each group a different price....
Suppose you constructed a 90% confidence interval for the true average GPA of California community college...
Suppose you constructed a 90% confidence interval for the true average GPA of California community college students. If all of the sample data were to be held constant, how would this confidence interval compare to an 80% confidence interval based on the same data? A random sample of 100 students was taken to determine interest in switching to a quarter system instead of semesters. Out of the 100 students, 73 stated that they were interested in switching to a quarter...
California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest. Because of...
California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest. Because of an increase in demand for its products, California Cabinets is considering hiring subcontractors to complete its current backlog of orders. The following information is available for each subcontractor: Subcontractor 1 Subcontractor 2 Subcontractor 3 Hours required to complete wood tables 50 42 30 Hours required to complete steel tables 60 48 35 Hours available 40 30 35 Cost per hour $36 $42 $55 For...
1. You are in charge of optimizing cell phone service for T-mobile at school because it...
1. You are in charge of optimizing cell phone service for T-mobile at school because it drops calls all the time. You need to add the capacity for 10,000 more calls and 100,000 more text messages per day. You can buy Megacells that can handle 800 calls and 2000 texts a day for $1000 each, and super cells that can handle 200 calls and 30,000 texts for $ 650 each, and basic cells that can handle 100 calls and 100...
Where do you see the U.S. in 25 years? If you were in charge, what competitive...
Where do you see the U.S. in 25 years? If you were in charge, what competitive strategy concepts are most relevant to our country? Please answer in detail
You are the manager of a wine company that produces output in two plants. The demand...
You are the manager of a wine company that produces output in two plants. The demand for your company's product is P = 78 − 15Q, where Q = Q1 + Q2. The marginal costs associated with producing in the two plants are MC1 = 3Q1 and MC2 = 2Q2. How much output should be produced in plant 1 in order to maximize profits? a. 1 b. 2 c. 3 d. 4
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT