STATISTICAL ASSIGNMENT

Statistical Assignment

Statistical Assignment

VAR00001

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

3

2

4.4

4.4

4.4

7

1

2.2

2.2

6.7

9

1

2.2

2.2

8.9

11

1

2.2

2.2

11.1

12

1

2.2

2.2

13.3

13

1

2.2

2.2

15.6

15

1

2.2

2.2

17.8

16

1

2.2

2.2

20.0

17

1

2.2

2.2

22.2

18

1

2.2

2.2

24.4

19

2

4.4

4.4

28.9

20

1

2.2

2.2

31.1

21

2

4.4

4.4

35.6

22

5

11.1

11.1

46.7

23

5

11.1

11.1

57.8

24

5

11.1

11.1

68.9

25

2

4.4

4.4

73.3

26

3

6.7

6.7

80.0

27

2

4.4

4.4

84.4

28

3

6.7

6.7

91.1

29

1

2.2

2.2

93.3

30

2

4.4

4.4

97.8

33

1

2.2

2.2

100.0

Total

45

100.0

100.0

Above frequency table shows that the values, 22, 23, and 24 have maximum frequencies in the data.

(b)

Comments on histogram

Histogram shows that data is negatively skewed as most of the bars of histogram falls on the right side and maximum values are between 20 and 30.

Q.2(a) solution:

Comments on histograms:

Histograms show a significant change in unit sales for vehicles from March 2006 to March 2007. As the above diagram shows that there is a consistency in the sales in earlier months of year 2007 but at the end i.e. in Feb and March sales have shoot up to a record level.

Question 3 Solution: (a)

Statistics

graduates

non-graduates

N

Valid

10

10

Missing

0

0

Mean

2.1300E4

14600.0000

Median

2.1000E4

14500.0000

Percentiles

25

1.7750E4

12750.0000

50

2.1000E4

14500.0000

75

2.4750E4

16250.0000

(b)

Statistics

graduates

non-graduates

N

Valid

10

10

Missing

0

0

Std. Deviation

4.16467E3

2366.43191

Range

13000.00

8000.00

(c) Above table shows a significant difference in the annual salaries of graduates and non graduates, as the salaries of graduates are more than double as compared with the salaries

Of the non graduates.

Q4 solution: (a)

Statistics

waiters

waitresses

N

Valid

4

4

Missing

6

6

Mean

30.0000

7.5000

Median

30.0000

8.0000

Std. Deviation

1.29099E1

3.41565

Range

30.00

8.00

(b)

There is no proper shape of distribution to be followed but majority of points fall near to centre diagonal so we can use normal distribution.

(c)

Statistics

waiters

N

Valid

4

Missing

6

Mean

30.0000

Std. Deviation

1.29099E1

Statistics

waiteresses

N

Valid

4

Missing

6

Mean

7.5000

Std. Deviation

3.41565

(d)

Ratio Statistics for waiters / waiteresses

Minimum

2.143

Maximum

15.000

Std. Deviation

6.167

Price Related Differential

1.457

Coefficient of Dispersion

1.174

Coefficient of Variation

Median Centered

225.1%

Question 5 solution:

FREQUENCIES VARIABLES=Traitanxiety Stateanxiety thinkingstyle

/HISTOGRAM NORMAL

/ORDER=ANALYSIS.

Frequencies

Traitanxiety

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

37

2

3.3

3.3

3.3

39

1

1.7

1.7

5.0

45

5

8.3

8.3

13.3

46

1

1.7

1.7

15.0

47

2

3.3

3.3

18.3

49

1

1.7

1.7

20.0

50

3

5.0

5.0

25.0

51

2

3.3

3.3

28.3

52

12

20.0

20.0

48.3

53

2

3.3

3.3

51.7

54

1

1.7

1.7

53.3

55

4

6.7

6.7

60.0

56

1

1.7

1.7

61.7

57

4

6.7

6.7

68.3

58

5

8.3

8.3

76.7

59

2

3.3

3.3

80.0

61

2

3.3

3.3

83.3

62

4

6.7

6.7

90.0

64

1

1.7

1.7

91.7

65

2

3.3

3.3

95.0

66

1

1.7

1.7

96.7

67

1

1.7

1.7

98.3

68

1

1.7

1.7

