Use the following information to:

Create a spreadsheet using Excel that:

a$.$ Replicates the table below accurately. $(10$ points$)$

b$.$ Includes yield ratios and cost ratios in the appropriate blanks $($the rows labeled in bold italics$).$

i$.$ The ratios should display a percentage to two decimal points. $(10$ points$)$

ii$.$ The ratios should be calculated using formulas that refer to the cells in the sheet that

contain the data. You should not type numbers directly into your yield ratio cells. $($Hint:

You can copy and paste the table into Excel without typing the data.$)(25$ points for

accuracy and for use of formulas$)$

Answer the following questions using complete sentences and clear explanations. Answer each question

separately, clearly labeling each answer.

a$.$ Based on the cumulative yield ratio, which recruiting source$($s$)$ offers the most efficient way for

Hamilton to hire an entry$-$level marketing analyst? Explain your answer in detail, citing specifics

from the data and your analyses. $(10$ points$)$

b$.$ Which recruiting program is the most cost$-$effective way for Hamilton, Inc. to hire an entry$-$level

marketing analyst? Explain your answer in detail, citing specifics from the data and your

analyses. $(10$ points$)$

c$.$ This year, Hamilton, Inc. plans to use the same recruiting sources with the goal of hiring only

two new analysts. They are trying to decide what their goal is in terms of the number of

applications. Across all recruiting sources, how many applicants were needed to yield two

individuals who accept job offers? How many applicants would be needed if their goal was to

hire $30$ analysts? Show and explain your computations in detail using either Excel or typing them

with your written responses. $(20$ points$)$

d$.$ Eliza wants to make sure that the people hired have the highest likelihood of succeeding at

Hamilton, Inc. Which one recruiting source should Eliza prioritize? Explain your answer in

detail, citing specifics from the data and your analyses. $(10$ points$)$

e$.$ Eliza knows that over the next ten years, the need for marketing analysts at Hamilton, Inc. is

going to skyrocket. She wants to build more of a relationship with one of the company's

recruiting sources to prepare for this. This will involve an investment of time and funds. Which

source should Hamilton, Inc. select and why? Explain your reasoning thoroughly with at least

two specific reasons. $(5$ points$)$

Assignment Format

Your deliverables will include a Word document to answer the questions and an Excel file for the table

and computations.

Please single$-$space your Word document, with space between each answer and each paragraph. Label

your answers according to the numbering used in this assignment document. Do not include the text of

the assignment questions in your response document. The use of accurately labeled and formatted bullet

points, similar to the above format, would be fine.

You should not need to use any sources other than course materials. If you do use other sources, cite

them appropriately.