Mis771 Descriptive Statistics And Visualisation Assessment Answers

Answer:

Introduction 

The paper manufacturing business and supplies has been negotiated by the developments in the technology and digital devices availability. In the modern era, human beings choose to read any sort of news with the help of social media, watching the news real-time in You Tube and other live streaming sites and with the help of various websites. Hence, the paper manufacturing industry has recognised this dare that has led to transformation in the operations of their business. The primary goal of the organizations is to employ the individual and corporate customers within a strategic association, which makes sure that the acquisition of the commodity is sustained. Furthermore, the firms do not have knowledge regarding the viewpoint of the active customers regarding their services and products. It is significant for an organization to gain knowledge about the particular weaknesses and strengths that might have an impact on the degree of sales for papers. The customers are discovering it difficult to acquire the commodity as the velocity of the magazine and newspaper sales is decreasing at a significant rate because of the above discussed factors.

It is seen that Auspaper is a ancillary firm, which is estimating a decline in the sales due to the reducing demand for magazines and newspaper. It is due to this outcome of the forecasts that there might be a fall in sales; it is significant to establish a suitable relationship among the customers that may ideally sustain their sales. The organization moved ahead towards a market research organization to aid them in establishing a proper knowledge regarding the personality of the customers. This would support in estimating the chances of a customer establishing a strategic coalition. Hence, this paper will concentrate on creating frameworks with respect to customer satisfaction and the probability of a consumer establishing an agreement. This paper will make a synopsis of the data gathered and discussion will be undertaken with respect to the framework prepared. The process of construction of the framework and the possibilities of gaining a strategic agreement with respect to Auspaper will be explained in this paper.

Main Body

Descriptive Statistics

The data that have been gathered from the consumers are inclusive of their outlook on the services and the product that were scaled on a degree of 0 to 10, where 0 is taken as the lowest and the highest value to be 10. The information that are obtained include the duration of time from when the customer has been purchasing papers from Auspaper, the newspaper company there exists, and the total number of employees that have been appointed by the firm. Furthermore, the location of the customer who are within or outside Australia and New Zealand is even a concerning point that could have an impact on the degree of satisfaction of the employees. The process of product distribution exploited and the distinguished qualities were even mined from the customers who were taken as samples.

In a degree of 0 to 10, the aggregate opinion and view on the product quality was 7894, revealing that Auspaer was increasing their abilities to manufacture qualified products for their consumers. There are various consumers who have reported rate of satisfaction of 9.9 out of 10 for the quality of the product. Conversely, the data regarding the quality of the product was skewed towards the right that revealed that most of the consumers were pretty much happy with the product quality of the papers they purchased. Auspaper did not do very well in rectifying the problems that therefore the aggregate score of the views was found to be 5.36. The information that was collected regarding resolution of the complaint was normally distributed as the median is equivalent to the mean. Furthermore, the breadth and the depth of the product line of Auspaper, the brand image of the sales force, the degree of intrinsic support and the degree of enhancing and selling innovative products are the other reasons that were examined averagely. The level of satisfaction and pricing were also found to be rated above the aggregate with the aggregate being 6.9 out of 10. It is even seen that the consumers gave out an aggregate score of 6.04, relying on which Auspaper aids the warranty and the claims.

Some other factors were found to be rated below the average as the consumers were unhappy and that included the idea of whether the ordering and the billing were administered effectively, their speed of deliverance, the e-commerce facilities etc. Thus, there are certain regions that are essential for the firm to concentrate so that they can enhance their customer services that could possibly enhance the probability of the consumers to construct a strategic coalition with Auspaper. The organizations that were purchasing paper from Auspaper were distributed in equilibrium among the magazine and the newspaper companies. The stagnation in the level of customers in Australia and New Zealand indicated that the demand was in countries irrespective of these two. Even though the indirect process of product supply was greater by 4% with respect to the direct process.

Identify the significant variable for the Model

There are certain predictions which should be completed when undertaking the multiple regressions. Primarily, response variable requires to be taken from the normal distribution. This prediction is examined by constructing a histogram, which reveal the data distribution. The completion of the plotting of the histogram, the distribution is seen to be normally distributed, which reveals that the data was taken from a population that was normally distributed. The second forecast is that the sustainable forecasters require to have a linear association with the response variable. It is seen that a correlation variable was constructed and it was discovered that only six variables had a relationship with the response that was above average. The scatter plots of this matrix were constructed and the data distribution of the variables with high and reasonable correlation with score of satisfaction revealed the linear relationship.

