Solution-Calculate the average min and max for each exam

Calculate the average min and max for each exam

Assignment Help Accounting Basics

Reference no: EM131542639

Assignment

Dr Fencil gives 5 exams during the semester, but throws out the lowest grade when determining the final grade.

- Calculate the average, min and max for each exam.
- Use formula to show total for each student based on four best exam scores.
- Use formula (vlookup or Nested IF) to find grade
- Create a clustered column chart to show student grades for each exam.

Dr Fencil's Gradebook
Assignment	Exam1	Exam2	Exam3	Exam4	Exam5	Total	Percent	Grade
Points	100	100	100	100	100
Student
Alice	87	100	80	88	97
Bob	76	97	87	88	90
Carol	84	82	73	87	0
David	65	70	0	68	56
Edith	78	100	75	87	0
Fred	89	90	87	74	80
Gwen	75	80	65	65	88
Henry	86	88	92	78	90

Average
Max
Min

Percent Range	Grade
90-100	A
80-89.9	B
70-79.9	C
60-69.9	D
below 60	F

Reference no: EM131542639

Questions Cloud

Describe and rationalize your plan : choose a concept or question that is relevant to class - identify THREE different sources that address the concept - write an essay explaining and justifying

Determine the average cost of manufacturing : Determine the average cost of manufacturing one custom greenhouse assuming the units given. How does a company identify each type of cost

Discuss the cultural factors organizations : Discuss the cultural factors organizations must understand in order to do business on a global scale. Support your reasoning.

What does the statement its a myth mean : How is the word myth used popularly? For example, what does the statement, "It's a myth" mean? In contrast, how is the word myth used in the academic context?

Calculate the average min and max for each exam : Calculate the average, min and max for each exam. Use formula to show total for each student based on four best exam scores.

Important economic principle you learned : What is the most important economic principle you learned from the course?

Describe the methodology behind constructing one : Summarize the project requirements and other assumptions (e.g., budget, human resources, workload, environmental dependencies, etc.).

Assess your current or most recent place of employment : Assess your current or most recent place of employment.Policy Statement against this form of violence in the workplace.

Describe the features of product : Based on this new information, and the evaluation you have already completed, make a recommendation of which EHR Liverty should choose.

User Account

All Pages

Calculate the average min and max for each exam

Reference no: EM131542639

Reference no: EM131542639

Questions Cloud

Reviews

Write a Review

Accounting Basics Questions & Answers

How much control does fed have over this longer real rate

Coures:- fundamental accounting principles

Accounting problems

Theory of interest - term structure of interest rates

Write a report on internal controls

Prepare the bank reconciliation for company

Cost-benefit analysis

Theory of interest

Liquidity and profitability

What is the expected risk premium on the portfolio

Simple interest and compound interest

Capm and venture capital

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT