Need formula. 4. Answer all of the following questions using Excel function(s). (5 pts each, 25...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Need formula. 4. Answer all of the following questions using Excel function(s). (5 pts each, 25 pts in total) 2 a. Compute the average of midterm and final exam grades for each student (use one decimal) 3 b. Assign grades: A if avg >=90, B if avg >=80, C if avg >=70. D if avg >=60, and F otherwise. 4 c. Label "Excellent" if both midterm and final >=90. 5 d. Label "Good" If either midterm or final >>#90. 6e. Mark if the average <60 7 8 Student Midterm 9 1 76 10 84 11 2 RA 29858 12 4 13 5 14 6 15 7 16 8 17 9 18 10 19 2 20 3 21 22 79 88 65 94 92 87 62 92 Final Exam a. Average b. Letter Grade c. Excellent performers d. Good performers e. Attention 70.5 87.0 73.5 86.0 67.5 65 90 68 84 70 93 90 93 55 85 93,5 91.0 90.0 58.5 88.5 Need formula. 4. Answer all of the following questions using Excel function(s). (5 pts each, 25 pts in total) 2 a. Compute the average of midterm and final exam grades for each student (use one decimal) 3 b. Assign grades: A if avg >=90, B if avg >=80, C if avg >=70. D if avg >=60, and F otherwise. 4 c. Label "Excellent" if both midterm and final >=90. 5 d. Label "Good" If either midterm or final >>#90. 6e. Mark if the average <60 7 8 Student Midterm 9 1 76 10 84 11 2 RA 29858 12 4 13 5 14 6 15 7 16 8 17 9 18 10 19 2 20 3 21 22 79 88 65 94 92 87 62 92 Final Exam a. Average b. Letter Grade c. Excellent performers d. Good performers e. Attention 70.5 87.0 73.5 86.0 67.5 65 90 68 84 70 93 90 93 55 85 93,5 91.0 90.0 58.5 88.5
Expert Answer:
Answer rating: 100% (QA)
To fill out the Excel sheet according to the requirements here are the formulas you need for each co... View the full answer
Related Book For
Statistics Data Analysis And Decision Modeling
ISBN: 9780132744287
5th Edition
Authors: James R. Evans
Posted Date:
Students also viewed these programming questions
-
Describe a scenario where the social network benefited the organization. How did you harness the network to accomplish your work task? For example, one might describe how they used a friendship with...
-
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...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The 2017 financial statements for the Thor and Gunnar companies are summarized below. These two companies are in the same business and in the same province but in different cities. One-half of Thor?s...
-
Is fragmentation needed in concatenated virtual-circuit internets or only in datagram systems?
-
In Exercises 1 and 2, mark each statement True or False. Justify each answer. 1. a. The equation Ax = b is referred to as a vector equation.
-
A recent survey of the Youth Health Information Desk at the Catholic University of the Sacred Heart, Rome, enquired about health awareness among students. The respondents voluntarily attended classes...
-
Items 1 through 6 represent the items that an auditor ordinarily would find on a client-prepared bank reconciliation. The accompanying List of Auditing Procedures represents substantive auditing...
-
Consider a derivative (1) of salvianolic acid B, an antioxidant and free radical scavenging compound from the root of Salvia miltiorrhiza Bunge, shown below. Answer parts i.- vii. on that molecule or...
-
At June 30, 2022, the end of its most recent fiscal year, Green River Computer Consultants post-closing trial balance was as follows: The company underwent a major expansion in July. New staff was...
-
The comparative balance sheets for the Teal Mountain Beauty Supply Corporation is presented below: TEAL MOUNTAIN BEAUTY SUPPLY CORPORATION Comparative Balance Sheets Assets 2025 2024 Cash $55,000...
-
MargeSimpson Inc. is considering the two capital budeting projects with the following cash flows that have a WACC of 10%. How 'Bout A Pretzel Year What a Falafel -150,000 -150,000 1 30,000 90,000 2...
-
Health and safety guidelines of the organisation dictate that all staff and clients are to wash their hands before handing food. You notice there is no procedure on the washing of hands. You advise...
-
Rondo and his business associate, Larry, are considering forming a business entity called R&L , but they are unsure about whether to form it as a C corporation, an S corporation, or an LLC taxed as a...
-
Describe specific heat capacity and its use in calorimetry.
-
Maria was the sole proprietor of an unincorporated business for many years. In September of 2023, she decided to dissolve her business and retire. She sold a small office building she had used...
-
Figure 3 Analyze the Circuit Using the Mesh-Current Method The circuit in Figure 3 is difficult to solve, since the series/parallel reduction technique and voltage/current division principle cannot...
-
In a system with light damping (c < cc), the period of vibration is commonly defined as the time interval d = 2/d corresponding to two successive points where the displacement-time curve touches one...
-
A study of nonfatal occupational injuries in the United States found that about 31% of all injuries in the service sector involved the back. The National Institute for Occupational Safety and Health...
-
Apply stepwise regression using each selection rule and p value criterion to find a good model for predicting the number of points scored per game by football teams using the data in the Excel file...
-
A college office has one photocopier. Faculty and staff arrive according to a Poisson process at a rate of five per hour. Copying times average seven minutes according to an exponential distribution....
-
A thin stainless steel disk of thickness \(b\) and outer radius \(r_{o}\) has been heat treated to a high, uniform initial temperature of \(T_{i}\). The disk is then placed upon a small stand and...
-
A plane wall of a furnace is fabricated from plain carbon steel \(\left(k=60 \mathrm{~W} / \mathrm{m} \cdot \mathrm{K}, ho=7850 \mathrm{~kg} / \mathrm{m}^{3}, c=430 ight.\) \(\mathrm{J} / \mathrm{kg}...
-
A steel sphere (AISI 1010), \(100 \mathrm{~mm}\) in diameter, is coated with a dielectric material layer of thickness \(2 \mathrm{~mm}\) and thermal conductivity \(0.04 \mathrm{~W} / \mathrm{m} \cdot...
Study smarter with the SolutionInn App