Negative correlation between quantity and price

Assignment Help Business Economics

Reference no: EM134040019

DATA GATHERING REGRESSION ANALYSIS ASSIGNMENT

Pick a minimum of 20 observations on any subject. This will include a dependent variable, y plus two independent variables, x 1 and x 2 that you may think are either negatively or positively correlated with the dependent variable. List the observed data (include the source). Then do the following:

a. State before doing any calculations whether you think they are positively or negatively correlated. What is your rationale?

Example: I test for a correlation between the quantity of coffee that people buy (Y) with the price of coffee (X1) and the household income (X2).

I hypothesize that there is a negative correlation between quantity and price because people like to buy goods at lower rather than higher prices. I also hypothesize that there is also a positive correlation between the quantity of coffee and household income because people can buy more coffee when their income increases.

b. Draw a graph of each of the two independent variables with the dependent variable either by hand or by using Excel.

c. Use Excel to do the necessary regression. Give the values for the y-intercept, b1 and b2. Write out the equation. Also show R-square, the F-statistic and its p-value and the t-statistics with their respective p-values. Use a confidence level of 95 %.

d. Test for multicollinearity using the rule that the two independent variables are multicollinear if their correlation coefficient is .70 or greater (implying r-square is .49 or greater). If they are multicollinear, give a brief statement on why do you think that is the case.

e. Pretend that this was an assignment from your manager and communicate your findings to the manager. You should assume in preparing this memo:

Your manager is not familiar with statistical terminology. So if you use terms like R square, F statistic, t statistic, multicollinearity, you need to explain what they mean.

Reference no: EM134040019

Questions Cloud

System in which exchange rates are held constant : A system in which exchange rates are held constant A system in which exchange rates are determined by market forces,

Numerous examples of social constructs : The video lists numerous examples of social constructs but doesn't explain many of them.

Make capitalism work better in their communities : How can Indigenous people make capitalism work better in their communities?

Describe how transactions would affect gdp accounts : Describe how the transactions would affect the GDP accounts of the relevant countries using the income method, the production method

Negative correlation between quantity and price : I hypothesize that there is a negative correlation between quantity and price because people like to buy goods at lower rather than higher prices

Make huge profits or sell at lower prices : Due to lower costs of extraction, the company can make huge profits or sell at lower prices to combat competition.

Government decides to offer wage subsidy : Suppose the government decides to offer a wage subsidy to people who are re-entering society after being in prison

Average costs associated with flood for each consumer : They decide to charge 1000 to everyone which is euqal to the average costs associated with a flood for each consumer.

Human population growth outstrip food production growth : In 1789, Malthus predicted that human population growth would outstrip food production growth, resulting in disastrous outcomes.

User Account

All Pages