ANALYTICAL SKILLS FOR BUSINESS

Analytical Skills for Business



Analytical Skills for Business

Introduction

Assignment of analytical skills for business and the subject area is IB. the results are obtained by using SPSS software.

Pilot Assessment 1: Individual Assignment

Solution 1

Data Set

4

7

3

4

4

5

3

4

7

3

8

9

2

5

6

5

9



6

6

8

4

7

4



8

9

6

5

9

3



3

Frequency Distribution

(X present in the data is assumed to be equal 1)

Statistics

Number of Vans on duties

N

Valid

30

Missing

0

Mean

5.5333

Median

5.0000

Mode

4.00

Std. Deviation

2.14530

Range

7.00

Number of Vans on duties

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

2

1

3.3

3.3

3.3

3

5

16.7

16.7

20.0

4

6

20.0

20.0

40.0

5

4

13.3

13.3

53.3

6

4

13.3

13.3

66.7

7

3

10.0

10.0

76.7

8

3

10.0

10.0

86.7

9

4

13.3

13.3

100.0

Total

30

100.0

100.0

Case Processing Summary

Cases

Valid

Missing

Total

N

Percent

N

Percent

N

Percent

Number of Vans on duties

30

100.0%

0

.0%

30

100.0%

Descriptives

Statistic

Std. Error

Number of Vans on duties

Mean

5.5333

.39168

95% Confidence Interval for Mean

Lower Bound

4.7323

Upper Bound

6.3344

5% Trimmed Mean

5.5185

Median

5.0000

Variance

4.602

Std. Deviation

2.14530

Minimum

2.00

Maximum

9.00

Range

7.00

Interquartile Range

3.25

Skewness

.277

.427

Kurtosis

-1.138

.833

Tests of Normality

Kolmogorov-Smirnova

Shapiro-Wilk

Statistic

df

Sig.

Statistic

df

Sig.

Number of Vans on duties

.163

30

.042

.925

30

.036

a. Lilliefors Significance Correction

Histogram with Normal Curve

Interpretation

The provided data of vans on duties is normally distributed which can be analyzed by histogram which is bell shaped and from both the normality tests of Kolmogorov-Smirnova and Shapiro-Wilk the significant value is less than 0.05.

Discussion

Frequencies distribution provides statistics and graphs that are useful to describe many types of variables. Frequencies procedure is a good place to start your data. To report the frequency and histogram can organize a variety of values ??in ascending or descending order, or you can use categories and their frequency.

Reliable statistics such as median, quartiles and percentiles, are appropriate for quantitative variables, or do not meet the assumption of normality.

Solution 2

Visual representation that best conveys the comparison of different assets over a 5-year period

Years

Property

Plant and Machinery

Stock and work-in-progress

Debtors

Cash

2005

69

160

520

410

25

2006

71

160

550

440

50

2007

86

170

580

510

100

2008

91

180

600

550

80

2009

86

175

590

580

55

Years: 1 = 2005

2 = 2006

3 = 2007

4 = 2008

5 = 2009

Discussion

In the above graph the comparison of different assets over a 5-year period has been made. Over the last five years the provided data from 2005 to 2009, assets have shown growth per year collectively.

In the last year i.e. 2009 the value of all assets is less than the value of 2008 except for the value of debtors.

Solution 3

Data set

5.27

2.59

4.24

5.33

7.77

3.78

6.45

3.28

5.56

8.1

1.38

5.33

8.66

8.29

4.76

6.55

6.66

4.65

6.68

1.78

1.54

9.66

6.37

2.39

8.55

5.26

5.72

4.87

9.99

0.46

Frequencies

Statistics

Customer Data

N

Valid

30

Missing

6

Mean

5.3973

Median

5.3300

Mode

5.33

Std. Deviation

2.51226

Range

9.53

Customer Data

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

0.46

1

2.8

3.3

3.3

1.38

1

2.8

