Survey of Satisfaction with College Facilities

Survey of Satisfaction with College FacilitiesAssignment 11. Plan for hookup of Primary info and subaltern dataPrimary data is the data which is collected directly from the field, i.e., it is commencement hand data and the lower-ranking data is collected from some other source, i.e. second hand data. In this given problem primary winding data can be collected through interview to the Students and Staffs of the college. A Questionnaire will be wide-awake which will be filled up on the response of these individuals. Based on the information provided by them the database will be prep atomic number 18d and thus the primary data will be collected.In baptismal font 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 utilizeThere argon 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 thus conducted on the basis of that and a selected sample will be chosen randomly from the students and from the staffs. Here since whizz has to plan a survey methodology, first thing which has to be done is to identify the sample members. For this think a total number of 50 individuals may be selected form70 students and 30 staffs taking 50% from from each one group (that is 35+15=50). Now, the Interview method will be used here for collection of data. Data on pleasure 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 essentially the area/ space from where the sampling is to be done. Here one has to see whether all the units in the cosmos are available in the sample. List of students and staffs must be representative of all divi siones and segments of the college.The level of satisfaction will be coded as 5= precise groovy, 4= good, 3= medium, 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 occasionGenderOrigin .Age.. precise good skillful second-rate darkVery big(p)How more cheery are you on the boilersuit infrastructure of the college?How much satisfied will you be if airstream facilities are available?How much satisfied are you with the indian lodge facilities of the college?How much satisfied are you with the gym?How much satisfied are you with the place forwardness of the college?How much satisfied are you on the mess 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 th e 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?1422522425442342332242244511243454221254614221247224424285322455935132241042253221144445441255252421322344141442222241554444341634242241721141121842252251953444342012222222141343122252545222323242342452444422541225432652452452743244222834122342954211553044422223134245423242322243353534443432222213554441123643522233732214423844222213954443324032425534155134224244255214352344124434222234554144244644244124754344244832244424955423235044353355. For Analytical procedure the variables are denoting as belowHow much satisfied are you on the overall infrastructure of the college?How much satisfie d 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 infrastructureLaundry facilitiesHostel facilitiesgymparking facilitytoilet facilitiesstructure of labsMeanoverall infrastructure3.88Laundry facilities3Hostel facilities2.66gym3.26parking facility3toilet facilities2.7structure of labs3.06The 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 withal to be there in the college.Regarding Hostel facilities, the average response is below averages which indicate that there is some imperative need to repair this sector.Gym facility is slightly more than the Average. The condition is better than Average but less than advantageouslyIn subject area of parking facility the satisfaction level is just 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 base on information derived from the surveyLaundryThe above diagram shows that 36% are look 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 supplier is paying good attention to selected individuals.Hostel facilitiesIn case of Hostel 46% saying it Bad and this is a matter of concern. While discussi ng with Average values, the data indicates the same urgency. But at the same quantify it can be observed that 24% , which is in 2nd 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. similarly 6% feeling their accommodation as Very Good.GymWhile discussing about Gym, which is yet to be established, 48% is in privilege 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 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 linesNow 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 sise independent variable. Taking each Independent variables separately, the trend line along with the graph will be created. movement 1. Overall infrastructure and Satisfaction on LaundryAs shown in the graph, the required equation is Y=.732x trip 2. Overall infrastructure and Satisfaction on HostelThe required equation is Y= .659X font 3. Overall infrastructure and Satisfaction on Gym The required equation is Y= .787XCase 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=.656xCase 5.Overall infrastructure and Satisfaction on Toilet facility Here the equation is Y= .735x9.Business Report wholly 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 real says whether there is really any need of refurbishing the whole college or not. This dependent variable depends on several(prenominal) 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 analytic thinking 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 2Question No.1X = scores of a market survey regarding the acceptability of a new crossroad launch by a companyFrequency Table with a class interval of 5Class interval5-1010-1515-2020-2525-3030-3535-4040-4545-50frequency2011621082Mean, variance and standard deviation.Mean () = ,where N = and variate = 2= 2 exemplar Deviation = Square root of variance.And Xi here will be the mid(prenominal) 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.25clxv4537.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.2 2)2= 97.83Standard Deviation = Square root of variance =9.90Score jibe to 50% percentile.50% percentile is also the median.Here the data cut back has to be written in increasing baseball club88182526262727293032353637383939394040404041414243444445454849There 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