Survey of Satisfaction with College Facilities

Published Date: 03 Oct 2016 Last Modified: 04 Oct 2017

Assignment 1

1. Plan for collection of Primary data and secondary data

Primary data is the data which is collected directly from the field, i.e., it is first hand data and the secondary data is collected from some other source, i.e. second hand data. In this given problem primary data can be collected through interview to the Students and Staffs of the college. A Questionnaire will be prepared which will be filled up on the response of these individuals. Based on the information provided by them the database will be prepared and thus the primary data will be collected.

In case of secondary data, the data could be collected from any organization / department which collects the school/college data or from any journal or from any Researcher.

2. Present the survey methodology and sampling frame used

There are different areas in the college which are simultaneously used both by the Students of the college as well as the Staffs of the college. Considering those area alongwith few other he questionnaire is prepared. The survey will be then conducted on the basis of that and a selected sample will be chosen randomly from the students and from the staffs. Here since one has to plan a survey methodology, first thing which has to be done is to identify the sample members. For this purpose a total number of 50 individuals may be selected form70 students and 30 staffs taking 50% from each group (that is 35+15=50). Now, the Interview method will be used here for collection of data. Data on satisfaction level of each individual will be collected on different variables. Once the sampling units is finalized, sampling frame needed to be done. Sampling frame is basically the area/ space from where the sampling is to be done. Here one has to see whether all the units in the population are available in the sample. List of students and staffs must be representative of all classes and segments of the college.

The level of satisfaction will be coded as 5= very good, 4= good, 3= average, 2= bad, 1= very bad, in five categories, following Likert scaling.

3. Design a questionnaire to know the opinion of students and staff on the matter

1. Gender………………………………………
2. Origin ……………………………………....
3. Age……………………………………………..

	Very good	Good	Average	Bad	Very Bad
How much satisfied are you on the overall infrastructure of the college?
How much satisfied will you be if Laundry facilities are available?
How much satisfied are you with the Hostel facilities of the college?
How much satisfied are you with the gym?
How much satisfied are you with the parking facility of the college?
How much satisfied are you on the toilet facilities?
How much satisfied are you on the structure of labs in the college?

4. Information for decision making by summarizing data using representative values

The data collected from the after the survey is recoded as per Likert scaling and is as below:

	How much satisfied are you on the overall infrastructure of the college?	How much satisfied will you be if Laundry facilities are available?	How much satisfied are you with the Hostel facilities of the college?	How much satisfied are you with the gym?	How much satisfied are you with the parking facility of the college?	How much satisfied are you on the toilet facilities?	How much satisfied are you on the structure of labs in the college?
1	4	2	2	5	2	2	4
2	5	4	4	2	3	4	2
3	3	2	2	4	2	2	4
4	5	1	1	2	4	3	4
5	4	2	2	1	2	5	4
6	1	4	2	2	1	2	4
7	2	2	4	4	2	4	2
8	5	3	2	2	4	5	5
9	3	5	1	3	2	2	4
10	4	2	2	5	3	2	2
11	4	4	4	4	5	4	4
12	5	5	2	5	2	4	2
13	2	2	3	4	4	1	4
14	4	2	2	2	2	2	4
15	5	4	4	4	4	3	4
16	3	4	2	4	2	2	4
17	2	1	1	4	1	1	2
18	4	2	2	5	2	2	5
19	5	3	4	4	4	3	4
20	1	2	2	2	2	2	2
21	4	1	3	4	3	1	2
22	5	2	5	4	5	2	2
23	2	3	2	4	2	3	4
24	5	2	4	4	4	4	2
25	4	1	2	2	5	4	3
26	5	2	4	5	2	4	5
27	4	3	2	4	4	2	2
28	3	4	1	2	2	3	4
29	5	4	2	1	1	5	5
30	4	4	4	2	2	2	2
31	3	4	2	4	5	4	2
32	4	2	3	2	2	2	4
33	5	3	5	3	4	4	4
34	3	2	2	2	2	2	1
35	5	4	4	4	1	1	2
36	4	3	5	2	2	2	3
37	3	2	2	1	4	4	2
38	4	4	2	2	2	2	1
39	5	4	4	4	3	3	2
40	3	2	4	2	5	5	3
41	5	5	1	3	4	2	2
42	4	4	2	5	5	2	1
43	5	2	3	4	4	1	2
44	3	4	2	2	2	2	3
45	5	4	1	4	4	2	4
46	4	4	2	4	4	1	2
47	5	4	3	4	4	2	4
48	3	2	2	4	4	4	2
49	5	5	4	2	3	2	3
50	4	4	3	5	3	3	5

