Question

In: Statistics and Probability

Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...

Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$)
1 1852 81478 410 1467000000
1 1608 64313 411 1150000000
1 1430 55783 403 1028000000
1 1562 57794 390 1100000000
1 1109 37695 391 728000000
1 905 28048 382 558000000
1 1852 81478 410 1467000000
1 901 30617 391 631000000
1 1727 69062 400 1223000000
1 1161 37148 394 761000000
1 1004 37141 400 713000000
1 1216 38912 390 784000000
1 2007 88302 422 1593000000
1 2983 173000 440 2649000000
2 1523 70080 372 1210000000
2 912 28286 370 607000000
2 1343 53715 382 977000000
2 1175 32908 381 700000000
2 1203 40902 393 811000000
2 1393 52951 392 1001000000
2 713 20681 375 468000000
2 1047 37681 411 747000000
2 1506 63270 421 1156000000
2 1642 70624 423 1268000000
2 1848 73936 403 1333000000
2 1627 60190 402 1162000000
2 1301 40321 384 864000000
2 905 25330 405 561000000
2 1727 72514 400 1303000000
2 1414 52318 392 1013000000
2 2001 76022 431 1487000000
2 400 9200 380 263000000
2 3100 102190 454 2112000000
2 1677 83860 410 1519000000
2 2415 130032 420 2045000000
2 1555 46637 410 1025000000
2 792 20596 420 540000000
Building Type
1 Reinforced Concrete
2 Steel

1) Run a regression model to estimate the cost of a building using average story height (mean centered) and total floor area (mean centered) as predictors. Using the adjusted R Square statistic, how much variation in the dependent variable can be explained by the model? Select one:

a. between 95% and 98%

b. above 98 percent

c. between 90% and 95%

d. less than 90%

2) Run a regression model to estimate the cost of a building using average story height (mean centered) and total floor area (mean centered) as predictors. Is story height a significant predictor at .05 level? Select one:

a. Yes

b. No

3) Run a regression model to estimate the cost of a building using average story height (mean centered) and total floor area (mean centered) as predictors. Is total area a significant predictor at .05 level? Select one:

a. Yes

b. No

4) Run a regression model to estimate the cost of a building using average story height (mean centered) and total floor area (mean centered) as predictors. Which of the following is wrong about the slope of total area? Select one:

a. It gives the expected change in the predicted cost for each 1 m2 change in total area, holding story height constant.

b. It is a significant slope

c. The expected cost of a building with a total area of 1 m2 is HK$13,965

5) Run a regression model to estimate the cost of a building using average story height (mean centered) and total floor area (mean centered) as predictors. Which of the following is wrong about the slope of story height? Select one:

a. It gives the expected change in the predicted cost for each 1 cm change in story height, holding total area constant.

b. It is a significant slope

c. The expected cost of a building with a story height of 0 cms is HK$3,185,038

6) Run a regression model to estimate the cost of a building using average story height (mean centered), total floor area (mean centered), and construction type (dummy coded) as predictors. Using the adjusted R Square statistic, how much variation in the dependent variable can be explained by the model? Select one:

a. between 95% and 98%

b. above 98 percent

c. between 90% and 95%

d. less than 90%

7) Run a regression model to estimate the cost of a building using average story height (mean centered), total floor area (mean centered), and construction type (dummy coded) as predictors. Which of the following is correct about the intercept? Select one:

a. It is the expected cost of a steel building with an average story height and an average total area.

b. It is the expected cost of a reinforced concrete building with an average story height and an average total area.

c. It is the expected cost of a steel building with a story height of 0 cm and an average total area.

d. It is the expected cost of a reinforced concrete building with an average story height and a total area of 0 m2.

8) Run a regression model to estimate the cost of a building using average story height (mean centered), total floor area (mean centered), and construction type (dummy coded) as predictors. According to the model, is it significantly more expensive (at .05 level) to build a steel building compared to a reinforced concrete building, holding everything else constant? Select one:

