Bus501 Business Analytics And Statistics Assessment Answers

Questions:

Answers:

Introduction 

In this report, we analyse the business performance of a newly established enterprise by the name Good Harvest Organic Farm and Market. The enterprise started its operations about two years ago and their main business proposition and operations entails growing a range of quality fresh organic produce and selling them direct to the local community through its home delivery service.

We are provided with the data from the enterprise which is inclusive of a whole year of trading. This is the second year of business and the business is still in a start-up phase. The reported high Cost of Goods (COGS) is reportedly consistent with the Organic industry.

The main challenges in the business are revenue (i.e. lead generation/new business), Cost of Goods (COGS margins) and average sales.

Problem definition and business intelligence required 

Using the one year data from the enterprise, we sought to analyze (conducting both descriptive and predictive analytics) so as to gain insight that can be shared with the CEO of the company. In particular we sought to answer the following research questions;

1. What are the top/worst selling products in terms of sales?
2. Is there a difference in payments methods?
3. Are the differences in sales performance based on where the product is located in the shop? How does this effect both profits and revenue?
4. Is there a difference in sales and gross profits between different months of the year?
5. Are their differences in sales performance between different seasons?

Selected analytics methods and technical analysis 

Each and every business problem stated above was addressed using appropriate statistical tests. The first step was to ensure that the variables under study are well scaled. The screenshot below presents the first few values of the data analyzed: 

Results and findings  

The boxplot shows that median returns are vastly different and that the downside of worst case is limited to total sales not exceeding $50, while the upside in best case yields returns up to almost $20,000. It is however important to note that there are quite a number of outliers both in the worst performing products and best performing products.  

To answer this question, we performed independent t-test. In the dataset there are 4 different payment methods namely; cash payment, credit, Visa and MasterCard payments. Cash and Credit were categorised into one group and an independent t-test was performed test whether there is a significant difference in the total cash received between the two payment methods. Independent t-test is normally used to compare two independent (unrelated) groups (Derrick, et al., 2017). Visa card and MasterCard were also grouped together and an independent t-test performed to compare the total cash received from the use of the two payment methods (John , 2006). We sought to test the following hypothesis;

Hypothesis 1:

H₀: There is no significant difference in the total cash received between the cash and the credit payment methods

H₀: There is significant difference in the total cash received between the cash and the credit payment methods

Table 2: t-Test: Two-Sample Assuming Equal Variances

Results from an independent samples t-test showed that total cash received from cash payment method (M = 412.18, SD = 144.26, N = 359) was significantly lower when compared to the credit payment method (M = 604.64, SD = 204.28, N = 354), t(711) = -14.50, p < .001, two-tailed. The difference of 192.46 was large (effect size, d = 1.08). 

Hypothesis 2:

H₀: There is no significant difference in the total cash received between the Visa and the MasterCard payment methods

H₀: There is significant difference in the total cash received between the Visa and the MasterCard payment methods.

Table 3: t-Test: Two-Sample Assuming Equal Variances

Results of the two-independent samples t-test shows that mean total cash received significantly differs between Visa payment method (M = 576.31, SD = 224.40, n = 353) and MasterCard payment method (M = 152.55, SD = 109.55, n = 53) at the .05 level of significance (t = 13.50, df = 404, p < .05, 95% CI for mean difference 365.02 to 485.48). On average Visa payment method tend to have higher total cash received than MasterCard payment method.

To test this research question, we performed analysis of variance (ANOVA) test. ANOVA tests the null hypothesis that the means of two or more populations are equal (Moore & McCabe, 2003). This test is used to assess the importance of one or more factors by comparing the response variable means at the different factor levels (Howell, 2002). As mentioned, the null hypothesis states that all population means (factor level means) are equal while the alternative hypothesis states that at least one is different (Gelman, 2005). The hypothesis tested in this analysis is;

Hypothesis 4:

H₀: There is no significant difference in the mean total sales between the different product locations in the shop

H₀: There is significant difference in the mean total sales between the different product locations in the shop.

Table 4: Analysis of variance (ANOVA) for the total sales versus product location

We conducted a one-way between subjects ANOVA so as to compare the mean total sales received based on the locations of the product. Table 4 above presents the ANOVA summary. As can be seen, there is significant differences in the mean total sales of the products based on the location of the product at the p<.05 level for the five conditions [F(4, 1029) = 37.18, p = 0.000].

Table 5: Mean total sales based on product location

Looking at table 5 above, we see that products located at outside front had the highest mean total sales while products located on the left side of the shop had the lowest mean sales.

