Using Only the "VLOOKUP" Function, Transfer All of the Data

question 34

Essay

Using only the "VLOOKUP" function, transfer all of the data from the table below into the "Individual Sales" table.
​ $$\begin{array} { | l | l | l | l | } \hline & { \text { Individual Sales } } \\\hline \text { Rank } & \text { Name } & \text { Sales } & \text { Team } \\\hline 6 & \text { Susan } & 5 & \text { red } \\\hline 8 & \text { Thomas } & 7 & \text { red } \\\hline 9 & \text { Lynn } & 2 & \text { blue } \\\hline 5 & \text { Sean } & 6 & \text { blue } \\\hline 1 & \text { Jerry } & 20 & \text { yellow } \\\hline 2 & \text { George } & 12 & \text { red } \\\hline 10 & \text { Elaine } & 1 & \text { red } \\\hline 7 & \text { Delores } & 4 & \text { blue } \\\hline 4 & \text { Tony } & 9 & \text { yellow } \\\hline 3 & \text { Ast } & 12 & \text { blue } \\\hline\end{array}$$ ​ $$\begin{array}{l}\text { Individual Sales }\\\begin{array} { | l | l | l | l | } \hline \text { Rank } & \text { Name } & \text { Sales } & \text { Team } \\\hline 1 & & & \\\hline 2 & & & \\\hline 3 & & & \\\hline 4 & & & \\\hline 5 & & & \\\hline 6 & & & \\\hline 7 & & & \\\hline 8 & & & \\\hline 9 & & & \\\hline 10 & & & \\\hline\end{array}\end{array}$$

---

Definitions:

Statistical Significance

A determination that a relationship between variables is caused by something other than chance at a specified confidence level.

True Proportion

The actual ratio or fraction of a population that possesses a particular attribute or characteristic.

Random Sample

A subset of individuals chosen from a larger set where each individual has an equal chance of being selected.

Large-Sample Z

A statistical test used to determine if two population means are different, applicable when the sample size is large.