Calculate the average and standard deviation for the set of exam scores shown in the accompanying table. Using a 90% = A,80% B, and so on, grading scale, what is the average grade on the exam? Scores 92 81 72 67 93 89 75 84 66 90 55 90
Calculate the average and standard deviation for the set of exam scores shown in the accompanying table. Using a 90% = A,80% B, and so on, grading scale, what is the average grade on the exam? Scores 92 81 72 67 93 89 75 84 66 90 55 90
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
Can you help me to do this problem in excel , can you show me the steps and formulas please
Transcribed Image Text:MS
Statistics Functions.
7.1 Exam Scores
Calculate the average and standard deviation for the set of exam scores shown in
the accompanying table. Using a 90% = A,80% = B, and so on, grading scale, what
is the average grade on the exam?
ys.
Scores
92
81
72
67
93
89
75
84
66
90
55
90
![Problems 253
3. Enter the =TRANSPOSE (matrix) array
4. Complete the transpose operation by pressing [Ctrl-Shift-Enter] to transpose
the matrix and place the formula in every cell in the result matrix.
Invert a Matrix
function.
Requirement: Only a square, nonsingular matrix can be inverted. (A nonzero
determinant indicates a nonsingular matrix.)
Process: Complex; fortunately it is handled by the MINVERSE function. To
invert a matrix:
1. Enter the matrix to be inverted, and name it (optional).
2. Indicate where the inverted matrix should be placed and the correct size
(same size as original matrix).
3. Enter the =MINVERSE (matrix) array function. The matrix to be inverted
can be indicated by name or cell range.
4. Press [Ctrl-Shift-Enter] to enter the array function in all the cells making up
the result matrix.
Matrix Determinant
Requirement: The determinant is calculated only for a square matrix.
Process: Complex; fortunately it is handled by the MDETERM function. T
calculate the determinant of a matrix:
1. Enter the matrix.
2. Use the formula =MDETERM (matrix) to calculate the determinant of t
matrix.
Solving Systems of Linear Equations
Requirement: Must be as many equations as unknowns.
Process:
1. Write the equations in matrix form (coefficient matrix multiplying
unknown vector, equal to a right-hand-side vector).
2. Invert the coefficient matrix.
3. Multiply both sides of the equation by the inverted coefficient matrix.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe8e7ecd1-00b2-4f87-97f4-1e990180b5ce%2F718ada32-6ee4-4544-bc28-5992ddf50d0c%2Fy0fvu6h_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Problems 253
3. Enter the =TRANSPOSE (matrix) array
4. Complete the transpose operation by pressing [Ctrl-Shift-Enter] to transpose
the matrix and place the formula in every cell in the result matrix.
Invert a Matrix
function.
Requirement: Only a square, nonsingular matrix can be inverted. (A nonzero
determinant indicates a nonsingular matrix.)
Process: Complex; fortunately it is handled by the MINVERSE function. To
invert a matrix:
1. Enter the matrix to be inverted, and name it (optional).
2. Indicate where the inverted matrix should be placed and the correct size
(same size as original matrix).
3. Enter the =MINVERSE (matrix) array function. The matrix to be inverted
can be indicated by name or cell range.
4. Press [Ctrl-Shift-Enter] to enter the array function in all the cells making up
the result matrix.
Matrix Determinant
Requirement: The determinant is calculated only for a square matrix.
Process: Complex; fortunately it is handled by the MDETERM function. T
calculate the determinant of a matrix:
1. Enter the matrix.
2. Use the formula =MDETERM (matrix) to calculate the determinant of t
matrix.
Solving Systems of Linear Equations
Requirement: Must be as many equations as unknowns.
Process:
1. Write the equations in matrix form (coefficient matrix multiplying
unknown vector, equal to a right-hand-side vector).
2. Invert the coefficient matrix.
3. Multiply both sides of the equation by the inverted coefficient matrix.
Expert Solution
Step 1
Excel is used to perform different mathematical calculations provided the data . It is one of the most important
applications that is used to solve complex calculations .
The Average can be obtained by the sum of the quantities divided by the number of quantities . We can also find the
Standard deviation of the values using the excel . Each cell in Excel can be recognized by the column and the row
identifier.
The grade of scores is calculated by examining the Average and if the result is greater than or equal to 90 the grade is A,if
the the result is greater than or equal to 80 the grade is B,if the result is greater than or equal to 70 the grade is C,if the
result is greater than or equal to 60 the grade is D, any other value is considered as Fail.
Step by step
Solved in 3 steps with 1 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY