MSC COURSEWORK IN MANAGEMENT QUANTITATIVE METHODS AND EXCEL Assignment

MSC COURSEWORK IN MANAGEMENT QUANTITATIVE METHODS AND leap out - Assignment ExampleThe scatter diagram for the individual purchase share (IPS) showed that clients spend from 30-60 per cent of their come income on Hindon products.Meanwhile, the histograms revealed that customer ratings were widely dispersed for components 1, 2, 3, 4 and 7, whereas Factors 5 and 6, IPS and overall satisfaction were found to be moderately dispersed.The combined scatterplots for Factors 8 and Factors 1 to 7, showed that (1) Factor 8 has a very slopped family with Factor 5 and overall satisfaction (2) Factor 8 has a substantial to very strong association with Factors 1 and 2 and (3) Factor 8 has a low to moderate relationship with Factors 3, 6 and 7, although 7 tends to be negatively correlated with Factor 8. All these three generalizations were verified using coefficient of correlation analysis. The complete workings with 26 figures and two tables are shown in Appendix 1.2. The HD management is inte rested in finding out the average perceptions of HDFactors 1 to 7 as seen by all of its customers. Do calculations to get up information on what you can say about these average perceptions on the basis of your sample.Answers The average customer satisfaction ratings are as follows For Factor 1, 3.5 for Factor 2, 7.9, for Factor 3, 5.2 for Factor 4, 2.4 for Factor 5, 2.9 for Factor 6, 2.7 and for Factor 7, 7.0. From the average perceptions, it may be concluded that among Factors 1 to 7, Factor 2 or the design promoter obtained the most favourable rating of 7.9 from the customers, followed by Factor 7 or the website quality work out with the encourage most favourable rating of 7.0. Factor 3 or the reliability factor was rated to be sightly from an average of 5.2. The rest of the factors received very low ratings, with Factor 4 or the price factor getting the lowest average rating of 2.4.3.The management of HD