1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
devlian [24]
4 years ago
14

Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the form

ulas. Calculate the average, highest, and lowest values for each of the following:a. Price b. MPG City c. MPG Highway d. Average MPG e. Maintenance/Year f. Registration Fee g. Insurance /Year h. Amount to Borrow i. APR j. Years k. Loan Payment l. Gas m. Maintenance/Month n. Insurance/Month o. Total Monthly
Business
1 answer:
hram777 [196]4 years ago
5 0

Answer:

The formula for average is =AVERAGE(E15,E16).

The formula for highest is =MAX(F15,F16).

The formula for lowest is =MIN(G15,G16).

Explanation:

In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13

The formula for average is =AVERAGE(E15,E16).

The formula for highest is =MAX(F15,F16).

The formula for lowest is =MIN(G15,G16).

The cells provided in the formula above is just an example and more than two cells can be selected.

You might be interested in
The best supplier will depend on the type of business. Explain how a business that specializes in supplying plumbers would have
IgorLugansk [536]

Answer:

the $$$ of the different thing will play a big part

7 0
3 years ago
The Federal Reserve purchases ​$8 million in U.S. Treasury bonds from a bond​ dealer, and the​ dealer's bank credits the​ dealer
Zinaida [17]

Answer:

The bank will be able to lend:

$42,105,263 ($8 million/ 0.19)

Explanation:

The above amount which the bank can lend from the $8 million received from the Federal Reserve for a customer is a function of $8 million deposit in a customer's account and the reserve ratio.  This is called the money multiplier.

The money multiplier is the amount of money that banks generate with each dollar of reserves. Reserves is the amount of deposits that the Federal Reserve requires banks to hold and not lend.  The level of Reserves and deposit liabilities determine the amount a bank can lend out.

The process by which banks create more money than the physical money is called money creation.  This shows that a bank creates more money in the economy through its lending activities.

6 0
3 years ago
Mountaineer Excavation operates in a low-lying area that is subject to heavy rains and flooding. Because of this, Mountaineer pu
Serjik [45]

Explanation:

1. The journal entry is as follows:

On March 1

Prepaid insurance A/c Dr $36,000

       To Cash A/c $36,000

(Being the prepaid insurance is recorded for cash)

For recording the advance purchase of insurance, we debited the prepaid insurance and credited the cash account. Both the accounts are recorded at $36,000 so that the proper posting could be done.

4 0
3 years ago
In January, 2006, Findley Corporation purchased a patent for a new consumer product for $720,000. At the time of purchase, the p
bezimeni [28]

Answer:

b. $360,000.

Explanation:

Data provided in the question

Purchase value of the patent = $720,000

At the time of purchase, the patent life is 15 years

And, the useful life of the patent is 10 years

So, the amortization expense recorded value is

= $720,000 ÷ 10 years × 5 years

= $360,000

The five years is counted from the year 2006 to the year 2011

8 0
3 years ago
On January 1, a company issues bonds dated January 1 with a par value of $730,000. The bonds mature in 3 years. The contract rat
quester [9]

Answer:

a. Debit interest expense $38,500; credit discount on bonds payable $2,000; credit cash $36,500

Explanation:

As the bonds are sold less than the face vaue then it is said the bonds are issued on discount, we need to calculate the discount on the bond

Discount on the bond = Face value of bond - Issuance value of bond = $730,000 - $718,000 = $12,000

The discount will be amortized over the life of the bond

The first interest and its amortization is as follow

Cash Payment = Face value x Coupon rate x Semiannual fraction = $730,000 x 10% x 6/12 = $36,500

Amortization of discount on bond = Discount on Bond / Total Numbers of periods = $12,000 / ( 3 years x 2 payment period per year ) = $2,000 per eperiod

The cash will be credited by $36,500

The bond liability will be credited by $2,000

Hence the interest exepense will be debited by $38,500 ( $36,500 + $2,000 )

6 0
3 years ago
Other questions:
  • An applicant for an individual health policy failed to complete the application properly. Before being able to complete the appl
    10·1 answer
  • Explain what the domino theory is and how it fits with the truman doctrine ?
    14·1 answer
  • A job order cost accounting system provides for a separate record of the cost of each particular quantity of product that passes
    8·1 answer
  • Citicorp buys a call option on Euro (contract size is Euro 2,000,000) at a premium of $0.02 per Euro. If the exercise price is $
    5·1 answer
  • Mr. and Mrs. Pitt filed a joint tax return in 2017. The couple divorced in 2018. The IRS audited their 2017 return and determine
    11·1 answer
  • Which of the following statements best defines the term credit according to the text?
    6·1 answer
  • Until the 2003 playoffs, NBA had used a best-of-five format for the first-round series, that is, the series would end as soon as
    12·1 answer
  • What is human resources in south Africa​
    14·1 answer
  • When the economy took a downturn and jobs were difficult to find, many people blamed immigrants. What would be a good explanatio
    15·1 answer
  • The extra costs incurred to avoid holding cash when there is inflation are called the?
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!