Reference no: EM13944610
Question 1.
Step1: First we need to create a new variable "output value", which is the total value of the rice produced. To construct a variable in excel for all the households, simply use the formula "=variable1*variable2" in the cell corresponding to the first household, then drag the lower right corner of that cell to fill in the entire column. Make sure to label you variables as you go along to avoid confusion.
Step2: Now that we have our dependent variable, we need to put everything in natural log. For each of the variables we need to estimate the production function:
outputi = A * Landx1 * Laborx2
create the logged version of this variable for all the households. I recommend keeping your independent variable in one column and your dependent variables in a block of adjacent columns to facilitate easier use of the regression function in excel.
Step3: Finally, we are ready to perform our regression. Use the "Data Analysis" tab, select "regression" then press "ok". You will see an "Input Y range" selector, use the selector to drag across the entire column of your dependent variable. Note that if you choose to include the top cell with variable labels the "Labels" box must be checked. Next use the "Input X Range" selector to highlight ALL of your independent variables (keeping the columns side by side helps make this easier). Then press the "Ok" button to perform the regression.
a. What are the values of X1 and X2? At what level are the two coefficients significant?
b. Interpret the coefficients, in the context of what they mean for the relationship between output, land and labor.
c. What is the sum of the two coefficients? What's the scale of production in this setting?
Question 2.
As an extension of the previous problem. We may not believe that land and labor are the only inputs used in producing rice. Let's not forget that rice production is very irrigation intensive, we should probably include that variable into the equation. This would change our production function to:
outputi = A * LandX1 * LaborX2 * IrrigationX3
Apply what you have learned in question 1 to re-estimate your model.
a. What are the values of the coefficients now? At what levels are the coefficients significant?
b. Interpret the coefficient on irrigation. What does it mean for rice production?
c. Now sum up your coefficients and obtain the scale of production.
|
Confidence interval estimate for the population mean
: Construct a 95% confidence interval estimate for the population mean turnover time. Interpret the interval constructed in (a). Do you think the quality improvement project was a success?
|
|
Differences between common stock and preferred stock
: Briefly explain the differences between common stock and preferred stock? Why would someone buy preferred shares over common shares? Which type shares traditionally pay the highest dividends?
|
|
Design and create an efficient, well-documented solution
: There are two types of accounts: Standard and Gold. The Standard account has a monthly interest rate of 18% and a monthly credit limit of $4000.
|
|
Guidelines for building effective ecommerce websites
: You should determine your evaluation criteria (approximately 10-15 criteria) based on principles and guidelines for building effective ecommerce Websites and the business models discussed in the prescribed textbook,
|
|
Coefficients and obtain the scale of production
: a. What are the values of the coefficients now? At what levels are the coefficients significant? b. Interpret the coefficient on irrigation. What does it mean for rice production? c. Now sum up your coefficients and obtain the scale of production.
|
|
What is the yield to maturity on the company bond
: A company issues bonds at a market price of $925. The face value is $1000. The bonds mature in 10 years, and the coupon rate is 6% compounded semi annually. What is the yield to maturity on the company's bond?
|
|
How much will daniel have on deposit
: Daniel deposits $2,000 per year at the end of the year for the next 15 years into an IRA account that currently pays 7%. How much will Daniel have on deposit at the end of the 15 years
|
|
What is the company after-tax cost of new debt
: Long-term Borrowing Company (LBC) is raising new capital by selling bonds. Its investment bankers have estimated that if the company sets the coupon rate for the new bonds at 8% paid semiannually, The bankers have estimated that the cost of selling t..
|
|
Knowledge of architectural theory
: In this assignment the student will demonstrate their knowledge of architectural theory by developing a detailed critique of an architectural work and demonstrating its significance to ONE of the movements or themes that have been discussed in the..
|