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
Susan bought a new sweater on sale for dollar 28.93.she was charged HST of 13%.find the total amount of her bill including taxes
Leya [2.2K]

Answer:

The answer is 32.69$.

Explanation:

The Sale price of sweater was $28.93, to add 13% HST we need to multiply 28.93 by 13 % & add 28.93 to it.

8 0
3 years ago
Stark Industries was just rated number one for job satisfaction on a survey compiled by an outside entity. The report cited that
Xelga [282]

Answer:

organizational commitment; perceived stress

Explanation:

Organizational commitment is the psychology of the employee towards his organization. This may be good and bad. If employee is happy with his work environment he will try to give the 100% of his job and its increases his working capacity. Employee think good about his organization and want stick with the organization passionately for a longer time. So they have low level of perceived stress.

According to the analysis, strong organizational commitment and reported low levels of perceived stress is the reason that stark industries was rated number one for job satisfaction.

3 0
3 years ago
Do all choices have costs?
expeople1 [14]
For every choice you make, you are sacrificing something else. For example, when you choose to buy a new phone, you are sacrificing buying a new laptop. The opportunity cost of buying the phone, is the cost of the laptop. Therefore, evey choice has a cost, because in every choice, there is a sacrifice
5 0
3 years ago
He was very excited by the new features of windows 95.
Irina18 [472]

What's the question?

5 0
3 years ago
Your sister has just been told that she will be given a $1,000 bonus next year. She is very eager to know its present value. So,
Stella [2.4K]

Answer:

discounting

hope it helps :0

3 0
2 years ago
Other questions:
  • Imagine that you are looking for a job as a interior decorator. Describe four specific ways that you could look for job leads
    14·2 answers
  • About this app<br> What is the benefit of this app
    6·2 answers
  • Job interviewers often say to job applicants, "tell me about yourself." the purpose of this request is to:
    8·1 answer
  • Katrina receives an offer to buy a box of candy through the mail each month. The letter says that she will begin receiving candy
    8·1 answer
  • Techincal analysis of stock market focuses on which of the following
    8·1 answer
  • . Licensing occurs when: a. A licensee allows a licensor to use its intellectual property for a fee. b. A professional league pa
    11·2 answers
  • A company had a budgeted production of 12000 units and actual production of 13200 units. Two types of raw material, P and Q are
    5·1 answer
  • How can zoning laws be beneficial to a city’s residents?
    15·1 answer
  • All accounting systems ______. (Select all that apply.) Multiple select question. record and summarize financial effects of tran
    10·1 answer
  • When income is allocated among members of society and is seen as equitable or inequitable it is called ________
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!