A summary on commodities below lists the change in price on a particular day for each commodity belonging to 3 categories - Base Metals, Precious Metals, and Agricultural & Cattle Futures.

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 3 categories - Base Metals, Precious Metals, and Agricultural & Cattle Futures.
  
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 3 categories - Base Metals, Precious Metals, and Agricultural & Cattle Futures.
  
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