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?

Question

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?

Quizplus · Accepted Answer

The Answer of 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?

A Summary on Commodities Below Lists the Change in Price