Suppose a Company Supplies Four of Its Products A, B

question 16

Essay

Suppose a company supplies four of its products A, B, C, and D, to five different regions. The management wants to know the total number of all products supplied to each region as well as the total number of units of each product supplied. The data collected over a period of month are given below. $$\begin{array} { | c | c | c | } \hline \text { Region } & \text { Model } & \begin{array} { c } \text { Number of } \\\text { units }\end{array} \\\hline \text { Region 1 } & \text { A } & 1,784 \\\hline \text { Region 2 } & \text { A } & 2,170 \\\hline \text { Region 3 } & \text { A } & 415 \\\hline \text { Region 4 } & \text { A } & 2,040 \\\hline \text { Region 5 } & \text { A } & 2,991 \\\hline \text { Region 1 } & \text { B } & 947 \\\hline \text { Region 2 } & \text { B } & 2,111 \\\hline \text { Region 3 } & \text { B } & 1,234 \\\hline \text { Region 4 } & \text { B } & 2,061 \\\hline \text { Region 5 } & \text { B } & 607 \\\hline \text { Region 1 } & \text { C } & 2,907 \\\hline \text { Region 2 } & \text { C } & 4,790 \\\hline \text { Region 3 } & \text { C } & 2,191 \\\hline \text { Region 4 } & \text { C } & 1,942 \\\hline \text { Region 5 } & \text { C } & 220 \\\hline \text { Region 1 } & \text { D } & 2,557 \\\hline \text { Region 2 } & \text { D } & 2,980 \\\hline \text { Region 3 } & \text { D } & 1,518 \\\hline \text { Region 4 } & \text { D } & 2,957 \\\hline \text { Region 5 } & \text { D } & 4,462 \\\hline\end{array}$$ Display your use of the SUMIF function and find the total volume by each region and total volume by each product.
​
​

---

Definitions:

Dependent Variable

The variable in an experiment that is expected to change as a result of manipulations made to the independent variable.

Predictor Variable

A variable that is used in statistical models to predict the outcome of a response variable.

Correlations

A statistical measure that indicates the extent to which two or more variables fluctuate together, showing the strength and direction of a relationship between them.

Absolute Values

The non-negative value of a number regardless of its sign; it represents the distance of a number on the number line from zero.