叶菲.docx

1、叶菲4BU005 Analytical Skills For BusinessModule Leader: Dr Yong WangYe Fei10233004BU005- Analytical Skills For BusinessQuestion one If X=2a). Data used57445544839935751067857581066943Frequency table showing the number of vans on duty for a 30 day periodNumber of Vans on DutyNumber of Days(frequency)3

2、but less than 434 but less than 555 but less than 676 but less than 737 but less than 848 but less than 939 but less than 10310 but less than 112total30Working for class intervalsRange=10-3=7b). c). In the histogram, we can see that the value are not symmetrical. The most common number of vans avail

3、able in the 30 day period was 5 or 6 vans. The histogram is inclined to right side. In the first three groups, the number is increased all the time. The second one is 4-5 numbers of vans on duty and the frequency is 8. In group 3-4 the frequency increases to 3 and then 4-5, 5-6. 5-6 the frequency in

4、crease showing the top of the number. 6-7frequency is back the number of 3-4, then, in last third group decreases showing the bars sloping down. The lowest frequency is 2. The highest number of the vans is 10 and the lowest number of the vans is 3. This date shows that the vans are not equally distr

5、ibuted, as more vans are available on some days than others. This could be due to many different reasons affecting the business such as the weather and the time of the month.If the data were grouped differently such as using more intervals then the histogram would look different, as the data would b

6、e more spread out.Question2If X=2Table showing the value of the companys assets over a five-period. Values (000s)Asset20052006200720082009Property7072879287Plant& machinery170160175180180Stock & work in progress540550590600600Debtors420440520550590cash30501108060a)b). The line graph shows the value

7、of assets in a five year period analyze. The stock and work in progress is the highest valued asset of the years analyzed, its the highest in 2009 and it increased to 600,000. The debtors increase all the time in five years. The value is as the same as the stock&work in progress in 2009. Both the pl

8、ant&machinery and the propertys value are symmetry. The plant&machinery always between 100,000 and 200,000 in the five years and the propertys value is always below 100,000. The cash is the lowest valued asset. Only in 2007 does it increase to 110,000 in this year.Question3If X=2Table showing the ti

9、mes taken for 30 customers to be served in the bank.(minute)0.461.782.382.392.542.593.283.784.654.875.245.265.335.335.766.276.556.566.727.377.457.667.688.108.298.779.559.669.6610.99Total=176.92a.)Workings:=176.92/30 5.90 Median= (n+1)/2 = (30+1)/2 =15.5 ordered observation 15.5number= (6.27+5.76) /2

10、 =13.03 /2 = 6.5 minuteFirst quartile=(n+1)/4 = 31/ 4 = 7.75 8 ordered observation Rule3 Q1= 8th number = 3.78miunte Third quartile= (n+1)*3/4 = (30+1)*3/4 = 93/4=23.2523 ordered observation Rule3 Q3= 23rd number=7.68 minuteAnswers:Mean=5.90miunteMedia=6.5miunteFirst quartile=3.78miunteThird quartil

11、e=7.68miunteb).Time(middle value)xx-m(x-m)20.46-5.4429.591.78-4.1216.972.38-3.5212.392.39-3.5112.322.54-3.3611.292.59-3.3110.963.28-2.626.863.78-2.124.494.65-1.251.564.87-1.031.065.24-0.660.445.26-0.640.415.33-0.570.325.33-0.570.325.76-0.140.026.270.370.146.550.650.426.560.660.446.720.820.677.371.47

12、2.167.451.552.407.661.763.107.681.783.178.102.204.848.292.395.718.772.878.249.553.6513.329.663.7614.149.663.7614.1410.995.0925.91-0.08 (m=5.90)Workings:Standard deviation =2.63 minuteRange= 10.99-0.46=10.5miunteInter-quartile range= Q3-Q1=7.68-3.78=3.9minuteAnswers:Standard deviation = 2.63minuteRan

13、ge= 10.5miuntesInter-quartile range= 3.9minutec).The branch manager should be base their statement to tell the customer how long will the customer need to wait. The mean time is 5.9minute,then the manager replies,” Almost certainly not longer than five minute” is certainly incorrect. Whats more, if

14、the manager used the median time, the manager would be incorrect as this is 6.5 minute.In the other way, the branch manager is using the time on the first quartile time of 3.78miuntes, thats under five minute. The inter-quartile range is also under five minute. Because the inter-quartile is third qu

