Estimate of indianas demand for kbc microbrews

Reference no: EM133222624

Question: Suppose the Kalamazoo Brewing Company (KBC) currently sells its microbrews in a seven-state area: Illinois, Indiana, Michigan, Minnesota, Mississippi, Ohio, and Wisconsin. The company's data analytics department has collected data from its distributors in each state. This data consists of the quantity and price (per case) of microbrews sold in each state, as well as the average income (in thousands of dollars) of consumers living in various regions of each state. The data for each state are available via the link below--please note there are multiple tabs at the bottom of the spreadsheet, each refers to one of the seven states selling the Kalamazoo Brewing Company's microbrews.

Excel Data File

Assuming that the underlying demand relation is a linear function of price and income, use your spreadsheet program to obtain least squares estimates of Indiana's demand for KBC microbrews.

Instruction: If the estimate is negative, enter a negative number (-) in the equation. Enter your responses rounded to two decimal places.

Reference no: EM133222624

Questions Cloud

Should it matter where the factory was located : If you lived 25 miles away? If you lived 1,000 miles away? What if the factory were in a foreign country? Should it matter where the factory was located

Types of training for the customer service team : Alternatively, you could also suggest types of training for the customer service team based on the positive KPI results for August.

Estimate a linear regression : Use your regression model to estimate the weekly quantity of milk consumed after this advertising increase.

How different personalities approach decision-making : There are four personas presented in the Mind Map article that describe how different personalities approach decision-making. Gunslingers, Evangelists, Professo

Estimate of indianas demand for kbc microbrews : BUSI 620 Liberty University, use your spreadsheet program to obtain least squares estimates of Indiana's demand for KBC microbrews.

Social media activity-impact on career-related perceptions : Direction: Read the case below and answer the following questions/requirements. Be detailed in the information you provide.

Example of a situation : Give an example of a situation in which the waiting time cost would be based on waiting time in the queue. Give an example of a situation in which the waiting t

How are plants and animals impacted : How are plants and animals impacted by climate change - discuss how it is being impacted by climate change - these impacts may be helpful or harmful

Statistical measures associated with global health issues : Analyze efforts taken by local agencies, international agencies, and international agreements to address global health issues.

User Account

All Pages