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

![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)

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