15、artile of 7.68 minute less first quartiles equal 3.9minute, as this is under five minute. But this is not very accuracy to judge the timing. The inter-quartile range represents the central fifty percent of the data that just the part of data, not included all of the data, so, its not so accuracy. Wh

16、ats more, the standard deviation is 2.63minute thats less than five minute. If the manager analyze from the standard deviation, thats correct. However, the standard deviation time is the average between each individual value and the mean value of data. The range of the data is 10.5 minute, therefore

17、, the standard deviation shouldnt be used as a time to give to a customer. Both the quartile and standard deviation is blemish to estimate the timing. Even thought there is some way to evaluate the wait time is less than five minute, all of them are not so accuracy. On basis of the results of a) and

18、 b), the common reply is more than five minute,Question4a) If X=2Table showing the access time of a computer disc system:access time in millisecondfrequencycumulative frequencymiddle value(x)fxx-m(x-m)2f(x-m)230 but less than 35393932.51268-11.37129.28 5041.80 35 but less than 40569537.52100-6.3740.

19、58 2272.31 40 but less than 453112642.51318-1.371.88 58.18 45 but less than 505017647.523753.6313.18 658.85 50 but less than 552119752.511038.6374.48 1564.01 55 but less than 603523257.5201313.63185.78 6502.19 Total2321017716097.34 WorkingsStandard deviation = = = = 8.33milliscecondAnswersMean=43.86

20、 millisecondsStandard deviation= 8.33 millisecondsb).Table showing cumulative frequency percentage for the access time on the computer system:access time (milliseconds)frequencycumulative frequencyCumulative percentage (%)30 but less than 3539391735 but less than 4056954140 but less than 45311265445

21、 but less than 50501767650 but less than 55211978555 but less than 6035232100total232Media= 232/2=116th number The number of the 116 is in the group of 40 but less than 45. From the cumulative frequency chart we can see that the media is in the group of 40 but less than 45c).Table showing access tim

22、e to the computer disc system when increased by 5 milliseconds.access time in millisencondfrequencycumulative frequendymiddle value (x)fxx-m(x-m)2f(x-m)235 but less than 40393937.51462.5-11.36129.05 5032.93 40 but less than 45569542.52380-6.3640.45 2265.18 45 but less than 503112647.51472.5-1.361.85

23、 57.34 50 but less than 555017652.526253.6413.25 662.48 55 but less than 602119757.51207.58.6474.65 1567.64 60 but less than 653523262.52187.513.64186.05 6511.74 Total2321133516097.31 WorkingsStandard deviation= = = 8.33 millisecond AnswersMean=48.86 millisecond Standard deviation=8.33 millisecondd)

24、.access time in millisecondfrequencycumulative frequendymid point(x)fxx-m(x-m)2f(x-m)242 but less than 49393945.51774.5-15.9252.819859.5949 but less than 56569552.52940-8.979.214435.7656 but less than 633112659.51844.5-1.93.61111.9163 but less than 705017666.533255.126.011300.570 but less than 77211

25、9773.51543.512.1146.413074.6177 but less than 843523280.52817.519.1364.8112768.35Total2321424531550.72Workings =11265/232=61.4 millisecondsStandard deviation= =e).The standard deviation in a) and c), both of them are 8.33 millisecond. Because the frequency is not change, the access times have all be

26、en increased by five. The mean is the 1.4multiple of standard deviation, so, 61.4(d)=1.4X43.86(a).11.6(d)=1.4*8.33(a). The f(x-m)2 is almost the same in the a) and c). however, the f(x-m)2 is much bigger when the access number increase40%, because the mean value will change a lot.Question5a). table

27、showing the number of houses sold in each price interval.price of house in ,000frequencycum.frequencymid point(x)fxx-m(x-m)2f(x-m)2below1502222751650-99.899978.01 219516.27 150n but under 1708410616013440-14.89221.71 18623.82 170 but under 1905416018097205.1126.11 1410.05 190 but under 2103919920078

28、0025.11630.51 24589.97 210 but under 23020219220440045.112034.91 40698.24 230 but under 25012231240288065.114239.31 50871.75 250 but under 2706237260156085.117243.71 43462.27 TOTAL2374145024374.28 399172.37 Workings=41450/237=174.89Standard deviation= AnswersMean=174.89(000s)Standard deviation=41.04(000s)A survey of house prices in five local newspapers is very clear. The price in the 170,000 but under 190,000 sold the best. Most of people can