eChapters

MS-ACCESS is a very powerful RDBMS (Data Base Management System) which manages data in term of special table called relation. Using MS-ACCESS you can manage all your information from a single database file. Database files are stored with extension. MDB.

ACCESS stores information in the form of tables and you build your database on its basis. Each row in a table holds all information’s & for a particular person it is called a record. And each column contains different pieces of information regarding that person, like Roll No, Name, Class, Address etc. Same as MSACCESS involves.

In ACCESS, you have few things known as Forms, Reports and Queries. They allow you to check and get desired information as and when required.

Solution:

Steps used for plotting the bar graph are as:

Step 1: Open Excel sheet and feed the above data as given in figure. 9.1.

Step 2: Select data and go to insert menu and select column chart. (figure 9.2)

Step 3: Select 2-D column, option first from dialog Box (figure 9.3).

Step 4: The desired output will be as shown (figure 9.4).

Remark The data labels, axis name, title of the graph etc. can be inserted through selecting option formatting chart area and add data labels by right clicking on the graph output (figure 9.5).

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.

7.1 The Formula Palette

By clicking on the equals sign in the formula bar a drop – down panel called the formula palette appeared.

Consider an example, type number 25 in cell A1 and move the cell pointer to cell B2. type or click the equal sign in the formulabar. Adrop – down panel will display formula result = and wait for further inputs. Enter sqrt result to 5 at B2.

The dialog box divides into parts as

(a) Name of the function at the top left of the argument entry box.

(b) Below of this there is the definition or description of the function.

(c) Next, there is an entry explanation.

(d) Formula result.

Things to remember: Any statistical or mathematical function can be activated with = (equal to) sign.

Now we have to learn how to enter numbers and text, how to edit any erroneous entry and then how to do simple calculations. Open empty excel spread sheet by clicking on the start menu in the window tool bars, click on Programs and then click on the Excel menu item.

6.1 Entering Numbers

