Determine the number of students receiving each letter grade

Assignment Help Finance Basics
Reference no: EM131668770

Question: Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455). He has thus far constructed a spreadsheet, part of which follows:

699_43.png

a. The Course Average is calculated by weighting the Midterm Score and Final Score 50 percent each. Use the VLOOKUP function with the table shown to generate the Course Grade for each student in cells E14 through E24.

b. Use the COUNTIF function to determine the number of students receiving each letter grade.

Reference no: EM131668770

Questions Cloud

Calculate the payment for a loan based on constant payments : A few years back, Dave and Jana bought a new home. They borrowed $230,415 at an annual fixed rate of 5.49 percent (15-year term) with monthly payments.
What is the size of the shortage : At a price of P = 36, what is the size of the shortage that will exist in the market?
Is it wise to take out a loan for a start-up company : Is it wise to take out a loan for a start-up company or pursue ways of building the capital yourself?
Find the price elasticity of demand : At this price, find the price elasticity of demand. USE THE POINT SLOPE METHOD to find this elasticity. Hint: You'll have to find the quantity at this price.
Determine the number of students receiving each letter grade : Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455).
Manufacturing process yields shafts : The manufacturing process yields shafts with a mean of 20.005 mm and a standard deviation of .004 mm.
How well companys strategic choices align with firm strength : how well a companys strategic choices align with firm strengths, weaknesses, opportunities, and threats, making recommendations for change in corporate-level
Substitution effect on charlie apple consumption : Charlie's utility function is xAxB. The price of apples used to be $1, the price of bananas used to be $2, and his income used to be $40.
Review problem related to the floyd bumpers : Floyd's Bumpers pays a transportation company to ship its product in full truckloads to its customers. Therefore, the cost for shipping is a function.

Reviews

Write a Review

Finance Basics Questions & Answers

  Determine the value today of one of bonds

Determine the value today of one of these bonds to an investor who requires a 14% rate of return on these securities?

  Would you recommend renewing the loan or demand repayment

Similarly, if you were the bank loan officer, would you recommend renewing the loan or demand its repayment?Would your actions be influenced if in early 2009 D'Leon showed you its 2009 projections along with proof that it was going to raise more than..

  Why does a rise in the level of interest rates adversely

why does a rise in the level of interest rates adversely affect the market value of both assets and

  Compute the effective interest rate on the note payable

Memminger Corporation purchased equipment on January 1, 2012. The terms of the purchase required that the company pay $1,000 in interest at the end of each year for five years and $20,000 at the end of the fifth year. The FMV of the equipment on J..

  Draw a cumulative frequency polygon

Midland national bank selected a sample of forty student checking accounts. Below are their end-of-month balances.

  Calculate the exercise price of call option

You bought a call option with a strike price of $25 on Fox stocks that are currently selling at $35 a share. The call option is trading at $4.50.

  Books of a kiltuu pension fund

The following account balances were extracted form the books of a kiltuu pension fund for the year ended 30thJune 19X7:

  What is the maximum possible price of a put option on

Consider the July 2009 IBM call and put options in Problem 3. Ignoring the negligible interest you might earn on TBills over the remaining few days’ life of the options, show that there is no arbitrage opportunity using put-call parity for the option..

  A corporate bond is sold at 91381 and it will mature in six

a corporate bond is sold at 913.81 and it will mature in six years. its ytm is 11. what is the annual coupon rate of

  How rulings by the courts and regulators have made

Explain how rulings by the courts and regulators have made the markets served by both commercial and investment banks more competitive.

  The softtec products company is a successful small rapidly

the softtec products company is a successful small rapidly growing closely held corporation. the equity owners are

  The hedge may reduce reported earnings prior

Which of the following types of contracts are generally excluded from SFAS 133 accounting rules (including fair market value adjustment rules)?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd