quantity– the number of pints your brewery pours monthly price– the price you charge per pint...

quantity– the number of pints your brewery pours monthly
price– the price you charge per pint
population– the surrounding population of the town your brewery is in (measured in thousands)
wine price– the price of wine sold by Adam Smith’s Invisible Hand Winery
wine quantity– the number of bottles of wine poured at Adam Smith
regional income– an index of regional income (measured in units, higher index means higher income)
pretzel price– the price of the pretzels that you sell
pretzel quantity – the number of pretzels that you sell
TV price– the price of 60-inch TV’s

As manager, you are focused on answering the following question

Estimate (and report) your demand equation using a linear regression (include the coefficients, p-values for the coefficients, and the and its p-values). Does this equation make economic sense (in other words, did the signs of these match up with your expectations from question 1)?
Evaluate how well this regression performed (use both statistics and your economic intuition). Do you trust your regression? (i.e. would you use it to forecast demand if you were the actual owner of this brewery?) Why or why not?
Using the mean of each of your explanatory variables (except for price), what is your forecasted demand as a function of price? At a price of $5 per pint, what is your forecasted revenue?

quantity	price	population	Wine price	regional income	Pretzel price	Pretzel quantity	TV price
582.39	5.52	65.000	5.88	100.00	6.47	419.82	435.93
647.71	4.62	65.423	5.05	100.20	4.53	483.11	430.53
630.73	4.55	65.670	6.34	100.33	6.17	460.68	475.03
530.46	5.44	65.627	4.36	100.35	7.94	410.21	428.11
591.69	5.38	65.836	4.45	100.22	6.75	438.68	485.2
571.22	4.55	66.174	5.09	100.12	5.98	456.03	449.28
592.02	4.94	66.344	5.09	100.51	6.51	437.19	450.64
594.98	5.43	66.691	5.33	100.35	5.64	455.07	436.4
647.15	4.10	67.207	4.89	100.70	6.41	436.45	443.41
545.97	5.17	67.164	3.82	101.03	7.22	414.50	441.22
611.25	4.26	66.485	5.06	100.75	6.74	427.98	471.37
627.39	3.86	66.306	5.35	101.04	6.69	418.57	440.04
650.20	3.38	66.715	3.65	101.05	6.10	454.61	451.33
581.59	4.37	66.523	4.55	101.21	8.82	389.18	441.29
600.35	4.65	66.666	4.71	101.31	5.79	458.25	512.9
602.40	4.60	67.138	4.97	101.48	8.35	390.42	423.4
556.38	6.24	67.231	5.61	101.45	7.61	408.74	446.77
569.91	4.83	67.397	4.34	101.32	5.12	476.67	485.7
552.82	5.40	67.620	3.50	101.67	9.68	367.18	509.06
596.04	4.98	67.802	5.19	101.68	7.65	420.94	464.65
579.05	5.13	67.901	5.05	101.98	7.66	421.70	451.93
607.55	4.33	67.766	4.06	102.01	7.29	425.85	444.5
547.34	4.76	68.190	4.72	102.14	8.36	377.16	478.54
550.19	5.67	68.015	4.77	102.23	7.50	421.82	447.58
594.48	4.58	68.024	4.27	102.30	6.10	451.82	439.6
612.38	5.28	67.606	6.10	102.49	7.21	405.93	465.48
601.80	6.16	67.363	6.66	102.71	6.24	431.57	446.81
597.78	4.80	67.315	3.54	102.65	8.11	398.63	420.81
614.90	5.03	67.445	6.20	102.77	6.57	428.84	433.13
656.44	3.97	67.827	5.53	102.83	7.09	434.49	454.8

Solutions

Expert Solution

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

Year Cupcakes Envelopes Price Quantity Price Quantity (Dollars per cupcake) (Number of cupcakes) (Dollars per envelope)...

Year Cupcakes Envelopes Price Quantity Price Quantity (Dollars per cupcake) (Number of cupcakes) (Dollars per envelope) (Number of envelopes) 2012 2 115 5 175 2013 4 150 2 180 2014 1 100 2 160 Use the information from the preceding table to fill in the following table. Year Nominal GDP Real GDP GDP Deflator (Dollars) (Base year 2012, dollars) 2012 2013 2014 From 2013 to 2014, nominal GDPdecreased , and real GDPdecreased . The inflation rate in 2014 was _______...

Exercise 1.8 Your long distance phone service has a base monthly charge and a per-minute charge....

Exercise 1.8 Your long distance phone service has a base monthly charge and a per-minute charge. When you used 350 minutes in a month the total cost was $32.50. When you used 400 minutes in a month the total cost was $36.50. You want an equation that will allow you to calculate your phone bill. Please provide: a. the definition of x, including the units b. the definition of y, including the units c. the equation in the form y...

Imagine that the Point Brewery actually had a person in charge of market research, and you...

Imagine that the Point Brewery actually had a person in charge of market research, and you were that person. The brewery is trying something really radical and launching a line of hard (11% alcohol) kombuchas. Describe your plan for using qualitative and quantitative research to determine how successful the launch has been. You must use both methods. You are in charge of market research for the small, independent cruise line MSC Cruises. Put on your competitive-intelligence hat and give me...

Table 21.3.2 Data from Southton Price (dollars) Price (dollars) Quantity (number) Quantity (number) Item Base Current...

Table 21.3.2 Data from Southton Price (dollars) Price (dollars) Quantity (number) Quantity (number) Item Base Current Base Current Rubber Ducks Beach Towels 1.00 9.00 1.25 6.00 100 12 100 14 1a) Refer to Table 21.3.2. From the data in Table 21.3.2. What is Southton's consumer price index for the current year and what is the rate of inflation over the base year? Show your calculations 1b) When CPI is reported, commodity substitution bias in CPI is not considered. What does...

year price per milk kg quantity of milk kg price of honey kg quantity of honey...

year price per milk kg quantity of milk kg price of honey kg quantity of honey 2011 1 100 2 50 2012 1 200 2 100 2013 2 200 4 100 compute the percentage change in nominal gap, real gap and the gap deflator in 2011 and 2012 from the preceding year. for each year, identify the variable that does not change. explain in words why your answer makes sense.

If you cut the price of your good or service to increase the quantity demanded by...

If you cut the price of your good or service to increase the quantity demanded by your consumers, is that going to be a good thing for your firm? Discuss and justify your answer. Consider two demand curves; on the left, demand for airline tickets by businesses, and, on the right, demand for airline tickets by vacationers. Let the initial price be $500 for each panel and let the price fall to $400. Choose a new quantity demanded for each...

Price (dollars per firework) Quantity demanded (fireworks per week) Quantity supplied (fireworks per week) 4 220...

Price (dollars per firework) Quantity demanded (fireworks per week) Quantity supplied (fireworks per week) 4 220 40 5 200 80 6 180 120 7 160 160 8 140 200 9 120 240 10 100 280 11 80 320 12 60 360 13 40 400 14 20 440 1. The table gives the demand and supply schedules for fireworks on the Island of Big Bang. In the past, because many deaths have resulted from accidents involving fireworks, the government has banned...

For this activity, select a recurring quantity from your OWN life for which you have monthly...

For this activity, select a recurring quantity from your OWN life for which you have monthly records at least 2 years (including 24 observations in the dataset at least). This might be the cost of a utility bill, the number of cell phone minutes used, or even your income. If you do not have access to such records, use the internet to find similar data, such as average monthly housing prices, rent prices in your area for at least 2...

For this activity, select a recurring quantity from your OWN life for which you have monthly...

For this activity, select a recurring quantity from your OWN life for which you have monthly records at least 2 years (including 24 observation in dataset at least). This might be the cost of a utility bill, the number of cell phone minutes used, or even your income. If you do not have access to such records, use the internet to find similar data, such as average monthly housing prices, rent prices in your area for at least 2 years...

For this activity, select a recurring quantity from your OWN life for which you have monthly...

Subjects