Khadi sales data analysis | Assignment Project Risk Management

Khadi sales data analysis | Assignment Project Risk Management
Scenario:

Khaadi-Kapra manufactures garments that are sold through large retail outlets across the world. Khaadi-Kapra is concerned with how variable the sales are at different stores. They requested and received for sales data of the past 30 weeks on their men’s product line, from five of their retail stores.

Question: What can we say about the weekly sales in store 2?

Find:

  1. Graph out the sales for Khaadi-Kapra.
  2. Create a histogram.
  3. Find the mean, range, inner quartiles, variance, standard deviation, co-efficient of variation.
30 Weeks Sales Data of Store 2
WeekWeekly Sales Data at khadi store 2
17
23
35
48
52
60
71
86
96
103
111
124
139
147
152
168
172
180
191
206
213
221
235
249
253
262
276
280
298
304
  1. Graph out the sales for Khaadi-Kapra.
Khadi Kapra sales – Graphing it Out
Sorted Weekly Sales Data (smallest to largest)
WeekWeekly Sales Data at khadi store 2
60
180
280
71
111
191
221
52
152
172
262
23
103
213
253
124
304
35
235
86
96
206
276
17
147
48
168
298
139
249
Khadi Kapra – Distributions
Frequency Table
 
Weekly sales (Range limits)FrequencyProbabilityCumulative %
0310%10.00%
1413%23.33%
2413%36.67%
3413%50.00%
427%56.67%
527%63.33%
6413%76.67%
727%83.33%
8310%93.33%
927%100.00%
Total30100%100.00%

2. Create Histogram – Khadi kapra

Cumulative Distribution of Sales – Khadi
3. Find the mean, range, inner quartiles, variance, standard deviation, co-efficient of variation.
Statistical Summary
Mean = 4.066666667
Standard Error = 0.522886184
Median = 3.5
Mode = 3
Standard Deviation = 2.863965581
Variance = 8.202298851
Coefficient of variance = 0.12857857
Range = 9
Minimum = 0
Maximum = 9
Sum = 122
Count = 30

Khadi – Quartiles Table

Quartiles
Q12
Q23.5
Q36
Q49

Leave a Reply