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
What benefits do customers receive in return for the sacrifice they make when buying a membership at Planet Fitness?
Galina-37 [17]

Answer:

Customers receive the following benefits in return for the price they pay when they buy membership at Planet Fitness:

a) Fitness training

b) Physical exercise

c) Relaxation and comfort

d) Clean and safe environment and conducive atmosphere

e) the friendly and courteous staff is a bonus

Explanation:

Planet Fitness operates fitness centers and clubs around the world under franchises.  Planet Fitness has adequate and clean cardio machines, free weights of up to 80 lbs., curl bars, and other strength training equipment and accessories.  The average gym user is offered abundant, 5-star, and world-class Cardio equipment and services.

4 0
3 years ago
A firm has a debt-to-equity ratio of 1.0. If it had no debt, its cost of equity would be 12 percent. Its cost of debt is 9 perce
Tpy6a [65]

Answer:

15%

Explanation:

The computation of the cost of equity in case of no taxes is shown below:

Cost of equity without tax  = Cost of equity + (cost of equity - cost of debt) × debt equity ratio

where,

Cost of equity = 12%

Cost fo debt = 9%

And, the debt equity ratio = 1

Now placing these values to the above formula,

So, the cost of equity without considering the tax is

= 0.12 + (0.12 - 0.09) × 1

= 0.12 + 0.03 × 1

= 0.12 + 0.03

= 0.15

= 15%

6 0
4 years ago
Pacifica Manufacturing retired a computerized metal stamping machine on December 31, 2011. Pacifica sold the machine to another
eduard

Answer:

Depreciation expense $95,000

      To Accumulated depreciation $95,000

(Being the depreciation expense is recorded)

Explanation:

The journal entry is shown below:

Depreciation expense $95,000

      To Accumulated depreciation $95,000

(Being the depreciation expense is recorded)

The computation is shown below:

= (Cost installed - Residual value) ÷ Useful life

= ($920,000 - $160,000) ÷ 8

= $95,000

For recording this journal entry we debited the depreciation expense as it is increased the expenses while at the same time it decreased the value of the fixed assets so the accumulated depreciation is credited

6 0
3 years ago
When there are a large number of relatively small account balances, negative confirmation of accounts receivable is feasible if
sveta [45]

Answer:

The correct option is D

Explanation:

When there are huge number of the small account balances, then the negative confirmation of the accounts receivable is practical or feasible which is issued by an auditor to the customers of client company and if the combination of the control as well as the inherent risk is low and the individuals who receives the confirmation requests which provide them sufficient consideration.

5 0
3 years ago
LaRoe Lawns’ inventory increased during the year by $6.7 million. Its accounts payable increased by $6.6 million during the same
kozerog [31]

Answer:

a. Cash paid to suppliers of merchandise during the reporting period: $44.1 million

b. A summary entry that represents the net effect of merchandise purchases during the reporting period as below:

Dr Cost of goods sold                  44,000,000

Dr Inventory                                   6,700,000

Cr Account Payable                      6,600,00

Cr Cash                                          44,100,000

Explanation:

We have the total amount goods buying from the supplier in the period = Cost of good sold in the period + Difference in the inventory balance of the period = $44 million + $6.7 million = $50.7 million

Thus, the additional amount owed supplier in the period is $50.7 million.

Account Payable increased by 6.6 million, it means that only 44.1 million ( that is, 50.7 million - 6.6 million) is paid during the period.

Thus, the summary will represents: Increase in COGS 44 million ( given); Increase in Inventory 6.7 million (given); Increase in account payable 6.6 million ( given) and Decrease in Cash 44.1 million ( calculated above).

4 0
3 years ago
Other questions:
  • The Junior League of Yadkinville, California, collected recipes from members and pub- lished a cookbook entitled Food for Everyo
    14·1 answer
  • A regional restaurant chain wants to place ads on a local newspaper's website. The marketing team at the restaurant chain knows
    11·1 answer
  • Please answer the questions you can
    5·1 answer
  • The higher the percentage of the active ingredient in a drug
    12·1 answer
  • A broad declaration of the organization's overriding purpose, which is intended to identify the organization's products and cust
    13·1 answer
  • Find the operating cash flow for the year for Harper​ Brothers, Inc. if it had sales revenue of $ 302,400,000​, cost of goods so
    15·1 answer
  • What is the total stockholders' equity based on the following account balances? Common Stock $375,000 Paid-in-capital in excess
    6·1 answer
  • True or False: Most countries in the world use a mix of command and market mechanisms to answer the fundamental economic questio
    11·1 answer
  • Management accountants would not assist in budget planning. prepare reports primarily for external users. be concerned with the
    15·2 answers
  • Jim borrowed $1,400. six months later, he paid back a total of $1,450. how much interest did jim pay?
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!