The Following Data of Causes of Absenteeism for a Fellow

question 113

Essay

The following data of causes of absenteeism for a fellow student for the year just completed were available.
$\begin{array}{lll}\text { Reason\# }&\text { Cause of Absenteeism }&\text { Number of Occurrences }\\1 & \text { Personal Illness } & 14 \\2 & \text { A child's illness } & 31 \\3 & \text { Car broke down } & 10 \\4 & \text { Personal emergency } & 38 \\5 & \text { Overslept } & 11 \\6 & \text { Unexplained visitor } & 13\end{array}$ Required:
1. Use the above information to construct a histogram.
2.Use the information from requirement (1) to prepare a Pareto diagram.
(Note: In constructing the above two items, you can use the information in column 1 to describe each of the identified causes. That is, you can use the reference numbers rather than the actual verbal descriptions presented in column 2.)
3. Within the context of managing and control quality, what is the primary purpose played by tools such as histograms and Pareto diagrams?

Analyze the impact of income changes on market demand for a product.

Understand the effect of complementary and substitute goods on market demand.

Calculate the necessary tax to achieve a desired decrease in consumption based on price elasticity of demand.

Calculate the optimal pricing strategy for maximizing profit taking into account the cost of production and elasticity of demand.

---

Definitions:

VBA Procedure

A set of coded instructions in Visual Basic for Applications used to perform actions or calculate expressions in Excel and other Microsoft Office applications.

Class Modules

A set of classes that can be used to extend the capabilities of a software program, typically within object-oriented programming.

Run In Response

A programming or software feature where a specific action or function is executed automatically in reaction to a defined event or input.

Create A Comment

A function in many applications that allows users to add notes or annotations to a document without altering the main content.