5. For Analytical; purpose the variables are denoting as below:

How much satisfied are you on the overall infrastructure of the college?	How much satisfied will you be if Laundry facilities are available?	How much satisfied are you with the Hostel facilities of the college?	How much satisfied are you with the gym?	How much satisfied are you with the parking facility of the college?	How much satisfied are you on the toilet facilities?	How much satisfied are you on the structure of labs in the college?
overall infrastructure	Laundry facilities	Hostel facilities	gym	parking facility	toilet facilities	structure of labs

	Mean
overall infrastructure	3.88
Laundry facilities	3
Hostel facilities	2.66
gym	3.26
parking facility	3
toilet facilities	2.7
structure of labs	3.06

The average of the Overall infrastructure is 3.88 which indicated that on average people are recognizing the overall infrastructure as almost “GOOD”.

When it was asked “How much satisfied will you be if Laundry facilities are available?”, the mean response is 3 which is Average. This is quite sensible because this facility is yet to be there in the college.

Regarding “Hostel facilities”, the average response is below averages which indicate that there is some urgent need to repair this sector.

Gym facility is slightly more than the “Average”. The condition is better than “Average” but less than “Good”

In case of “parking facility” the satisfaction level is exactly “Average” which indicates that there is scope to improve the sector.

Satisfaction level on “Toilet facilities” is below average which also requires urgent attention of the college authority.

Structure of Labs also requires some kind of attention.

6. Drawing valid conclusions based on information derived from the survey

Laundry

The above diagram shows that 36% are saying good to Laundry facility and also 36% is recognizing it as Bad. Only 8% is saying it “very Good” and 8% is saying very Bad. Some kind of symmetrical situation is observed here. It seems that the service provider is paying good attention to selected individuals.

Hostel facilities

In case of Hostel 46% saying it “Bad” and this is a matter of concern. While discussing with Average values, the data indicates the same urgency. But at the same time it can be observed that 24% , which is in 2^nd position as far as percentages in concern, is saying is good. It may indicate that some portion of the Hostel is having better situation than the rest. Also 6% feeling their accommodation as “Very Good”.

Gym

While discussing about Gym, which is yet to be established, 48% is in favour of this, out of which 42% saying it as a Good facility and 6% as “Very Good” facility.

Parking

The above diagram shows that 38% are saying “Bad” to Parking facility and also 30% is recognizing it as “Good”. Only 8% is saying it “very Bad” and 12% is saying “Very Good”.

Toilet

In case of Toilet 44% saying it “Bad” and this is also a matter of concern. While discussing with Average values, the data indicates the same urgency. But at the same time it can be observed that 22% is saying is good. It may indicate that there is also some better situation. Also 8% feeling as “Very Good”.

Lab

In case of Lab, which is more related to education, 46% is in favour of this, out of which 36% saying it as a Good facility and 10% as “Very Good” facility.

7. Trend lines

Now as per the given question, the trend lines have to be created in the spreadsheet graph. For this purpose , here the intercept is considered as zero(0) and then the equation is shown alongwith the scatter plot and the trend line.

Here the first variable “Overall infrastructure” is considered as the Dependent Variable and there are other six independent variable. Taking each Independent variables separately, the trend line along with the graph will be created.

Case 1. Overall infrastructure and Satisfaction on Laundry:

As shown in the graph, the required equation is Y=.732x

Case 2. Overall infrastructure and Satisfaction on Hostel:

The required equation is Y= .659X

Case 3. Overall infrastructure and Satisfaction on Gym :

The required equation is Y= .787X

Case 4. Overall infrastructure and Satisfaction on Parking facility :

The equation here is Y= .740X.

