GET BENEFITTED WITH QUALITY CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT HELP SERVICE OF EXPERTSMINDS.COM

MIS771 Descriptive Analytics and Visualization - Deakin University

Learning Outcome 1: Apply quantitative reasoning skills to solve complex problems.
Learning Outcome 2: Use contemporary data analysis and visualisation tools and recognise the limitation of such tools.

Question:

Topic Mad Dog Craft Beer Project - Analytics Details

Q1. Provide an overall summary of the following two variables:
1.1. Order_Qty
1.2. Recommend

Q2. Identifying potential factors that may influence Order_ Qty:

Q3. Finalise the model to predict the likelihood of recommending Mad Dog Craft Beer to others:

Q4. Develop a time-series model to forecast Mad Dog Craft Beer production of pale ale in the next four fiscal quarters.

Q5. Produce a written report detailing ALL aspects of your analysis. Your report should be as detailed as possible and should describe ALL key outputs of your analysis.

SAVE TOP GRADE USING CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT HELP SERVICE OF EXPERTSMINDS.COM

Solution:

I have made report that contains various predicting models and analysis of the data. This report contains insights into the data as per the requirements. Each requirement is clearly pictured with explanation with the help of charts and tables .My findings will help in predicting the order quantity and recommendation variable of the Mad dog craft beer.

Introduction
Mad Dog Craft beer is an Australian brewery company with its operations in Melbourne and near regions like Victoria in brewing ale. It has limited experience in brewing but inspite of having limited experience it has seen increase in sales and production from last few years. Mad Dog Craft Beer sells beer to two segments of market. One is Pubs, Bars and Restaurants and other one is bottleshops. Beer is sold to these segments either directly or via sale representative. Mad Dog craft beer is concerned with forecasting the future demand and supply of their product. So, they have conducted a large survey to understand the customer buying behaviour. Therefore, the aim of this report is to analyze Mad dog craft beer's customers buying behavior and provide predictive models and insights for the provided data. The Mad dog survey has various variables such as

Some of the variables are independent of the other variables.

The provided database consists of 200 observations. There are three segments of information in this database. The first group of information comes from Mad Dog Craft Beer's data warehouse and includes information about the customer such loyalty in years, type, region, and distribution channel. The second cluster of information relates to the customers' perceptions of Mad Dog Craft Beer on nine attributes. Mad Dog Craft Beer's customers were asked to rate the company on basis of a set of nine attributes using a 1 - 10 scale. The third cluster of information relates to order quantity and relationships in business(e.g., number of bottles bought from Mad Dog Craft Beer; and the probability of recommending Mad Dog Craft Beer to others).

The main features of this report include:
• What potential factors influence the order quantity of Mad dog Craft beer
• How many people suggest Mad dog craft beer to their concerned ones.
• A model for predicting order quantity of the mad dog craft beer
• Forecasting the production of beer in 2019 and 2020

Assumption
• The tools used in the analysis of data are Microsoft Excel and Add-in in excel real statistics.

• While making the model, only the statistical significance is considered, and p-value should be greater than 0.05

Analysis

DONT MISS YOUR CHANCE TO EXCEL IN CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT! HIRE TUTOR OF EXPERTSMINDS.COM FOR PERFECTLY WRITTEN CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT SOLUTIONS!

Task 1: Summary statistics of order Quantity and Recommend variables

1.1 Order Quantity

To provide overall picture of the order quantity and recommendation variables we have been provided with set of 200 random observations of Mad dog Craft Beer. We noticed that the mean of the order quantity is 7.7 thousand of bottles and the maximum value is 9.9 thousand. However, this statistics can differ with standard deviation of 0.89 thousand in and around the minimum and maximum. We can also observe from the graph that order quantity keep on increasing to a certain point. There are no outliers in the Order quantity. Order quantity has always remained less than 10000.

Fig 1: Chart of Order Quantity

Table 1:Summary Statastics of Order Quantity

1.2 Recommendation

The Recommend variable suggests whether customers will suggest Mad Dog Craft Beer to others or not. From analysing of 200 random customer samples,5it has been observed that 50% of the customers recommended Mad dog craft beer to the other customers and 50% of the customers did not recommend Mad dog craft beer to other customers. This is clearly shown in the pie chart which we obtained by plotting recommendation of various customers.

Fig 2:-Recommendation Chart

ARE YOU LOOKING FOR RELIABLE CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT HELP SERVICES? EXPERTSMINDS.COM IS RIGHT CHOICE AS YOUR STUDY PARTNER!

Task 2: Potential factors influencing Order Quantity

2.1 Identify possible factors
Order Quantity is an independent variable. Leaving recommend variable aside, multiple regression is performed with all the variables provided. With the help of multiple regression we get the coefficients of for the regression equation. After this, a scatter plot is plotted with dependent and independent variables to obtain a relationship between them.
Scatter Diagram:

Scatter diagram is a diagram which shows relationship between dependent and independent variables. Scatter plot is plotted between all the 14 variables. From the plotted scatter plots we can observe that the variables, loyalty and shipping cost have a linear relationship with order quantity whereas the other variables have a non-linear relationship with order quantity.