The variables discussed above are inclusive of the quality of the product, response of the complaint, image, product line and the delivery speed and billing. The variables would then be taken in within the concentrated framework on forecasting the level of satisfaction towards the consumers. The frequencies of the variables were gathered and it was discovered that the type of industry did not reveal a vital difference among the industries as they were similar. Furthermore, all the definite variables will be inclusive in the first framework and the one that are seen to be unimportant shall be eliminated for the intention of development.

Constructing the model to forecast the customer satisfaction

First Model

The primary model for forecasting and estimating the degree of customer satisfaction for products and services of Auspaper includes the predictor sets that are given below:

• Quality of product
• Degree of complaint resolution
• The product line of Auspaper regarding their length and breadth
• Image of the sales force
• Awareness of billing and ordering
• The speed of delivery
• Type of Customer
• Type of Industry
• Company size
• Customer Location
• Process of distribution

Using the sample data, an R² value was generated i.e. of 84.96% and the set described that there was a variation of 84.96% in the satisfaction levels of the customers. Few variables still turned out to be of an insignificant category at the interval of 95% confidence and as an intern those variables must be removed for the improvement of the level of reliability.

The type of the customers had been sliced into two variables of dummy nature for the catering the categories of 3-levels.

Analysis 

Customer buying the Auspaper product of 1 to 5 years was more satisfied by 0.665 and those more than 5 years by 0.726. The magazines provided satisfaction by 0.093 more than the newspaper industry. Further, the customers of Australia and New Zealand had a greater satisfaction level by 0.127. While carrying on the business with Auspaper, the method of direct distribution was more effective as the satisfaction level would increase by 0.403. The increase in the quality score would lead to an improvement by 0.273.

The increase in the image of the sales force and the improvement and billing and ordering would improve the satisfaction by 0.346 and 0.056 respectively. Additionally, the speed of delivery makes a customer satisfied by 0.102.

Second model

I was based on removal of the unnecessary predictors and after their removal, there was a refitting and the remaining predictors were important as their p-values were low than 0.0001. The model consisted of the variables like the sales force image, quality of products, product line, firm size, customer type and the system of distribution.

Customer Satisfaction

The second model state that the increment in line of product will improve the satisfaction by 0.237 and the image of the sales force will increase by 0.353. The product quality is a significant factor that improves the satisfaction by 0.237. The direct system of distribution made the satisfaction level higher by 0.397 compared to brokers. The satisfaction of the customers of the Auspaper between 1 to 5 years was high by 0.907 and those more than 5 years was high by 0.3.

Interaction effect for product line and Region

There were three models for checking the importance of the predictors. The first model had a generation of R² of 41.78% and second model generated R² of 45.23%. Both of the product line and location of customers had a position at 95% of the level of confidence.

The line of product will increase the satisfaction level by 0.31 points and also the customers of the Australia and New Zealand had lower satisfaction by 2.927. The effect of the interaction improved the satisfaction by 0.555.

Probability of having alliance for customers with neutral views on Sales force image and product line

There was a plotting done for the prediction of probabilities of the strategic alliance on the image of sales force and the product line. The model had less sensitivity as it was 76.31% in comparison to 70.9%.

The model attained is below: -

The probability of alliance of neutral image of sales force and product line was 0.2258.

Probability for having strategic alliance on different levels of customers' perceptions of product quality and price flexibility

Similar to the logistic model, the quality of product and flexibility of price were used and the model that was obtained for computing the probabilities were as below:

The probabilities are illustrated below:

In the above table, the customer having quality of product as 1 and flexibility in price as 0 was devoid of having a strategic alliance. The alliance probabilities increased with the level of the rating and the maximum rating had probability that was too close to 1.

Time series for predicting turnover

There was a fitting of the simple time series and a model of linear prediction had been used in the evaluation of the three periods. The values obtained were 5,701.2, 5,754.1 and 5,807 respectively for the three periods and had been measured in thousands of dollars. The equation for the prediction of the same is :

Conclusion 

The customer satisfaction of Auspaper depends the type of customer, the size of the firm, distribution system, product quality, product line and image. Auspaper should have strategic alliance with organizations interested in product line and image of Auspaper. The price of Auspaper changes with product quality. Finally the turnover for the last three quarters of 2017 were generated.