Just like in analysis 3, this analysis also utilized ANOVA to test whether there is a significant difference in sales and gross profits between different months of the year. Two hypothesis were coined out of this analysis. The hypothesis are as follows;

Hypothesis 5:

H₀: There is no significant difference in the mean total sales between the different months of the year.

H₀: There is significant difference in the mean total sales between the different months of the year. 

Table 6: Analysis of variance (ANOVA) for the net sales versus months

A one-way between subjects ANOVA was conducted to compare the mean net sales received based on the month of the year. Table 6 above presents the ANOVA summary. As can be seen, there is no significant differences in the mean net sales of the products based on the month of the year at the p>.05 level for the 12 conditions [F(11, 354) = 1.303, p = 0.221].

Table 7: Mean net sales based on month of the year

As can be seen in table 7 above, there is no much difference between the net sales for the month with highest mean net sales and that with the lowest mean net sales. November had the highest net sales (M = 1154.40, SD = 302.65) while June had the lowest net sales (M = 946.63, SD = 350.20).

Hypothesis 6:

H₀: There is no significant difference in the mean gross profits between the different months of the year.

H₀: There is significant difference in the mean gross profits between the different months of the year.

Table 8: Analysis of variance (ANOVA) for the gross profits versus months

We performed a one-way between subjects ANOVA to compare the mean gross profits based on the month of the year. Table 8 above presents the ANOVA summary. As can be seen, there is significant statistical differences in the mean gross profits based on the month of the year at the p<.05 level for the 12 conditions [F(11, 354) = 3.867, p = 0.000]. 

Table 9: Mean gross profits based on month of the year

The average gross profits for the month of June was 19.32(the lowest in all the months), this was statistically different from the October’s gross profit which was 46.26 (the highest in all the months). 

Using analysis of variance (ANOVA), we sought to answer this research question. There are four seasons (factors) making it prudent to use ANOVA.

The following hypothesis was tested;

Hypothesis 7:

H₀: There is no significant difference in the mean net sales between the different seasons.

H₀: There is significant difference in the mean net sales between the different seasons.

Table 10: Analysis of variance (ANOVA) for the net sales versus seasons

We performed a one-way between subjects ANOVA to compare the mean net sales based on the season. Table 10 above presents the ANOVA summary. As can be seen, there is no significant statistical differences in the mean net sales based on the season at the p<.05 level for the four conditions [F(4, 362) = 1.658, p = 0.176].

Table 11: Mean net sales based on season

The season with the highest average net sales was autumn (M = 1045.64, SD = 336.46) while winter had the lowest mean net sales (M = 956.02, SD = 257.44). Despite the observed differences, statistically the differences were not significant at 5% level of significance.

Discussion of the results and recommendations

Analysis of the company’s one year data showed some interesting results that we believe are very insightful to the CEO towards executing his duties as the overall overseer of the company. The key results were as follows;

• Water, vegetable, dairy products and drinks were among the best performing products of the company while juicing, herbal teas, spices, snacks, salad greensand stock sauces were among the worst performing products within the company.
• Credit card and Visa payment methods were the payment options that received huge cash collections.
• Location of the product in the shop matters a lot in terms of the sales performance.
• Month of the year does not significantly affect the net sales of the products however it significantly affects the gross profit.
• Season does not significantly affect the net sales of a product.

Recommendations

We found out that month of the year does not affect the net sales but affects the gross profits; this suggests that there are months when the production costs goes high (either through the materials or labor), the CEO should therefore find out whether there are months that the cost of goods just go up and see on how to solve this. If for instance, the cost of materials rise some months then the CEO could come up with a policy to make purchases before that months comes.

The CEO should also focus on how the products are displayed in the shops as this was found to significantly impact on the net sales.

References

Derrick, B., Toher, D. & White, P., 2017. How to compare the means of two samples that include paired observations and independent observations. The Quantitative Methods for Psychology, 13(2), p. 120–126.

Gelman, A., 2005. Analysis of variance? Why it is more important than ever. The Annals of Statistics, Volume 33, p. 1–53.

Gelman, A., 2005. Analysis of variance? Why it is more important than ever. The Annals of Statistics, p. 1–53.

Howell, D., 2002. Statistical Methods for Psychology. p. 324–325.

John , A. R., 2006. Mathematical Statistics and Data Analysis.

Moore, D. S. & McCabe, G. P., 2003. Introduction to the Practice of Statistics. p. 764.