You have just started working at large wine distribution company and have been tasked with analyzing...

You have just started working at large wine distribution company and have been tasked with analyzing how the company should be pricing their bottles of wine. You have data on a number of different wines that include very detailed reviews, the country of origin, the wine’s rating and designation, and the price that is has been sold at in the past. You hypothesize that higher rated wines should sell for a higher price (duhhh), but want to figure out how much more you can sell wine for that has higher ratings. Use your wine data, which is included below, to answer the following questions.

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, you will need to install the data analysis tool pack on your computer. How to do this differs based on the type of computer you are using, but instructions can be found on google for both Mac and PC.

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

Use the exponential model to predict the sales price of a wine that has a rating of 92. Hint, round all of the estimates to 4 decimals prior to making your predictions. Round intermediary calculations to 4 decimals and round your final answer to 4 decimals

Estimate the sample regression equation below and fill in the estimated coefficients. Pay close attention the form of the variables prior to estimating the model. Round the coefficient estimates to 4 decimals.

Linear Model: Priceˆ= _____________ + ______________ Rating + ______________ Rating²

Solutions

Expert Solution

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.543771157
R Square	0.295687072
Adjusted R Square	0.295676807
Standard Error	30.48331263
Observations	137235

ANOVA
	df	SS	MS	F	Significance F
Regression	2	53536057.86	26768028.93	28806.60469	0
Residual	137232	127520413.7	929.2323487
Total	137234	181056471.5

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	5622.506072	47.2410031	119.0174997	0	5529.914591	5715.097554	5529.914591	5715.097554
Rating	-132.3245732	1.073794523	-123.2308141	0	-134.4291904	-130.219956	-134.4291904	-130.219956
Rating^2	0.781009186	0.006097088	128.0954366	0	0.769059007	0.792959365	0.769059007	0.792959365

Linear Model:

Use the exponential model to predict the sales price of a wine that has a rating of 92.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

You have just started work at an aircraft engineering company and have been tasked with a...

You have just started work at an aircraft engineering company and have been tasked with a complex engine change on the aircraft. What kind on negative reactions could this cause in you? And what could you do to reduce these negative reactions?

A) Assume you have just started working in the marketing department for a large firm that...

A) Assume you have just started working in the marketing department for a large firm that sells major consumer products such as toothpaste or sodas or athletic shoes. You are in a meeting with some of the other workers in other departments - accounting, human resources, finance, and manufacturing. These people are saying that the company should get rid of the marketing to save millions of dollars. What would you say to persuade them that the marketing department is vital...

You are working for a US-based company and have been tasked with integrating an acquisition in...

You are working for a US-based company and have been tasked with integrating an acquisition in Japan (based in Osaka). Prior to this acquisition your company had only a representative office based in Tokyo. What are the four key elements of Human Relations Management and for each element list at least one criterion relevant to your firm’s future success in this marketplace. Where would you establish the administrative offices for the acquired company (explain the rationale for your decision).

1. Assume you have just started working for a company that does not have an organizational...

1. Assume you have just started working for a company that does not have an organizational chart that shows reporting relationships. How would you go about determining to whom your boss reports and where your department fits in the overall organization structure? 2. Describe managerial skills and behaviors that would be required to manage effectively in a functional department. Are these skills and behaviors different from those required in a product department? Please explain. 3. For what type of an...

1. You just started at a new position at a large investment bank. You have been...

1. You just started at a new position at a large investment bank. You have been assigned to help a senior analyst, Ms. Jones, on a Dutch Auction of shares for Thornton & Danaher Inc. The equity of the firm is currently closely held by the founding families and the senior managers, so there is no available ma rket price. They are hoping to raise about $300,000,000. This represents about 20% of the fi rm’s current equity value. Ms. Jones...

u have been tasked to develop a layout for a warehouse/distribution centre for a small company...

u have been tasked to develop a layout for a warehouse/distribution centre for a small company that is growing and requires better control of the inventory so that they can excel in customer fulfillment and satisfaction. Without worrying about the actual location of the facility or the number of products, what tools or information would you use/examine to develop a plan to assist the company in achieving its goal of excellent customer fulfillment and service? Explain you choices

Suppose that you have just graduated from college and have started working at a biotechnology firm....

Suppose that you have just graduated from college and have started working at a biotechnology firm. Your first job assignment is to clone the pig gene for the hormone prolactin. Assume that the pig gene for prolactin has not yet been isolated, sequenced, or mapped; however, the mouse gene for prolactin has been cloned, and the amino acid sequence of mouse prolactin is known. Briefly explain two different strategies that you might use to find and clone the pig gene...

You have been tasked to evaluate the financial health and working capital policy of Yoyo Co....

You have been tasked to evaluate the financial health and working capital policy of Yoyo Co. The extracts of the balance sheet as at 31 December 2019 and income statement for the year ended are as follows: Balance sheet $'000 Income Statement $'000 Current assets Sales 20,000 Inventory 2,500 Cost of Sales 15,000 Accounts receivables 4,250 Cash 4,000 Current liabilities Accounts payables 2,750 Short-term bank loan 2,500 Companies which are similar to Yoyo Co have the following average metrics for...

You are the HR manager for a new company and you have been tasked with developing...

You are the HR manager for a new company and you have been tasked with developing a concise employee manual for your new middle managers. This manual must help the managers understand certain HR initiatives so that they can recruit, select, and manager their staff effectively. The manual will consist of explaining and providing guidelines for best practices in the areas below. Explain the importance of a job description and briefly describe the necessary components Describe an effective recruiting process...

You have just started at a company and they present you with historical data for the...

You have just started at a company and they present you with historical data for the time in minutes that it takes to prepare a solar panel. The company has 3 locations and they give you the following sample data: Minutes to Prepare A Solar Panel Site 1 Site 2 Site 3 119.5 120.3 128.1 118.0 100.0 126.6 114.4 107.2 123.5 118.6 118.4 125.5 126.9 111.6 127.3 122.0 113.1 118.3 116.1 102.9 125.6 136.5 103.2 128.2 119.5 100.3 126.1 124.7...

Subjects