MIS771 Descriptive Analytics and Visualization Assignment 2 - Future Business Decision of AusPaper

1
MIS771 Descriptive Analytics and
Visualization
Assignment 2
Future Business Decision of AusPaper
Student Name: Student ID:
Due Date: Unit Name:

2
Table of Contents
Assignment 2...............................................................................................................................................1
Future Business Decision of AusPaper.........................................................................................................1
Introduction.................................................................................................................................................3
Research direction...................................................................................................................................4
Task 1.......................................................................................................................................................4
Task 2.......................................................................................................................................................5
2.1 Correlation Analysis.......................................................................................................................5
2.2 Regression Analysis........................................................................................................................6
2.3 Outside ANZ Model........................................................................................................................8
Task 3.......................................................................................................................................................8
3.0 Logistic Regression.........................................................................................................................8
3.1 Maximum Likelihood...................................................................................................................10
3.2 Predicted probability visualization...............................................................................................11
Task 4.....................................................................................................................................................13
Forecasting of Sales...............................................................................................................................13
Conclusion.................................................................................................................................................14
References.................................................................................................................................................16
Appendices................................................................................................................................................17
Appendix 1.............................................................................................................................................17
Appendix 2.............................................................................................................................................22
Appendix 3.............................................................................................................................................30
Appendix 4.............................................................................................................................................31
Appendix 5.............................................................................................................................................33

3
Introduction
The Australian paper giant Auspaper has a long history of success in production of paper
products. The company is an affiliated franchise of Pinnon Paper Industries. The historical
backdrop of the company is very encouraging, and they used to produce almost equal amount of
paper products compared to the total products all the similar companies. The major customers
belonged to two different market sectors. The company used to sell their products to the
magazine and newspaper sectors through direct sales or through dealer. The company also
exported paper products to various countries of Asia, Middle East, USA, and Europe and in
different provinces of India as well as Africa.
The future problem areas were identified by the research and development wing of Auspaper and
some of the concerns bothered the management. The expansion of social media, along with
increasing market of electronic gadgets was two of the most important factors for probable future
decline in sale. The company indented to perform a market research and they approached the
research team manager Hugo Barra, a PhD in Data Science and a Master in Digital Marketing at
ANALYTICS7. The job of analysing the project was given to the scholar after a long
conversation on the scope of the research.
Research direction
The key factor was identified as edification of strategic alliance in a business to business
environment with respect to the customer satisfaction with Auspaper’s functioning and products.
The likelihood of the customers was also evaluated with a logistic model for further

4
understanding the trend of strategic alliance. Furthermore a forecasting for last three quarters of
sales was conducted for the year 2017.
Task 1
The first task was to assess the dependent factor of the collected data fields of 200 customers.
The descriptive values of strategic alliance were found for satisfaction level of the customers.
The job was performed using Microsoft Excel Tool pack facility. The average satisfaction score
was found as 6.95 in scale of 10. Indication of almost 70% likely future purchase of Auspaper
products was observed. The deviation of satisfaction score of 1.24 was also noticed. This factor
was a very disturbing figure as 12% deviation in the negative side could deter the future planning
of the company. The median was 7.05 and a Gaussian nature of the distribution of satisfaction
score was seen with a very minor skewness of 0.09. The mode of the data was at 5.4; this
indicated the satisfaction level for most of the customers. This trend was not at all encouraging
for the company. The range of the satisfaction was noted to be 5.2 with minimum satisfaction
level at 4.7 and maximum at 9.9. Total 200 samples were analyzed for this study and the
standard error was calculated as 0.08, which provided an approximate estimate for the population
mean. The 95% confidence interval for the satisfaction score was between 6.77 and 7.12, the
compactness of the confidence interval was a useful result to analyse the customer likelihood for
the paper products of Auspaper.
The entire data was split into two subcategories based on the strategic alliance choice of the
customers. The first part consisted of 86 customers who preferred to continue future alliance
with the company. The average satisfaction level for those customers was found to be 7.94,
which was expectedly greater than that of the total data set. The median was at 7.9 and the mode

