100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 3 out of 3 pages.
4.A K-12 school recieves a score based on the following weights: English 25% Math 25% Grad 30% CCR 20% If the school earns a B = 3 in English, a C = 2 in Math, a B = 3 in Graduation rates, and a D = 1 in CCR (Career readiness), what score will the school receive? SOLUTIONS 20 28 18 4 0
5.Buying the best. Sara is researching phones and decides to use a weighted average score to determine the ‘best’. She uses the following weights: 50% battery life, 30% cost, 20% camera. She finds the following ratings out of 10 for each category on the internet. Determine the weighted average score for each phone using Sara’s strategy. Which phone will she choose? BatteryCostCameraiPhone9 7 Samsung9 7 Motorola8 9 Suppose you wanted to use the follwing spreadsheet in Excel to calculate the scores for the phones.What formula would you need to type in cell E2 to calculate the weighted average for the iPhone? Use cell referencesfor to the Battery, Cost, and Camera scores for the iPhone (rather than the values).8 7 8