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
There are three key approaches to entering international markets. each company must decide how to enter each chosen marketlong d
Minchanka [31]

The three key approaches that are needed in entering international markets include the following; direct investment, exporting and even joint venturing. These are three key approaches that will complete the space provided above as this is where the company decide on how a chosen market long dash may enter.

3 0
3 years ago
The pita pit borrowed $192,000 on november 1, 2018, and signed a six-month note bearing interest at 12%. principal and interest
timofeeve [1]
<span>The interest expense is $3,850.52. 12% annual interest is equivalent to a daily interest rate of 0.0328767123% in 2018, a 365 day year, and with 61 days between November 1 and December 31 the amount calculated is (0.0328767123/100)*61*192000 which is equal to 3,850.52.</span>
6 0
3 years ago
Walmart is thinking about offering a 25% discount on a brand of shoes. If the elasticity of demand is two, then the discount wou
sweet-ann [11.9K]

Answer:

A.50%.

Explanation:

The price elasticity of demand formula is:

PED = Change in quantity demanded / change in price

plugging the amounts into the formula we obtain:

2 = X / 25%

Now, simply solve for X:

2 x 25% = X

50% = X

Thus, the total quantity demanded would increase by 50%

6 0
3 years ago
Suppose that without specialization, Iran produces 4 barrels of oil and 6 bottles of olive oil, and Iraq produces 4 barrels of o
Elza [17]

Answer:

With specialization Iran will be able to consume 1.7 bottles of olive oil.

Explanation:

Iran produces 4 barrels of oil and 6 bottles of olive oil.

Iraq produces 4 barrels of oil and 4 bottles of olive oil.

The opportunity cost of producing a barrel of oil for Iran

= \frac{6}{4}

= 1.5

The opportunity cost of producing a barrel of oil for Iraq

= \frac{4}{4}

= 1

Iraq has a lower opportunity cost for producing oil so we can say it has a comparative advantage in producing oil.

The opportunity cost of producing a barrel of olive oil for Iran

= \frac{4}{6}

= 0.66

The opportunity cost of producing a barrel of olive oil for Iraq

= \frac{4}{4}

= 1

Iran has a lower opportunity cost for producing olive oil so we can say it has a comparative advantage in producing it.

The terms of trade with specialization are 4 barrels of oil for 4.3 bottles of olive oil, and that 4 barrels of oil are indeed traded for 4.3 bottles of olive oil.

Without trade, Iran is consuming 4 barrels of oil and 6 bottles of olive oil.

With specialization, Iran will be able to consume

= 6 - 4.3

= 1.7 bottles of olive oil

6 0
3 years ago
Pioneer or breakthrough products:___________
lianna [129]

<u>Answer:</u> Option 2

<u>Explanation:</u>

Pioneer of breakthrough products are advanced products in the market. These products help in fulfilling the consumer needs in the market when compared to the current available products. When the breakthrough products  meet consumer needs which makes their work and life easier then the consumer preferences change to these pioneer products.

The consumer preferences  bring a change in the consumer products market.   When modern and latest resources are available in the market with advantages such as ease of use the consumers prefer pioneer products.

5 0
3 years ago
Other questions:
  • PLEASE HELP, ILL GIVE BRAINLIEST IF IT'S RIGHT. 35 POINTS! the answer isnt C!
    15·2 answers
  • Which of the following is a fixed cost for a company that sells greeting cards online and mails the printed cards to customers?
    10·1 answer
  • If Angela's $98,760 home appreciates three percent a year, will she have enough appreciation to try to sell the home for a $15,0
    10·1 answer
  • Select the correct answers. Which strategy would be most suitable for a company at the maturity stage of its product life cycle?
    13·1 answer
  • Smashing Pumpkins Co. uses the LCM method, on an individual-item basis, in pricing its inventory items. The inventory at Dec. 31
    7·1 answer
  • Why is good judgement important to making budgeting decisions
    14·2 answers
  • Warren Supply Inc. is evaluating its capital budget. The company finances with debt and common equity, but because of market con
    8·1 answer
  • PLZ HELP ME!!!!!!
    6·2 answers
  • A random sample of respondents would be distributed randomly, half to the experimental group and half to the control group. A pr
    15·1 answer
  • Jordan Sales Company (organized as a corporation on April 1, 2014) has completed the accounting cycle for the second year, ended
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!