In the table below, there are test scores from a dozen students. The test was worth 200 points. The scores in the table are the # of points out of 200. Letter grades will be assigned using the standard grade boundaries given below.

You will need to create a new Excel file for this assignment.

1. Create a worksheet with the columns of student names and scores as shown above.
2. Add a column to the right of Test Score labeled “Percentage”
3. Add a column to the right of Percentage labeled “Letter grade”
4. Using absolute addressing, calculate the corresponding percentage score for each student. You must utilize absolute addressing in this formula. (hint – put the total possible score in one separate cell someplace in your worksheet and use it for the first student, then copy and paste).
5. Use the AVERAGE function to calculate the average percentage and display with a label of “Average Percentage”.
6. Use the MAX function to calculate the highest percentage score and display with a label of “Maximum Percentage.”
7. Using VLOOKUP, determine and display the letter grade for each student.

In the table below, there are test scores from a dozen students. The test was worth 200 points. The scores in the table are the # of points out of 200. Letter grades will be assigned using the standard grade boundaries given below.

You will need to create a new Excel file for this assignment.

1. Create a worksheet with the columns of student names and scores as shown above.
2. Add a column to the right of Test Score labeled “Percentage”
3. Add a column to the right of Percentage labeled “Letter grade”
4. Using absolute addressing, calculate the corresponding percentage score for each student. You must utilize absolute addressing in this formula. (hint – put the total possible score in one separate cell someplace in your worksheet and use it for the first student, then copy and paste).
5. Use the AVERAGE function to calculate the average percentage and display with a label of “Average Percentage”.
6. Use the MAX function to calculate the highest percentage score and display with a label of “Maximum Percentage.”
7. Using VLOOKUP, determine and display the letter grade for each student.
8. PLEASE SHOW FORMULAS FOR EACH ENTRY

Examine your last pay check. Determine the percentage of your gross pay that is taken for deductions (including taxes, social security, health care, retirement, etc.). Total these deductions and then divide by your gross pay to determine the percentage. You do not have to disclose the amount of your gross pay or your deductions, but you may share the percentage of your pay that went for these deductions. Does this surprise you? Are there things you could change about this?

A state's environmental agency worries that a larger percentage of cars may be violating clean air standards. In the past, the percentage of cars that violate clean air standards has been 10%. The agency hopes to check a sample of vehicles in order to estimate that percentage with a margin of error of 1% and with 99% confidence.

How many cars should be sampled? Show your work! Formula(s), substitutions, answer! Round your z or t value to 3 decimal places.

In the following Table you are given information on Real GDP and Nominal GDP.

Compute the percentage change in Nominal GDP from 1970 to 1980 (15 points) and the percentage change in Real GDP (15 points) from 1970 to 1980.

Where do you attribute the difference between the two percentage changes?

The body temperatures of a group of healthy adults have a​ bell-shaped distribution with a mean of

98.2198.21degrees°F

and a standard deviation of

0.540.54degrees°F.

Using the empirical​ rule, find each approximate percentage below.

Azure has a job order and the following data have been recorded on its job cost sheet: Direct material $50,000 Direct labour hours 1,000 Direct labour wage rate $25 Machine hours 750 hours Number of units completed 800 The company applies manufacturing overhead on the basis of machine hours and the predetermined overhead rate is $20 per machine hour. Management is now considering whether this job order is profitable or not and how does this job order fare compared to the industry benchmark. Required a) Compute the unit product cost that would appear on the job cost sheet for this job. b) Using a mark-up percentage of 20% of the full product cost, how much profit/loss would this job make? c) Considering the industry benchmark for manufacturing overhead for similar jobs is 50% of direct labour, identify whether this job has a manufacturing overhead lower or higher than a similar job using the industry benchmark. Briefly explain what could cause a difference. ?

NPVs and IRRs for Mutually Exclusive Projects

Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $22,000, whereas the gas-powered truck will cost $17,500. The cost of capital that applies to both investments is 12%. The life for both types of truck is estimated to be 6 years, during which time the net cash flows for the electric-powered truck will be $6,290 per year, and those for the gas-powered truck will be $5,000 per year. Annual net cash flows include depreciation expenses. Calculate the NPV and IRR for each type of truck, and decide which to recommend. Do not round intermediate calculations. Round the monetary values to the nearest dollar and percentage values to two decimal places.

​After-tax cost of debt- Personal Finance Problem  

Bella Wans is interested in buying a new motorcycle. She has decided to borrow the money to pay the $20,000 purchase price of the bike. She is in the 33% income tax bracket. She can either borrow the money at an interest rate of 4​% from the motorcycle​ dealer, or she could take out a second mortgage on her home. That mortgage would come with an interest rate of 8​%. Interest payments on the mortgage would be tax deductible for​ Bella, but interest payments on the loan from the motorcycle dealer could not be deducted on​ Bella's federal tax return.

a.  Calculate the ​after-tax cost of borrowing from the motorcycle dealership.

b. Calculate the ​after-tax cost of borrowing through a second mortgage on​ Bella's home.

c.  Which source of borrowing is less costly for​ Bella?

d.  Should Bella consider any other factors when deciding which loan to take​ out?

a. The​ after-tax cost of borrowing from the motorcycle dealership is _____%. ​(Round to the nearest whole​ percentage.)