- In the early stages of design, it is believed that the cost of a newly designed spacecraft is related to its weight. Cost and weight data for six spacecraft have been collected and normalized and are shown in the next table. A plot of the data suggests a linear relationship. a) Use a spreadsheet model plot the relation b) Determine the values of the coefficients for the CER. (The regression formula) c) Determine the SE and the correlation coefficient for the CER developed. Spacecraft Weight (lb) Cost ($ million) i xi yi 1 400 278 2 530 414 3 750 557 4 900 689 5 1,130 740 6 1,200 851