Question: Use Excel to solve this problem. Please show the working steps. Thanks. Q4. The Salem Board of Education wants to evaluate the efficiency of the

Use Excel to solve this problem. Please show the working steps. Thanks. Use Excel to solve this problem. Please show the
Q4. The Salem Board of Education wants to evaluate the efficiency of the town's four elementary schools. The three outputs of these schools are: (1) average reading score, (2) average mathematics score, and (3) average self-esteem score. The three inputs to these schools are: (1) average educational level of mothers (defined by highest grade completed: 12 = high school graduate, 16 = college graduate, and so on), (2) number of parent visits to school (per child), and (3) teacher-to-student ratio. The relevant information for the four schools is given in the table below. School Input 1 Input 2 Input 3 Output 1 Output 1 Output 3 A 14.5 0.25 3.5 2.7 3 13 0.13 3.3 2.5 2.4 15.5 0.28 3.8 3 3.3 16.2 3 0.33 4 3.8 3 B 2 4 3 3 4 Which of the following statement(s) is(are) true? A) If we assume constant returns to scale, school A is efficient B) If we assume constant returns to scale, school D is not effcient. C) If we assume non-constant returns to scale, school A is efficient D) If we assume non-constant returns to scale, school C is efficient. E) None of the above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!