answer.
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
8_murik_8 [283]
2 years ago
14

Excel:In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns

the value in column 2, and specifies an exact match.
Mathematics
1 answer:
sp2606 [1]2 years ago
8 0

Answer:

=Vlookup'B13' A11' 7'false

Press enter.

Step-by-step explanation:

Vlookup is a technique in excel which enables users to search for criterion values. It is vertical lookup function in excel which return a value from a different column. The formula for Vlookup function is:

=Vlookup'select cell you want to look up in' select cell you want to lookup from' select column index number' true/false.

where true is approximate match and false is exact match.

You might be interested in
In 2015, in Buffalo, New York, there were 8,625 arrests, 2,678 robberies, 865 assaults, and 20 murders. The population of Buffal
m_a_m_a [10]
I'm pretty sure simplest form would still be 865:2678
I could be wrong tho
6 0
2 years ago
Read 2 more answers
There are 50 students in a class and the professor chooses 15 students at random. what is the probability that you or your frien
Alenkasestr [34]
Try this option (see the attachment). Make design according own requirements.
Note, that the description and details are under green line.

Answer: 0.030921

3 0
2 years ago
Read 2 more answers
Factorise : 16x^2 +72xy + 81y^2 -12x +27y
never [62]
Hello!!

It will be the same since there is no common factor. You just need to arrange in order. 

6x^2 + 72xy - 12x + 81y^2 + 27y

Good luck :)
5 0
2 years ago
Web Shooting: A radioactive spider has escaped from the lab and bit you. The spider bite infects (and consequently mutates) 10,0
Mrrafil [7]

Answer:

Step-by-step explanation:

find the solutions below

6 0
2 years ago
Upgrading a certain software package requires installation of 68 new files. Files are installed consecutively. The installation
ser-zykov [4K]

Answer:

The probability that the whole package is uppgraded in less then 12 minutes is 0,1271

Step-by-step explanation:

The mean distribution for the length of the installation (in seconds) of the programs will be denoted by X. Using the Central Limit Theorem, we can assume that X is normal (it will be pretty close). The mean of X is 15 and the variance is 15, hence, the standard deviation is √15 = 3.873.

We want to find the probability that the full installation process takes less than 12 minutes = 720 seconds. Then, in average, each program should take less than 720/68 = 10.5882 seconds to install. Hence, we want to find the probability of X being less than 10.5882. For that, we will take W, the standariation of X, given by the following formula

W = \frac{X-\mu}{\sigma} = \frac{X-15}{3.873}

We will work with \phi , the cummulative distribution function of the standard Normal variable W. The values of \phi can be found in the attached file.

P(X < 10.5882) = P(\frac{X-15}{3.873} < \frac{10.5882-15}{3.873}) = P(W < -1,14)

Since the density function of a standard normal random variable is symmetrical, then \phi(-1.14) = 1-\phi(1.14) = 1-0.8729 = 0.1271

Therefore, the probability that the whole package is uppgraded in less then 12 minutes is 0,1271.

Download pdf
7 0
2 years ago
Other questions:
  • I received a letter from your competitor that mentions a savings of 15% over your prices. Can you match this offer? My current r
    6·1 answer
  • Estimate 1.9 times 4.4
    15·1 answer
  • Lillian collects stickers. Of her collection, 5/12 are animals stickers. Of remainder, 5/14 are flower stickers. What fraction o
    14·2 answers
  • Which statement is true about the square pyramid below?
    5·2 answers
  • PlEASE HELP WITH THIS QUESTION Lisa bought 5 CDs from a store. The price of each CD was the same. After she bought the CDs, her
    14·1 answer
  • A salesman has a base salary $2600 per month and makes 3 commission on each unit sold. If his total annual compensation is $48,0
    12·2 answers
  • Bald-faced hornets have a hive that is approximately cone-shaped, as shown in the image. One such hive has a radius of 15 inches
    6·1 answer
  • Which graph shows a dilation? On a coordinate plane, 2 triangles are shown. The smaller triangle has points (negative 2, 0), (ne
    13·2 answers
  • Consider the function f(x) = round(x), which rounds the input, x, to the nearest integer. Is this function one-to-one? Explain o
    15·1 answer
  • Humans living in highly populated areas are more inclined to _______. a. violence b. socially isolate c. appetite loss d. all of
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!