Survey of Satisfaction with College Facilities

Survey of Satisfaction with College FacilitiesAssignment 11. Plan for collection of Primary info and secondary dataPrimary data is the data which is collected directly from the field, i.e., it is first exceed data and the secondary data is collected from rough 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 forefrontnaire leave be prep ared which will be filled up on the response of these one-on-ones. 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(prenominal) organization / department which collects the school/college data or from any journal or from any Researcher.2. Present the survey methodology and sampling frame usedThere are different ranges in the college which are concurrently 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. hither 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 crowd (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 shiftings. 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 matterGenderOrigin .Age.. truly good safe mediocreBadVery BadHow a good deal comfortable are you on the overall infrastructure of the college?How a great deal satisfied will you be if backwash facilities are available?How much satisfied are you with the hostelry facilities of the college?How much satisfied are you with the gym?How much satisfied are you with the parking speediness 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 valuesThe data collected from the after the survey is recoded as per Likert scaling and is as belowHow much satisfied are you on the overall infrastructure of the college?How much sa tisfied 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 quick-wittedness 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?1422522425442342332242244511243454221254614221247224424285322455935132241042253221144445441255252421322344141442222241554444341634242241721141121842252251953444342012222222141343122252545222323242342452444422541225432652452452743244222834122342954211553044422223134245423242322243353534443432222213554441123643522233732214423844222213954443324032425534155134224244255214352344124434222234554144244644244124754344244832244424955423235044353355. For analytic purpose the variables are denoting as belowHow much satisfied are you on the overall infrastructure of the college?How much satisfied will you be if wash bring out facilities a re 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 infrastructureLaundry facilitiesHostel facilitiesgymparking facilitytoilet facilitiesstructure of labsMeanoverall infrastructure3.88Laundry facilities3Hostel facilities2.66gym3.26parking facility3toilet facilities2.7structure of labs3.06The average of the boilers suit 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 at that place in the college.Regarding Hostel facilities, the average response is below averages which indicate that there is some urgent need to repair this sector.middle school facility is slightly to a greater extent than the Average. The condition is offend than Average but less than GoodIn 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 surveyLaundryThe above diagram shows that 36% are aspect 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 centrosymmetric situation is observed here. It seems that the service provider is paying good attention to selected individuals.Hostel facilitiesIn case of Hostel 46% saying it Bad and this is a matter of concern. While discussing with Average values, the data indicates the resembling urgency. But at the same time it can be observed that 24% , which is in second 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.GymWhile 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.ParkingThe 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.ToiletIn 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.LabIn case of Lab, which i s 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 literary argumentsNow as per the given question, the edit 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 LaundryAs shown in the graph, the required equation is Y=.732xCase 2. Overall infrastructure and Satisfaction on HostelThe required equation is Y= .659XCase 3. Overall infrastructure and Satisfaction on Gym The required equation is Y= .787XCase 4. Overall infrastructure and Satisfaction on Parking facility The equation her e is Y= .740X.Case 5. Overall infrastructure and Satisfaction on Toilet facility Here the equation is Y=.656xCase 5.Overall infrastructure and Satisfaction on Toilet facility Here the equation is Y= .735x9.Business ReportAll 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 in reality 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 devil issues .i.e. Toilet and Hos tel need to be addressed seriously.Assignment 2Question No.1X = scores of a market survey regarding the acceptability of a new product launch by a companyFrequency confuse with a class interval of 5Class interval5-1010-1515-2020-2525-3030-3535-4040-4545-50frequency2011621082Mean, variance and standard deviation.Mean () = ,where N = and Variance = 2= 2Standard 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 intervalmid value(xi)frequency5-107.5210-1512.5015-2017.5120-2522.5125-3027.5630-3532.5235-4037.51040-4542.5845-5047.52247.5 = 32Heremid value(xi)frequency7.5256.2515112.512.50156.250017.51306.2517.5306.2522.51506.2522.5506.2527.56756.251654537.532.521056.25652112.537.5101406.2537514062.542.581806.253401445047.522256.25954512.5247.5 = 32= 8306.25= 1095= 40600Mean = = 1095/32 = 34.22Variance = 2= (40600/32) (34.22)2= 97.83Standard Deviation = Square root of variance =9.90Score corresponding to 50% percentile.50% percentile is also the median.Here the data set has to be written in increasing order88182526262727293032353637383939394040404041414243444445454849There 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 order881825262627