Correlation:
Correlation formula is used to identify a correlation coefficient between the dependent and independent variables .To get more clear picture of the dependent variable we have found correlation coefficient of all the variables. We have correlation coefficient of every variable with every other variable. From observing the correlation coefficient of all the variables, we have observed that order quantity is mainly influenced by the shipping cost. The variables which have correlation coefficient more than 0.5 have strong degree of relationship. Independent variables with the value correlation coefficient>0.5 have a strong relationship with each other and therefore we have chosen the variable shipping cost to predict the variable order quantity and eliminated all other variables as they have low correlation coefficient.

2.2 Model Building

In the process of model building, we have identified only one variable that is shipping cost to make the regression equation as all other variables have low correlation coefficient. The Adjusted r-square value indicates the usuage of variables which are not required and is found to be 96% which is almost equal to the r-square value. The standard error is found to be 1.83.The significance value indicates whether the model is significant to predict values or not .The r-squared value suggests the variation in order quantity and 96% of the variations in order quantity is explained by the variations in the dependent variables.
The final regression equation is as follows:

Order Quantity = 1.37 *Shipping cost
This equation can be interpreted as:
• For every unit increase in the shipping cost, the order quantity will increase by 1.37.

2.3 Interaction Effect

Here we are studying the interaction effect between order quantity, Brand and Quality. The quality is taken to be the independent variable while the shop open and brand image is a moderator. We define the interaction variable to be the product of quality and brand image variable.

A regression model is run in which the p-value for all variables is observed to be more than 0.05 indicating that the model is insignificant. The visualization shows that the perception of the product quality does not affect the order quantity and from the interaction table we can infer that the assumption made by Todd of the brand image and order quantity is weaker for low quality product perception. There is no interaction between brand image and quality perception of product.

SAVE YOUR HIGHER GRADE WITH ACQUIRING CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT HELP & QUALITY HOMEWORK WRITING SERVICES OF EXPERTSMINDS.COM

Task 3: Predicting the likelihood of recommending Mad dog Craft beer to others

The objective is to predict likelihood of recommending Mad dog craft beer to other customers on basis of distribution channel, quality , brand image and shipping speed. On analyzing classification table, we can observe that 101 customers has recommended Mad dog craft beer to others while 99 customers has not recommended Mad dog craft beer to others The overall hit ratio is 77% suggesting that 76% of the classifications are done correctly. 103 observations have been correctly classified and 97 observations have been wrongly classified.

For predicting the model, we are considering four variables that is quality, brand image , distribution channel and shipping speed.. A line graph is used to visualize the change in probabilities of recommending Mad dog craft beer related to the other factors. We notice that from the line chart that regardless of these factors there is high probability of recommending Mad dog craft beer to others.

Fig 4: Probability of Recommending Mad Dog Craft Beer

DO YOU WANT TO EXCEL IN CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT? HIRE TRUSTED TUTORS FROM EXPERTSMINDS AND ACHIEVE SUCCESS!

Task 4: Time series Forecast

The objective of this task is to make a time series model to predict of production of Mad dog craft beer for the next four quarters. To find this forecast we have used the concept of moving average and the centered moving average. With the help of this we have found the trend and the forecast for the required quarters. To find the moving average we have found the average of the production of beer taking 4 at a time . then we have found the centered moving average of the production by averaging the moving average. After that we have found the average of each quarter then we found the Deseasonality of the production. After deaseasonality we found the regression equation and found the forecast for next for quarters.

Fig 5: Production Forecast

Drawbacks

Since the sample size is 200, there are possibilities of variations in the process of modeling assuming the presence of any outliers. Although outlier is present, it has not been excluded to eliminate any inaccuracies in the prediction. Complying to that, the analysis is conducted on the provided statistical data without considering any business problems .Also most of the data is nominal so it is hard to predict the influencing potential factors affecting the model.

Conclusion
By Preparing various predictive models and analyzing the whole data we can conclude and suggest these results.
Mad dog craft beer needs to make the size of sample data more larger to avoid any sampling error.

Shipping cost mainly determine the order quantity. There is no interaction between the variables brand image and the perception of quality by the customer.

The likelihood of recommending Mad dog craft beer to other customers is high on basis of shipping speed, distribution channel , brand image and quality .

The forecast for Mad dog craft beer is low for the next 4 quarters as compared to the previous quarters.

NEVER LOSE YOUR CHANCE TO EXCEL IN CASE STUDY - MAD DOG CRAFT BEER ASSIGNMENT - HIRE BEST QUALITY TUTOR FOR ASSIGNMENT HELP!

Avail Deakin University Assignment Help service for its major courses and units, such as:

• MIS779 Decision Analytics in Practice Assignment Help
• MIS782 Value of Information Assignment Help
• MIS770 Foundation Skills in Data Analysis Assignment Help
• MIS772 Predictive Analytics Assignment Help
• MIS780 Advanced Artificial Intelligence for Business Assignment Help
• MIS784 Marketing Analytics Assignment Help
• MIS781 Business Intelligence Assignment Help
• MIS775 Decision Modelling for Business Analytics Assignment Help