VLC Home
  Course Home
   
--  MS EXCEL CASE STUDY
-

Problem
-

Procedure
- Data Preparation
- Calculation of crop productivity, convert the data of "Total land holding", "Soil depth " amenable to analysis
- Summarize the data with suitable statistical measures and frequency distribution
- Regression Analysis
- View data using database features
- Represent the data through appropriate graphs and tables
   
 
Self Test
Ask a Question
Download PDF File


Data Preparation

Copy the Data in District Worksheet into another worksheet named DATA

  1. Select OPEN Option form the FILE MENU
  2. Choose SAMPLE DATA. XLS file from DATA Folder. Then it will open the data file.
  3. Select WORKSHEET Option from the INSERT Menu
  4. Double Click on Sheet1 and Type DATA as the name for newly inserted worksheet
  5. Click on District Worksheet
  6. Block the entire data range
  7. Click on COPY Icon
  8. Activate DATA Worksheet
  9. Position the mouse pointer in Cell A1
  10. Click on PASTE ICON. Then it will copy the entire data in DATA Sheet Formatting the data
Adjust the column width
  1. Block the Entire data.
  2. Click on FORMAT Menu
  3. Select AUTOFIT SELECTION from COLUMN Option. Then it will adjust column width automatically. Formatting the Numbers
  4. Block the data Range starting from D1 to N51.
  5. Select CELLS option from the FORMAT Menu
  6. Click on NUMBER Tab of the displayed FORMAT CELLS Window
  7. Select category as NUMBER
  8. Click OK to display all the data in two decimals.