Question

In: Statistics and Probability

A regression analysis can be used to derive a relationship for input to another CER. Derive...

A regression analysis can be used to derive a relationship for input to another CER. Derive a relationship for converting size units, plug in a value and use its output for the size input in a CER for systems engineering effort.

You are tasked to perform an early systems engineering cost estimate during the conceptual stage of a project. The only measure of size available from the architects is an estimated 22 capabilities, but your CER is based on more detailed measurements for system requirements.

Derive a relationship that converts capabilities to system requirements using linear regression with the data below from past projects. System requirements is the dependent variable and capabilities is the independent variable in the regression. What is your assessment of the strength of the regression relationship?

Project

# Capabilities

# System Requirements

1

14

129

2

25

277

3

9

122

4

21

248

5

9

35

6

18

240

7

19

262

8

26

259

9

3

36

10

15

147

11

8

119

12

16

141

13

7

108

14

14

157

15

12

70

16

1

10

17

3

67

18

17

244

19

22

196

20

15

186

  1. What is the estimated number of System Requirements for 22 Capabilities using your model?
  2. Also approximate the 95% confidence interval for the number of requirements using the regression standard error.
  3. Then use the CER below to derive an estimate of systems engineering effort for 22 capabilities using the requirements point estimate.

Effort (Person-Months) = .25 * System Requirements1.06

Solutions

Expert Solution

Solution

Final answers are given below. Back-up Theory and Details of calculations follow at the end.

Let x = capability and y = system requirement.

Part (a)

Estimated regression equation is: System Requirements = 8.51 + 10.52Capabilities

Estimated number of System Requirements for 22 Capabilities = 239.98 Answer 1

Part (b)

95% confidence interval for the number of requirements (for 22 Capabilities)

= [212.92, 267.03] Answer 2

Part (c)

Systems engineering effort for 22 capabilities = 0.25 x 239.98 = 59.995 Answer 3

Back-up Theory and Details of calculations

Back-up Theory

The linear regression model: Y = β0 + β1X + ε, ……………………..............................................................…………………..(1)

where ε is the error term, which is assumed to be Normally distributed with mean 0 and variance σ2.

Estimated Regression of Y on X is given by: Yhat = β0hat + β1hatX, ………….........................................................………….(2)

β1cap = Sxy/Sxx and β0cap = Ybar – β1cap.Xbar.............………………..........................................................…………….…..(3)

Estimate of σ2 is given by s2 = (Syy – β1cap2Sxx)/(n - 2)…………………………………...................................................…..(4)

100(1 - α)% Confidence Interval (CI) for ycap at x = x0 is: (ycap at x = x0) ± tn – 2, α/2xs[(1/n) + {(x0 – Xbar)2/Sxx}] ........... (5)

where

[Mean X = Xbar = (1/n) Σ(i = 1 to n)xi ; Mean Y = Ybar = (1/n) Σ(i = 1 to n)yi Sxx = Σ(i = 1 to n)(xi – Xbar)2

Syy = Σ(i = 1 to n)(yi – Ybar)2 ; Sxy = Σ(i = 1 to n){(xi – Xbar)(yi – Ybar)} ] .......................................................................... (6)

Details of calculations

n

20

Xbar

14

ybar

153

Sxx

982.2

Syy

133564.55

Sxy

10333.9

β1cap

10.5212

β0cap

8.5099

s^2

1379.9866

s

37.1482

α

0.05

n-2

18

tn-2,α/2

2.1009

x0

22

ycap at x0

239.9758

CIYcapLB

212.9245

CIYcapUB

267.0271

DONE


Related Solutions

how can regression analysis be used to determine causality?
how can regression analysis be used to determine causality?
Regression analysis is often used to provide a means to express the relationship between one or...
Regression analysis is often used to provide a means to express the relationship between one or more input variables and a result. It is easy to plot in Excel (“add trendline”) so is found frequently in business presentations. Your company has made a model with 10 different factors measured from past years’ and states based upon the model, the company expects to make a 23 million dollar profit next year. Discuss possible concerns with banking on the 23 million dollar...
Regression analysis is often used to provide a means to express the relationship between one or...
Regression analysis is often used to provide a means to express the relationship between one or more input variables and a result. It is easy to plot in Excel (“add trendline”) so is found frequently in business presentations. Your company has made a model with 10 different factors measured from past years’ and states based upon the model, the company expects to make a 23 million dollar profit next year. Discuss possible concerns with banking on the 23 million dollar...
Multiple regression analysis was used to study the relationship between a dependent variable, y, and four...
Multiple regression analysis was used to study the relationship between a dependent variable, y, and four independent variables; x1, x2, x3, and x4. The following is a partial result of the regression analysis involving 31 observations. Coefficients Standard Error Intercept 18.00 6.00 x1 12.00 8.00 x2 24.00 48.00 x3 -36.00 36.00 x4 16.00 2.00 ANOVA df SS MS F Regression 125 Error Total 760 a) Compute the multiple coefficient of determination. b) Perform a t test and determine whether or...
A regression line describes the relationship between the dependent and independent variables and can be used...
A regression line describes the relationship between the dependent and independent variables and can be used to estimate specific points for x or y, provided an individual is supplied with the values of all the other variables but one. true or false
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales prices and the various characteristics of apartments and buildings. The variables collected from a random sample of 25 compartments are as follows: Sale price: The sale price of the apartment (in €) Apartments: Number of apartments in the building Age: Age of the building (in years) Size: Apartment size (area in square meters) Parking spaces: Number of car parking spaces in the building Excellent...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales prices and the various characteristics of apartments and buildings. The variables collected from a random sample of 25 compartments are as follows: Sale price: The sale price of the apartment (in €) Apartments: Number of apartments in the building Age: Age of the building (in years) Size: Apartment size (area in square meters) Parking spaces: Number of car parking spaces in the building Excellent...
Derive the ordinary least squares estimator in case of multiple regression analysis
Derive the ordinary least squares estimator in case of multiple regression analysis
Multiple Regression Analysis was used to find out which X variable have relationship with my Y...
Multiple Regression Analysis was used to find out which X variable have relationship with my Y variable (reduce overspending on food and beverage), and how strong relationship is.FIT A FIRST ORDER AUTO AGGRESSIVE MODEL (AR(1) USING Y(T) AS THE RESPONSE VARIABLE Y (T-1) AS THE INPUT VARIABLE. RECORD THE REGRESSION EQUATION. CALCULATE THE EXPONENTIAL SMOOTHING MODELS AND CALCULATE A MOVING AVERAGE MODEL. 4-Mar $31.69 5-Mar $4.19 5-Mar $19.01 5-Mar $7.99 6-Mar $3.32 6-Mar $57.11 7-Mar $4.07 8-Mar $2.49 8-Mar $6.30...
Questions about relationship* 1. Explain the relationship between correlation analysis dan regression analysis( * is relationsip,...
Questions about relationship* 1. Explain the relationship between correlation analysis dan regression analysis( * is relationsip, not difference ) 2. Explain the relationship between correlation covariance 3. Explain the relationship on this three analysis
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT