eChapter Name: Data Analysis Using MS-Excel
9789389907834
eBook Name: COMPUTERS IN AGRICULTURE
by Manish Kr. Sharma, Anil Bhat, M. Iqbal Jeelani Bhat
Some basic and most common analysis tools used in research are summary statistics. These can be analyzed in Ms-Excel through the following ways.
8.1 Summary Statistics
The following data are the yield (q/ha) of 60 varieties of paddy maintained in a research station for breeding trails:
53 ,74, 89, 65, 88, 65, 45, 70, 25, 80, 75, 85, 47, 63, 78, 44, 42, 51, 59, 86, 76, 48, 30, 38, 67, 78, 74, 68, 58, 59, 36, 76, 89, 48, 67, 69, 35, 46, 89, 75, 79, 56, 42, 41, 60, 65, 68, 69, 61, 63, 95, 94, 85, 83, 76, 71, 68, 62, 64, 62.
Calculate the summary statistics for the study of the data.
Solution: The summary statistics of the data using MS – excel can be obtained / analyzed through following steps:
Step 1: Open Excel sheet and feed the data as given in Fig. 8.1.
Step 2: Go to data menu and select Data Analysis. Sometimes this menu is not available in the data, it can be added through add in → check in, analysis tool pack → go. It will appear as the way showing in Fig. 8.1.