A Summary on Commodities Below Lists the Change in Price

Essay

A summary on commodities below lists the change in price on a particular day for each commodity belonging to three
categories - Base Metals, Precious Metals, and Agricultural & Cattle Futures. $\begin{array}{l|l|r|r}&\text { Commodity Summary }\\\hline \text { Commodity } & \text { Type of Commodity } & \text { Price } & \text { Change (\%) } \\\hline \text { Aluminu } & \text { Base metals } & 1700 & 0.0750 \\\text { Gold } & \text { Precious metals } & 1229 & -0.2300 \\\text { Corn } & \text { Agricultural \& Cattle Futures } & 400 & 0.0125 \\\text { Silver } & \text { Precious metals } & 1975 & -0.1800 \\\text { Aluminu } & \text { Base metals } & 1750 & -0.1000 \\\text { Wheat } & \text { Agricultural \& Cattle Futures } & 640 & -0.0425 \\\text { Soybeans } & \text { Agricultural \& Cattle Futures } & 1300 & -0.1250 \\\text { Copper } & \text { Base metals } & 7012 & -0.1700 \\\text { Platinum } & \text { Precious metals } & 1357 & -0.1900 \\\text { Cocoa } & \text { Agricultural \& Cattle Futures } & 2.8 & 0.0000 \\\text { Coffee } & \text { Agricultural \& Cattle Futures } & 109 & -0.0085 \\\text { Lead } & \text { Base metals } & 2065 & -0.1000 \\\text { White Sugar } & \text { Agricultural \& Cattle Futures } & 450 & -0.0900 \\\text { Sugar 11 } & \text { Agricultural \& Cattle Futures } & 20.19 & -0.0087 \\\text { Nickel } & \text { Base metals } & 13300 & -0.2500 \\\text { Cotton } & \text { Agricultural \& Cattle Futures } & 77.39 & -0.0087 \\\text { Oranges } & \text { Agricultural \& Cattle Futures } & 139.62 & -0.0040 \\\text { Tin } & \text { Base metals } & 22600 & 0.3000 \\\text { Palladium } & \text { Precious metals } & 717 & -0.0700 \\\text { Palm oil } & \text { Agricultural \& Cattle Futures } & 930 & 0.0500 \\\text { Zinc } & \text { Base metals } & 1800 & -0.0100\end{array}$
a. Prepare a PivotTable that gives the frequency count of the data by Commodity Type (rows) and the Change (columns). Use classes of -0.25-(-0.15), -0.15-(-0.05), -0.05-0.05, 0.05-0.15, and 0.25-0.35 for the Change (%).
b. What conclusions can you draw about the commodity type and the change (%) in price for that particular day?