Numeric entries are constant, can be integers, decimal fractions, integer fractions and scientific nations which can be entered by typing the number in the active cell [cell which can be made active by clicking the mouse on the cell.

5.1 Introduction

According to Croxton and Cowden, “Either for one’s own use or for the use of other, the data must be presented in some suitable form”.

Now – a – days everybody uses tables in one form or another, and accountants use them quite often. The work become tedious, especially if you had to do for 12 columns for the 12 months of the year, and more so if there were some modification to be done after having set up the entire table. The Americans have a special name for such tables- spreadsheet which makes life easy.

Steve Jobs and Steve Wozniak two young Americans in 1976 AD developed the first desktop computer – The Apple which was not user friendly and needed programming for useful work. Dan Bricklin, Robert Frankston and Dan Fylstra proposed a program to turn the computer’s memory into a giant virtual spreadsheet where necessary corrections and modifications could be done fairly, quickly and easily and marketed the program in 1978 under the trade name VisiCalc. VisiCalc was soon succeeded by Sugercal and other computer programs which were more user friendly. The Lotus 1-2-3 designed and developed by Larry Kaplan put further step, which set the standard for many applications under the IBM, Now a days Microsoft under the leadership of Bill Gates had been working on the sidelines perfecting graphical user Interface (GUI) packages for the PC range of computers that would widen its reach. Now Microsoft office program Suite the integrated word processing, spreadsheet, presentation and data base management.

The spreadsheet package in Microsoft office is called Excel – our basic software, or program for this manual.

There are manyreasons for using computerstoday. Word processing is area which has proved computers to be powerful than ever. There are many different kinds of word processors availabletoday, however, most share the same basic functions and do not require advanced computeror typing skills to use. These basicfunctions include typing, savingdocuments,openingdocuments, copying, pasting, cutting printing, checking spelling, etc. The commonly used word processors include Microsoft Word, ClarisWorks, Word Perfect, Word Pad, Apple Works, etc.

4.1 Microsoft Word

4.1.1 Introduction

Microsoft Word, or Word as it is commonly known, is a software application that allows the user to perform word processing. The word processing means the creation, input, editing, and production of documents and texts by means of computers systems. Microsoft Word allowthe user to format text with attributes such as bold, italics, font size, and margins. It is part of the Microsoft Office suite of applications and is a highly popular programme for the workplace.

Microsoft Word was first released in 1983 under the name Multi-Tool Word for Xenix systems. Versions were later writtenfor several other platformsincluding IBS PCs running DOS in 1983,the Apple Macintosh in 1984 and Microsoft Windows in 1989. The latest release is Word 2010.

Windows is an operating system with a Graphical User Interface (GUI). GUI displays graphical objects called icons, which represents the items you use. Also it is a menu driven interface, where you have menus and submenus to perform even the most basic tasks such as File open, Copy, and Help etc. The user need not know the computer commands, he just need to know simple English language to operate windows. This feature of windows made it a widely accepted operating system. Also windows allow multiprocessing environment, where we can perform more than one task simultaneously. For example, if you need to take a print out of a very long report which may take a couple of hours, you may give the command, and leave it at the background, and then you can keep working on the other applications. Windows supports a very useful pointing device called a mouse. With the mouse you can go anywhere on the screen and click where ever you want and pass instructions.

2.1 Definition and Concept

An operating system (abbreviated as ‘OS’) is the program that, manages all the other programs in a computer. Every general-purpose computer must have an operating system. It provides support for the loading and execution of other programs which are known as Application Programs.

1.1 Introduction

The word ‘computer’comes from the word ‘compute’, which means to calculate or perform a sequence of operations. Hence, a computer is normally considered to be a calculating device, which can perform arithmetic operations at enormous speed.

In other words, a computer takes information (or input), processes it according to a set of instructions (or process), and gives back a result (or output). In this respect, it is very similar to a calculator, but obviously somewhat more complex.

A computer is a multi-function platform. The same machine can perform many different tasks by using different programs. The programs (also termed as applications) are written to do everything imaginable. In other words, we can say that a program is a set of instructions issued to a computer in order to get the desired output.

Definition

A Computer can defined as an electronic device that takes input from its user, stores, processes data and generates the required output as per the processing instructions given to it by the user.

8.1. INTRODUCTION

The word ‘non-parametric’ means “not for any specific parameter”. For example, in the student’s t test we use the parameter ‘mean’. In the non-.parametric tests we check the randomness and trend of the pattern of distribution of a variable directly, without using a population parameter for comparing.

In contrast to the parametric tests, where many assumptions are made regarding the distribution of the parameter in the population (i.e. Gaussian features), here we do not make stringent assumptions about the population from which samples are drawn. These techniques are, therefore, also known as ‘distribution free’ tests.

We shall be discussing about 10 such non-parametric tests.

7.1. INTRODUCTION

The word ‘significance’ in statistics does not describe the strength of association. Statistical significance is simply related to the probability of the result being commonly or rarely encountered (If the probability of chance occurrence is low the result is likely to be determined by the set of circumstances under study and not by chance). If conclusions are to be drawn that a difference exists between two groups of subjects, then we have to ensure that they are equal in all respects except the one under test.

‘P’ values are used to assess the degree of dissimilarity between two (or more) sets of measurements. The ‘P’ value is the probability of obtaining a result as extreme as or more extreme than the one observed. The ‘P’ value is actually a measure of surprise and the smaller the value, the more surprising is the result. When ‘P’ value is between 0.05 and 0.01, the result is usually called statistically significant; when it is less than 0.01, it is usually called highly significant and if, values are lower than 0.005, then it is called very highly significant. Traditionally, the approach had been to indicate the level of significance by rounded off ‘P’ values e.g., P < 0.01. Now it has become a fashion to calculate the exact probabilities and thus arrive at a particular decision.

6.1. INTRODUCTION

All ecologist and biology researchers have to find out: (i) how reliable are the observed results? and (ii) what is the probability of difference between observed and expected results? The question of reliability is solved by estimating the confidence interval and the second question is addressed by the application of statistical tests for significance. Both these methods help us to draw conclusions on our observations, hence, may be grouped together as ‘inferential statistics’.

Referring back to the chapter on sampling, we may recall that it is usually not possible to calculate the ‘population parameter’ directly. Instead, we have to rely on estimates. Two types of estimates can be used, a point estimate and an interval estimate. A point estimate is a single numerical value of a sample statistic that is used to estimate the corresponding population parameter. For example, the sample mean, x , is used as an estimate of the population mean, μ Point estimates are not used widely because the value of some statistic, say mean, varies from sample to sample and we can’ t conclude with any degree of certainty that a single point estimate equals the population parameter. Therefore, an interval estimate is typically favoured. An interval estimate is a range of values within which the population parameter is likely to lie.

5.1. INTRODUCTION

Mean and standard deviation summarizes the salient features of a data set. But they do not describe adequately the full characteristics of the data. For an adequate description of the characteristics of a data set, a convenient method is to plot a frequency distribution curve. Such curve is constructed by first drawing a frequency polygon, which may then be smoothened to a frequency curve, indicating the distribution. The frequency curve or distribution of specific biological variables generally has a specific form and plays a very important role in statistical theory and practice. It is customary to describe a curve in terms of its symmetry or assymmetry and its flatness or peakedness.

The following types of distribution are commonly seen in the biological world:

4.1. INTRODUCTION

Dispersion is the extent to which values in a distribution differ from the average of the distribution. To quantify the extent of the variation, there are certain measures namely:

1. Range
2. Quartile Deviation
3. Mean Deviation
4. Standard Deviation

Range and Quartile deviation measure the dispersion by calculating the spread within which the values lie. Mean Deviation and Standard Deviation calculate the extent to which the values differ from the average.

3.1. INTRODUCTION

In this chapter, we will study the measures of central tendency which is a numerical method to explain the data in brief. We can see examples of summarizing a large set of data in day to day life like average marks obtained by students of a class in a test, average rainfall in an area, average production in a factory, average income of persons living in a locality or working in a firm etc.

One of the most important objectives of statistical analysis is to get one single value that describes the characteristic of the entire mass of data. Such a value is called the central value or an ‘average’ or the expected value of the variable. This single value is the point of location around which individual values cluster and, therefore, called the measure of location. Since this single value has a tendency to be somewhere at the center and within the range of all values it is also known as the measure of central tendency. The purpose of computing an average value for a set of observations is to obtain a single value which is representative of all the items.

2.1. INTRODUCTION

Many biological variables do not meet the assumptions of parametric statistical tests as they are not normally distributed, the variances are not homogeneous, or both. Objects in nature commonly exhibit one of three distributions:

1.1. INTRODUCTION

In this chapter, we will know how to classify raw data. The purpose of classifying raw data is to bring order in them so that they can be statistically analysed easily. Classification of objects or things saves our valuable time and effort. It is done in a logical manner and similar things are arranged into a group or class.

A Patent is a written document explaining an invention with exclusive right. It is used to protect an inventor/scientist and to prevent other from making profits without permission. It is also used as an authority paper permitting license holders to duplicate the results. A patent application requires a combination of legal documentation and technical papers. This issue makes patent writing a very different writing style.

In India, patent applications can be filed by a patent agent or an individual having some scientific and technical background to understand the invention. However, no one can understand the invention better than the inventors themselves. Document preparation requires healthy discussions between the inventor and agent. For inventors, a good understanding on patent writing style can greatly facilitate the documentation process. Before filing the patent application inventor must be sure about that the subject is eligible for patent protection, the invention has something new, the invention is not obvious and is not easily predictable from general consensus, and the invention has practical application.

Keeping in view the importance of intellectual property rights and their protection, Journal of Intellectual Property Rights (JIPR) was started in 1996. The objective of the journal is enhancing communication between policy makers, organizational agents, academics, and managers on the critical understanding and research on intellectual property; and to promote the development of the newly cultivated research field. The journal publishes contributed/invited articles, case studies and patent reviews; technical notes on current IPR issues; literature review; world literature on IPR; national and international IPR news, book reviews, and conference reports.

JIPR is covered in the abstracting/ indexing services namely Scopus, EBSCO host Electronic Journals Service, Directory of Open Access Journal, Library & Information Science Abstracts database and Legal information Institute of India database.