Question Help Problem 14-18 (algorithmic) Two sport utility vehicles (SUVS) are being considered by a recent engineering graduate. Using the following data evaluate which sport utility vehicle is better. Use six attributes in your analysis: price point, overall appearance, comfort, safety, reliability, and fuel mileage. Larger scores on overall appearance, comfort, safety, reliability, and fuel mileage are preferred to smaller ones. Click the icon to view the table with data you have gathered about the SUVS. Determine attribute weights and use the nondimensional scaling technique to find the resulting set of vehicle scores. Fill in the table below. (Round to two decimal places.) Alternatives Final score Which alternative should be chosen using the additive weighting technique? Choose the correct answer below More Info O Sport utility vehicle 2 Sport utility vehicle 1. Attribute Price Appearance Comfort Safety Reliability Fuel mileage SUV 1 0.63 Relative Rank 6 3 2 4 1 5 Print SUV 2 0.38 Alternatives SUV 1 $21,550 Done 2 4 5 4 18 mpg SUV 2 $28,250 4 3 4 2 24 mpg STUD X

Question Help Problem 14-18 (algorithmic) Two sport utility vehicles (SUVS) are being considered by a recent engineering graduate. Using the following data evaluate which sport utility vehicle is better. Use six attributes in your analysis: price point, overall appearance, comfort, safety, reliability, and fuel mileage. Larger scores on overall appearance, comfort, safety, reliability, and fuel mileage are preferred to smaller ones. Click the icon to view the table with data you have gathered about the SUVS. Determine attribute weights and use the nondimensional scaling technique to find the resulting set of vehicle scores. Fill in the table below. (Round to two decimal places.) Alternatives Final score Which alternative should be chosen using the additive weighting technique? Choose the correct answer below More Info O Sport utility vehicle 2 Sport utility vehicle 1. Attribute Price Appearance Comfort Safety Reliability Fuel mileage SUV 1 0.63 Relative Rank 6 3 2 4 1 5 Print SUV 2 0.38 Alternatives SUV 1 $21,550 Done 2 4 5 4 18 mpg SUV 2 $28,250 4 3 4 2 24 mpg STUD X

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

OVERVIEW Body mass index (BMI) is a value derived from the mass (weight) and height of a person. The BMI is defined as the body mass divided by the square of the body height, and is expressed in units of kg/m2, resulting from mass in kilograms and height in meters. The BMI may be determined using a table or chart which displays BMI as a function of mass and height using contour lines or colors for different BMI categories, and which may use other units of measurement (converted to metric units for the calculation). The BMI is a convenient way for classifying persons in to 4 categories based the BMI value as shown the following table: BMI value Category Underweight Normal Overweight Less than 18.5 18.5 to less than 25 25 to less than 30 30 or higher Obese A national study in some country to analyze the BMI of the people in the country is considered. In this study, a set of cities is selected in the study and randomly specific number of persons are selected to check the BMI category of…
Practice Question 6
Question 31 A survey on pollution has been conducted on four cities. The degree of pollution is classified as not polluted, moderately polluted, and heavily polluted. The results of the survey are illustrated in the table below: City city1 city2 city3 city4 Xi1: not polluted 0.3 0.2 0.1 0.7 X12: moderately polluted 0.4 0.2 0.2 0.4 Xi3: heavily polluted 0.3 0.6 0.5 0.1 Use the cosine amplitude method to develop the fuzzy relation R that relates the pollution degree to the city.
Use the table below to answer the questions in Group B. Lawn Service Comparisons (unless otherwise noted, dollars are yearly) Mowing, Trimming, Bagging (if necessary) May 1st through Oct. 31st Lawn Lawn Service Service A $1040 $125/cut $2.50/linear foot Trimming Bushes, Hedges included Lawn Fertilizations, and Aeration $170 $225 Weed and Seeding Control Fall and Spring Raking and Clean-Up $20/application included $205 $475
Please see the image and read carefully. Solve a) and c) questions. If possible then solve b) question.
Note: “breadth” is a boolean indicating whether or not a course satisfies the breadth requirement for degrees in the Faculty of Arts and Science. Student(sID, surName, firstName, campus, email, cgpa) Course(dept, cNum, name, breadth) Offering(oID, dept, cNum, term, instructor) Took(sID, oID, grade) answer queries for them Department and cNum of all courses that have been taught in every term when csc448 was taught? Name of all students who have taken, at some point, every course Gries has taught (but not necessarily taken them from Gries).? Department and course number of courses that have never been offered?
Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79 Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate: The Average Grade of each student; this average should be a vector. The average of the class; this average is a scalar vector. The highest grade among the Average Grade of Each Student The lowest grade among the Average Grade of Each Student Show a table with each student's name, average grade and letter score using A, B, C, D, F…
Q3) If you have a list of names for a group of employees, it is required to summation three salaries for the previous months and show the result to the manager, what are the means you will need to accomplish this task? (15Marks )
QUESTION 1 An admission charge for Bandar Orchid Wetlands varies according to the age of the customer as in Figure 1. The system will receive the input for the number of persons for each category as in Figure 2. Then, it will calculate and display the total charge (include SST 8%) and the category Figure 3. [Assume all items are required. The process is not involving any decision]. Category (Age) 50 and above 13- 49 7-12 4-0 Charge (RM) 30.00 35.00 25.00 15.00 Below 4 Figure 1: Charges for Visitors Free The Bold items are the input from the user. WELCOME TO BANDAR ORCHID WETLANDS Enter the number of persons for each category Age Over 50 Age 13 - 50 Age 7 - 12 Age 4 - 6 Age Below 4 1 2 Figure 2: The Input Total for Over 50 (1 Fersons): BM 30.00 Total for 13 - 50 (2 Persons): RM 70.00 Total for 7 - 12 (4 Persons): RM 100.00 Total for 4 - 6_(O Persons): RM 0.00 Total for Below 4 (FREE) : RM 0.00 ITEMS RM 200.00 12.00 TOTAL 3ST (6R) SUB-TOTAL = 212.00 THANK YOU.ENJOY YOUR HOLIDAY!! Figure…
Question 1 included for reference
CASE BACKGROUND Levi Landon owns a small lawn care business with three employees. He owns the lawn mowers, rakes, and weed whackers that are housed in a storage area at the back of his home. He currently keeps his records in a spiral-bound book. He has a page for his list of customers, and their information including when he first started to do their garden, and the size of their lawns. He has another section to keep track of payments. Levi usually requires payment on completion of the service, but this rarely happens and he has lost track of who owes him and how much. Levi realizes that he is not as efficient as he could be in his record keeping and asks you to help him to track customer service dates, payments and lawn care revenue. He may want to get a loan to purchase some more equipment. He provides you with his book of customers, and payments and prices of the various lawn sizes. To help Levi with the reporting requirements, you need to work with Customer, Payment, and Prices…
Read and answer question carefully.