5
at 7.6. Almost perfect normal distribution for the satisfaction curve was seen with a negligible
skewness of -0.08. The consistency and homogeneity for the customers was evident from the
descriptive figures. The 95% confidence interval was calculated as [7.75, 8.13]. The second
section of customers with preference of discontinuing their strategic alliance with Auspaper was
114 in numbers. It was noticed that most of the customers were unhappy with services in the
collected sample data. The average satisfaction was 6.2 and the median was at 6.3, the most
important observation was for the median which was 5.4 for the data set. The distribution had a
skewness of 0.26 with kurtosis of -0.77.
Task 2
2.1 Correlation Analysis
The satisfaction of customers was the dependent variable and it was cross checked with the
independent factors. Multiple correlation technique was used for the purpose and association
levels among the factors were noticed.
The probable dependent variable was customer satisfaction score, which was continuous in
nature. The strategic alliance was a binary dependent variable. Initially correlation with these
dependent variables was noticed. In order to narrow down on the search of independent factors,
and finalize the list for most significant independent factors multiple correlation matrix was
constructed using the excel tool pack using this set of 15 variables.
For the purpose of visual influence, initially scatter diagrams were drawn. The diagrams
represented the trend of the dependent factor based on the independent factors. The delivery
speed was found to have a high positive (R = 0.63) correlation with customer satisfaction; price

6
flexibility had a low level of correlation (R = 0.03) with satisfaction. The dependent variable had
a high positive correlation (R = 0.54) with billing, image (R = 0.48), product line (R = 0.65),
complaint readdress (R = 0.59) and product quality (R = 0.51). Some of the variables such as e-
commerce (R = 0.34) and technical support (R = 0.2) also had low level of positive correlation
with satisfaction of customers. The scatter diagrams clearly reflected the trend of these
associations. Pricing was the only factor which was negatively (R = -0.28) correlated with the
dependent variable. The purchase intention of the customers was hampered by the higher prices
of paper products of Auspaper compared to other rival companies. On the positive side the fast
delivery of the paper products, product line variability, complaint readdress system and correct
billing were the major factors for customer retention research work. The sales channel ways of
distribution, the different regions, the industry types did not come into the correlation analysis.
2.2 Regression Analysis
After the correlation analysis, the scholar went ahead with multiple regression technique using
excel tool pack. The first model consisted of fourteen variables including the strategic alliance of
the customers with the company. It was observed that advertising was not a significant factor for
the regression model with p value of 0.98 and coefficient of -0.001. The model was restructured
by removing advertisement factor and warranty on products was found to be insignificant with a
p value of 0.85 and likelihood coefficient of -0.015. The model was reconstructed again without
the factor warranty, and gradually, delivery speed of the company (p value of 0.66), billing
transparency (p value of 0.58), new product launching in market (p value of 0.21), technical
support for customers (p value of 0.22), pricing of paper products (p value of 0.09), and
complaint readdress system (p value of 0.06) were also eliminated from the model due to level of
insignificance levels. The final model consisted of six factors, which were product quality, e-

7
commerce, and product line variability, image of the company, price flexibility and type of
future strategic alliance possibility with the customers. The multiple-linear regression model was
finalized as below (Ton & Raman, 2010).
Y =0. 34 X1−0. 33 X2+ 0 . 4 X3 +0 .57 X4 +0 .25 X5+0 . 59 X6−1. 2
The dependent variable Y was the satisfaction level of the customers and the independent
variables were as follows.
X1 = Product quality
X2 = E-commerce
X3 = Product line
X4 = Image
X5 = Price flexibility
X6 = Strategic alliance level
The model described the fact that for one unit level of increase in product quality (keeping other
factors same) will increase the satisfaction level of the customers by 34%. The similar decision
was possible for other five factors (Woodside, 2013).
2.3 Outside ANZ Model
For outside ANZ region a regression model with previously identified variables was found, and
five variables were found to be significantly correlated to customer satisfaction. Product quality,

8
complaints readdress system, image of the company, pricing of paper products, and strategic
alliance type were used to build up the new regression model. The final model was as below,
Y =0. 32 X1+ 0. 0 . 39 X2+0 . 28 X3−0 .14 X4 +0 . 89 X5+ 1. 55
Y = Customer satisfaction
X1 = Product quality
X2 = Complaint readdress system
X3 = Image
X4 = Price of products
X5 = Strategic alliance level
Task 3
3.0 Logistic Regression
The course coordinator of the scholar and an analytical expert at ANALYTICS7, Dr. Hugo Barra
analyzed and predicted that Product Line, Product Quality, Price Flexibility, Competitive
Pricing, and Personnel Image were the important and decisive factors for strategic alliance of the
customers with the firm. The scholar was guided to cross check the likelihood estimation for the
above predictive factors. The scholar used a logistic regression model as the factor strategic
alliance was binary in nature. Due to incapability of linear regression model to handle binary
factors the scholar went ahead with his proposed logistic model. The logistic regression model
with Dr. Hugo’s prescribed variables revealed that competitive pricing of the paper products was