In: Statistics and Probability

People in the aerospace industry believe the cost of a space project is a function of the weight of the major object being sent into space. You will use the following data to develop a regression model to predict the cost of a space project by the weight of the space object. Object Weight (tons) 1. 1.897, 2. 3.019, 3. 0.453 , 4. 0.988, 5. 1.058, 6. 2.100, 7. 2.387 total 11.902

Project Cost ($millions) 1. 53.6, 2. 184.9 ,3. 6.4, 4. 23.5, 5. 33.4, 6. 110.4, 7. 104.6, Totals: 516.8

a. Complete all of the blank entries in the partial Excel output below.

Regression Statistics

Multiple R

R Square

Standard Error

Observations.

ANOVA SS DF MS F

REGRESSION

RESIDUAL 446.4700921

TOTAL 23744.45429

COEFFCIENTS STANDARD ERROR T STAT

INTERCEPTS -39.00709075 18.1114242

WEIGHTS(TONS) 9.560469477 6.941370994

b.Calculate the least squares regression equation for predicting the cost of a space project as a function of the weight of the major object being sent into space.

c. Interpret the practical meaning of the slope of the least squares regression line (i.e., in the context of the problem, in plain English).

d. Identify the independent and dependent variables in this regression analysis.

e. Using a significance level of ? = .05, is there sufficient evidence to conclude that the weight of the major object being sent into space is useful in predicting the cost of a space project? Do a complete and appropriate hypothesis test.

f. What proportion of the total variability in the cost of a space project can be explained by knowing the weight of the major object being sent into space?

g. Calculate the coefficient of correlation between the independent and dependent variables. Comment on what the magnitude and direction of this correlation coefficient says about the linear relationship between the independent and dependent variable.

h. Construct an appropriate interval estimate of the mean cost of all space projects when the weight of the major object being sent into space is 1.5 tons, with 95% confidence. Interpret the practical meaning of this interval estimate, in plain English.

i. Construct an appropriate interval estimate of the cost of a single space project when the weight of the object being sent into space is 1.5 tons, with 95% confidence. Interpret the practical meaning of this interval estimate, in plain English.

j. Construct a 95% confidence interval estimate of the true population slope for this least squares regression line. Interpret the practical meaning of your interval estimate, in plain English.

k. Calculate and report the estimated variance of the random errors, ?, for this regression analysis.

l. Calculate and report the estimated standard deviation of the random errors, ?, for this regression analysis. m. Calculate and report the residual for the 2nd observation in the data set

a) i have attached an image containing all the required values and R program for calculating those values. Refer to the image for the answer of this part.

b) let weight be x and total project cost be y.Then, the least squares regression equation for predicting the cost of a space project as a function of the weight of the major object being sent into space is given by: y=a+bx

Where the coefficients a is given by a=mean of y-b*mean of x

And b=Covariance between x and y/variance of x

b=46.30846/0.814 09=56.88237

a=73.82857-(56.88237)*1.700286

=-22.8877

So, the required equation is given by :

Space project cost=-22. 8877+56.88237*weight of the object sent into space

C) slope of the regression line tells us the amount by which the response variable changes(increase or decreases) on average, when the explanatory variable changes by one.

Here, on changing the weight by one unit, the cost of space project is increasing by 56.8824 units.

D) here, cost of space project is dependent variable and weight of major objects sent into space is independent variable.

E) We know that if the p value for F test is less than significance level, tgen our sample provide sufficient evidence to conclude that our regression model fits the data better than the model with no independendent variable.

Here, we got p value as 0.0009529 which is less than significance level 0.05.hence there is evidence that weight of the major objects sent into space (which is independent variable) is useful in predicting the cost of space project.

F) We know that, COEFFICIENT of determination r^{2}
tells the measure of variability in response variable that is
explained by explanatory variable.

Here R^{2} is 0.906

So.90% of the variability in cost of space project can be explained by weight of the major objects sent into space.

G) correlation between the two variables is 0.9518

Which indicates a strong linear relationship between two i.e. With the increase in one variable, the variable will also increase.

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and se.
Weight (tons)
1.897
3.019
0.453
0.965
1.058
2.100
2.379
Cost ($ millions)
$53.6
184.9
6.4
23.5
34.2
110.4
104.6
*(Do not round the intermediate values. Round...

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and se. Weight (tons) Cost ($ millions) 1.897
$ 53.6 3.019 184.0 0.453 6.4 0.967 23.5 1.058 34.1 2.100 110.4
2.371 104.6 *(Do not round the intermediate values....

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and
se.
Weight (tons)
Cost ($ millions)
1.897
$ 53.6
3.019
184.8
0.453
6.4
0.975
23.5
1.058
32.6
2.100
110.4
2.379
104.6
*(Do not round the intermediate values....

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and
se.
Weight (tons)
Cost ($ millions)
1.897
$ 53.6
3.019
183.8
0.453
6.4
0.997
23.5
1.058
32.8
2.100
110.4
2.377
104.6
*(Do not round the intermediate values....

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and se.
Weight (tons) 1.897, 3.019, 0.453, 0.979, 1.058, 2.100, 2.408,
Cost ($ millions) 53.6, 184.7, 6.4, 23.5, 33.4, 110.4, 104.6
*(Do not round the intermediate values. Round...

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and se. Weight (tons) Cost ($ millions) 1.897
$ 53.6 3.019 184.7 0.453 6.4 0.993 23.5 1.058 33.3 2.100 110.4
2.392 104.6 *(Do not round the intermediate values....

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and
se.
Weight (tons) Cost ($ millions)
1.897 $ 53.6
3.019 $185.2
0.453 $6.4
0.960 $23.5
1.058 $33.5
2.100 $110.4
2.392 $104.6
ŷ = ________ + __________ x...

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. Determine r2 and se.
Weight (tons)
Cost ($ millions)
1.897
$ 53.6
3.019
183.9
0.453
6.4
0.996
23.5
1.058
32.9
2.100
110.4
2.380
104.6
*(Do not round the intermediate values....

people in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object. determine r^2 and se. weight= 1.897, 3.019, 0.453, 0.970,
1.058, 2.100, 2.389. cost = 53.6, 183.9, 6.4, 23.5, 33.4, 110.4,
104.6. y= + x r^2= se=

People in the aerospace industry believe the cost of a space
project is a function of the mass of the major object being sent
into space. Use the following data to develop a regression model to
predict the cost of a space project by the mass of the space
object.
Determine r2 and se. Weight (tons) Cost ($ millions)
1.897 $ 53.6
3.019 $184.1
0.453 $6.4
0.996 $23.5
1.058 $33.7
2.100 $110.4
2.400 $104.6 *(Do not round the intermediate values....

ADVERTISEMENT

ADVERTISEMENT

Latest Questions

- This class should include .cpp file, .h file and driver.cpp (using the language c++)! Overview of...
- Problem 15-1 On January 5, 2017, Crane Corporation received a charter granting the right to issue...
- Consider the combustion reaction of hydrocarbon. CH + O2 -----> CO2 + H20 a. Write out...
- Que 1: a. Describe four different materials used for curing. b. Explain how ponding curing...
- Calculate the atomic percent of tungsten in an alloy prepared with 56 grams of tungsten and...
- 1. Calculate [H3O+] in the following aqueous solution at 25 C: [OH−]=1.1×10−9 M. 2. Calculate [H3O+]...
- In what ways can economic incentives and cost/benefit analysis be used to strengthen existing policies? What...

ADVERTISEMENT