Case Exercises
43
.
This video introduces crop budgets in the state of Nebraska. This crop budget monitoring is done by the University of Nebraska-Lincoln, and they have all the input costs that go into producing the crop yield. You can download the datasets by visiting the University of Nebraska-Lincoln’s website. Download any of their current year crop budgets in Excel format.
A.
Copy and paste the Materials tab into a new workbook.
B.
Create a PivotTable from this data to examine the Applied Price (total) by Category.
C.
Insert a PivotChart for the data.
D.
Write a short summary of the data set.