Question 17 to 18 The price (in lakhs) of 3 Bed room apartment in four different category of cities is presented below. A B C D 87 108 74 72 97 94 70 64 73 96 51 45 72 61 68 44 133 63 76 62 107 77 52 65 131 96 61 46 87 102 71 44 133 112 79 59 97 87 58 50 105 71 73 79 82 71 91 76 88 97 76 49 106 98 82 80 84 94 68 49 85 78 60 36
Question 17 to 18
The price (in lakhs) of 3 Bed room apartment in four different category of cities is presented below.
|
A |
B |
C |
D |
|
87 |
108 |
74 |
72 |
|
97 |
94 |
70 |
64 |
|
73 |
96 |
51 |
45 |
|
72 |
61 |
68 |
44 |
|
133 |
63 |
76 |
62 |
|
107 |
77 |
52 |
65 |
|
131 |
96 |
61 |
46 |
|
87 |
102 |
71 |
44 |
|
133 |
112 |
79 |
59 |
|
97 |
87 |
58 |
50 |
|
105 |
71 |
73 |
79 |
|
82 |
71 |
91 |
76 |
|
88 |
97 |
76 |
49 |
|
106 |
98 |
82 |
80 |
|
84 |
94 |
68 |
49 |
|
|
85 |
|
78 |
|
|
60 |
|
|
|
|
36 |
|
|
The four categories are A, B, C and D are decided based on urbanization and population of a city. The partial ANOVA table is given below:
|
Anova: Single Factor |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SUMMARY |
|
|
|
|
|
|
|
Groups |
Count |
Sum |
Average |
Variance |
|
|
|
A |
A1 |
1479.74 |
98.65 |
415.99 |
|
|
|
B |
A2 |
1507.36 |
83.74 |
400.03 |
|
|
|
C |
A3 |
1049.29 |
69.95 |
118.65 |
|
|
|
D |
A4 |
961.20 |
60.07 |
188.46 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
|
Between Groups |
A5 |
A8 |
4367.11 |
A11 |
0.00 |
A12 |
|
Within Groups |
A6 |
A9 |
285.21 |
|
|
|
|
|
|
|
|
|
|
|
|
Total |
A7 |
A10 |
|
|
|
|
- Find missing values ?1 to ?12?
- At the 05 level of significance, does the mean price of 3BHK varies according to the city category? (Yes/No)
Step by step
Solved in 3 steps with 3 images
