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
viva [34]
2 years ago
15

On the "Compiled Information" tab, a VLOOKUP formula has been pre-entered into cell E3. This formula was written correctly, and

it uses references to the numbers in cells E1 through G1 to determine the correct index_number parameter. Fill in cells F1 and G1 with the correct index numbers, then copy the formula in cell E3 down to all the rows in columns E, F, and G. What number did you enter into cell G1?
Mathematics
1 answer:
Mashcka [7]2 years ago
6 0

Answer:

3

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
Reyna has 5 coins worth 10 cents each and 4 coins
Zolol [24]

Answer:

The Probability found is:

P =  \frac{13}{18}

Step-by-step explanation:

Let x be the 10 cents coin.

Let y be the 25 cents coin.

We have to find all the possible outcomes

1) First coin = 10 cents, Second coin = 10 cents , so

(x,x) = 20

2) First coin = 10 cents, Second coin = 25 cents , so

(x,y) = 35

3) First coin = 25 cents, Second coin = 10 cents , so

(y,x) = 35

4) First coin = 25 cents, Second coin = 25 cents , so

(y,y) = 50

Find the probability of each outcome:

P(x,x) =  \frac{5}{9}\cdot\frac{4}{8}=\frac{20}{72}

P(x,y) =  \frac{5}{9}\cdot\frac{4}{8}=\frac{20}{72}

P(y,x) =  \frac{5}{9}\cdot\frac{4}{8}=\frac{20}{72}

P(y,y) = \frac{4}{9}\cdot\frac{3}{8}=\frac{12}{72}

Add all the probabilities where sum is at least 35 i.e P(x,y) , P(y,x) , P(y,y)

P(x,y) + P(y,x) + P(y,y) = \frac{20}{72}+\frac{20}{72}+\frac{12}{72} = \frac{52}{72}=\frac{13}{18}\\

6 0
2 years ago
The table shows the shipping costs for items of different values. A 2-column table with 4 rows. The first column is labeled tota
Lisa [10]

A strong positive correlation.

Step-by-step explanation:

The question requires you to calculate the correlation coefficient and then make a conclusion about its value.

Form a table as shown where x is cost of items and y is shipping cost

x               y           xy                   x²         y²

25           5.99       149.8          625         35.9

45            8.99       404.6       2025        80.8

50            8.99      449.5         2500       80.8

70            10.99      769.3         4900       120.8

190           34.96     1773.2        10050      318.3 ------sum

The formula for correlation coefficient follows;

r=n(∑xy)-(∑x)(∑y) ÷ √{[n∑x²-(x)²] [n∑y²-(y)²]}

where n=4

r=4(1773.2)-(190)(34.96) ÷ √{[4(10050)-190²] [4(318.3)-34.96²]}

r=450÷ √{4100*51)

r=450÷√209100

r=450÷457.3

r=0.98409

The value of r indicates a stronger positive correlation

Learn More

Correlation coefficient :brainly.com/question/12528676

Keywords :shipping costs,cost of items, strength of the model

#LearnwithBrainly

4 0
2 years ago
Read 2 more answers
Label the place value 12,354.897
Angelina_Jolie [31]
From left to right

Ten thousands, thousands, hundreds, tens, ones, tenths, hundreths, thousandths,
6 0
2 years ago
Read 2 more answers
Chelsea is graphing the function f(x) = 20()x. She begins by plotting the initial value. Which graph represents her first step?
Soloha48 [4]

we have the function

f(x)=20(\frac{1}{4})^{x}

we know that

In the equation of the exponential function of the form

f(x)=a(b)^{x}

a is the initial value

b is the base

x is the exponent

The initial value is the value of the function when the value of x is equal to zero

in this problem

for x=0

f(0)=20(\frac{1}{4})^{0}

f(0)=20(1)=20

the initial value is the point (0,20)

therefore

the answer in the attached figure

6 0
1 year ago
Read 2 more answers
Elyria Warehousing desired to locate a central warehouse to serve five Ohio markets. Placed on a grid system, its five markets h
Iteru [2.4K]

Answer:

The correct option is 2.

Step-by-step explanation:

According to the the center-of-gravity technique, the coordinates of the center-of-gravity location are

(\frac{\sum x_iL_i}{\sum L_i},\frac{\sum y_iL_i}{\sum L_i})

Where ((x_i,y_i) represent the coordinates and L_i is demand.

We have to find the Y-coordinate of the center-of-gravity location.

The sum of product of demand and corresponding y coordinates is

\sum y_iL_i=65\times 2200+55\times 900+95\times 1300+200\times 1750+175\times 3100=1208500

The sum of demanded units is

\sum L_i=2200+900+1300+1750+3100=9250

The Y-coordinate of the center-of-gravity location is

y_0=\frac{\sum y_iL_i}{\sum L_i}

y_0=\frac{1208500}{9250}

y_0=130.6486

y_0\approx 131

The Y-coordinate of the center-of-gravity location is 131. Therefore the correct option is 2.

7 0
2 years ago
Other questions:
  • The following table shows the number of hours some teachers in two schools expect students to spend on homework each week: Schoo
    15·1 answer
  • At the beginning of the month, Kimberly had $65.78. since then, she has received three payments of $32.50 from her babysitting j
    14·2 answers
  • Sue played four games of golf.
    15·2 answers
  • Adrienne has several receipts from recent transactions that she entered in her records. The receipts include an ATM receipt for
    14·2 answers
  • Which represents the solution set of the inequality 5 x minus 9 less-than-or-equal-to 21
    12·2 answers
  • The Garcia family is driving from San Diego, California, to bar harbor, Maine. In 5 day,they have traveled 2,045 miles. At this
    12·1 answer
  • Alexandra and her children went into a grocery store and she bought $7.65 worth of
    14·1 answer
  • Determine the possible survey questions that could be used to collect data on a population that consists of elementary school st
    10·1 answer
  • Why is the slope of line segment AC the same as the slope of line segment DF in the figure below?
    13·2 answers
  • Is ½y=1 a linear equation ​
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!