People in the aerospace industry believe the cost of a space project is a functi

Question

People in the aerospace industry believe the cost of a space project is a function of the weight of the major object being sentinto 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.897 3.019 0.453 0.988 1.058 2.100 2.387 Project Cost (Smillions) 53.6 84.9 6.4 23.5 33.4 110.4 04.6 516.8 5 Totals:11.902 a. Complete all of the blank entries in the partial Excel output below SUMMARY OUTPUT Note: You should be able to manually complete virtually every entry in this Exce output. You will not be provided with complete data on the exam, so you will need to know how to obtain all of the entries in this output by using your formula sheet and the information Regression Statistics Multiple R R Square Standard Error Observations ANOVA df MS Regression Residual Total 446.4700921 23744 45429 Standard Error f Stat Coefficients -39.00709075 18.1114242 Intercept 9.560469477 6.941370994 Woight (tons)

Explanation / Answer

solutionA:

go to

data >data analysis>Regression in excel

SolutionE:

F=48.1826

p=0.0009

p<0.05

Rejevct Ho

model is significant can be used for prediction

There is suffcient evidence to conclude that weight of the major object being sent into space is useful in predicting the cost of a space project.

Solutionf/;

90.6% variatiion in y is explianed by x.

SUMMARY OUTPUT Regression Statistics Multiple R 0.951832 R Square 0.905984 Adjusted R Square 0.887181 Standard Error 21.12984 Observations 7 ANOVA df SS MS F Significance F Regression 1 21512.1 21512.1 48.18263 0.000953 Residual 5 2232.35 446.4701 Total 6 23744.45 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -39.0071 18.11142 -2.15373 0.083849 -85.564 7.549807 Object Weight 66.36277 9.560469 6.941371 0.000953 41.7868 90.93873

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.