MGMT2263 Tutorial Sheet #6
1) A real estate agent wanted to see how much a home
selling price (in thousands of dollars) depends on house size (in thousands of
square feet), number of bedrooms and whether it has an attached garage or not
(attached = 1). A sample of 8 homes produced the following results:
|
Home size |
Bedroom |
Garage |
Price |
|
1.36 |
2 |
1 |
2.49 |
|
1.6 |
3 |
1 |
3.02 |
|
1.88 |
3 |
0 |
3.65 |
|
1.38 |
2 |
0 |
2.34 |
|
1.02 |
2 |
1 |
2.16 |
|
1.33 |
2 |
0 |
2.94 |
|
2.04 |
4 |
1 |
3.75 |
|
1.56 |
3 |
1 |
2.84 |
Using the criteria of adjusted r2, ANOVA p-value, t-test p-values (compared to 5%) and presence of multicollinearity, which one of the following models is the best? Fill in the following table and state why you chose the model you did based on these four criteria. (see key for solution)
|
Variables |
Adj.
R2 |
ANOVA
p-value |
t-test:
are all variables significant? (yes or no) |
Any
multicollinearity? (yes or no) |
|
All
variables |
|
|
|
|
|
Home
size, garage |
|
|
|
|
|
Home
size |
|
|
|
|
2)
A deli with 3 checkout
counters took 100 sales from each counter and classified them as shown in the
following crosstab:
|
|
Counter A |
Counter B |
Counter C |
Total |
|
Under $30 |
48 |
35 |
27 |
110 |
|
$30 to
under $40 |
34 |
38 |
35 |
107 |
|
$40 and
over |
18 |
27 |
38 |
83 |
|
Total |
100 |
100 |
100 |
300 |
Based
on organizing the data this way, do the sales depend on the counter? Test at
5%. To what degree does the amount of the sale depend on the counter?
(chi-square = 13.623; conclude the sales depend on the counter; 15.07%)