BUS501: Business Analytics and Statistics - Sales Volume - Statistics Report Writing Assessement Answer

February 27, 2019
Author : Syd Howell

Solution Code: 1AGIG

Question: Business Analytics and Statistics - Sales Volume Report Writing

ThisBusiness Analytics and Statistics - Sales Volume Report Writingassignment falls under Introduction to which was successfully solved by the assignment writing experts at My Assignment Services AU under assignment help service.

Business Analytics and Statistics - Sales Volume - Statistics Report Writing Assignment

Assignment Task:

Goal: To undertake a business analytics approach to solve a set of business problems that require the use of appropriately selected business analytics approaches.

The assignment file was solved by professionalBusiness Analytics and Statistics - Sales Volume - Statistics Report Writingexperts and academic professionals at My Assignment Services AU.The solution file, as per the marking rubric, is of high quality and 100% original (as reported by Plagiarism). The assignment help was delivered to the student within the 2-3 days to submission.

Looking for a new solution for this exact same question? Our assignment help professionals can help you with that. With a clientele based in top Australian universities, My Assignment Services AU’s assignment writing service is aiding thousands of students to achieve good scores in their academics. OurBusiness Analytics and Statistics - Sales Volume - Statistics Report Writing Assignmentassignment experts are proficient with following the marking rubric and adhering to the referencing style guidelines.

Solution:

Introduction

The main objective of this study is to determine the sales volume and profit of fruit shop among four seasons. The trend of the gross sales, net sales and total profit for each month is also validated to determine the performance of the sales in fruit shop. For the purpose of the study, a random sample of 366 fruit shops sales volume information is taken for the analysis

Problem Definition

The research hypotheses are

There is a significant mean difference in the total profit among the four seasons

There is a significant mean difference in the average sales among the four seasons

There is a significant mean difference in the total orders placed among four seasons

There is a significant mean difference in the credit total among the seven days of the week

There is a significant mean difference in the total orders among the seven days of the week

Statistical Analysis

The box plot given below shows the information about the gross sales among the four seasons

Analysis Report

Going through the box plot, it is observed that the median gross sales are high during the spring season followed by autumn, summer and winter, but the difference is not very high. This indicates that people tend to buy fruits throughout the seasons ignoring the climatic conditions. During the winter seasons, there is a slight drop in the gross sales and this drop will not affect the sales volume to a great extent

The sales trend over the year is given below

Business Analytics

 

Analysis 1: To determine whether there is a significant mean difference in the total profit among the four seasons

business analytics

business analytics

business analytics

business analytics

The ANOVA table indicates that there is a significant mean difference in the total profit among the four seasons (F test statistic = 11.456, p – value = 0.000 < 0.05). Going through the mean plot, it is found that the mean total profit is high during the spring season when compared with other three seasons. Thus, the trend of profit moves upwards during the winter and spring seasons. The total profit drops down during the autumn season and it assumed that the fruit sales seems to be moderate or low during the autumn season

Analysis 2: To determine whether there is a significant mean difference in the average sales among the four seasons

business analytics

business analytics

The ANOVA table indicates that there is no significant mean difference in the average sales among the four seasons (F test statistic = 0.316, p – value = 0.814 > 0.05). Going through the mean plot, it is found that the mean average sales are high during the autumn season when compared with other three seasons, but the average sales in autumn is slightly higher when compared to other three seasons

Analysis 3: To determine whether there is a significant mean difference in the total orders placed among four seasons

Business Analytics Business Analytics

The ANOVA table indicates that there is no significant mean difference in the total orders among the four seasons (F test statistic = 1.138, p – value = 0.334 > 0.05). Going through the mean plot, it is found that the mean total orders are high during the spring season when compared with other three seasons. The number of total orders remains to be same during the summer and autumn season and there is a little bit drops in the total fruits ordered during the winter season, but the difference is not statistically significant.

Analysis 4: To determine whether there is a significant mean difference in the credit total among the seven days of the week

business analytics

The ANOVA table indicates that there is a significant mean difference in the credit total among the seven days of the week (F test statistic = 3.881, p – value = 0.001 < 0.05). Going through the mean plot, it is found that the mean credit total is high during the Monday and Thursday and low during the Saturday and Sunday. This indicates that the credit total reaches its maximum during the weekdays and its worse during the weekends   Analysis 5: To determine whether there is a significant mean difference in the total orders among the seven days of the week

The ANOVA table indicates that there is a significant mean difference in the credit total among the seven days of the week (F test statistic = 3.881, p – value = 0.001 < 0.05). Going through the mean plot, it is found that the mean credit total is high during the Monday and Thursday and low during the Saturday and Sunday. This indicates that the credit total reaches its maximum during the weekdays and its worse during the weekends

Analysis 5: To determine whether there is a significant mean difference in the total orders among the seven days of the week

business analyticsbusiness analytics

The ANOVA table indicates that there is a significant mean difference in the total orders among the seven days of the week (F test statistic = 11.585, p – value = 0.000 < 0.05). Going through the mean plot, it is found that the mean total orders are high during the Monday, Tuesday and Thursday and low during the Saturday and Sunday. This indicates that the total orders reaches its maximum during the weekdays and its worse during the weekends

Results

From the analysis, we found that

  • The median gross sales are high during the spring season followed by autumn, summer and winter, but the difference is not very high
  • The total profit drops down during the autumn season and it assumed that the fruit sales seems to be moderate or low during the autumn season
  • No significant mean difference in the average sales among the four seasons
  • No significant mean difference in the total orders among the four seasons
  • The credit total reaches its maximum during the weekdays and its worse during the weekends. The variation is high in total orders during the weekdays and weekends
  • The total orders reach its maximum during the weekdays and its worse during the weekends. The variation is high in total orders during the weekdays and weekends

This Business Analyticsassignment sample was powered by the assignment writing experts of My Assignment Services AU. You can free download thisBusiness Analytics and Statistics - Sales Volume - Statistics Report Writingassessment answer for reference. This solvedBusiness Analytics and Statistics - Sales Volume - Statistics Report Writing assignment sample is only for reference purpose and not to be submitted to your university. For a fresh solution to this question, fill the form here and get our professional assignment help.

RELATED SOLUTIONS

Request Callback

My Assignment Services- Whatsapp Get 50% + 20% EXTRAAADiscount on WhatsApp

Get 500 Words FREE