Reference no: EM131719079
DATA GATHERING REGRESSION ANALYSIS ASSIGNMENT:
Pick a minimum of 20 observations on any subject. This will include a dependent variable plus two independent variables 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. (Insert an XY/Scatter chart.)
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.
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 multicolliear, 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 or t-statistic, you need to explain what they mean.
|
How much interest income should jorge report
: Jorge purchased a newly issued $20,000 corporate bond on November 1, 2015. How much interest income should Jorge report on his 2015 and 2016 tax returns
|
|
What happens to nelson effort
: If the CEO increases the incentive from 0.2 to 0.25, what happens to Nelson's effort? Will profits rise or fall?
|
|
Discuss the advantages and disadvantages of dbmss
: Discuss the advantages and disadvantages of DBMSs (Database Management System)?
|
|
Calculate depletion cost per unit
: Novak Corp. purchased for $5,829,200 a mine that is estimated to have 44,840,000 tons of ore and no salvage value. Calculate depletion cost per unit
|
|
Data gathering regression analysis assignment
: Pick a minimum of 20 observations on any subject. This will include a dependent variable plus two independent variables
|
|
What are the total lease payments in this lease arrangement
: Leases a building and land. The lease term is 7 years and the annual fixed payments are $720,000. What are the total lease payments in this lease arrangement
|
|
Indicate variable type of the given sentences
: For each of the following, indicate whether the variable is ordinal or not. If the variable is not ordinal, indicate its variable type.
|
|
Write a one page summary about what you learned reflection
: Once you chose your two popular journals, you will need to write a one page summary and half a page about what you learned Reflection.
|
|
Cost-minimizing input mix for producing
: If the wage rate is $30 per hour and the rental rate on capital is $10 per hour, what is the cost-minimizing input mix for producing 6 units of output?
|