W132_Task01_DA

Task prompt

What the agent was asked to do

Calculate and report the following metrics: 1. The Overall Vitamins Purchase Intent Score for each buyer segment. 2. The buyer segment with the highest average purchase intent score for Vitamins 3. The Vitamin Purchase Intent Index 4. Whether the Vitamin Purchase Intent Index Rating is desirable or undesirable Vitamin Purchase Intent Index is a composite metric calculated as: Average of Vitamins Purchase Intent Score across all segments × Segment Weight (i.e., Average of Population Size of buyer segment with highest purchase intent score for Vitamins × Average of Loyalty Score of buyer segment with highest purchase intent score for Vitamins) x PureLife Awareness Factor (i.e., Survey Respondents who said ‘Definitely yes’ or ‘Probably yes’ to trying PureLife divided by total Survey Respondents who have heard about PureLife). Vitamin Purchase Intent Index Rating is determined as: Vitamin Purchase Intent Index of >=8 is considered 'Desirable' other wise is considered 'Undesirable'. Base your analysis off the survey data and buyer behaviour data. Percentage values must be formatted to the nearest 0.01%. Dollar values must be formatted as US$ with 2 decimal places All other number calculations should be formatted to two decimals. Post your answer straight here.

Grading rubric

Criteria and grader verdict (showcase run)

1. States the Active Lifestyle - Purchase Intent Score for Vitamins is 5.82

   Pass

   Evidence: TEXT_RESPONSE states “Vitamins Purchase Intent Score — Active Lifestyle | 5.82”. Assessment: Criterion asks whether it states Active Lifestyle score is 5.82; pass.

2. States the Fitness Enthusiasts - Purchase Intent Score for Vitamins is 6.33

   Pass

   Evidence: TEXT_RESPONSE states “Vitamins Purchase Intent Score — Fitness Enthusiasts | 6.33”. Assessment: Criterion asks whether it states Fitness Enthusiasts score is 6.33; pass.

3. States the Health-Conscious - Purchase Intent Score for Vitamins is 6.29

   Pass

   Evidence: TEXT_RESPONSE states “Vitamins Purchase Intent Score — Health-Conscious | 6.29”. Assessment: Criterion asks whether it states Health-Conscious score is 6.29; pass.

4. States the Preventive Care - Purchase Intent Score for Vitamins is 6.15

   Pass

   Evidence: TEXT_RESPONSE states “Vitamins Purchase Intent Score — Preventive Care | 6.15”. Assessment: Criterion asks whether it states Preventive Care score is 6.15; pass.

5. States the Weight Management - Purchase Intent Score for Vitamins is 6.27

   Pass

   Evidence: TEXT_RESPONSE states “Vitamins Purchase Intent Score — Weight Management | 6.27”. Assessment: Criterion asks whether it states Weight Management score is 6.27; pass.

6. States that the buyer segment with the highest average purchase intent score for Vitamins is Fitness Enthusiasts

   Pass

   Evidence: TEXT_RESPONSE states “Buyer segment with highest average Vitamins purchase intent | Fitness Enthusiasts”. Assessment: Criterion asks whether it states the highest segment is Fitness Enthusiasts; pass.

7. States the Vitamin Purchase Intent Index is 10.76

   Fail

   Evidence: TEXT_RESPONSE states “Vitamin Purchase Intent Index | 10.84”. Assessment: Criterion asks whether it states the Index is 10.76; the response gives 10.84 instead, so fail.

8. States the Vitamin Purchase Intent Index Rating is Desirable

   Pass

   Evidence: TEXT_RESPONSE states “Vitamin Purchase Intent Index Rating | Desirable”. Assessment: Criterion asks whether it states the rating is Desirable; pass.