Home G4 15 16 17 Paste 18 1 Names 2 Max 3 Alpha 4 Bravo 5 Charlie 6 7 8 9 10 11 12 13 14 19 20 Insert A. A Draw Page Layout Calibri (Body) BIU x ✓ fx B Midterm 100 88 94 58 92 V 83 75 75 67 82 97 78 39 81 78 77 16 Formulas Data Review A A A 22242HDGE 20 20 18 14 Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Final 20 20 20 22 20 25 23 11 15 20 21 21 16 8 20 25 17 18 17 20 4 12 11 19 = = = = = € ∞ w w-POP8 20 21 10 25 19 24 23 15 24 1 25 3 View 3 5 12 8 16 6 20 Tell me 8 9 ab Wrap Text Merge & Center 8 13 24 1 17 23 15 5 6 General 14 15 13 25 22 5 $%9 4 12 11 19 19 24 23 15 24 1 H .00 100 79 85 88 95 100 90 83 85 92 96 86 82 89 84 92 -0000 V Cell Conditional Format Formatting as Table Styles I J SD IX V M Insert K Delete Each of the 5 assignments is graded out of 20 points and assignments are worth 35% on the final grade, the mid-term is worth 15% and final is worth 50% What formula would you enter in cell 14 to calculate final grade for Bravo and be able to copy for all students to calcuate their grades if all grades count. v Format L
Home G4 15 16 17 Paste 18 1 Names 2 Max 3 Alpha 4 Bravo 5 Charlie 6 7 8 9 10 11 12 13 14 19 20 Insert A. A Draw Page Layout Calibri (Body) BIU x ✓ fx B Midterm 100 88 94 58 92 V 83 75 75 67 82 97 78 39 81 78 77 16 Formulas Data Review A A A 22242HDGE 20 20 18 14 Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Final 20 20 20 22 20 25 23 11 15 20 21 21 16 8 20 25 17 18 17 20 4 12 11 19 = = = = = € ∞ w w-POP8 20 21 10 25 19 24 23 15 24 1 25 3 View 3 5 12 8 16 6 20 Tell me 8 9 ab Wrap Text Merge & Center 8 13 24 1 17 23 15 5 6 General 14 15 13 25 22 5 $%9 4 12 11 19 19 24 23 15 24 1 H .00 100 79 85 88 95 100 90 83 85 92 96 86 82 89 84 92 -0000 V Cell Conditional Format Formatting as Table Styles I J SD IX V M Insert K Delete Each of the 5 assignments is graded out of 20 points and assignments are worth 35% on the final grade, the mid-term is worth 15% and final is worth 50% What formula would you enter in cell 14 to calculate final grade for Bravo and be able to copy for all students to calcuate their grades if all grades count. v Format L
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question

Transcribed Image Text:Home
G4
6
7
1
2 Max
3 Alpha
4 Bravo
5
8
9
10
11
12
13
14
15
16
17
18
Paste
19
20
21
Insert Draw Page Layout
X
P
Names
A.
A
Charlie
V
Calibri (Body)
BIU✔
× ✓
fx
B
Midterm
100
88
16
94
58
92
83
75
75
67
82
97
78
39
81
78
77
Formulas Data Review
A A
Av
20
25
17
18
17
20
4
12
11
19
D
=== ==
C
E
F
G
Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Final
20
20
20
20
20
22
8
20
18
14
AHHAHEEN
20
21
10
25
19
24
23
15
24
1
25
View
3
3
5
12
8
25
23
11
15
20
21
21
16
8
16
6
20
Tell me
8
9
Wrap Text
Merge & Center v
13
24
1
17
23
15
5
6
14
15
13
25
22
General
5
$ %
V
9
% 95.000
4
12
11
19
19
24
23
15
24
1
H
100
79
85
88
95
100
90
83
85
92
96
86
82
89
84
92
‒‒‒
I
Conditional Format. Cell
Formatting as Table Styles
V
J
4
MIX ✔
Insert Delete
K
Each of the 5 assignments is graded out of 20 points and assignments are worth 35% on the final grade, the mid-term is worth 15% and final is worth 50%
What formula would you enter in cell 14 to calculate final grade for Bravo and be able to copy for all students to calcuate their grades if all grades count.
Format
L
Expert Solution

Step 1
Given the names and midterm marks of 5 students in an Excel file. We have to write a formula which we will enter in cell I4 to calculate the final grade for Bravo.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman