Reference no: EM13148097
How to use use the Excel trendline method to estimate a regression equation of the form
y = a + bx + (cx)^2?
Louisa is managing a training program for a major bank. She designs the following experiment to assess the effect of sleep on learning. A group of trainees is given a 3-hour session on some task, followed by a 2-hour test on what they have just learned. The trainees are then sent home and told to keep track of how many hours they sleep that night. The next morning the trainees are tested again and their performance relative to the previous day is recorded. The following data is generated. The top row shows hours of sleep for a given employee and the bottom row shows the next day's relative test performance.
|
sleep
|
4
|
4
|
4.5
|
5
|
5
|
5.5
|
6
|
7
|
7.5
|
8.5
|
9
|
9
|
|
score
|
70
|
68
|
75
|
82
|
80
|
86
|
90
|
98
|
96
|
102
|
98
|
101
|
(a) ) Use the trendline approach in Excel to run a linear regression of the form y = a + bx where y is the relative test score and x is hours of sleep. (Put sleep in Column A and score in Column B.) Cut and paste the Excel diagram into the space below.
(b) What is the estimated effect of one additional hour of sleep? What is the R2?
(c) Now use the Excel trendline method to estimate a regression equation of the form y = a + bx + cx2. Report the estimated equation and the R2. Cut and paste the diagram into the space below. If you were asked to predict the score associated with 10 hours of sleep, would you use this quadratic regression or the linear regression in a)? What relative score would you predict? Explain.
Question #2
Wheat is produced according to the production function Q = 5(K0.8 L0.2) where Q denotes output, K denotes capital and L denotes labor.
(a) Does this production function exhibit increasing, decreasing or constant returns to scale? Show the mathematics you used to arrive at your answer.
(b) With capital fixed at 10 units, derive an expression for the MP of labor and AP of labor. Graph your expressions for MPL and APL (L on the horizontal axis).
(c) If w =10 and r = $5, find cost minimizing combination of K and L to produce 1000 units of Q. Draw a graph to illustrate your result.
Question #3 Suppose newsprint is produced in a perfectly competitive market by many identical firms. Each firm (including potential entrants) has a total variable cost VC(q) = 40q + 0.5q2. Each firm's fixed cost is equal to $50.
a) Assuming that the fixed cost is entirely non-sunk (i.e. recoverable), calculate the price below which the firms will not produce any output in the short run.
b) Assume that there are 12 identical firms in this industry. Currently the market demand for newsprint is Qd = 360 - 2P. What is the short-run equilibrium price?
|
How many hogs should receive new experimental diet
: If the standard deviation is 20 pounds, and the weight gain is normally distributed, how many hogs should receive the new experimental diet?
|
|
Suppose that the carnival and the circus
: Suppose that the carnival and the circus have both come to town, and are both o?ering free admission. You have 6 free hours to kill. Draw the BUDGET LINE that shows your options for how you can spend the day.
|
|
Cost of merchandise basics
: Assuming that Reed uses the perpetual inventory method, record the necessary journal entries on June 24 and June 30. The cost of merchandise to Reed Company is 60% of its selling price.
|
|
Why some scientists believe the pleistocene is over
: What impact does this division of views have on the public policies that are enacted by state, national, and international bodies?
|
|
Louisa is managing a training program
: Louisa is managing a training program for a major bank. She designs the following experiment to assess the effect of sleep on learning. A group of trainees is given a 3-hour session on some task, followed by a 2-hour test on what they have just learn..
|
|
Explain the rock cycle.
: 1. Describe a boreal forest biome's climate, vegatation, and location.2. Explain the rock cycle. Be sure to include how minerals from one rock end up in a different rock.
|
|
Write out the exchange reaction?
: Describe one possible simple ionic substitution or one possible coupled ionic substitution that might be present in the mineral calcite? write out the exchange reaction?
|
|
Bigbiz, a local monopsonist
: BigBiz, a local monopsonist, currently hires 50 workers and pays them $6 per hour. To attract an additional worker to its labor force, BigBiz would have to raise the wage rate to $6.25 per hour. What is BigBiz's marginal factor cost?
|
|
Specific policies might the united states enact to reduces
: As the United States is one of the largest contributors to atmospheric carbon emissions, what specific policies might the United States enact to reduce its impact on global climate change? Using at least two scholarly or reputable resources and your ..
|