FloorArea (Sq.Ft.)OfficesEntrancesAgeAssessedValue ($'000)479042817964720321215445940422209457204234196836603238156750004231187829902119949261021489105650424217743570214118729303215111312802131671488032421678162012357101820211767845302251585257021138424690224515391280114543341003127126835302241125136602233109411101250638267022399991100112065358104317191425602224772234031589036902215128235803227126436102181162396032171447 Suppose our final model is:AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x OfficesWhat wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?

procedure to obtain regression model using EXCEL. Go to Data > Data Analysis > Regression>…

Answered: AssessedValue

Structural Analysis

6th Edition

ISBN:9781337630931

Author:KASSIMALI, Aslam.

Publisher:KASSIMALI, Aslam.

Chapter2: Loads On Structures

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

FloorArea (Sq.Ft.)	Offices	Entrances	Age	AssessedValue ($'000)
4790	4	2	8	1796
4720	3	2	12	1544
5940	4	2	2	2094
5720	4	2	34	1968
3660	3	2	38	1567
5000	4	2	31	1878
2990	2	1	19	949
2610	2	1	48	910
5650	4	2	42	1774
3570	2	1	4	1187
2930	3	2	15	1113
1280	2	1	31	671
4880	3	2	42	1678
1620	1	2	35	710
1820	2	1	17	678
4530	2	2	5	1585
2570	2	1	13	842
4690	2	2	45	1539
1280	1	1	45	433
4100	3	1	27	1268
3530	2	2	41	1251
3660	2	2	33	1094
1110	1	2	50	638
2670	2	2	39	999
1100	1	1	20	653
5810	4	3	17	1914
2560	2	2	24	772
2340	3	1	5	890
3690	2	2	15	1282
3580	3	2	27	1264
3610	2	1	8	1162
3960	3	2	17	1447

Suppose our final model is:
AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices
What wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.

Similar questions