Mis171 Comparison Between Stores Answers Assessment Answers
In order to prepare a reply to the General Manager, you will need to examine and analyse the dataset thoroughly. The General Manager has asked a number of questions. The following guidelines for each question should be considered carefully:
1. A summary of sales: To answer this question you should calculate, then analyse the total sales by itself. You should derive summary measures and check for unusual data.
2. Sales by stores: Investigate any particular relationship between sales and stores. Remember to include the online marketspace as the fifth store.
3. Sales by weekdays: Explore any particular relationship between total sales and weekdays. You can be creative and combine some weekdays to get a more meaningful conclusion.
4. Sales by month: Research any particular relationship between sales and months. You can extract months from date.
5. Sales by number of visitors: To answer this question you should calculate the total number of visitors for each day. Then, you can analyse any potential relationship between sales and number of visitors.
6. Probability: To answer this question, you need to do the calculationsfor each store separately using the relevant Excel functions.
The analysis section you submit should be no more than 8 pages of computer output (i.e., output that you have copied into a Word document from Microsoft Excel). When you conduct your analysis,you will produce much more than this initially, but you should trim it down to only show the most relevant results in your maximum of 8 pages (of analysis). Where possible, it is always useful to produce both numerical and graphical statistical summaries as sometimes, something is revealed in one that is not obvious in the other. Within the Word document, your analysis should be presented in the same numbered sequence (and contain that same numbered sequence) that the questions have been asked by Claudia Brady (the General Manager). Your analysis should be clearly labelled and grouped around each question. Poorly presented, unorganised analysis or excessive output (more than 8 pages) will be penalised.
It is usual, when writing any professional document, to caption any tabular or graphical output professionally. For example, TABLE 1: Summary statistics for the measure Gross Profit.
Part 2: Email
You are required to reply by email, detailing essential information and conclusions from your data analysis. You are allowed no more than 2 pages to convey your written conclusions. Your 2 page email will be included as a front section to your 8 pages analysis. A document 10 pages in length.Keep the English simple and the explanations succinct. Avoid the use of technical statistical jargon.Your reader will not necessarily understand even simple statistical terms, thus your task is to convert your analysis into plain, simple, easy to understand language.
Answer:
- Summary of the total sales
The total sales ranges from a minimum of $ 81,450 per day to a maximum of $ 294,840. The expected value of sales per day is $ 134,660, this value does vary with standard deviation of $ 25340. From the descriptive statistics the total sales is skewed to the right indicating that most of the sales per day are over the expected sales.
Analysis of the sales data per month indicate that most of the sales are done in January with this value fluctuating from month to month.
- Comparison between stores
The value of the total sales does vary from store to store. The online store is the leading seller of the beautiful products catering for around 29% of the total sales throughout the year. Store 1 follows with 27% of the total sales. On the other hand, store 4 is experiencing the worst sales only catering for 10% of the total sales. This poor performance in sales is replicated in store 2 which also just contribute 14% of the total sales.
The pie chart below gives a visual illustration.
Overall, the majority of the sales are made in January with online sales experiencing total sales per year way above the other stores. From February onwards, the sales of the online store are nearly uniform with that of store 1. The store 4 maintains a poor sales performance from January to December.
- Comparison of total sales per day
Analysis of the total sales values indicate that there is a significance different between the sales values dictated by the day of the week. As presented in the pie chart all the weekdays experience lower sales value of 13% each while Saturday and Sunday do experience significantly higher sales with 17% and 18% respectively. This means that in general the stores are making most of the sales during the weekends as opposed to the weekdays.
Looking at the bar graph, its evident that the online store is making significantly higher sales on the weekends. During the weekdays the sales in the store 1 and online store tends to be uniform with the other stores indicating lower sales.
Store 1
Most of the sales in store 1 are made during the month of June. The sales value is at its lowest during the month of February. The four months from May to August represents a high season for the sales in store 1 with April joining January in experiencing very low sales.
Store 2
This store experiences the lowest sales during the month of June, however the sales are highest in March. From April the sales begin to drop and hit the lowest level in June after which is rises gradually and kind of levels up from July to December.
Store3
There is a minimal fluctuation in sales over the months in store 3 though the highest sales occur in July while the value is lowest in February. The sales trend line rises from February to hit a maximum pint in July, afterwards it somehow levels of up to December.
Store 4
Just like store 3, this store experienced almost a level sales trend. It though makes most of the sales in October while February remains the month with the lowest sales.
Online store
The online store experiences booming sales in January. This value then drops afterwards to reach a minimum in the month of May. From May to December the sales kind of levels up with very little variation being shown among the months.
- Relationship between visitors and sales
- 007578413
- The sales target for store 1 should be $36,687
- 0.00579192
- 547986316
- The sales target for store 2 should be $ 1949
0.372830056
- 277064626
- The sales target for store 3 should be $ 26459
0.00000347029
- 967816145
- The sales target for store 4 should be $ 13194
0.7496317
- 075416206
- The sales target for store 5 should be $38822.