Case 5. Overall infrastructure and Satisfaction on Toilet facility :

Here the equation is Y=.656x

Case 5.Overall infrastructure and Satisfaction on Toilet facility :

Here the equation is Y= .735x

9.Business Report

All the equations are formed considering the variables separately. In each equation, if value of x is given, the estimated value of Y will be obtained by solving the equation with simple calculation. The dependent variable is considered as “Overall infrastructure:” which actually says whether there is really any need of ‘refurbishing the whole college” or not. This dependent variable depends on several other issues/ factors as considered as Independent variable.

So, taking care or giving attention on those areas actually help the project to take decision whether or not this could be done. The above analysis tells which area needs utmost attention and which area is somehow okay up to this. Based on the analysis, one could say that the two issues .i.e. Toilet and Hostel need to be addressed seriously.

Assignment 2

Question No.1

X = scores of a market survey regarding the acceptability of a new product launch by a company

Frequency Table with a class interval of 5

Class interval	5-10	10-15	15-20	20-25	25-30	30-35	35-40	40-45	45-50
frequency	2	0	1	1	6	2	10	8	2

 

Mean, variance and standard deviation.

Mean () = ,where N = and Variance = σ2= ²

Standard Deviation = Square root of variance.

And Xi here will be the mid value of the class interval. The following table is being constructed for the required calculations.

Class interval	mid value(xi)	frequency
5-10	7.5	2
10-15	12.5	0
15-20	17.5	1
20-25	22.5	1
25-30	27.5	6
30-35	32.5	2
35-40	37.5	10
40-45	42.5	8
45-50	47.5	2
	247.5	= 32

Here

mid value(xi)	frequency
7.5	2	56.25	15	112.5
12.5	0	156.25	0	0
17.5	1	306.25	17.5	306.25
22.5	1	506.25	22.5	506.25
27.5	6	756.25	165	4537.5
32.5	2	1056.25	65	2112.5
37.5	10	1406.25	375	14062.5
42.5	8	1806.25	340	14450
47.5	2	2256.25	95	4512.5
247.5	= 32	= 8306.25	= 1095	= 40600

Mean = = 1095/32 = 34.22

Variance = σ2= (40600/32) – (34.22)2

= 97.83

Standard Deviation = Square root of variance =9.90

Score corresponding to 50% percentile.

50% percentile is also the median.

Here the data set has to be written in increasing order

8	8	18	25	26	26	27	27
29	30	32	35	36	37	38	39
39	39	40	40	40	40	41	41
42	43	44	44	45	45	48	49

There are 32 observations in all

=> There will be two middle values.

The average of those two middle values will be the value corresponding to 50% percentile or the Median.

Now since both are 39 implies the average is also 39.

So, it could be said that the score 39 corresponds to 50% percentile.

Calculate the location of third quartile.

Rewriting the data set in increasing order:

8	8	18	25	26	26	27	27	29	30
32	35	36	37	38	39	39	39	40	40
40	40	41	41	42	43	44	44	45	45
48	49

Median is the average of the two 39 (differently marked).

Now, 3rd quartile is the median of the data points which are above the Score corresponding to 50%. Here the scores which are above median are as follows:

39	39	40	40	40	40	41	41	42	43
44	44	45	45	48	49

Here also the number of observations is even, (16). So, there will be two middle-most values. These are 41 and 42. The average between these two, i.e. (41+42)/2 =41.5 is the required answer.

Question No.2

Given,

Income(00’s £)	20	54	46	42	36	23	61	26	49	64
Phone bill (£)	45	165	175	90	95	35	210	50	110	190

Step 1:

Let X = Income and

Y = Phone bill

The correlation coefficient is defined as

where

and

= and

=

Step 2:

20	45	400	2025	900
54	165	2916	27225	8910
46	175	2116	30625	8050
42	90	1764	8100	3780
36	95	1296	9025	3420
23	35	529	1225	805
61	210	3721	44100	12810
26	50	676	2500	1300
49	110	2401	12100	5390
64	190	4096	36100	12160
= 421	= 1165	= 19915	= 173025	=57525

Step 3:

So, = 421/10 =42.1 =>