The file provides the question and the data needed to answer the question.The report should be written in a Microsoft Word document format with single spacing and
Times New Roman font of 12 point font size. The calculations should be done in microsoft excel.Finalize the calculation and answers for each question must be in microsoft word.
bus105e_gba_jul2016_31_aug_2016.pdf
bus105e_gba_jul2016_31_aug_2016.pdf
bus105_gba_dataset_pawnshop.xlsx
Unformatted Attachment Preview
BUS105e
Statistics
Assignment 2 – Group-based Assignment
July 2016 Presentation
BUS105e
Assignment 2
Group-based Assignment
This assignment is worth 30% of the final mark for BUS105e Statistics.
The cut-off date for this assignment is 31 Aug 2016, 2355hrs.
This is a group-based assignment. You should form a group of 3 members from your
seminar group. Each group is required to upload a single report to Canvas via your respective
seminar group. Please elect a group leader. The responsibility of the group leader is to upload
the report on behalf of the group.
It is important for each group member to contribute substantially to the final submitted work.
All group members are equally responsible for the entire submitted assignment. If you feel
that the work distribution is inequitable to either yourself or your group mates, please
highlight this to your instructor as soon as possible. Your instructor will then investigate and
decide on any action that needs to be taken. It is not necessary for all group members to be
awarded the same mark.
___________________________________________________________________________
Guidelines on GBA Report Writing
The report should be written in a Microsoft Word document format with single spacing and
Times New Roman font of 12 point font size.
___________________________________________________________________________
Feasibility Study of Pawn Broking Operation in Singapore
Pawn broking in Singapore started in the 19th century. In the past, pawn brokers were
regarded as the “poor man’s bankers”. Now their customers include white-collar workers and
businessmen. Each year, the pawnshops gave out loans in excess of $1 billion, and as at 2014,
there were 214 pawnshops on the island (NLB, 2015).
Pawnshops has always been the place to go to when individual needs immediate cash by
surrendering or pawning their valuable items, where they will get loan up to a certain
percentage of the item’s value. For the past few years, pawnshops in Singapore have
undergone significant facelift and in a bid to attract the younger generation. According to a
report by CNBC, tighter credit, rising living costs and a make-over of shops away from
intimidating store fronts with metal bars have all contributed to their popularity among
consumers in the Southeast Asian nation.
Pacific Pawn Brokers, an established pawnbroker based in Hong Kong is keen to set up
operations in Singapore and its corporate mission is to be among the top three pawn brokers
in whichever country it invests in. Mr Owen Shaw, CEO of Pacific Pawn Brokers, has
engaged your consultancy service to help him analyse the pawn broking business in
Singapore, and whether there is a significant growth in the pawnshop business in Singapore
since the last financial crisis in 2008-2009.
You are provided with a sample of monthly pawnshop data from 1980 to 2015, showing the
number of pledges received, number of pledges redeemed, amount of loans given out and
SIM UNIVERSITY
Assignment 2 – Page 2 of 4
BUS105e
Assignment 2
amount of loans redeemed with interest. You are to assist Mr. Owen Shaw to analyse the data
using Excel software and provide solutions to the following questions:
Data Source: partially extracted from Department of Statistics (2015), Statistical Tables from
SingStat Table Builder http://www.tablebuilder.singstat.gov.sg/
___________________________________________________________________________
Question 1
Compare monthly number of pledges received between pre-Year 2000 and post-Year 2000.
Use descriptive statistics to describe and interpret the data on number of pledges received.
You are required to identify the measures of location and dispersion as well as organise the
appropriate output from your software into a relevant statistical and graphical presentation of
the data. Justify your choices. What are your preliminary observation/s?
Hint: Summaries and presentations should help you decide subsequent analysis.
(8 marks)
Question 2
(a)
Identify the probability of the sample mean of number of pledges (monthly) received
post-Year 2000 is more than 260,000 per month. Assume that the standard deviation
for number of pledges received can be approximated by the sample standard
deviation.
(4 marks)
(b)
Construct and state the 90% confidence intervals for the amount of loans (monthly)
given out for the period pre-Year 2000 and post-Year 2000. Interpret these confidence
intervals in your report. With these findings, can you validate if the amount of loans
given out during those two periods is different?
(8 marks)
(c)
List the key assumption(s) you have made in constructing this confidence interval.
Discuss if this/these assumption(s) is (are) reasonable.
(4 marks)
(d)
Explain what will be your follow-up actions including statistical tests, if the key
assumption(s) were found to be violated.
(6 marks)
SIM UNIVERSITY
Assignment 2 – Page 3 of 4
BUS105e
Assignment 2
Question 3
Mr Owen Shaw claims that the hearsay from business associate is that since 2008-2009 crisis,
the pawn broking business has not improved much in terms of loans redemption with interest
(high volume of loans redemption with interests represents more profit for the pawn brokers).
Select an appropriate test of hypothesis to determine if the mean amount of loans redeemed,
including interest, has increased significantly between pre-financial crisis (2000 – 2009) and
post-financial crisis (2010 onwards).
You should include the following:
(a)
State the null and alternative hypotheses and explain how you developed these two
hypotheses.
(7 marks)
(b)
Use the output from your software for an appropriate hypothesis test with α = 0.05.
List the test statistic you will use for this test. Explain your decision criteria.
(18 marks)
(c)
Discuss the assumptions you have made in performing the hypothesis test. Are these
assumptions reasonable for this case? Please provide explanation/s to substantiate
your view.
(10 marks)
Question 4
Interpret the above statistical testing outcome and highlight three (3) possible business or
statistical concerns regarding the approach used here in determining whether the mean
amount of loans redeemed including interest has significantly improved post-financial crisis.
If your group has a free hand on the project, starting from measurements, sampling, to
analysis, what recommendations would you give for the problem in question?
Keep your answer within 400 to 500 words (indicate your word count)
(20 marks)
Question 5
In about 300 words (indicate your word count), provide an executive summary of your
analysis and findings to Mr. Owen Shaw with respect to pawn broking operations in
Singapore and business prospects.
(15 marks)
—- END OF ASSIGNMENT —-
SIM UNIVERSITY
Assignment 2 – Page 4 of 4
BUS105e
Statistics
Assignment 2 – Group-based Assignment
July 2016 Presentation
BUS105e
Assignment 2
Group-based Assignment
This assignment is worth 30% of the final mark for BUS105e Statistics.
The cut-off date for this assignment is 31 Aug 2016, 2355hrs.
This is a group-based assignment. You should form a group of 3 members from your
seminar group. Each group is required to upload a single report to Canvas via your respective
seminar group. Please elect a group leader. The responsibility of the group leader is to upload
the report on behalf of the group.
It is important for each group member to contribute substantially to the final submitted work.
All group members are equally responsible for the entire submitted assignment. If you feel
that the work distribution is inequitable to either yourself or your group mates, please
highlight this to your instructor as soon as possible. Your instructor will then investigate and
decide on any action that needs to be taken. It is not necessary for all group members to be
awarded the same mark.
___________________________________________________________________________
Guidelines on GBA Report Writing
The report should be written in a Microsoft Word document format with single spacing and
Times New Roman font of 12 point font size.
___________________________________________________________________________
Feasibility Study of Pawn Broking Operation in Singapore
Pawn broking in Singapore started in the 19th century. In the past, pawn brokers were
regarded as the “poor man’s bankers”. Now their customers include white-collar workers and
businessmen. Each year, the pawnshops gave out loans in excess of $1 billion, and as at 2014,
there were 214 pawnshops on the island (NLB, 2015).
Pawnshops has always been the place to go to when individual needs immediate cash by
surrendering or pawning their valuable items, where they will get loan up to a certain
percentage of the item’s value. For the past few years, pawnshops in Singapore have
undergone significant facelift and in a bid to attract the younger generation. According to a
report by CNBC, tighter credit, rising living costs and a make-over of shops away from
intimidating store fronts with metal bars have all contributed to their popularity among
consumers in the Southeast Asian nation.
Pacific Pawn Brokers, an established pawnbroker based in Hong Kong is keen to set up
operations in Singapore and its corporate mission is to be among the top three pawn brokers
in whichever country it invests in. Mr Owen Shaw, CEO of Pacific Pawn Brokers, has
engaged your consultancy service to help him analyse the pawn broking business in
Singapore, and whether there is a significant growth in the pawnshop business in Singapore
since the last financial crisis in 2008-2009.
You are provided with a sample of monthly pawnshop data from 1980 to 2015, showing the
number of pledges received, number of pledges redeemed, amount of loans given out and
SIM UNIVERSITY
Assignment 2 – Page 2 of 4
BUS105e
Assignment 2
amount of loans redeemed with interest. You are to assist Mr. Owen Shaw to analyse the data
using Excel software and provide solutions to the following questions:
Data Source: partially extracted from Department of Statistics (2015), Statistical Tables from
SingStat Table Builder http://www.tablebuilder.singstat.gov.sg/
___________________________________________________________________________
Question 1
Compare monthly number of pledges received between pre-Year 2000 and post-Year 2000.
Use descriptive statistics to describe and interpret the data on number of pledges received.
You are required to identify the measures of location and dispersion as well as organise the
appropriate output from your software into a relevant statistical and graphical presentation of
the data. Justify your choices. What are your preliminary observation/s?
Hint: Summaries and presentations should help you decide subsequent analysis.
(8 marks)
Question 2
(a)
Identify the probability of the sample mean of number of pledges (monthly) received
post-Year 2000 is more than 260,000 per month. Assume that the standard deviation
for number of pledges received can be approximated by the sample standard
deviation.
(4 marks)
(b)
Construct and state the 90% confidence intervals for the amount of loans (monthly)
given out for the period pre-Year 2000 and post-Year 2000. Interpret these confidence
intervals in your report. With these findings, can you validate if the amount of loans
given out during those two periods is different?
(8 marks)
(c)
List the key assumption(s) you have made in constructing this confidence interval.
Discuss if this/these assumption(s) is (are) reasonable.
(4 marks)
(d)
Explain what will be your follow-up actions including statistical tests, if the key
assumption(s) were found to be violated.
(6 marks)
SIM UNIVERSITY
Assignment 2 – Page 3 of 4
BUS105e
Assignment 2
Question 3
Mr Owen Shaw claims that the hearsay from business associate is that since 2008-2009 crisis,
the pawn broking business has not improved much in terms of loans redemption with interest
(high volume of loans redemption with interests represents more profit for the pawn brokers).
Select an appropriate test of hypothesis to determine if the mean amount of loans redeemed,
including interest, has increased significantly between pre-financial crisis (2000 – 2009) and
post-financial crisis (2010 onwards).
You should include the following:
(a)
State the null and alternative hypotheses and explain how you developed these two
hypotheses.
(7 marks)
(b)
Use the output from your software for an appropriate hypothesis test with α = 0.05.
List the test statistic you will use for this test. Explain your decision criteria.
(18 marks)
(c)
Discuss the assumptions you have made in performing the hypothesis test. Are these
assumptions reasonable for this case? Please provide explanation/s to substantiate
your view.
(10 marks)
Question 4
Interpret the above statistical testing outcome and highlight three (3) possible business or
statistical concerns regarding the approach used here in determining whether the mean
amount of loans redeemed including interest has significantly improved post-financial crisis.
If your group has a free hand on the project, starting from measurements, sampling, to
analysis, what recommendations would you give for the problem in question?
Keep your answer within 400 to 500 words (indicate your word count)
(20 marks)
Question 5
In about 300 words (indicate your word count), provide an executive summary of your
analysis and findings to Mr. Owen Shaw with respect to pawn broking operations in
Singapore and business prospects.
(15 marks)
—- END OF ASSIGNMENT —-
SIM UNIVERSITY
Assignment 2 – Page 4 of 4
Time
1980 Jan
1980 Feb
1980 Mar
1980 Apr
1980 May
1980 Jun
1980 Jul
1980 Aug
1980 Sep
1980 Oct
1980 Nov
1980 Dec
1981 Jan
1981 Feb
1981 Mar
1981 Apr
1981 May
1981 Jun
1981 Jul
1981 Aug
1981 Sep
1981 Oct
1981 Nov
1981 Dec
1982 Jan
1982 Feb
1982 Mar
1982 Apr
1982 May
1982 Jun
1982 Jul
1982 Aug
1982 Sep
1982 Oct
1982 Nov
1982 Dec
1983 Jan
1983 Feb
1983 Mar
1983 Apr
1983 May
1983 Jun
1983 Jul
Number
Of
Received(Number)
Pledges Number
Of
Pledges Amount Of Loans
Redeemed(Number)
Out(Million Dollars)
179,012
157,187
172,721
163,931
152,429
148,287
167,886
161,609
179,484
166,376
147,170
149,664
158,161
148,396
169,797
163,573
149,324
156,043
161,911
159,724
175,464
161,287
158,706
150,206
137,003
167,878
164,390
165,139
154,700
152,535
155,078
180,422
166,865
163,007
164,274
149,560
154,392
150,772
175,990
164,303
159,288
152,151
159,101
195,929
193,351
140,108
132,059
131,891
130,591
156,863
161,944
165,971
159,512
143,261
174,352
171,537
153,173
141,953
137,312
136,045
136,475
165,041
134,839
158,751
160,184
144,466
181,396
190,427
137,024
144,975
141,318
139,909
132,366
162,134
151,067
161,095
162,165
154,675
176,880
157,538
183,201
143,415
138,890
137,925
134,051
153,932
Given
34.6
32.6
33
29.5
26.1
27
33.4
33.2
36.4
34.3
30
32.6
34.7
33.2
37.1
34.9
31.7
33.3
34.3
33.3
36.1
33.3
32.1
32.1
29.3
34.8
33.8
32.8
31.6
30.3
32.5
35.8
34.7
33.6
34.8
33.2
33.1
34.9
39.9
36.9
36.8
35.2
36.9
1983 Aug
1983 Sep
1983 Oct
1983 Nov
1983 Dec
1984 Jan
1984 Feb
1984 Mar
1984 Apr
1984 May
1984 Jun
1984 Jul
1984 Aug
1984 Sep
1984 Oct
1984 Nov
1984 Dec
1985 Jan
1985 Feb
1985 Mar
1985 Apr
1985 May
1985 Jun
1985 Jul
1985 Aug
1985 Sep
1985 Oct
1985 Nov
1985 Dec
1986 Jan
1986 Feb
1986 Mar
1986 Apr
1986 May
1986 Jun
1986 Jul
1986 Aug
1986 Sep
1986 Oct
1986 Nov
1986 Dec
1987 Jan
1987 Feb
1987 Mar
1987 Apr
1987 May
1987 Jun
182,940
165,825
163,607
164,977
153,886
163,415
165,080
179,065
169,972
170,816
153,748
182,937
176,994
170,722
183,374
173,695
156,951
169,474
149,357
190,661
192,033
181,018
162,450
201,221
180,604
191,512
194,304
184,134
180,235
185,018
168,500
195,199
193,495
177,831
177,481
199,337
181,471
195,848
194,635
172,773
185,627
168,594
182,605
196,811
186,645
169,527
191,520
156,343
159,088
155,116
149,791
178,936
199,984
144,701
149,176
143,129
145,113
159,238
149,157
155,782
155,878
164,741
156,464
176,188
165,101
184,369
148,774
153,827
150,892
153,882
156,069
153,036
168,535
171,160
167,053
186,920
183,719
183,088
165,992
164,104
162,631
163,832
165,925
163,791
185,286
189,884
159,794
206,025
211,179
157,539
168,150
165,426
177,240
159,718
42.2
39.6
38.2
39.3
38
39
40.7
44.5
40.7
40.7
38.5
41.2
41.3
41.7
43.8
41.1
38.8
38.7
36.6
46.3
45.4
43
39
45.3
42
45.8
45.4
43.3
43
42.9
41.7
46.8
45.4
42.5
42.1
46.1
43.7
48
47.4
41.9
46.4
42.2
46.2
50.6
47.4
45.3
49.2
1987 Jul
1987 Aug
1987 Sep
1987 Oct
1987 Nov
1987 Dec
1988 Jan
1988 Feb
1988 Mar
1988 Apr
1988 May
1988 Jun
1988 Jul
1988 Aug
1988 Sep
1988 Oct
1988 Nov
1988 Dec
1989 Jan
1989 Feb
1989 Mar
1989 Apr
1989 May
1989 Jun
1989 Jul
1989 Aug
1989 Sep
1989 Oct
1989 Nov
1989 Dec
1990 Jan
1990 Feb
1990 Mar
1990 Apr
1990 May
1990 Jun
1990 Jul
1990 Aug
1990 Sep
1990 Oct
1990 Nov
1990 Dec
1991 Jan
1991 Feb
1991 Mar
1991 Apr
1991 May
187,830
183,378
188,714
188,937
181,147
185,661
174,340
170,164
205,338
186,608
183,120
195,743
183,665
192,357
189,746
189,056
192,358
187,525
180,467
177,013
199,186
184,581
200,918
193,609
190,867
192,497
194,178
194,428
203,850
182,527
182,254
193,988
202,186
186,806
209,965
193,385
190,171
204,785
194,447
215,123
210,408
189,513
194,573
177,417
209,535
219,187
218,976
165,674
168,331
176,155
181,078
165,157
207,404
172,545
193,225
168,918
159,621
169,859
159,381
161,457
169,119
177,524
175,410
176,920
223,904
186,124
173,611
163,984
158,837
175,005
159,875
173,248
170,030
179,073
179,128
183,381
218,810
225,922
154,316
167,279
174,563
165,164
159,225
172,134
181,410
174,768
186,294
183,744
212,907
185,001
202,587
165,670
189,270
168,809
48.8
49.4
52
52.1
50.9
52.6
48.3
51.1
60.3
54
53.8
56.8
53.4
57.1
56.5
55
56.7
56.5
53.4
52.9
58.9
55
58.7
56.6
55.6
57.3
57.4
57.6
60.2
55.7
55.7
60.9
61.7
57.4
60.6
56.8
56.6
62.8
59.5
65.1
62.5
57.8
58.2
57.5
65.9
67.6
64.4
1991 Jun
1991 Jul
1991 Aug
1991 Sep
1991 Oct
1991 Nov
1991 Dec
1992 Jan
1992 Feb
1992 Mar
1992 Apr
1992 May
1992 Jun
1992 Jul
1992 Aug
1992 Sep
1992 Oct
1992 Nov
1992 Dec
1993 Jan
1993 Feb
1993 Mar
1993 Apr
1993 May
1993 Jun
1993 Jul
1993 Aug
1993 Sep
1993 Oct
1993 Nov
1993 Dec
1994 Jan
1994 Feb
1994 Mar
1994 Apr
1994 May
1994 Jun
1994 Jul
1994 Aug
1994 Sep
1994 Oct
1994 Nov
1994 Dec
1995 Jan
1995 Feb
1995 Mar
1995 Apr
193,632
213,092
196,341
209,085
218,598
217,772
197,522
193,701
192,405
210,273
216,674
207,645
204,746
205,221
200,272
211,811
218,203
216,138
197,243
178,962
207,641
221,261
234,799
226,980
212,898
215,358
215,658
221,347
227,159
228,198
211,938
205,519
191,480
236,058
229,934
218,104
214,458
208,820
217,826
222,927
228,988
226,214
209,804
197,226
200,426
241,994
224,637
156,950
181,148
168,813
187,770
196,317
196,261
222,185
217,559
176,591
178,908
178,964
167,580
168,268
181,322
172,767
186,210
194,636
180,229
218,804
212,288
152,108
196,939
171,126
184,023
167,465
186,786
182,434
193,564
198,908
201,946
239,326
199,396
206,209
205,644
175,288
178,965
174,430
183,682
186,697
199,921
209,224
194,790
232,696
233,093
169,131
188,782
171,594
59.1
65.2
61
65
66.9
61.3
62.5
59.6
62.6
67.2
65
60.9
62.3
62.7
61.9
65.1
66.4
65
63.4
58.5
67.8
72.1
72.1
70.5
70.9
72.2
72.7
73.9
75.5
76.3
73.7
74.4
73.1
87.5
79.5
77.8
77.2
77.1
80.7
82
82.7
82.5
79.7
75.9
80.8
92.5
82.9
1995 May
1995 Jun
1995 Jul
1995 Aug
1995 Sep
1995 Oct
1995 Nov
1995 Dec
1996 Jan
1996 Feb
1996 Mar
1996 Apr
1996 May
1996 Jun
1996 Jul
1996 Aug
1996 Sep
1996 Oct
1996 Nov
1996 Dec
1997 Jan
1997 Feb
1997 Mar
1997 Apr
1997 May
1997 Jun
1997 Jul
1997 Aug
1997 Sep
1997 Oct
1997 Nov
1997 Dec
1998 Jan
1998 Feb
1998 Mar
1998 Apr
1998 May
1998 Jun
1998 Jul
1998 Aug
1998 Sep
1998 Oct
1998 Nov
1998 Dec
1999 Jan
1999 Feb
1999 Mar
231,124
215,537
213,348
222,086
232,406
233,731
233,374
207,847
216,804
189,714
250,616
235,683
231,358
217,101
226,733
219,848
238,776
237,264
228,133
217,648
206,013
195,624
248,485
233,113
230,709
215,571
216,851
208,419
241,197
233,344
224,048
224,156
188,200
237,570
255,816
235,255
223,931
232,473
225,263
235,455
24 …
Purchase answer to see full
attachment
Recent Comments