The Project Lead in an MNC Decides to Assign Every

question 66

Essay

The project lead in an MNC decides to assign every member of his team to a new project and monitors their performance on a customized scale of scores. The data on their performance over a period of six months are shown below
a. Create a heat map in Excel that shades the cells with negative performance scores. Use Excel's Conditional Formatting function to create this heat map.
b. For each month, identify the team members who scored negative. Which month has the highest negative performance scores?

---

Definitions:

Association

A relationship or connection between two or more variables where changes in one variable correspond with changes in another.

Sales Ice Cream

The commercial transaction of buying and selling ice cream products.

Lurking Variable

A variable that affects both variables of interest in a study but was not included in the study, potentially confounding the results.

Outdoor Temperature

The temperature of the air outside, which can vary widely depending on the weather, time of day, and geographic location.