100.0

Total

60

100.0

100.0

Stateanxiety

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

41

2

3.3

3.3

3.3

44

3

5.0

5.0

8.3

46

4

6.7

6.7

15.0

47

8

13.3

13.3

28.3

48

3

5.0

5.0

33.3

49

1

1.7

1.7

35.0

50

3

5.0

5.0

40.0

51

6

10.0

10.0

50.0

52

3

5.0

5.0

55.0

54

6

10.0

10.0

65.0

55

2

3.3

3.3

68.3

56

6

10.0

10.0

78.3

57

3

5.0

5.0

83.3

58

2

3.3

3.3

86.7

60

2

3.3

3.3

90.0

61

3

5.0

5.0

95.0

62

1

1.7

1.7

96.7

63

1

1.7

1.7

98.3

74

1

1.7

1.7

100.0

Total

60

100.0

100.0

thinkingstyle

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

type 1

39

65.0

65.0

65.0

type 2

12

20.0

20.0

85.0

type 3

9

15.0

15.0

100.0

Total

60

100.0

100.0

Above table shows frequencies of various types of thinking style and the third type have maximum frequency.

Histogram

Histogram shows negatively skewness

Above histogram shows positive skewness.

Above histogram shows positive skewness.

DESCRIPTIVES VARIABLES=thinkingstyle Stateanxiety Traitanxiety

/STATISTICS=MEAN VARIANCE SKEWNESS.

Descriptives

Descriptive Statistics

N

Mean

Variance

Skewness

Statistic

Statistic

Statistic

Statistic

Std. Error

thinkingstyle

60

1.5000

.559

1.132

.309

Stateanxiety

60

52.3000

37.434

.703

.309

Traitanxiety

60

54.0000

48.983

-.243

.309

Valid N (listwise)

60

Above table shows mean greater than median means that the variables are independetly distributed.

ONEWAY Stateanxiety Traitanxiety BY thinkingstyle

/MISSING ANALYSIS.

Oneway ANOVA

ANOVA

Sum of Squares

df

Mean Square

F

Sig.

Stateanxiety

Between Groups

24.709

2

12.354

.322

.726

Within Groups

2183.891

57

38.314

Total

2208.600

59

Traitanxiety

Between Groups

152.092

2

76.046

1.583

.214

Within Groups

2737.908

57

48.033

Total

2890.000

59

Analysis of variance shows that .021 and .726 are greater than p value so we will reject our null hypothesis and conclude that there is both the variables are significant at 0.05% level of significance.

NPar Tests

Descriptive Statistics

N

Mean

Std. Deviation

Minimum

Maximum

Stateanxiety

60

52.3000

6.11832

41.00

74.00

Traitanxiety

60

54.0000

6.99879

37.00

68.00

Test Statistics

Stateanxiety

Traitanxiety

Chi-Square

22.967a

50.400b

df

18

22

Asymp. Sig.

.192

.001

a. 19 cells (100.0%) have expected frequencies less than 5. The minimum expected cell frequency is 3.2.

b. 23 cells (100.0%) have expected frequencies less than 5. The minimum expected cell frequency is 2.6.

Chi-square value calculated from data is 50.400 which is greater than p-value.

REGRESSION

/MISSING LISTWISE

/STATISTICS COEFF OUTS R ANOVA CHANGE

/CRITERIA=PIN(.05) POUT(.10)

/NOORIGIN

/DEPENDENT thinkingstyle

/METHOD=ENTER Stateanxiety Traitanxiety

/RESIDUALS NORM(ZRESID).

Variables Entered/Removedb

Model

Variables Entered

Variables Removed

Method

1

Traitanxiety, Stateanxietya

.

Enter

a. All requested variables entered.

b. Dependent Variable: thinkingstyle

ANOVAb

Model

Sum of Squares

df

Mean Square

F

Sig.

1

Regression

.074

2

.037

.064

.938a

Residual

32.926

57

.578

Total

33.000

59

a. Predictors: (Constant), Traitanxiety, Stateanxiety

b. Dependent Variable: thinkingstyle

There is a positive reltionship and dependence b/w both the variales.

Residuals Statisticsa

Minimum

Maximum

Mean

Std. Deviation

N

Predicted Value

1.4313

1.6089

1.5000

.03553

