Business Analytics and Statistics Report for Honeybee Fruit

Business Analytics and Statistics
Student Name:
Instructor Name:
Course Number:

Table of Contents
Introduction......................................................................................................................................2
Problem definition and business intelligence required....................................................................2
Results of the selected analytics methods and technical analysis....................................................4
What are the best and worst selling products in terms of sales?..................................................4
Is there a difference in payments methods? (Cash vs Credit)?....................................................5
Are the differences in sales performance based on where the product is located in the shop?
How does this effect both profits and revenue?...........................................................................5
Is there a difference in sales and gross profits between different months of the year?................7
Are their differences in sales performance between different seasons?......................................9
Discussion of the results and recommendations............................................................................10
Recommendations......................................................................................................................10
References......................................................................................................................................11
Appendix........................................................................................................................................12

List of tables
Table 1: Top best-selling products in terms of sales.......................................................................5
Table 2: Worst selling products in terms of sales............................................................................6
Table 3: t-Test: Two-Sample Assuming Equal Variances..............................................................6
Table 4: Descriptive statistics..........................................................................................................7
Table 5: Test of Homogeneity of Variances....................................................................................7
Table 6: ANOVA.............................................................................................................................8
Table 7: ANOVA.............................................................................................................................8
Table 8: Descriptive Statistics.........................................................................................................9
Table 9: Test of Homogeneity of Variances..................................................................................10
Table 10: ANOVA.........................................................................................................................10
Table 11: Descriptive statistics......................................................................................................11
Table 12: ANOVA.........................................................................................................................11

Introduction
This report sought to present findings to the CEO of Honeybee Fruit in relation to the
performance of the business.
We ae provided with data that 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 fruit industry.
The study focusses on the main challenges of the business which are revenue (i.e. lead
generation/new business), Cost of Goods (COGS margins) and average sales. We seek to
answer a number of research questions which at the end would answer the concerns of the
CEO.
Problem definition and business intelligence required
The following are the research questions that this study sought to respond to;
1. What are the best and worst selling products in terms of sales?
For this question, we sought to look at the frequency statistics. We looked at the
measures of central tendency such as the mean, median and the mode to understand the
distribution of the sales data for the various products. This is ideal since we are not
testing any hypothesis but rather trying to figure out how the distribution looks like
(Bonett & Seier, 2006).
2. Is there a difference in payments methods? (Cash vs Credit)
For this question, we sought to compare the mean differences between the two payments
methods (Cash and Credit). As such an ideal test that was to be used was the t-test. T-test
helps test and compare the average differences in two groups and in this case we had two