Question

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² and s_e.

Weight (tons)	Cost ($ millions)
1.897	$ 53.6
3.019	183.7
0.453	6.4
0.963	23.5
1.058	34.1
2.100	110.4
2.405	104.6

*(Do not round the intermediate values. Round your answers to 4 decimal places.)
**(Round the intermediate values to 4 decimal places. Round your answer to 3 decimal places.)


ŷ = enter a number rounded to 4 decimal places  * + enter a number rounded to 4 decimal places * x
r² = enter a number rounded to 3 decimal places  **
s_e = enter a number rounded to 3 decimal places  **

Answer 1

Please don't hesitate to give a "thumbs up" for the answer in case the answer has helped you

Answer in yellow below . I have conducted the linear regression exercise below in Excel.