Assignment:
Question 1. Units of barbies sold since launch jan 2011
|
YEAR
|
EUROPE
|
AUSTRALIA
|
NEWZEALAND
|
CANADA
|
TOTAL WORLDWIDE
|
|
2011
|
115,873
|
57,146
|
2058
|
9435
|
184,512
|
|
2012
|
26,667
|
71,958
|
4056
|
56,593
|
159,274
|
|
2013
|
3269
|
36,050
|
4188
|
40,519
|
84,026
|
|
2014
|
4645
|
10
|
2863
|
892
|
8410
|
|
2015
|
-16
|
2
|
0
|
-30
|
-44
|
Number of complaints recieved for barbies (v3)
|
YEAR
|
EUROPE
|
Australia & New Zealand
|
Canada
|
TOTAL
|
|
2011
|
25
|
0
|
3
|
28
|
|
2012
|
13
|
2
|
7
|
22
|
|
2013
|
4
|
1
|
68
|
73
|
|
2014
|
9
|
0
|
3
|
12
|
|
2015
|
4
|
0
|
0
|
4
|
A) I don’t know how the complaint rates were worked out, i need to work out 2014 and 2015, can hyou please provide worked example? I think it is number of complaints/ product sold but i don’t understand how they got for example 0.022%.
B) Also where does the worldwide figure ie 0.015% come from???? Can you show you me how this is worked out?
C) Do the complaint rates in green have anything to do with the calculation? What are they for ? How are they worked out?
|
YEAR
|
Europe
|
Canada
|
Australia & New Zealand
|
Worldwide
|
|
2011
|
0.022%
|
0.032%
|
0
|
0.015%
|
|
2012
|
0.049%
|
0.012%
|
0.003%
|
0.014%
|
|
2013
|
0.152%
|
0.170%
|
0.002%
|
0.087%
|
|
2014
|
|
|
|
|
|
2015
|
|
|
|
|
|
TOTAL SINCE LAUNCH
|
|
|
|
|
World wide complaint rates for barbie’s have been static at approximately what perecentage? Since product launch, which represents a rate of ( note answer sould be written as follows: < 1 in 1,000 units.
Complaint rates in europe crepresent<1 in 1000 units
Complaint rates for canada represent < 1 in 1000 unitsor australia and newzealand<1 in 10,000 units
Complaint rates world wide represent <1 in 1000 units.
Question 2. Units of sponges sold dec 2012:
|
YEAR
|
EUROPE
|
AUSTRALIA and newzealand
|
CANADA
|
TOTAL WORLDWIDE
|
|
2012
|
153
|
0
|
0
|
153
|
|
2013
|
17,969
|
13,142
|
3128
|
34239
|
|
2014
|
19490
|
11524
|
8340
|
39354
|
|
2015
|
2392
|
5139
|
894
|
8425
|
Worldwide Complaints received about sponges
|
YEAR
|
EUROPE
|
Australia & New Zealand
|
Canada
|
TOTAL world wide
|
|
2012
|
0
|
0
|
0
|
0
|
|
2013
|
1
|
0
|
1
|
1
|
|
2014
|
4
|
0
|
0
|
4
|
|
2015
|
0
|
2
|
0
|
3
|
Table showing complaint rates by units sold - sponges
|
YEAR
|
EUROPE
|
AUSTRALIA AND NEWZEALAND
|
CANADA
|
World wide
|
|
2012
|
0
|
0
|
0
|
0
|
|
2013
|
|
|
|
|
|
2014
|
|
|
|
|
|
2015
|
|
|
|
|
Fill the above table.
How to work out the complaint rate for europe, canada, australia and newzealand and worldwide. The answer needs to be shown as sentences ie “complaint rates for europe represent ~ 1 in 10,000 unit”.
Provide complete and step by step solution for the question and show calculations and use formulas.