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
Which would be an example of sustainable development? a. Current use of fossil fuels in the U.S. b. Heap-leach extraction of gol
Setler [38]

Answer:

The correct answer is letter "D": Development of brownfields in urban areas.

Explanation:

In urban planning, sustainable development refers to continuous activities that can be performed during extended periods of time. They are the result of repeated patterns of individuals who, sometimes unconsciously, provoke more and more individuals to repeat their actions.

Under such a scenario, <em>the development of brownfields in urban areas is the result of building more department complexes in the cities because of the increasing need for renting and selling houses as a result of the increasing population growth.</em>

5 0
3 years ago
Read 2 more answers
Market anomaly refers to _______.A. an exogenous shock to the market that is sharp but not persistentB. a price or volume event
Klio2033 [76]

Answer:

the correct answer is C. A trading or pricing structure that interferes with efficient buying and selling of securities.

Explanation:

7 0
3 years ago
Managing economic exposure is generally perceived to be ____ managing transaction exposure. a. more difficult than b. less diffi
Anit [1.1K]

Answer:

the correct answer is a. more difficult than

Explanation:

Unlike Transaction exposure, economic exposure is difficult to predict and difficult to mitigate in an event of occurence, thus making it harder to manage than transaction exposure.

This is mainly because economic exposure can happen due to various macro economic factors and international political incidents.

6 0
3 years ago
Read 2 more answers
A regulatory agency that protects workers is
bagirrra123 [75]

Answer:

answer is A

Explanation:

6 0
3 years ago
A regional trucking company landed a contract to supply products for a major retailer. To do this, it needs to hire an IT profes
Zigmanuir [339]

Answer: • set up the computer hardware for the database.

• Set up the computer software for the database.

• train designated employees to use the database

• protect the confidentiality of the database

Explanation:

The options include:

a. Set up the computer hardware for the database

b. Set up the computer software for the database

c. train designated employees to use the database

d. Design a help page to show people how to use the database

e. protect the confidentiality of the database

Since the new hire is an IT professional who is employed to create a shipment database, the individual should be able to:

• set up the computer hardware for the database.

• Set up the computer software for the database.

• train designated employees to use the database

• protect the confidentiality of the database

7 0
3 years ago
Other questions:
  • Polly Smith, a supervisor at Kroger's, was recently evaluated by her subordinates. Their responses indicated that Polly uses The
    7·1 answer
  • The result of a decision made or an action taken is known as a(n):
    8·2 answers
  • As competition increases, businesses find greater opportunities for successTrue or false?
    8·1 answer
  • Assuming that data mining techniques are to be used in the following cases, identify whether the task required is supervised or
    6·1 answer
  • If people expect the price of packaged coffee to rise next week, coffee demand will:
    15·1 answer
  • A south sea island produces only coconuts. In 2010, the price of a coconut is $1.50 and the quantity produced is 300. In 2012, t
    5·1 answer
  • What would be the value of the bond described in Part d if, just after it had been issued, the expected inflation rate rose by 3
    7·1 answer
  • annual property taxes are $1,776. the previous year's taxes are paid. if the closing is one May 1, what is the seller's portion
    5·1 answer
  • Furniture purchase for cash in accounting equation​
    8·1 answer
  • If the fed buys more bonds from the public, and increases the price it is willing to pay for the bonds, what will happen to inte
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!