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
Mandy’s Packaging Inc. is a multibillion-dollar supplier of packaging materials. One of its salespeople rearranged production sc
daser333 [38]

Answer:

<u>Relationship selling</u>

Explanation:

Relationship selling is focussed more upon successfully building a long term relationship between a seller and a buyer rather than being merely focussed upon effecting a sales through .

The technique emphasizes upon the quality of interaction between the seller and the buyer which shall serve as a basis for develoment of a future relationship between the company and the customer.

This technique is prominent in case of those companies that rely on repetitive purchases on part of the buyer like private instructors. Good relationships may lead to customer loyalty which prompt repetitive purchases at their end.

In the given case, the supplier company's sales person rearranged production schedule so as to accomodate unexpected demand from a major client. Such an action demonstrates company's sales policy with emphasis upon relationship selling.

3 0
3 years ago
Teach a Lesson: Explore Moral Dilemmas What are the components of a lesson?
dusya [7]
<span>Objective, Introduction, Instruction, Practice, and Conclusion</span>
4 0
3 years ago
Read 2 more answers
Which statement regarding strategies is true?
Iteru [2.4K]
<span>"C. Strategies facilitate objectives" This is true because there's a series of objectives that must be completed within any strategy, and the other options can be true however not for every strategy.</span>
5 0
3 years ago
ABC Corp. has just paid a dividend of $0.26. ABC has an annual required return of 12%.
Elis [28]

Answer:

a. If dividends are annual and expected to be constant, what is the intrinsic value (fair price) of ABC stock?

P₀ = $0.26 / 12% = $2.16667 = $2.17

b. What is ABC's dividend yield?

$0.26 / $2.17 = 12%

c. From now on, assume that the dividend of 0.26 was a quarterly dividend. What is the quarterly discount rate?

12% / 4 = 3%

d. What is the intrinsic value if dividends are constant and quarterly?

P₀ = $0.26 / 3% = $8.66667 = $8.67

e. We now think that dividends will grow by 0.3% from quarter to quarter. The firm just paid the quarterly dividend of 0.26. What is the intrinsic value of ABC stock?

P₀ = ($0.26 x 1.003) / (3% - 0.3%) = $9.6585 = $9.66

f. A different analyst thinks that ABC's dividends will grow by 5% for the next 4 quarters, and then grow by 0.3% thereafter. What is the intrinsic value?

Div₀ = $0.26

Div₁ = $0.273

Div₂ = $0.287

Div₃ = $0.301

Div₄ = $0.316

Div₅ = $0.317

terminal value in 4 quarters = $0.317 / (3% - 0.3%) = $11.74

P₀ = $0.273/1.03 + $0.287/1.03² + $0.301/1.03³ + $0.316/1.03⁴ + $11.74/1.03⁴ = $0.265 + $0.271 + $0.275 + $0.281 + $10.43 = $11.522  

8 0
2 years ago
Consider an economy described by the following equations:
Ede4ka [16]

Answer:

a. exchange rate = 1

b. exchange rate = 1.5

Explanation:

(a)  National Saving = Private saving + public saving

Private saving = Y - C - T

=> Private saving = 5000 - (250 + 0.75(Y – T)) - 1000

=> Private saving = 5000 - (250 + 0.75(5000 – 1000)) - 1000 = 750

Public saving = T - G = 1000 - 1000 = 0

National saving = 750 + 0

= 750

Investment = 1000 - 50r = 1000 - 50*5

= 750

Y = C + I + G + NX

Trade Balance = Y - C - G - I = 5000 - (250 + 0.75(5000 – 1000)) - 1000 - 750 = 0

Thus Trade Balance = 0

NX = 0 => NX = 500 – 500e = 0

=> e = 1

Thus exchange rate = 1

(b)

National Saving = Private saving + public saving

Private saving = Y - C - T

=> Private saving = 5000 - (250 + 0.75(Y – T)) - 1000

=> Private saving = 5000 - (250 + 0.75(5000 – 1000)) - 1000 = 750

Public saving = T - G = 1000 - 1250 = -250

National saving = 750 - 250

= 500

Investment = 1000 - 50r = 1000 - 50*5

= 750

Y = C + I + G + NX

Trade Balance = Y - C - G - I = 5000 - (250 + 0.75(5000 – 1000)) - 1250 - 750 = -250

Thus Trade Balance = -250

NX = -250 => NX = 500 – 500e = -250

=> e = 750/500 = 1.5

Thus exchange rate = 1.5

 

8 0
3 years ago
Other questions:
  • Early capitalist economists argued that supply-and-demand pricing worked better without any _______.
    8·2 answers
  • List and describe three causes for shifts in the demand curve.
    7·1 answer
  • Crown Company established a petty cash fund of $600 for incidental expenditures on January 2, 2019. At the end of the month, the
    14·1 answer
  • What is the use of collateral?
    9·1 answer
  • Question 6
    5·1 answer
  • Land costing $71,000 was sold for $50,000 cash. The loss on the sale was reported on the income statement as other expense. On t
    12·1 answer
  • Jim Company bought a machine for $36,000 with an estimated life of 5 years. The residual value of the machine is $6,000. This ma
    13·1 answer
  • Name 5 types of business farms​
    9·2 answers
  • The main purpose of insurance policies that are protected by COBRA is to:
    13·1 answer
  • Which audit procedure is most effective in testing credit sales for overstatement?
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!