Last Name First Name UserID Test 1 Test 2 Test 3 Test 4 Average Grade Redfield...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Last Name First Name UserID Test 1 Test 2 Test 3 Test 4 Average Grade Redfield Logan OGLD 94 89 91 90 94.73 A Goodwin Jon ONIN 97 90 87 93 94.68 A Verma Zaniyah 91 88 90 98 Ahmad Kalel 92 87 89 90 Jurecki Oaklee 83 85 97 80 Krueger Mohamed 85 79 94 82 Wood Tristian 88 96 79 79 McMillan Melvin 85 93 78 82 Waldrop Alma 85 86 100 70 Swaim Shruti 88 85 82 75 Shepherd Manuel 83 78 87 81 Taylor Gatlin 82 87 89 71 Wurz Alexandria 91 93 54 94 Baugh Winnie 80 90 65 91 Harry Melany 91 77 72 85 Jain Brandon 72 72 99 88 King Miles 92 90 74 68 Browne Emory 76 70 88 88 Govindappa Talon 86 79 68 88 Buquet Oscar 76 81 90 73 Corley Felix 73 84 91 72 Price Lian 81 78 83 77 Tao Paris 84 81 71 83 Robinson Lyric 81 83 81 73 Hensley Lauren 92 90 45 91 Cangelosi Yaretzi 90 73 63 90 Sturm Ariel 90 49 85 94 Bryant Hunter 92 88 46 90 Melton Atlas 85 83 80 66 Kimbrell Boston 93 90 79 54 Torres Serena 89 60 73 90 Morris Brandon 86 84 72 69 Schuhmacher Helena 89 78 72 71 Mathew Kinley 89 79 58 83 Aird Reign 88 80 53 85 User Ezra 93 93 74 47 Fernandez Rylie 71 75 84 73 Aziz John 78 64 86 74 1. Create UserID which consists of the 2nd and 3rd letter of the 1st name and the last 2 letters of the last name. 2. Find Average after a. adding 20% to the highest test score (but not going past 100) b. adding 10% to the lowest score 3. Assign grades Use Vlookup or IFS. 0 to <58: F; 58 to <69: D; 69 to < 77: C; 77 to < 86: B, Use proper Excel functions to be more efficient as on the test, You'll have very limited time to answer these questions. You'll not be able to sort or Filter or copy data to another Excel sheet. 86 or more: A Whitaker Ayleen 75 81 72 73 Canessa Edison 90 23 99 98 Shah Jaylin 83 60 78 78 Song Makenzie 87 82 84 46 Baer Leland 79 68 75 76 Naik Henrik 84 82 50 82 Jain Kamryn 89 73 48 86 Nwaekwe Dallas 94 89 44 72 Sandlin Angie 60 80 89 66 Garcia Addilyn 81 87 64 63 Singh Emory 87 79 56 73 Tsai Dilip 83 70 64 77 Chism Jakob 85 69 56 83 Mackey Creed 70 63 96 68 Rusek Justin 88 74 45 86 Mahapatra Cadence 74 74 71 73 Baqatyan Charli 96 82 40 78 Marchese Xander 84 81 45 81 Danalian Aditi 89 68 45 88 Zhu Estella 87 85 45 72 Vuga Bodie 96 95 67 35 White Zaiden 64 83 67 70 Yang Ayan 90 86 41 66 Robles Mustafa 79 92 40 72 Moran Maisie 95 73 51 66 Mandaogane Justice 89 80 49 62 Cole Harlem 60 64 88 67 Kaiser Sebastian 59 83 68 69 Michael Sasha 74 65 65 75 Alvarez Sekani 76 88 64 48 Fields Meadow 69 79 65 Mcbride Brecken 68 77 59 Bumber Phoenix 70 53 87 626 70 61 Darrow Maren 86 86 45 54 Yao Ahmed 72 84 42 70 Johnson Demetrius 64 69 62 73 Lloyd Graham 76 75 51 64 Braughton Daniela 76 86 46 56 Krider Estella 64 57 99 47 Jon-Ubabuco Casen 70 72 66 50 Chen Ryker 56 47 90 45 Okulate Ibrahim 26 87 56 69 Shurtleff Andrew 73 53 40 68 Antone Jayson 52 74 81 25 Lima Sahana 56 60 59 56 Xuan Lian 56 56 46 68 Hollister Cannon 53 48 85 36 Nolen Larry 59 45 46 61 Soppin Kaysen 56 53 42 54 Kaskas Pablo 47 27 98 34 Catral Rex 60 47 45 45 White Rajesh 54 29 74 32 Omana Clarissa 31 33 77 46 Koroma Clay 39 42 46 53 Glover Cassandra 46 30 98 0 Bradley Jesse 40 32 45 37 McCartt Brantley 25 29 59 27 QUESTION 2 For Set 1 data, what is the average score of RAIN? 5 points QUESTION 3 For Set 1 data, what is the average score of AREN? QUESTION 4 For Set 1 data, The grade of student with User ID ELEY is QUESTION 5 For Set 1 data, what is the average score of ELRY? Save Answer 5 points Save Answer 5 points Save Answer 5 points Save Answer QUESTION 6 For Set 1 data, What percentage got B or D? 5 points QUESTION 7 For Set 1 data, what is the class average? QUESTION 8 For Set 1 data,, what is the Average of the students whose UserID's do not start with letter L? Save Answer 5 points Save Answer 5 points Save Answer QUESTION 9 5 points Save Answer For Set 1 data, what is the Average of the students whose UserID's start with letter A? Last Name First Name UserID Test 1 Test 2 Test 3 Test 4 Average Grade Redfield Logan OGLD 94 89 91 90 94.73 A Goodwin Jon ONIN 97 90 87 93 94.68 A Verma Zaniyah 91 88 90 98 Ahmad Kalel 92 87 89 90 Jurecki Oaklee 83 85 97 80 Krueger Mohamed 85 79 94 82 Wood Tristian 88 96 79 79 McMillan Melvin 85 93 78 82 Waldrop Alma 85 86 100 70 Swaim Shruti 88 85 82 75 Shepherd Manuel 83 78 87 81 Taylor Gatlin 82 87 89 71 Wurz Alexandria 91 93 54 94 Baugh Winnie 80 90 65 91 Harry Melany 91 77 72 85 Jain Brandon 72 72 99 88 King Miles 92 90 74 68 Browne Emory 76 70 88 88 Govindappa Talon 86 79 68 88 Buquet Oscar 76 81 90 73 Corley Felix 73 84 91 72 Price Lian 81 78 83 77 Tao Paris 84 81 71 83 Robinson Lyric 81 83 81 73 Hensley Lauren 92 90 45 91 Cangelosi Yaretzi 90 73 63 90 Sturm Ariel 90 49 85 94 Bryant Hunter 92 88 46 90 Melton Atlas 85 83 80 66 Kimbrell Boston 93 90 79 54 Torres Serena 89 60 73 90 Morris Brandon 86 84 72 69 Schuhmacher Helena 89 78 72 71 Mathew Kinley 89 79 58 83 Aird Reign 88 80 53 85 User Ezra 93 93 74 47 Fernandez Rylie 71 75 84 73 Aziz John 78 64 86 74 1. Create UserID which consists of the 2nd and 3rd letter of the 1st name and the last 2 letters of the last name. 2. Find Average after a. adding 20% to the highest test score (but not going past 100) b. adding 10% to the lowest score 3. Assign grades Use Vlookup or IFS. 0 to <58: F; 58 to <69: D; 69 to < 77: C; 77 to < 86: B, Use proper Excel functions to be more efficient as on the test, You'll have very limited time to answer these questions. You'll not be able to sort or Filter or copy data to another Excel sheet. 86 or more: A Whitaker Ayleen 75 81 72 73 Canessa Edison 90 23 99 98 Shah Jaylin 83 60 78 78 Song Makenzie 87 82 84 46 Baer Leland 79 68 75 76 Naik Henrik 84 82 50 82 Jain Kamryn 89 73 48 86 Nwaekwe Dallas 94 89 44 72 Sandlin Angie 60 80 89 66 Garcia Addilyn 81 87 64 63 Singh Emory 87 79 56 73 Tsai Dilip 83 70 64 77 Chism Jakob 85 69 56 83 Mackey Creed 70 63 96 68 Rusek Justin 88 74 45 86 Mahapatra Cadence 74 74 71 73 Baqatyan Charli 96 82 40 78 Marchese Xander 84 81 45 81 Danalian Aditi 89 68 45 88 Zhu Estella 87 85 45 72 Vuga Bodie 96 95 67 35 White Zaiden 64 83 67 70 Yang Ayan 90 86 41 66 Robles Mustafa 79 92 40 72 Moran Maisie 95 73 51 66 Mandaogane Justice 89 80 49 62 Cole Harlem 60 64 88 67 Kaiser Sebastian 59 83 68 69 Michael Sasha 74 65 65 75 Alvarez Sekani 76 88 64 48 Fields Meadow 69 79 65 Mcbride Brecken 68 77 59 Bumber Phoenix 70 53 87 626 70 61 Darrow Maren 86 86 45 54 Yao Ahmed 72 84 42 70 Johnson Demetrius 64 69 62 73 Lloyd Graham 76 75 51 64 Braughton Daniela 76 86 46 56 Krider Estella 64 57 99 47 Jon-Ubabuco Casen 70 72 66 50 Chen Ryker 56 47 90 45 Okulate Ibrahim 26 87 56 69 Shurtleff Andrew 73 53 40 68 Antone Jayson 52 74 81 25 Lima Sahana 56 60 59 56 Xuan Lian 56 56 46 68 Hollister Cannon 53 48 85 36 Nolen Larry 59 45 46 61 Soppin Kaysen 56 53 42 54 Kaskas Pablo 47 27 98 34 Catral Rex 60 47 45 45 White Rajesh 54 29 74 32 Omana Clarissa 31 33 77 46 Koroma Clay 39 42 46 53 Glover Cassandra 46 30 98 0 Bradley Jesse 40 32 45 37 McCartt Brantley 25 29 59 27 QUESTION 2 For Set 1 data, what is the average score of RAIN? 5 points QUESTION 3 For Set 1 data, what is the average score of AREN? QUESTION 4 For Set 1 data, The grade of student with User ID ELEY is QUESTION 5 For Set 1 data, what is the average score of ELRY? Save Answer 5 points Save Answer 5 points Save Answer 5 points Save Answer QUESTION 6 For Set 1 data, What percentage got B or D? 5 points QUESTION 7 For Set 1 data, what is the class average? QUESTION 8 For Set 1 data,, what is the Average of the students whose UserID's do not start with letter L? Save Answer 5 points Save Answer 5 points Save Answer QUESTION 9 5 points Save Answer For Set 1 data, what is the Average of the students whose UserID's start with letter A?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
My question is how to write the code in WareHouse.java This is WareHouse.java package warehouse; /* * * This class implements a warehouse on a Hash Table like structure, * where each entry of the...
-
aj b) If the magnitude of the force F is 700 N, what is the value of the internal moment at point A in N.m? d) 0.5 m 540 180 210 A 0.8 m 240 Bo birak F A
-
Describe the processes of chemical weathering and mechanical weathering. How do these processes contribute to the recycling of rocks?
-
Consider a mixture of two gases A and B. Show that when the mass fractions mfA and mfB are known, the mole fractions can be determined from where MA and MB are the molar masses of A and B. and = 1-ya
-
What is a learning curve? Under what circumstances should learning curve effects be used in cost estimation of project activities?
-
Joint costs and byproducts. (W. Crum adapted) Royston, Inc., is a large food processing company.It processes 150,000 pounds of peanuts in the peanuts department at a cost of $180,000 to yield12,000...
-
Selling price per unit on the intermediate market Variable costs per unit Fixed costs per unit (based on capacity) Capacity in units $ 112 $ 94 $ 8 25,000 Sako Company has a Hi-Fi Division that could...
-
The Hotel Pariss competitive strategy is To use superior guest service to differentiate the Hotel Paris properties, and to thereby increase the length of stay and return rate of guests, and thus...
-
Question 1 [15 marks] The tallest dam in the world is the 1001-ft-high Jinping-1 Dam constructed on the River Yalong in China. Its primary purpose is to generate hydroelectric power. There are...
-
Make a Range Control Chart. Labelling the X-axis "Sample Number" and the Y-axis "Sample Range". The data above is not meant to be divided up; it's one continuous string of data. Please show all...
-
This lab practices with inheritance and function overriding by having you create characters from the game "Among Us". We provide a very basic gameplay in main.cc, and you do not need to edit this...
-
Find currents I, I2 and 13 based on the following circuit: 3 9V 122 ^^^ AAA 202 102 6 V 122 [a] Write linear equations in terms of I1, I2 and 13 based on the given circuit. [b] Write the equations...
-
Pivot the matrix about the circled element. 714 4 1(2) 6 2 0 2 3 -1 The result of pivoting is -8 3 -3
-
Port Accounting performs two types of services, Audit and Tax. Port's overhead costs consist of computer support, $240,000; and legal support, $120,000. Information on the two services is: Audit Tax...
-
Conduct a VRIO analysis by ranking Husson University (in Maine) business school in terms of the following six dimensions relative to the top three rival schools. If you were the dean with a limited...
-
Prove that \(B(x ; n, p)=1-B(n-x-1 ; n, 1-p)\).
-
Prove that \(b(x ; n, p)=b(n-x ; n, 1-p)\).
-
With reference to Exercise 4.5, find an expression for the distribution function \(F(x)\) of the random variable. Data From Exercise 4.5 k 4.5 Given that f(x): = is a probability distribution for 2x...
Study smarter with the SolutionInn App