a. no

b. yes

9) Run a regression model to estimate the cost of a building using average story height (mean centered), total floor area (mean centered), and construction type (dummy coded) as predictors. Which of the following is wrong about the slope of story height? Select one:

a. it is the expected change in the predicted building cost for a one unit change in story height, holding total area and construction type constant.

b. Has a positive relationship with the cost of building

c. Has a negative relationship with the cost of building

10) Run a regression model to estimate the cost of a building using average story height (mean centered), total floor area (mean centered), and construction type (dummy coded) as predictors. Which of the following is wrong about the slope of total area? Select one:

a. it is the expected change in the predicted building cost for a one unit change in total area, in holding story height and construction type constant.

b. Has a positive relationship with the cost of building

c. Has a negative relationship with the cost of building Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1

Solutions

Expert Solution

1)Option A (Adjusted R-squared: 0.9786)

R Code:

reg<-lm(dat$`COST (HK$)`~dat$`avg story height(cms)`+dat$`Total floor area (m2)`)

summary(reg)

Output:

Coefficients:

Estimate Std. Error t value Pr(>|t|)   

(Intercept) -1.007e+09 3.234e+08 -3.115 0.003724 **

dat$`avg story height(cms)` 3.185e+06 8.511e+05 3.742 0.000674 ***

dat$`Total floor area (m2)` 1.397e+04 5.043e+02 27.694 < 2e-16 ***

Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 72020000 on 34 degrees of freedom

Multiple R-squared: 0.9798, Adjusted R-squared: 0.9786

F-statistic: 824.8 on 2 and 34 DF, p-value: < 2.2e-16

2)Yes,avg story height is a significant predictor at level 0.05 since pvalue=0.003724 < 0.05

3)Yes,Total floor area is a significant predictor at level 0.05 since pvalue< 2e-16 < 0.05.

4)c)The expected cost of a building with a total area of 1 m2 is HK$13,965

5)c). The expected cost of a building with a story height of 0 cms is HK$3,185,038

6)Option A (Adjusted R-squared: 0.9792)

R Code:

reg<-lm(dat$`COST (HK$)`~dat$`avg story height(cms)`+dat$`Total floor area (m2)`+dat$`Building type`)

summary(reg)

Output:

Coefficients:

Estimate Std. Error t value Pr(>|t|)   

(Intercept) -1.034e+09 3.197e+08 -3.234 0.00277 **

dat$`avg story height(cms)` 3.101e+06 8.420e+05 3.683 0.00082 ***

dat$`Total floor area (m2)` 1.406e+04 5.025e+02 27.987 < 2e-16 ***

dat$`Building type` 3.375e+07 2.434e+07 1.387 0.17480   

Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 71060000 on 33 degrees of freedom

Multiple R-squared: 0.9809, Adjusted R-squared: 0.9792

F-statistic: 565.5 on 3 and 33 DF, p-value: < 2.2e-16

7)d.) It is the expected cost of a reinforced concrete building with an average story height and a total area of 0 m2.

8)No it is not significantly more expensive since p value=0.17480>0.05.

9)c.) Has a negative relationship with the cost of building

10)c.) Has a negative relationship with the cost of building


