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]
3 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]3 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
Mondale Winery depreciates its equipment using the group method. The cost of equipment purchased in 2021 totaled $565,000. The e
beks73 [17]

Answer:

$90,400

Explanation:

Mondale Winery depreciates it's equipment by making use of the group method.

The cost of equipment that was purchased in 2021 totaled $565,000

The residual value of the equipment was $54,000

The group depreciation rate is 16%

= 16/100

= 0.16

Therefore, the annual depreciation can be calculated as follows

Annual depreciation= Cost of equipment × Group depreciation rate

= $565,000×0.16

= $90,400

Hence the annual depreciation for the group is $90,400

4 0
3 years ago
On January 1, Graves Corporation had 60,000 shares of no-par common stock issued and outstanding. The stock has a stated value o
Zina [86]

Answer:

Date        Account Titles and Explanation     Debit          Credit

June 15   Cash Dividends                              $103,500

               [(60000+9000)*$1.5]

                        Dividends payable                                     $103,500

                (Being dividend declared for 69000 shares at $1.5 each)

July 10     Dividends payable                        $103,500

                         Cash                                                          $103,500

                (Being dividend paid)

Dec 15      Cash Dividends                             $116,800

                [(60000+9000+4000)*1.6]

                          Dividends payable                                   $116,800

                (Being dividend declared for 73000 shares at $1.6 each)

6 0
2 years ago
Explain 10 reasons why a joint stock company is preferable to a one man's business<br>​
mart [117]

Answer:

Advantages of a Joint Stock Company

One of the biggest drawing factors of a joint stock company is the limited liability of its members. their liability is only limited up to the unpaid amount on their shares. Since their personal wealth is safe, they are encouraged to invest in joint stock companies

The shares of a company are transferable. Also, in the case of a listed public company they can also be sold in the market and be converted to cash. This ease of ownership is an added benefit.

Perpetual succession is another advantage of a joint stock company. The death/retirement/insanity/etc does affect the life of a company. The only liquidation under the Companies Act will shut down a company.

A company hires a board of directors to run all the activities. Very proficient, talented people are elected to the board and this results in effective and efficient management. Also, a company usually has large resources and this allows them to hire the best talent and professionals.

Disadvantages of a Joint Stock Company

One disadvantage of a joint stock company is the complex and lengthy procedure for its formation. This can take up to several weeks and is a costly affair as well.

According to the Companies Act, 2013 all public companies have to provide their financial records and other related documents to the registrar. These documents are then public documents, which any member of the public can access. This leads to a complete lack of secrecy for the company.

And even during its day to day functioning a company has to follow a numerous number of laws, regulations, notifications, etc. It not only takes up time but also reduces the freedom of a company

A company has many stakeholders like the shareholders, the promoters, the board of directors, the employees. the debenture holders etc. All these stakeholders look out for their benefit and it often leads to a conflict of

Explanation:

6 0
3 years ago
Huprey Co. is the defendant in the following legal claims. For each of following claims, does Huprey (a) record a liability, (b)
salantis [7]

Answer:

1. Huprey can resonably estimate that a pending lawsuit will result in damages of $1,280,000, it is probable that Huprey will lose the case.

  • Record a liability.  

2. It is reasonably possible that Huprey will lose a pending lawsuit. The loss cannot be estimable.

  • Disclose in notes.

3. Huprey is being sued for damages of $2,400,000. It is very unlikely (remote) that Huprey will lose the case.

  • Have no disclosure.

Explanation:

Contingent liabilities must be recorded only when it is probable that the liability will happen and you can estimate the associated costs.

When contingent liabilities are only reasonably possible or you cannot estimate the amount, they must be included in the footnotes of the financial statements.

When contingent liabilities are not reasonably possible, nothing needs to be disclosed.

7 0
3 years ago
Chester's product manager is considering lowering the price of the Cone product by $2.50 and wants to know what the impact will
lozanna [386]

Answer:

The contribution margin will decrease by 2.50

Explanation:

Sales \: Revenue - Variable \: Cost = Contribution \: Margin

IF sales decreases, then the contribution margin decreases.

That's because, there is less money to pay for the variable cost.

The company will also have to sale more units to break even, as now each units contribution is fewer.

Cone's should evaluate how much their sales are expected to increase for the lower price and be cautious

7 0
3 years ago
Other questions:
  • Which type of bank account typically offers the least <br> interest?
    11·1 answer
  • Paul's Dogs Corp. has 9 percent coupon bonds making annual payments with a YTM of 8.5 percent. The current yield on these bonds
    14·1 answer
  • During the year, Bassett Company paid a total of $58,000 for inventory. In one transaction, Bassett sold inventory that had cost
    12·1 answer
  • What is the difference between an "I" statement and a "You" statement? A. The "I" statement is non-confrontational b. The "You"
    6·2 answers
  • Which statement best describes the laissez-faire economic policies of the 1920s? There should be extensive government control of
    10·2 answers
  • Whats a SIMPLE topic setance for why Autumn is my favorite season
    10·1 answer
  • Classify the following exchanges as "Qualifying" or "Not Qualifying" as a like-kind exchange under § 1031. Qualifies / Not Quali
    5·1 answer
  • Markung's Co. is 100% equity-financed company (no debt or preferred stock); hence, its WACC equals it cost of common equality. M
    5·1 answer
  • The following data are available relating to the performance of Seminole Fund and the market portfolio: Seminole Market Portfoli
    11·1 answer
  • In the case where a broker was found guilty of license law violations and the Recovery Fund was required to pay a judgment of $8
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!