3.3

6.7

1.54

1

2.8

3.3

10.0

1.78

1

2.8

3.3

13.3

2.39

1

2.8

3.3

16.7

2.59

1

2.8

3.3

20.0

3.28

1

2.8

3.3

23.3

3.78

1

2.8

3.3

26.7

4.24

1

2.8

3.3

30.0

4.65

1

2.8

3.3

33.3

4.76

1

2.8

3.3

36.7

4.87

1

2.8

3.3

40.0

5.26

1

2.8

3.3

43.3

5.27

1

2.8

3.3

46.7

5.33

2

5.6

6.7

53.3

5.56

1

2.8

3.3

56.7

5.72

1

2.8

3.3

60.0

6.37

1

2.8

3.3

63.3

6.45

1

2.8

3.3

66.7

6.55

1

2.8

3.3

70.0

6.66

1

2.8

3.3

73.3

6.68

1

2.8

3.3

76.7

7.77

1

2.8

3.3

80.0

8.1

1

2.8

3.3

83.3

8.29

1

2.8

3.3

86.7

8.55

1

2.8

3.3

90.0

8.66

1

2.8

3.3

93.3

9.66

1

2.8

3.3

96.7

9.99

1

2.8

3.3

100.0

Total

30

83.3

100.0

Missing

System

6

16.7

Total

36

100.0

Histogram with normal curve

Interpretation

The data of customers is normally distributed which is analyzed through the bell shaped histogram. The case in data are 6 missing and 30 valid cases.

Solution 4

Data set

Access time in milliseconds

Frequency

30 but less than 35

38

35 but less than 40

55

40 but less than 45

30

45 but less than 50

49

50 but less than 55

20

55 but less than 60

34

Case Processing Summary

Cases

Valid

Missing

Total

N

Percent

N

Percent

N

Percent

Customer Data

30

83.3%

6

16.7%

36

100.0%

Descriptives

Statistic

Std. Error

Customer Data

Mean

5.3973

.45867

95% Confidence Interval for Mean

Lower Bound

4.4592

Upper Bound

6.3354

5% Trimmed Mean

5.4056

Median

5.3300

Variance

6.311

Std. Deviation

2.51226

Minimum

.46

Maximum

9.99

Range

9.53

Interquartile Range

3.30

Skewness

-.116

.427

Kurtosis

-.599

.833

Extreme Values

Case Number

Value

Customer Data

Highest

1

33

9.99

2

12

9.66

3

14

8.66

4

21

8.55

5

17

8.29

Lowest

1

36

.46

2

8

1.38

3

9

1.54

4

35

1.78

5

18

2.39

Box Plot

Frequency

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

24

1

3.3

16.7

16.7

34

1

3.3

16.7

33.3

38

1

3.3

16.7

50.0

42

1

3.3

16.7

66.7

53

1

3.3

16.7

83.3

59

1

3.3

16.7

100.0

Total

6

20.0

100.0

Missing

System

24

80.0

Total

30

100.0

Discussion

Descriptives procedure displays univariate statistic for multiple variables in a single table and calculates standardized values ??(Z scores). For Z estimates are stored, they are added to the data in the editor and are available for charts, data lists and reports. Question 5

A survey of house prices in five local newspapers provides the following information:

Price of house in £,000

Number of houses sold

Below 150

20+X

150 but under 170

82+X

170 but under 190

52+X

190 but under 210

37+X

210 but under 230

18+X

230 but under 250

10+X

250 but under 270

4+X

TOTAL

223 + 7*X

Solution

Price of house in £,000

Number of houses sold

Below 150

21

150 but under 170

83

170 but under 190

53

190 but under 210

48

210 but under 230

19

230 but under 250

11

250 but under 270

5

TOTAL

230

Statistics

Number of houses sold

N

Valid

7

Missing

29

Number of houses sold

Frequency

Percent

Valid Percent

Cumulative ...