Problem

Procedure

Summarize the data with suitable statistical measures and frequency distribution

Descriptive Statistics

In Microsoft Excel, this Descriptive Statistics option, Generates a report of univariate statistics for data in the input range

1. Select DATA ANALYSIS Option from Tool Menu
2. Select DESCRIPTIVE STATISTICS Option from the displayed DATA ANALYSIS Dialogue Window
3. Block the data Range starting from F1 to P51 as the INPUT RANGE option in Descriptive Statistics Dialogue Window
4. Select COLUMN as the option for GROUPED BY
5. Click in CHECK BOX for Labels in the First Row
6. Click on NEW WORKSHEET as the option for OUTPUT

7. Click in CHECK BOX for SUMMERY STATISTICS to get one field for each of the following statistics in the output table: Mean, Standard Error (of the mean), Median, Mode, Standard Deviation, Variance, Kurtosis, Skewness, Range, Minimum, Maximum, Sum, Count, Largest, Smallest and Confidence Level.

8. Click OK Then it will display the required Summary Statistics for each of the parameter
9. Rename this sheet as SUMMARY Frequency Distribution and Histogram

Calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of Farmers that fall within ranges of Crop Yield . Because FREQUENCY returns an array (Bin Range), it must be entered as an array formula

Frequency Distribution and Histogram for Crop Yield

1. Copy the Entire Data in DATA Worksheet to New Worksheet as did earlier and rename the new worksheet as Frequency
2. From the Summary Worksheet observe that the Minimum and Maximum Values for Crop Yield is 388 and 2033 respectively.
3. Position the mouse pointer in the cell A55 and type the heading as Frequency Distribution for Crop Yield
4. Position the mouse pointer in Cell A56 and Type as BIN RANGE
5. Type value 350 in Cell A57 and type value 550 in Cell A58
6. Block the cells A57 and A58
7. Drag this blocked area up to Cell A67 to fill the values these cells automatically with an incremental values of 200
8. Select DATA ANALYSIS Option from Tool Menu
9. Select HISTOGRAM Option from the displayed DATA ANALYSIS Dialogue Window
10. Select the INPUT RANGE as F1 : F51
11. Select the BIN RANGE A57:A67
12. Type the cell address C57 as the OUTPUT option
13. Click on CHART OUTPUT option to get Histogram for the selected parameter.
14. Click OK
15. Similarly Calculate frequencies and Histogram for other parameters.