Problem

Procedure

Represent the data through appropriate graphs and tables

Graphical Representation of Nitrogen vs Crop Yield of Village E

1. Position the mouse pointer in Cell A55
2. Click on CHART Icon. Then it will display the CHART WIZARD Dialogue Window
3. Select the LINE as the CHART TYPE option. Then select required CHART SUB TYPE
4. Click NEXT To goto next step of the CAHRT WIZARD
5. Click on SERIES Tab of the CHART WIZARD Step 2 of 4 Window
6. Click on ADD button to add SERIES to the Chart
7. Type CROP YIELD as the title for series in the NAME Dialogue Box
8. Select the Crop Yield data Range i.e F41:F51 as the option for VALUES
9. Select the N Data Range i.e I41:I51 as the option for CATEGORY X AXIS LABEL
10. Click on NEXT To goto next step of the CAHRT WIZARD
11. Click on TITLE Tab of the CHART WIZARD Step 3of 4 Window
12. Type the Title as RESPONSE OF NITROGEN ON CROP YIELD IN VILLAGE E
13. Type NITROGEN as the title for CATEGORY X AXIS
14. Type CROP YILED as the Title for VALUE Y AXIS
15. Click NEXT To goto next step of the CAHRT WIZARD
16. Select the option AS OBJECT IN to keep the required chart on the same data worksheet.
17. Click FINISH To display the required Graph
18. Resize the graph and change the fonts as desired for better presentation. Preparation of Cross Tables ( Pivot Table)

A PivotTable is an interactive table that quickly summarizes, or cross-tabulates, large amounts of data. You can rotate its rows and columns to see different summaries of the source data, filter the data by displaying different pages, or display the details for areas of interest.

Problem: Create a Table for Village wise Total Land Holdings under different Soil Types.

1. Copy the entire data in DATABASE Worksheet to New Worksheet and rename this sheet as PIVOT
2. Position the mouse pointer in Cell A55
3. Select PIVOT TABLE REPORT Option from the DATA Menu. Then it will display Pivot Table Wizard Step 1 of 4 Dialogue Window
4. Keep the default option for data
5. Click NEXT to goto 2nd step of Pivot Table Wizard
6. Select the Data Range for A1:P51 as the option for RANGE
7. Click NEXT to goto 3rd step of Pivot Table Wizard. Here it will display the Pivot Table Layout with available list of fields. With help of this layout Define ROWS , COLUMNS and DATA to get the required table.
8. Hold the VILLAGE field and DRAG on to ROW option in the LAYOUT
9. Similarly, Hold the SOIL TYPE field and DRAG on to COLUMN option in the LAYOUT and finally
10. Hold TOTAL LAND HOLDING field and DRAG on to DATA option in the LAYOUT
11. Click NEXT to goto 4th step of Pivot Table Wizard and type the Cell address A55 to keep the output table in EXISITING WORKSHEET
12. Click FINISH to get the required table. Similarly create the following Tables:

Problem: Create a Table for Village wise different farmers Total Land Holdings under different Soil Types.

Problem: Create a Table for usage of N,P,K by the different farmers in each village under different Soil Types.

Prepare the report based on the results