Question: Refer to Example. While cleaning out an old file, someone uncovers the first spacecraft manufactured by your company-30 years ago! It weighed 100 pounds and cost $600 million. Extend the spreadsheet to include this data point. How does adding this observation affect R and the standard error? How about the regression coefficients? Should this new data point be included in the model used for predicting future costs?
Example: Cost Estimating Relationship (CER) for a Spacecraft In the early stages of design, it is believed that the cost of a Martian rover 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. Use a spreadsheet model to determine the values of the coefficients for the CER.
