Details of this Paper

Parametric Estimating Homework Assignment

Description

solution


Question

A contracting firm collected data on its previously completed commercial facility construction projects. The data is provided in the embedded Excel worksheet below, with the following;column titles (double-click to access the worksheet);? Cost: Actual direct cost in $100,000;? SqFt: Square footage of the facility in 1,000 square feet;? LinFtInt: Linear footage of interior walls in 100 linear feet;? SqFtExt: Square footage of exterior walls in 1,000 square feet;Obtaining Credit for this Assignment;1. Generate three parametric models using simple linear regression for estimating the direct cost of commercial facility construction projects performed by this firm based on;a. Model 1: Square footage of the facility;b. Model 2: Linear footage of interior walls;c. Model 3: Square footage of exterior walls;2. Generate the parametric model (Model 4) using multiple linear regression for estimating the cost of commercial facility construction projects performed by this firm using all three;parameters given above. Provide plots and explain in Question #4 below what they show.;3. Using these four models, estimate the cost of the following two potential projects;a. SqFt = 30;LinFtInt = 5;SqFtExt = 14;b. SqFt = 45;LinFtInt = 12;SqFtExt = 25;4. Comment briefly on the eight estimates and the four models used to generate them. Be sure to indicate all potential weaknesses in both the estimates and the underlying models. (In other words, are they valid?);5. Specify the best parametric model for estimating the direct cost of commercial facility construction projects performed by this firm. You may select one of the above models or propose a new model, but be sure that your proposal is clearly explained and well-defended,including arguments for why your chosen model?s weaknesses are not fatal to your recommendation. Among other items, please defend why your model is valid.;Parametric Estimating HW2 Assignment;Page 2 of 2 PROJ 522;Cost SqFt LinFtInt SqFtExt;2.92 31.00 10.50 11.00;2.22 21.50 8.00 10.00;2.09 21.00 9.00 5.00;2.57 26.00 7.50 6.50;2.64 21.00 13.00 10.00;2.88 30.00 9.00 12.50;2.73 25.00 12.00 9.00;2.36 22.00 9.00 7.00;2.56 28.00 8.00 5.00;3.02 32.00 15.00 12.50;2.23 21.00 12.00 9.00;2.48 21.00 13.00 11.00;2.04 24.00 7.00 5.00;2.52 26.00 9.00 8.00;2.43 25.00 12.00 11.00;2.35 26.00 9.00 6.00;2.54 27.00 10.00 8.00;2.28 20.00 12.00 6.00;2.16 20.00 13.00 9.00;2.75 24.00 12.00 12.00;2.28 20.00 11.00 11.00;2.65 28.00 11.50 8.00;2.54 24.00 11.00 7.00;2.32 20.00 13.00 6.00;2.57 24.00 13.00 11.00;2.28 25.00 8.00 7.00;2.34 25.00 9.00 7.00;2.19 17.00 13.00 7.00;2.15 17.00 12.50 9.00;2.35 24.00 11.00 9.00

 

Paper#32804 | Written in 18-Jul-2015

Price : $27
SiteLock