60

Residual

-.60886

1.51210

.00000

.74703

60

Std. Predicted Value

-1.933

3.064

.000

1.000

60

Std. Residual

-.801

1.990

.000

.983

60

a. Dependent Variable: thinkingstyle

GRAPH

/SCATTERPLOT(BIVAR)=Traitanxiety WITH Stateanxiety BY thinkingstyle

/MISSING=LISTWISE.

Scatter plot

There is no proper shape of distribution to be followed but majority of points fall near to centre diagonal so we can use normal distribution.

CORRELATIONS

/VARIABLES=Stateanxiety Traitanxiety

/PRINT=TWOTAIL NOSIG

/MISSING=PAIRWISE.

Correlations

Stateanxiety

Traitanxiety

Stateanxiety

Pearson Correlation

1

.401**

Sig. (2-tailed)

.002

N

60

60

Traitanxiety

Pearson Correlation

.401**

1

Sig. (2-tailed)

.002

N

60

60

**. Correlation is significant at the 0.01 level (2-tailed).

There is very strong correlation b/w both the varibles and we can say it a perfect correlation.

USA

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

6

5.8

5.8

5.8

Acura

2

1.9

1.9

7.8

Audi

2

1.9

1.9

9.7

BMW

1

1.0

1.0

10.7

Buick

4

3.9

3.9

14.6

Cadillac

2

1.9

1.9

16.5

Car data set

1

1.0

1.0

17.5

Chevrolet

8

7.8

7.8

25.2

Chrylser

1

1.0

1.0

26.2

Chrysler

2

1.9

1.9

28.2

Dodge

6

5.8

5.8

34.0

Eagle

2

1.9

1.9

35.9

Ford

8

7.8

7.8

43.7

Geo

2

1.9

1.9

45.6

Honda

3

2.9

2.9

48.5

Hyundai

4

3.9

3.9

52.4

Infiniti

1

1.0

1.0

53.4

Lexus

2

1.9

1.9

55.3

Lincoln

2

1.9

1.9

57.3

Manufacturer

1

1.0

1.0

58.3

manufacturer's

1

1.0

1.0

59.2

Mazda

5

4.9

4.9

64.1

Mercedes-Benz

2

1.9

1.9

66.0

Mercury

2

1.9

1.9

68.0

Mitsubishi

2

1.9

1.9

69.9

name

1

1.0

1.0

70.9

Nissan

4

3.9

3.9

74.8

Oldsmobile

4

3.9

3.9

78.6

Plymouth

1

1.0

1.0

79.6

Pontiac

5

4.9

4.9

84.5

Saab

1

1.0

1.0

85.4

Saturn

1

1.0

1.0

86.4

Subaru

3

2.9

2.9

89.3

Suzuki

1

1.0

1.0

90.3

Toyota

4

3.9

3.9

94.2

Volkswagen

4

3.9

3.9

98.1

Volvo

2

1.9

1.9

100.0

Total

103

100.0

100.0

V2

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

7

6.8

6.8

6.8

100

1

1.0

1.0

7.8

190E

1

1.0

1.0

8.7

240

1

1.0

1.0

9.7

300E

1

1.0

1.0

10.7

323

1

1.0

1.0

11.7

535i

1

1.0

1.0

12.6

626

1

1.0

1.0

13.6

850

1

1.0

1.0

14.6

90

1

1.0

1.0

15.5

900

1

1.0

1.0

16.5

Accord

1

1.0

1.0

17.5

Achieva

1

1.0

1.0

18.4

Aerostar

1

1.0

1.0

19.4

Altima

1

1.0

1.0

20.4

Astro

1

1.0

1.0

21.4

Bonneville

1

1.0

1.0

22.3

Camaro

1

1.0

1.0

23.3

Camry

1

1.0

1.0

24.3

Capri

1

1.0

1.0

25.2

Caprice

1

1.0

1.0

26.2

Caravan

1

1.0

1.0

27.2

Cavalier

1

1.0

1.0

28.2

Celica

1

1.0

1.0

29.1

Century

1

1.0

1.0

30.1

Civic

1

1.0

1.0

31.1

Colt

1

1.0

1.0

32.0

Concorde

1

1.0

1.0

33.0

Continental

1

1.0

1.0

34.0

