QUESTIONAIRE DATA

A Statistics report on a questionaire data

A Statistics Report On a Questionaire Data

Case

Company P is a large agrochemicals producer with headquarters in the US. It has a major sales and research subsidiary in the UK. The company sells its crop protection products (such as insecticides and fungicides) to retail firms, who sell them in turn to farm operators. Farmers generally follow the advice of independent agents when they make their decisions about which crop protection products to use on specific crops in specific situations at specific times of year.

The UK sales organization operates a website for marketing these products. It is an important way for informing agents and farmers of new and existing products, enabling them to make informed choices and encouraging them to specify the company's products. It also provides a means of doing e-business with the retailers, who can place orders and make pricing enquiries directly on the website.

The website has been running now for 12 months and the sales research department needs to assess how well it has been received and how it might be improved. It therefore designed an online questionnaire to which all users who signed on, over the period of a week, were directed. They had the option of completing the questionnaire (and having the chance of winning a year's supply of high quality British cheeses) or cancelling and going back to the sign on page.

Questionnaire

The questionnaire was designed to be simple and non-specific.

The data that was collected were the first 20 responses from farmers, the first 20 from agents, and the first 20 from retailers. Some of the response items from these 60 respondents are given in the accompanying spreadsheet. The number of the respondent indicates the order in which the completed questionnaires were submitted (that is, respondent 1 was the first to submit).

Data analysis

Age (Binned)

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

<= 25.00

7

11.7

11.7

11.7

26.00 - 32.60

10

16.7

16.7

28.3

32.61 - 40.20

10

16.7

16.7

45.0

40.21 - 47.80

8

13.3

13.3

58.3

47.81 - 55.40

8

13.3

13.3

71.7

55.41+

17

28.3

28.3

100.0

Total

60

100.0

100.0

The above table provides the frequency distribution for age. It can be figured out that majority of the respondent have an age above 50.

yrs_use (Binned)

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

<= 2.00

12

20.0

20.0

20.0

3.00 - 4.00

7

11.7

11.7

31.7

5.00 - 6.00

12

20.0

20.0

51.7

7.00 - 8.00

9

15.0

15.0

66.7

9.00 - 10.00

13

21.7

21.7

88.3

11.00+

7

11.7

11.7

100.0

Total

60

100.0

100.0

From the above table it can be seen that 20% of the respondent use this website less than two years, 11.7 % use this website between 3 to 4 years, 20% use it between 5 to 6 years, 15% use it between 9 to 10 years and 11.7% use it more than 11 years.

Freq_use (Binned)

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

<= 2.00

7

11.7

11.7

11.7

3.00 - 5.60

6

10.0

10.0

21.7

5.61 - 9.20

9

15.0

15.0

36.7

9.21 - 12.80

20

33.3

33.3

70.0

12.81 - 16.40

15

25.0

25.0

95.0

16.41+

3

5.0

5.0

100.0

Total

60

100.0

100.0

The above table reveals this fact that 11.7 % of the respondents use this website less than 2 times, 10% use this website between 3 to 5 times, 15.0% use this website between 5 to 9 times. It is as well an be found that majority of the respondent use this website more than 12 times in a month.

Histogram

Descriptive Statistic for Ag, yrs_use and Freq_use

Descriptive Statistics

N

Minimum

Maximum

Mean

Std. Deviation

Age

60

22.00

63.00

43.7000

13.01668

yrs_use

60

1.00

12.00

6.3500

3.55502

Freq_use

60

.00

20.00

9.8833

4.92689

Valid N (listwise)

60

From the above table it can be figured out that respondents have an average age ...