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
Montano1993 [528]
4 years ago
10

What would be the Excel Formula to solve this question?

Mathematics
1 answer:
spayn [35]4 years ago
7 0

Answer:

Income after 20 years = 162550.01

Step-by-step explanation:

In cell B2, enter 90000

In cell B3, enter +B2*1.03

Copy cell B3 to cells B4:B22

Set number format for column B to 2 decimal places.

Read cell B22 = 162550.01

Income after 20 years = 162550.01

You might be interested in
1–5 change the following improper fractions to mixed number.
Alexxx [7]
Q1 is 2 2/3 or 2 2 out of 3 or 2.66666666667
Q5 is 3 1 out of 3 or 3 1/3 or 3.33333333
Q6 is 27/12 or 27 out of 12
Q10 is 109/10 or 109 out of 10
6 0
2 years ago
What is the slope of the function, represented by the table of values below?
alexira [117]

Answer:

-4

Step-by-step explanation:

The slope is given by

m = (y2-y1)/( x2-x1)

   = ( 13-5)/(-2 -0)

    = 8/-2

   = -4

7 0
3 years ago
Read 2 more answers
According to Harper's Index, 40% of all federal inmates are serving time for drug dealing. A random sample of 20 federal inmates
loris [4]

Answer:

(a) P(X≥10) = 0.245

(b) P(X≤5) = 0.125

(c) The expected number of inmates who are serving time for drug dealing is 8.

Step-by-step explanation:

We will use the binomial distribution to solve this problem. Let X be the number of federal inmates who are serving time for drug dealing. We will use the binomial probability formula:

P(X=x) = ⁿCₓ pˣ qⁿ⁻ˣ

where n = total number of federal inmates

           x = no. of federal inmates who serve time for drug dealing

           p = probability that a federal inmate is serving time for drug dealing

           q = probability that a federal inmate is not serving time for drug dealing

(a) P(X≥10) = 1 - P(X<10)

                 = 1 - [P(X=0) + P(X=1) + P(X=2) + P(X=3) + P(X=4) + P(X=5) + P(X=6) + P(X=7) + P(X=8) + P(X=9)]

                = 1 - [²⁰C₀(0.4)⁰(0.6)²⁰⁻⁰ + ²⁰C₁(0.4)¹(0.6)²⁰⁻¹ + ²⁰C₂(0.4)²(0.6)²⁰⁻² + ²⁰C₃(0.4)³(0.6)²⁰⁻³ + ²⁰C₄(0.4)⁴(0.6)²⁰⁻⁴ + ²⁰C₅(0.4)⁵(0.6)²⁰⁻⁵ + ²⁰C₆(0.4)⁶(0.6)²⁰⁻⁶ + ²⁰C₇(0.4)⁷(0.6)²⁰⁻⁷ + ²⁰C₈(0.4)⁸(0.6)²⁰⁻⁸ + ²⁰C₉(0.4)⁹(0.6)²⁰⁻⁹

                 = 1 - (0.000036 + 0.00048 + 0.00308 + 0.0123 + 0.0349 + 0.0746 + 0.1244 + 0.1658 + 0.1797 + 0.1597)

                 = 1 - 0.7549

P(X≥10) = 0.245

(b) P(X≤5) = P(X=0) + P(X=1) + P(X=2) + P(X=3) + P(X=4) + P(X=5)

since we have calculated these values in the previous part, we will simply plug them in here and then add them up.

P(X≤5) = 0.000036 + 0.00048 + 0.00308 + 0.0123 + 0.0349 + 0.0746

P(X≤5) = 0.125

(c) For a binomial distribution, the expected value can be calculated as:

μ = np

  = (20)(0.4)

μ = 8

The expected number of inmates who are serving time for drug dealing is 8.

7 0
3 years ago
Suppose Viviana sent 100 text messages to her friend. She plans to send an additional 10
Vsevolod [243]

Answer:

20 More Periods

Step-by-step explanation:

Just Divide 200/10 and you get 20.

4 0
3 years ago
I do not understand this at all. help please
Len [333]

Equation:

-9x+10y=-9

10y=9x-9

y=9/10x-9/10


Slope: 9/10

Y intercept:  -9/10


So your answer is D


5 0
3 years ago
Read 2 more answers
Other questions:
  • Each member of a nine-person committee attends any given meeting of the committee with probability 1/2. What is the probability
    10·1 answer
  • What statement about 6x^2+7x-10 is true
    7·1 answer
  • Word form of 0.654 and fraction
    7·1 answer
  • A hike climbs from an elevation of 230 feet below sea level to an elevation of 1250 feet above sea level
    9·1 answer
  • A list of numbers in a specific order
    6·1 answer
  • Solve for x 8 is to 64 as 2 is to X
    8·2 answers
  • I need help with this
    13·2 answers
  • A salesperson at a jewelry store earns 9% commission each week. Last week, Heidi sold $640 worth of jewelry. How much did she ma
    10·1 answer
  • Please help! geometry probabilities​
    5·1 answer
  • WHATS THE AREA OF THIS SHAPE
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!