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
max2010maxim [7]
3 years ago
11

The type of match to use in a Vlookup() function to assess the resort fee as a possible additional cost for a particular room is

: Group of answer choices A fuzzy match An approximate match An exact match None of the answer sections are correct
Mathematics
1 answer:
schepotkina [342]3 years ago
6 0

Answer:

An approximate match

Step-by-step explanation:

The vlookup (vertical lookup) function is a search function in excel used in locating values in an excel table.

The vlookup syntax is written as:

=VLOOKUP(value, table, col_index, [range_lookup])

The range_lookup is an optional parameter which is used to indicate if the search should be for an exact match or approximate match. Since a column, resort fee will be used as a possible additional cost; the search would be required to return an approximate search rather than an exact match in other for the search condition to be adequately implemented.

You might be interested in
SoMeonE plZ hAlp me lol
jeka94

C.√93


A=17

B=14

...........................

3 0
3 years ago
Soft drink consumption in New Zealand. A survey commissioned by the Southern Cross Healthcare Group reported that 16% of New Zea
lidiya [134]
<h2>Answer with explanation:</h2>

Given : The proportion of New Zealanders consume five or more servings of soft drinks per week :\hat{p}= 0.16

a) The number of survey respondents reported that they consume five or more servings of soft drinks per week = 2006

b) Confidence interval for population proportion (p) :

\hat{p}\pm z^*\sqrt{\dfrac{\hat{p}(1-\hat{p})}{n}}

, where \hat{p} = Sample proportion.

n= Sample size.

z* = Critical value.

For n= 2006 , \hat{p}= 0.16 and critical value for 95% confidence interval : z* = 1.96

Then , the required confidence interval will be :

0.16\pm (1.96)\sqrt{\dfrac{ 0.16(1- 0.16)}{2006}}

0.16\pm (1.96)\sqrt{ 0.000066999002991}

0.16\pm (1.96)(0.00818529186963)

0.16\pm 0.0160431720645

(0.16-0.0160431720645,\ 0.16+0.0160431720645)

(0.143956827935,\ 0.176043172064)\approx(0.144,\ 0.176)

i.e. A 95% confidence interval for the proportion of New Zealanders who report that they consume five or more servings of soft drinks per week. = (0.144,\ 0.176)

c) (0.144,\ 0.176)=(0.144\times100\%,\ 0.176\times100\%)

=(14.4\%,\ 17.6\%)176\times100\%)[/tex]

d) The estimate might be biased because the survey is taken online that means offline New Zealanders are out of consideration.

6 0
3 years ago
A student is reading a book at about 370 words per minute. convert this rate to words per hour
Vlad1618 [11]
This would convert to 22,200 words an hour.
3 0
3 years ago
What fraction greater than one can you write 4 3/5?
mina [271]
You just change the mixed number into an improper fraction.
4 3/5
5x4=20
20+3=23
23/5
3 0
3 years ago
Read 2 more answers
Find the opposite of the opposite of each integer. 9
maks197457 [2]

Hi!

The opposite of 9 is -9.

Hope this helps!

7 0
3 years ago
Read 2 more answers
Other questions:
  • Using the completing-the-square method, find the vertex of the function f(x) = 5x2 + 10x + 8 and indicate whether it is a minimu
    11·1 answer
  • A bag contains 3 blue cards, 8 green cards, 12 red cards, and 4 yellow cards. You randomly choose a card.
    12·1 answer
  • Double digit subtraction with regrouping
    15·1 answer
  • Fernanda bought a 500-milliliter container of orange juice. She used some of the juice and has 200 milliliters left. How much or
    8·2 answers
  • Please help me on this <br> U need to zoom in
    6·1 answer
  • Answer the 3 questions please !! i’ll give you 10 points and brainl if you get it correct !!
    11·2 answers
  • The table shows the relationship between the number of faculty members and the number of students at a local school. What is the
    7·1 answer
  • If a polynomial has two factors: It will either have two zeros or the same zero twice.
    6·1 answer
  • The point p and all points to the left and right of P ​
    12·1 answer
  • Determine the sign of each product and place it in the correct category​
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!