In: Statistics and Probability
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 |
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
p value< 0.05 , reject H0
So there is a difference in the average number of collisions for different types of cars