Student's Name:

Workforce Analytics & Planning

Barriers

Data must be integrated from multiple sources

Lack of automation$/$repeatable process

Metrics need to be identified or defined

Production is cumbersome

Data quality is not reliable

Sharing findings is challenging

Analytic tools are too complex

Ensuring security and integrity of workforce data

Other

Totals

Source: Data extracted from The State of Workforce Analytics and

Planning, $2014$ Survey Report, available at

bit.ly$/1$zuM$99$Z$.($Data revised$)$

Organizing & Visualizing Data: Developing Charts

Complete the following:

a$.$ Bold the headings in the table; apply Arial font $12$ to the headings and data; center the frequencies.

b$.$ Add a Percent column next to the Frequency column; calculate the percent that each value is of the total

in the percent column; calculate the total

c$.$ Format the values in the Percent column as percents with $1$ decimal place.

d$.$ Create the charts and update the chart title

a$.$ Develop a Clustered Column Chart using the above data.

b$.$ Develop a Pareto Chart using the above data.