Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. use the provided excel format to formulate an answ

Use the provided excel format to formulate an answer The Salem Board of Education wants to evaluate...

60.1K

Verified Solution

Question

Statistics

Use the provided excel format to formulate ananswer

The Salem Board of Education wants to evaluate the efficiency ofthe town’s four elementary schools. The three outputs of theschools are

■   output 1 = average reading score
■   output 2 = average mathematics score

■   output 3 = average self-esteem score


The three inputs to the schools are

■   input 1 = average educational level ofmothers
(defined by highest grade completed: 12 = high
school graduate; 16 = college graduate, and so on)

■   input 2 = number of parent visits to school (perchild)

■   input 3 = teacher-to-student ratio

The relevant information for the four schools is given in the fileP04_42.xlsx. Determine which (if any) schools are inefficient.

Selected DEA school
Inputs used for outputs produced
Inputs
SchoolInput 1Input 2Input 3
11340.05
21450.05
31160.06
41580.08
Outputs
SchoolOutput 1Output 2Output 3
1976
21087
31178
4999
Input 1Input 2Input 3
Unit costs of inputs
Output 1Output 2Output 3
Unit value of outputs
Costs/prices of inputs/outputs used
SchoolInput costsOutput values
1
2
3
4
Selected school input cost
Selected school output value
SchoolEfficient or not?
1
2
3
4

Use the provided excel format to explainanswer

Answer & Explanation Solved by verified expert
4.4 Ratings (691 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Advance Math
1.2K views

Consider rolling two 6-sided dice. What is the probability that at least two of the rolls have...

Medical Sciences
1.2K views

Describe the similarities between pain and the other somatic sensations. Describe the differences. Explain the mechanism of...

Physics
1.2K views

A 0.05kg bouncy ball is dropped from height 9m and loses 20% of its energy upon...

Basic Math
1.2K views

Anthony's math teacher finds that there's roughly a linear relationship between the amount of time...

Basic Math
1.2K views

Find the slope of the line that passes through (10, -8) and (1, 12).4/9-20/99/420/9

Statistics
1.2K views

For each situation state the null and alternative hypotheses Type mu for the symbol e...

Calculus
1.2K views

8 Suppose a population of bacteria is changing at a rate of dp 2 500...

Accounting
1.2K views

Can anyone solve this plz ?

Accounting
1.2K views

As a recently hired accountant for a small business,SMC,Inc.,you are provided with last years balance...

Accounting
1.2K views

Cougar Corp. recorded revenues of $350,000 in 2019 and $275,000 in 2020. Which of the...

Accounting
1.2K views

Realizing the Dream: Decision-Making in Action BACKGROUND ...

Accounting
1.2K views

1. Revenue Per Available seat hour Hour Available Seats Guests Served Revenue REVPASH 7 am-9...