Question

How to solve this USING SAS EG? THANKS

Automobile collisions: The number of collision claims (COLLISION) reported for 1984-1986 cars are listed for 9 car categories: small two-door, midsized two-door, large two-door, small four-door, midsized four-door, large four-door, small station wagons and vans, midsized station wagons and vans, large station wagons and vans..

a. In excel convert the data to the format which is appropriate for SAS EG (the data should have 2 columns with names CARCLAS and CRASH).

b. Using the classification variable (CARCLAS), run an ANOVA in SAS EG for the number of collisions.

c. Determine whether there is a difference in the average number of collisions for different types of cars. Use a 5% level of significance. State the hypotheses to be tested, the decision rule, the test statistic, and your decision.

CLASS1	CLASS2	CLASS3	CLASS4	CLASS5	CLASS6	CLASS7	CLASS8	CLASS9
155	80	52	122	75	65	77	84	59
119	70	68	108	95	55	76	74	82
137	98	72	110	70	65	94	80	59
137	103	67	109	67	79	70	90	63
103	108		100	78	59	79	66	58
232	91		88	83	76	87	113	57
254	114		91	76		76	64	63
160	119		87	92			80	49
122	88		81	93			69
98	104		82	75			91
98	93		102	97			89
186	110		113	73			75
111	121		112	121			65
118			124	79
118			111	158
135			145	87
142			123	130
106			103	83
103				85
147				84
				83
				91
				101

Answer 1

Hypotheses:

H0 : there is no difference in the average number of collisions for different types of cars

Ha : there is a difference in the average number of collisions for different types of cars

Data Summary Groups Group 1 Group 2 Group 3 Group 4 Group 5 Group 6 Group 7 Group 8 Group 9 Mean 139.05 99.9231 64.75 106.1667 90.2609 66.5 79.8571 80 61.25 Std. Dev. 42.4729 15.1793 8.7702 16.6283 21.0394 9.3755 8.0297 13.7417 9.4529 Std. Error 9.4972 4.21 4.3851 3.9193 4.387 3.8275 3.0349 3.8113 3.3421 20) 13 4 18 23 13

ANOVA Summary Degrees of Freedom Sum of Squares Mean Square Source F-Stat P-Value DF Between Groups Within Groups Total: MS 7973.7848 538.131 14.8176 63790.2783 55427.4959 119217.7742 103

p value< 0.05 , reject H0

So there is a difference in the average number of collisions for different types of cars