Required information

DV $10-1($LO $10\mathrm{.}8)$

Skip to question

$[$The following information applies to the questions displayed below.$]$

Keeping track of employee overtime hours is extremely important to understanding staffing, employee morale and turnover, and labor costs. A company created the following non$-$interactive, hand$-$typed data visualization to document overtime by employees. It appears that column B is reporting the number of employees who worked overtime hours, and the number in rows $213$ corresponds to a specific month. For example, $1$ employee worked a total of $20$ overtime hours in January; $2$ employees worked $36$ hours of overtime in February; and $3$ employees worked a total of $76$ hours of overtime in March.

A table for employee overtime hours. The table lists overtime hours by month for number of employees. The column headers are from January to December. Column $1$ lists the number of employees and the horizontal bars indicate the hours. The bars are of increasing length from January to December. The data is as follows: January, $1$ employee, $20$ hours; February, $2$ employees, $36$ hours; March, $3$ employees, $76$ hours; April, $4$ employees, $72$ hours; May, $1$ employee, $15$ hours; June, $2$ employees, $40$ hours; July, $4$ employees, $80$ hours; August, $2$ employees, $38$ hours; September, $2$ employees, $36$ hours; October, $3$ employees, $65$ hours; November, $1$ employee, $24$ hours; December, $4$ employees, $68$ hours.

DV $10-1($LO $10\mathrm{.}8)-$ Part $2$

First, create a properly organized data file with headers and data values based on the given visualization. Then, create an interactive visualization that makes it easy to determine the number of employees working overtime during a month and the total number of overtime hours for each month. What additional data would help to enhance the data visualization even more?

Note: Please submit your file attachment response in one of the approved file formats; Word file $(.$doc or $.$docx$),$ Excel file $(.$xls or $.$xlsx$),$ or PDF$.$ To submit photo or image files please paste them into Word or PDF$.$ Consult with your instructor as needed on their preferred file attachment format.