Attachment # 00001010 - ECO-_Midterm_Excel_Question.xlsx
ECO-_Midterm_Excel_Question.xlsx (39.9 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
CEOSAL2.DESsalary age college grad comten ceoten sales profits mktval lsalary lsales lmktval comtensq ceotensq profmarg Obs: 177 1. salary 1990 compensation, $1000s 2. age in years 3. college =1 if attended college 4. grad =1 if attended graduate school 5. comten years with company 6. ceoten years as ceo with company 7. sales 1990 firm sales, millions 8. profits 1990 profits, millions 9. mktval market value, end 1990, mills. 10. lsalary log(salary) 11. lsales log(sales) 12. lmktval log(mktval) 13. comtensq comten^2 14. ceotensq ceoten^2 15. profmarg profits as % of sales(i) Find the average salary and the average tenure in the sample.The data set CEOSAL2 contains information on chief executive officers for U.S. corporations.average salary=average tenure=(ii) How many CEOs are in their first year as CEO (that is, ceoten=0)? What is the longest tenure as a CEO?Number of CEOs in the first year=Longest tenure=(iii) Estimate the simple regression model log(salary)=beta0+beta1*ceoten+ubeta0=beta1=SSR=R2=use intercept( )use slope( )SSRu =SSRr =(approximate) predicted percentage increase in salary given one more year as a CEO=Use appropriate Excel commands, not just counting from the data with your eyespercent(iv) You wish to compare the explanatory power of ceoten and profits. Estimate the simple regression model log(salary)=beta0+beta1*profits+u Based on the values of R-squared, we conclude that the better explanatory variable between ceoten and profits is profits(v) Compute predicted values of ln(salary) from each model and plot the data points and the regression line.ln(salrary)ceotenmodel(iii)model(iv)model(iii) Figure(approximate) predicted percentage increase in salary given one million dollar more profit =Use + as the mark for data and set the size=3Compute SSRu and SSRr first, and then compute R2Midterm Excel Questions(Computer Exercise 2.2)The variable salary is annual compensation, in thousands of dollars, and ceoten is prior number of years as company CEO, and profits in millions of dollarsPredicted values3 pointsPredicted values in question (v) are 3 points for the entire column for each model. That is, 3 points for the column for model (iii) and 3 points for the column for model (iv). This is all-or-none questionEach figure in question (v) is worth 3 points.Fill in the yellow shaded cells. Each cell is worth 3 points.
ECO- Midterm Excel Questions

ECO- Midterm Excel Questions

Question # 00009879 Posted By: expert-mustang Updated on: 03/09/2014 05:22 AM Due on: 03/09/2014
Subject Economics Topic General Economics Tutorials:
Question
Dot Image

Midterm Excel Questions (Computer Exercise 2.2)
Fill in the yellow shaded cells. Each cell is worth 3 points.
Predicted values in question (v) are 3 points for the entire column for each model. That is, 3 points for the column for model (iii) and 3 points for the column for model (iv). This is all-or-none question
Each figure in question (v) is worth 3 points.
The data set CEOSAL2 contains information on chief executive officers for U.S. corporations.
The variable salary is annual compensation, in thousands of dollars, and ceoten is prior number of years as company CEO, and profits in millions of dollars
(i) Find the average salary and the average tenure in the sample.
average salary=
average tenure=
(ii) How many CEOs are in their first year as CEO (that is, ceoten=0)? What is the longest tenure as a CEO? Use appropriate Excel commands, not just counting from the data with your eyes
Number of CEOs in the first year=
Longest tenure=
(iii) Estimate the simple regression model log(salary)=beta0+beta1*ceoten+u
beta0= use intercept( )
beta1= use slope( )
SSR=
R2= SSRu = SSRr = Compute SSRu and SSRr first, and then compute R2
(approximate) predicted percentage increase in salary given one more year as a CEO= percent
(iv) You wish to compare the explanatory power of ceoten and profits.
Estimate the simple regression model log(salary)=beta0+beta1*profits+u
beta0=
beta1=
SSR=
R2= SSRu = SSRr =
Dot Image
Attachments
ECO-_Midterm_Excel_Question.xlsx (39.9 KB)
Tutorials for this Question
  1. expert-mustang
    Tutorial # 00009487 Posted By: expert-mustang Posted on: 03/09/2014 05:24 AM
    Puchased By: 3
    Tutorial Preview
    of dollars (i) Find the average salary and the average ...
      Get the Solution
    Attachments
    ECO-_Midterm_Excel_Questions_Solution.xlsx (61.87 KB)
Whatsapp Lisa