Solved

Describe and Construct a Cross-Tabulation Showing the Region-Wise Percentage Breakdown

Question 36

Essay

Describe and construct a cross-tabulation showing the region-wise percentage breakdown of purchase of glass bottles and silver spoons and visually represent the data in a 3-D column chart.
Counts:  Region  Glass  Bottle  Silver  Spoon  Grand  Total  Almeco 67985 Antasia 0184184 Puitoria 133043\begin{array} { | r | r | r | r | } \hline \text { Region } & \begin{array} { r } \text { Glass } \\\text { Bottle }\end{array} & \begin{array} { r } \text { Silver } \\\text { Spoon }\end{array} & \begin{array} { r } \text { Grand } \\\text { Total }\end{array} \\\hline \text { Almeco } & 6 & 79 & 85 \\\hline \text { Antasia } & 0 & 184 & 184 \\\hline \text { Puitoria } & 13 & 30 & 43 \\\hline\end{array} Percentages by Region:  Region  Glass  Bottle  Silver  Spoon  Grand  Total  Almeco 7%93%100% Antasia 0%100%100% Puitoria 30%70%100%\begin{array} { | r | r | r | r | } \hline \text { Region } & \begin{array} { r } \text { Glass } \\\text { Bottle }\end{array} & \begin{array} { r } \text { Silver } \\\text { Spoon }\end{array} & \begin{array} { r } \text { Grand } \\\text { Total }\end{array} \\\hline \text { Almeco } & 7 \% & 93 \% & 100 \% \\\hline \text { Antasia } & 0 \% & 100 \% & 100 \% \\\hline \text { Puitoria } & 30 \% & 70 \% & 100 \% \\\hline\end{array}

Correct Answer:

verifed

Verified

Construct a pivot table with regions as ...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions