Please solve out these

QUESTION 1 (60 points) Acme Motorcycle Co has determined that the engine size (in cc) is the key cost driver for estimating the cost of a new model of a motorcycle. They plan to introduce two new motorcycles, Cadet XL with engine size 750 cc, and Megal800 with engine size 1800 cc Acme's historic cost model is as shown below: Engine 50 250 500 1000 1250 1500 Cost $800 $3,600 $4,900 $6,250 $6,700 $7.000 Use Excel to develop a CER model to determine the most reliable model for estimating the cost of a new motorcycle (using Trendline and R). Then, predict the cost of Cadet XL and Megal800 motorcycles a Develop then cut and paste the Excel model and chart below. b) Display the equation of the model and R on the chart. c) State the type of the model/trendline and its parameters, d) State the cost of Cadet XL and Megal800. e) Provide a rationalization for the optimal cost estimation model