Related Solutions

Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1 1852 81478 410 1467000000 1 1608 64313 411 1150000000 1 1430 55783 403 1028000000 1 1562 57794 390 1100000000 1 1109 37695 391 728000000 1 905 28048 382 558000000 1 1852 81478 410 1467000000 1 901 30617 391 631000000 1 1727 69062 400 1223000000 1 1161 37148 394 761000000 1 1004 37141 400 713000000 1 1216 38912 390 784000000 1 2007 88302 422 1593000000...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1 1852 81478 410 1467000000 1 1608 64313 411 1150000000 1 1430 55783 403 1028000000 1 1562 57794 390 1100000000 1 1109 37695 391 728000000 1 905 28048 382 558000000 1 1852 81478 410 1467000000 1 901 30617 391 631000000 1 1727 69062 400 1223000000 1 1161 37148 394 761000000 1 1004 37141 400 713000000 1 1216 38912 390 784000000 1 2007 88302 422 1593000000...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1 1852 81478 410 1467000000 1 1608 64313 411 1150000000 1 1430 55783 403 1028000000 1 1562 57794 390 1100000000 1 1109 37695 391 728000000 1 905 28048 382 558000000 1 1852 81478 410 1467000000 1 901 30617 391 631000000 1 1727 69062 400 1223000000 1 1161 37148 394 761000000 1 1004 37141 400 713000000 1 1216 38912 390 784000000 1 2007 88302 422 1593000000...
Assume the following for a floor in a multistory office building: total usable area: 33,000 sq...
Assume the following for a floor in a multistory office building: total usable area: 33,000 sq ft; Total common area: 5,000 sq ft; total rentable area: 38,000 sq ft; Tenant A’s usable area: 5,500 sq ft. Tenant A’s annual rental rate is $25 per sq ft. How much total rent does Tenant A pay per year? Can you teach me how to do this in excel?
Question 1 Run a regression model to estimate the cost of a building using average story...
Question 1 Run a regression model to estimate the cost of a building using average story height (mean centered) and total floor area (mean centered) as predictors. Using the adjusted R Square statistic, how much variation in the dependent variable can be explained by the model? Select one: a. between 95% and 98% b. above 98 percent c. between 90% and 95% d. less than 90% Question 2 Run a regression model to estimate the cost of a building using...
1) Run a regression model to estimate the cost of a building using average storey height...
1) Run a regression model to estimate the cost of a building using average storey height (mean centered) and total floor area (mean centered) 2) Run a regression model to estimate the cost of a building using average storey height (mean centered), total floor area (mean centered), and the type of construction (dummy coded with reinforced concrete as the control group) Interpret the slopes, intercepts, and regression statistics in the models Building type Average floor area (m2) Total floor area...
Building Type   Land Area in Acres   Living Area   Total Assessed Land Value   Total Assessed Parcel Value...
Building Type   Land Area in Acres   Living Area   Total Assessed Land Value   Total Assessed Parcel Value Commercial   0.20860882 318 625900 730700 Commercial   0.21751607 3630 423700 741100 Commercial   5.5474977 59506 10253200 13547100 Commercial   0.18682277 3780    293300 460200 Commercial   0.55227273 22017 681300 1214000 Condominium   0 1776 0 579500 Condominium   0   1270 0 512100 Condominium   0 2076 0 578900 Condominium   0 1132 0 281800 Condominium   0 957 0 266800 Condominium   0 1128 0 481100 Condominium   0 1235 0 470400 Condominium   0 1264...
1) What is the fixed cost, marginal cost, average total cost, average variable cost and average...
1) What is the fixed cost, marginal cost, average total cost, average variable cost and average fixed cost of the following cost function?    . 2) What is the level of output that minimizes AVC? (in other words, what is the level of output that corresponds to the minimum of AVC?)
Question 1 Output total cost marginal cost fixed cost average cost Total revenue average revenue Marginal...
Question 1 Output total cost marginal cost fixed cost average cost Total revenue average revenue Marginal revenue 0 10 0 1 16 20 2 26 40 3 40 60 4 60 80 5 88 100 6 120 120 A) Complete the missing data on the table B) What is the selling price of a laptop case explain your answer c) What is the profit maximizing level of output for this firm explain your answer d) create a graph using three...
1. The long run average total cost shows what happens to average (per unit) total cost...
1. The long run average total cost shows what happens to average (per unit) total cost as a firm grows in size (adds more capital or increases its plant size). True or false? 2. In the short run, at least one input is variable and one input is fixed. True or false? 3. If marginal product is less than average product, average product must be falling. True or false? 4. In the long run, all inputs are variable. True or...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT