Please use this below data set to solve for the super efficiency scores in Excel Please share an excel file I already know the theory and explanation on how to solve it 3 separate excel model to be solved 1 By removing the DMU 1 under consideration from the constraints 2 By removing the DMU 2 under consideration from the constraints 3 By setting benchmarking share 0 for DMU 1 Brand Model Price ($) Weight (lbs) Average battery life (hours) RAM (gb) HDD capacity (gb) Processor type Screen resolution Screen size HP 11 E010nr 414 99 3 4 5 4 500 1 GHz Dual Core A4 4355M 1366x768 11 6 Acer V5 131 339 98 3 3 6 5 4 500 1 5 GHz Intel Celeron 1007U 1366x768 11 6 Acer AS1410 8414 449 99 3 1 6 2 250 1 4 GHz Intel Core 2 Solo 1366x768 11 6 Lenovo X100e 498 88 3 3 7 5 1 250 2 7 GHz AMD Athlon 1366x768 11 6 Acer V5 171 9620 683 67 3 5 6 500 1 9 GHz Core i7 3517U 1366x768 11 6 ASUS X200CA DB01T 299 99 2 6 5 2 500 1 5 GHz Intel Celeron 1007U 1366x768 11 6 ASUS Q200E BSI3T08 399 99 3 1 11 4 500 1 8 GHz Core i3 3217U 1366x768 11 6 Lenovo IdeaPad S210 279 99 3 1 4 4 500 1 9 GHz Intel Pentium 2127U 1366x768 11 6 Dell Inspiron 11 i3137 299 99 3 1 8 2 500 1 4 GHz Intel Celeron 1366x768 11 6 Acer S3 391 6046 405 3 3 4 320 Intel Core i3 2367M 1 4GHz 1366x768 13 Lenovo IdeaPad Yoga 13 1,029 00 3 3 8 4 500 Intel Core i5 3337U 1 8 GHz 1600x900 13 Gateway LT41P04u 338 45 2 4 5 2 320 Intel Celeron N2805 1 46 GHz 1366x768 10 1 Samsung Series 5 799 99 3 7 5 5 4 500 Intel Core i5 3317U 1366x768 13 ASUS 1015E DS01 259 2 8 7 5 2 320 1 1 GHz Celeron 847 1366x768 10 1 Asus X202E DH51T 669 58 3 4 5 4 500 1 8 GHz ( Dual Core ) 1366x768 11 6 Toshiba T115D S1120 300 3 5 9 2 250 1 6 GHz AMD Athlon 1366x768 11 6 Sony YB Series VPC 340 3 2 5 45 2 320 1 65 GHz AMD E Series 1366x768 11 6

The Answer is in the image, click to view ...

Question: Please use this below data set to solve for the super efficiency scores in Excel. Please share an excel file I already know the theory

Please use this below data set to solve for the super efficiency scores in Excel. Please share an excel file I already know the theory and explanation on how to solve it.

3 separate excel model to be solved-

1. By removing the DMU 1 under consideration from the constraints. 2. By removing the DMU 2 under consideration from the constraints.

3. By setting benchmarking share = 0 for DMU 1

Brand	Model	Price ($)	Weight (lbs)	Average battery life (hours)	RAM (gb)	HDD capacity (gb)	Processor type	Screen resolution	Screen size
HP	11-E010nr	414.99	3.4	5	4	500	1 GHz Dual-Core A4-4355M	1366x768	11.6
Acer	V5-131	339.98	3.3	6.5	4	500	1.5 GHz Intel Celeron 1007U	1366x768	11.6
Acer	AS1410-8414	449.99	3.1	6	2	250	1.4 GHz Intel Core 2 Solo	1366x768	11.6
Lenovo	X100e	498.88	3.3	7.5	1	250	2.7 GHz AMD Athlon	1366x768	11.6
Acer	V5-171-9620	683.67	3	5	6	500	1.9 GHz Core i7-3517U	1366x768	11.6
ASUS	X200CA-DB01T	299.99	2.6	5	2	500	1.5 GHz Intel Celeron 1007U	1366x768	11.6
ASUS	Q200E-BSI3T08	399.99	3.1	11	4	500	1.8 GHz Core i3-3217U	1366x768	11.6
Lenovo	IdeaPad S210	279.99	3.1	4	4	500	1.9 GHz Intel Pentium 2127U	1366x768	11.6
Dell	Inspiron 11 i3137	299.99	3.1	8	2	500	1.4 GHz Intel Celeron	1366x768	11.6
Acer	S3-391-6046	405	3	3	4	320	Intel Core i3-2367M 1.4GHz	1366x768	13
Lenovo	IdeaPad Yoga 13	1,029.00	3.3	8	4	500	Intel Core i5-3337U 1.8 GHz	1600x900	13
Gateway	LT41P04u	338.45	2.4	5	2	320	Intel Celeron N2805 1.46 GHz	1366x768	10.1
Samsung	Series 5	799.99	3.7	5.5	4	500	Intel Core i5-3317U	1366x768	13
ASUS	1015E-DS01	259	2.8	7.5	2	320	1.1 GHz Celeron 847	1366x768	10.1
Asus	X202E-DH51T	669.58	3	4.5	4	500	1.8 GHz ( Dual-Core )	1366x768	11.6
Toshiba	T115D-S1120	300	3.5	9	2	250	1.6 GHz AMD Athlon	1366x768	11.6
Sony	YB Series VPC	340	3.2	5.45	2	320	1.65 GHz AMD E Series	1366x768	11.6

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!

Dataset name:"Medical Cost Personal Dataset". please use this data set for below questions : https://www.kaggle.com/datasets/mirichoi0218/insurance *Note: - Please do this in excel and Provide excel...

PROJECT 3 INSTRUCTIONS! USE EXCEL PROPERLY!!!!! Please download the template attached and complete the requirements for this project using my template. You should upload the one Excel file to this...

I have attached the file with the information on it. Project 3 Name: TYPE in your name here Please use this template below to solve project 3 which has 2 parts on separate worksheets. Save your file...

please fill in yellow values ( ignore ones already filled) and include formula thank you Please use the data from the following table to complete the cash budget in Excel spreadsheets. You can use...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Please read the pdf requirement and fix this assessment. First, the analysis part is less accounting theory to evidence the case. I need some more legitimacy theory to concern the case. Second,...

Hello please refer to part 4 from the question paper I have attached the past student work for your reference just have to follow the format if you feel comfortable with I have attached the necessary...

The accounting profession has employed the matching concept to determine what to report in the income statement and to determine how to measure items reported in the income statement. This concept...

The Does have qualified for a mortgage of $500,000 to be amortized over 25 years. Their mortgage broker has offered them the following options: a. Two consecutive 5-year terms with a fixed rate with...

It would be appropriate for the internal audit function to perform which of the following? a . design controls for a process b . develop a new whistleblower policy c . review a new IT application...

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...