Q: Kindly read the below comprehension and perform hypothesis testing on an Excel File to verify the claims that the engineering team has made about the specifications (mileage and top speed) of the Rocinante36 and Marengo32 models.

Pls Note : The Excel file should contain all the calculations and analyses that you will be doing for the hypothesis testing for both the models. Kindly create separate sheets within the same Excel file for both the models.

Comprehension:

Imagine you are the Lead Business Analyst atRandom Motors, an automobile conglomerate that manufactures cars across a large range of price points. Given the scale of your firm, you have different brands for different consumer segments. For the price-conscious working-class consumers, Random Motors manufactures cars under the brandRocinante.The various models of Rocinante fall in the range of?5-10 lakh.The brand is known for cars that arevalue for money and very attractive mileage. For the consumers willing to purchase a luxury car, Random Motors operates under the brandMarengo.Marengo models fall in the range of?30-60 lakh.They are considered sports cars and havehigh horsepower and top speed.

Every time Random Motors launches a new model, it advertises the model's specifications, such as price, mileage, and top speed, because consumers usually take these factors into account before purchasing cars.

Suppose your chief engineer has recently come up with two new models:Rocinante36 and Marengo32.He promises that they will outperform the existing competitors in the market. Rocinante36is priced at?7 lakhand has been designed to deliver a mileage of22 km/litreand a top speed of140 km/hr. Marengo32is priced at?41 lakhand has been designed to deliver a mileage of15 km/litreand a top speed of210 km/hr.

The chief engineer has built 20 prototypes of each of the two models to check if the cars are performing as per the desired specifications. If the cars are performing better than expected, then the engineer wants to revise the specifications. However, if they are performing worse than expected, then it is an indication that more investment is needed in the design to improve their performance. The test drive results for the 20 prototypes of each of the two models are provided in the file titledData Exhibit 1.During the test, the mileage and the top speed is recorded for each of the prototypes. The data will be used for performing hypothesis testing for the claims made on the specifications.

\f\f\f\f