Corrado

1

1.0

1.0

35.0

Corsica

1

1.0

1.0

35.9

Corvette

1

1.0

1.0

36.9

Cougar

1

1.0

1.0

37.9

Crown_Victoria

1

1.0

1.0

38.8

Cutlass_Ciera

1

1.0

1.0

39.8

DeVille

1

1.0

1.0

40.8

Diamante

1

1.0

1.0

41.7

Dynasty

1

1.0

1.0

42.7

Eighty-Eight

1

1.0

1.0

43.7

Elantra

1

1.0

1.0

44.7

ES300

1

1.0

1.0

45.6

Escort

1

1.0

1.0

46.6

Eurovan

1

1.0

1.0

47.6

Excel

1

1.0

1.0

48.5

Festiva

1

1.0

1.0

49.5

Firebird

1

1.0

1.0

50.5

Fox

1

1.0

1.0

51.5

Grand_Prix

1

1.0

1.0

52.4

Imperial

1

1.0

1.0

53.4

Integra

1

1.0

1.0

54.4

Justy

1

1.0

1.0

55.3

Laser

1

1.0

1.0

56.3

LeBaron

1

1.0

1.0

57.3

Legacy

1

1.0

1.0

58.3

Legend

1

1.0

1.0

59.2

LeMans

1

1.0

1.0

60.2

LeSabre

1

1.0

1.0

61.2

Loyale

1

1.0

1.0

62.1

Lumina

1

1.0

1.0

63.1

Lumina_APV

1

1.0

1.0

64.1

Maxima

1

1.0

1.0

65.0

Metro

1

1.0

1.0

66.0

Mirage

1

1.0

1.0

67.0

model

1

1.0

1.0

68.0

Model

1

1.0

1.0

68.9

MPV

1

1.0

1.0

69.9

Mustang

1

1.0

1.0

70.9

of car

1

1.0

1.0

71.8

Passat

1

1.0

1.0

72.8

Prelude

1

1.0

1.0

73.8

Previa

1

1.0

1.0

74.8

Probe

1

1.0

1.0

75.7

Protege

1

1.0

1.0

76.7

Q45

1

1.0

1.0

77.7

Quest

1

1.0

1.0

78.6

Riviera

1

1.0

1.0

79.6

Roadmaster

1

1.0

1.0

80.6

RX-7

1

1.0

1.0

81.6

SC300

1

1.0

1.0

82.5

Scoupe

1

1.0

1.0

83.5

Sentra

1

1.0

1.0

84.5

Seville

1

1.0

1.0

85.4

Shadow

1

1.0

1.0

86.4

Silhouette

1

1.0

1.0

87.4

SL

1

1.0

1.0

88.3

Sonata

1

1.0

1.0

89.3

Spirit

1

1.0

1.0

90.3

Stealth

1

1.0

1.0

91.3

Storm

1

1.0

1.0

92.2

Summit

1

1.0

1.0

93.2

Sunbird

1

1.0

1.0

94.2

Swift

1

1.0

1.0

95.1

Taurus

1

1.0

1.0

96.1

Tempo

1

1.0

1.0

97.1

Tercel

1

1.0

1.0

98.1

Town_Car

1

1.0

1.0

99.0

Vision

1

1.0

1.0

100.0

Total

103

100.0

100.0

V3

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

1

1.0

1.0

1.0

(code)

1

1.0

1.0

1.9

1

16

15.5

15.5

17.5

1=compact

1

1.0

1.0

18.4

2

21

20.4

20.4

38.8

2=small

1

1.0

1.0

39.8

3

22

21.4

21.4

61.2

3=midsize

1

1.0

1.0

62.1

4

11

10.7

10.7

72.8

4=large

1

1.0

1.0

73.8

5

14

13.6

13.6

87.4

5=sporty

1

1.0

1.0

88.3

6

9

8.7

8.7

97.1

6=van

1

1.0

1.0

98.1

Car Type

1

1.0

1.0

99.0

Type code

1

1.0

1.0

100.0

Total

103

100.0

100.0

USA * V3

USA

V3

N

1

(code)

1

1

16

1=compact

1

2

21

2=small

1

3

22

3=midsize

1

4

11

4=large

1

5

14

5=sporty

1

6

9

6=van

1

Car ...