Fuel cell capacity (kW) Cost (R'000) 11 1155 14 1414 36 3492 180 16020 225 18900 You are employed by a company that converts underground diesel locomotives to fuel cell driven locomotives. During During such a conversion, the diesel engine is replaced by a fuel cell, an electrochemical engine, and associated control and fuel system. A number of conversions had been done over time for different size locomotives required by different clients. A potential client wants a few 76-KW diesel locomotives to be converted to fuel cell driven ones. One hour before your manager has to attend a meeting with the client, he asks you to provide a ball-park estimate of the cost of converting You noticed from historic cost data obtained from a cost accountant that there is a relationship between conversion cost and locomotive capacity, measured in kW engine size. This is shown by the following scatter plot you did. Cost of converting an underground diesel locomotive to a fuel cell driven one 1000 Use the data in the attached spreadsheet (CER_FCLoco_Q.xls) to determine the relationship between the conversion cost and capacity of a locomotive, by means of the regression function. From that information estimate the cost of converting one 76-kW locomotive. Fuel cell capacity (kW) Cost (R'000) 11 1155 14 1414 36 3492 180 16020 225 18900 You are employed by a company that converts underground diesel locomotives to fuel cell driven locomotives. During During such a conversion, the diesel engine is replaced by a fuel cell, an electrochemical engine, and associated control and fuel system. A number of conversions had been done over time for different size locomotives required by different clients. A potential client wants a few 76-KW diesel locomotives to be converted to fuel cell driven ones. One hour before your manager has to attend a meeting with the client, he asks you to provide a ball-park estimate of the cost of converting You noticed from historic cost data obtained from a cost accountant that there is a relationship between conversion cost and locomotive capacity, measured in kW engine size. This is shown by the following scatter plot you did. Cost of converting an underground diesel locomotive to a fuel cell driven one 1000 Use the data in the attached spreadsheet (CER_FCLoco_Q.xls) to determine the relationship between the conversion cost and capacity of a locomotive, by means of the regression function. From that information estimate the cost of converting one 76-kW locomotive