(d) Using SUMPRODUCT Function, write a formula in cell range D64 to compute the weighted score of Vendor 1. Copy the formula to cells E64 and F64 to calculate other vendor's weighted scores.(e) Using MAX Function, write a formula in cell range D66 to compute the maximum weighted score. (f) Using MATCH Function, write a formula in cell range D67 to compute the cell's column number having the maximum score. Hint: Match the value D66 in the array D64:F64 using exact match type.(g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55. 454655565758596061626364656667A68coBAssessment CriteriaEase of managementС47 Based on the data in Table 2 and Table3, convert the categorical values to Rating Scale values.48 (c) Using VLOOKUP write a formula in cell D56 to lookup for the cell D32 value in Table 3 (using Exact match type). Copy the formula to cells D57:F62.49 (d) Using SUMPRODUCT Function, write a formula in cell range D64 to compute the weighted score of Vendor 1. Copy the formula to cells E64 and F64 to calculate other vendor's50 (e) Using MAX Function, write a formula in cell range D66 to compute the maximum weighted score.51 (f) Using MATCH Function, write formula in cell range D67 to compute the cell's column number having the maximum score. Hint: Match the value D66 in the array D64:F64 using exact52 (g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55.5354AccessibilityScalabilityCost SavingsSecurityCustomer SupportCustomizabilityWeight12.0%10.0%8.0%30.0%20.0%15.0%5.0%Weighted ScoreMaximum ScoreColumn Number ofMaximum Score(using MATCHYourDExceeds ExpectationsRecommendationTable 4EVendor 1FVendor 2GVendor 3HJK

“Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Answered: d) Using SUMPRODUCT Function, write a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

(d) Using SUMPRODUCT Function, write a formula in cell range D64 to compute the weighted score of Vendor 1. Copy the formula to cells E64 and F64 to calculate other vendor's weighted scores.

(e) Using MAX Function, write a formula in cell range D66 to compute the maximum weighted score.

(f) Using MATCH Function, write a formula in cell range D67 to compute the cell's column number having the maximum score. Hint: Match the value D66 in the array D64:F64 using exact match type.

(g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55.

45
46
55
56
57
58
59
60
61
62
63
64
65
66
67
A
68
co
B
Assessment Criteria
Ease of management
С
47 Based on the data in Table 2 and Table3, convert the categorical values to Rating Scale values.
48 (c) Using VLOOKUP write a formula in cell D56 to lookup for the cell D32 value in Table 3 (using Exact match type). Copy the formula to cells D57:F62.
49 (d) Using SUMPRODUCT Function, write a formula in cell range D64 to compute the weighted score of Vendor 1. Copy the formula to cells E64 and F64 to calculate other vendor's
50 (e) Using MAX Function, write a formula in cell range D66 to compute the maximum weighted score.
51 (f) Using MATCH Function, write formula in cell range D67 to compute the cell's column number having the maximum score. Hint: Match the value D66 in the array D64:F64 using exact
52 (g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55.
53
54
Accessibility
Scalability
Cost Savings
Security
Customer Support
Customizability
Weight
12.0%
10.0%
8.0%
30.0%
20.0%
15.0%
5.0%
Weighted Score
Maximum Score
Column Number of
Maximum Score
(using MATCH
Your
D
Exceeds Expectations
Recommendation
Table 4
E
Vendor 1
F
Vendor 2
G
Vendor 3
H
J
K

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions