Scribd Logo
Upload

Welcome to Scribd!

  • 96 views

    Random Motors Project Submission: Name - Sanjana Shetty

    Uploaded by

    sanjana shetty
    The document contains questions and responses regarding analyzing the performance of two new car models, Rocinante36 and Marengo32, based on their design specifications. It involves formulating null and alternative hypotheses, performing hypothesis tests to check if specifications are being met, predicting sales using regression equations, and determining the most profitable model to invest in.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Random Motors Project Submission: Name - Sanjana Shetty

    Uploaded by

    sanjana shetty
    96 views10 pages
    The document contains questions and responses regarding analyzing the performance of two new car models, Rocinante36 and Marengo32, based on their design specifications. It involves formulating null and alternative hypotheses, performing hypothesis tests to check if specifications are being met, predicting sales using regression equations, and determining the most profitable model to invest in.

    Original Title

    Random Motors

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains questions and responses regarding analyzing the performance of two new car models, Rocinante36 and Marengo32, based on their design specifications. It involves formulating null and alternative hypotheses, performing hypothesis tests to check if specifications are being met, predicting sales using regression equations, and determining the most profitable model to invest in.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    96 views10 pages

    Random Motors Project Submission: Name - Sanjana Shetty

    Uploaded by

    sanjana shetty
    The document contains questions and responses regarding analyzing the performance of two new car models, Rocinante36 and Marengo32, based on their design specifications. It involves formulating null and alternative hypotheses, performing hypothesis tests to check if specifications are being met, predicting sales using regression equations, and determining the most profitable model to invest in.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 10

    Random Motors Project

    Submission
    Name – Sanjana Shetty
    Q-1a) Formulate the null hypotheses to check whether the new models are
    performing as per the desired design specifications.

    For Rocinante36: For Marengo32:

    Mileage HO :22km/litre. Mileage HO :15km/litre.

    Top speed HO :140km/hr. Top speed HO :210km/hr.


    Q-1b) Formulate the alternate hypotheses to check whether the new models are
    performing as per the desired design specifications.

    For Rocinante36: For Marengo32:

    Mileage H1 : Mileage less /more Mileage H1 : Mileage less /more


    than 22km/lt. than 15km/lt.
    Mean not equal 22km/lt. Mean not equal 15km/lt.

    Top speed H1 :Top speed Top speed H1 :Top speed


    less/more than 140km/hr. less/more than 210km/hr.

    Mean not equal 140km/hr. Mean not equal 210km/hr.


    Q-2) In order to comment on whether the design specifications are being
    matched or not, perform relevant hypothesis tests and calculate the p-value for
    each. What will you conclude? Assume you are performing the tests at 95%
    confidence level.
    For Rocinante36: Conclusion

    p-value for mileage =0.082 If the p-value =0


    p-value for top speed =0.082 Reject HO at confidence level less
    For Marengo32: than 95%

    (1-0.05= 0.95)
    p-value for mileage =0.082
    p-value for top speed =0.373
    Q-3) You have learnt about the possible errors that might result from the
    hypothesis tests. What type of error is more expensive for Random motors
    based on the hypothesis they are testing? Why? Assume that you need to
    refund all your customers if your cars deviate from specifications.
    The type of error which is more Reason:
    expensive:
    Type 2 error is committed when you
    fail to reject null hypothesis that is
    Type 2 error is expensive for false.
    Rocinante and Marengo
    • Effect: Not provide the promised
    specifications; the company will
    suffer negative publicity

    • Will be obliged to refund all their


    customers.
    Q-4) Develop a regression equation for each model at 95 percent confidence
    level. From the regression equation predict the sales of the two models.
    Develop the regression equation for the Develop the regression equation for the
    Rocinante models and Predict the number Marengo models and Predict the number of
    of unit sales of Rocinante36 model? unit sales of Marengo32 model?

    Regression coefficients = 50.723 Regression coefficients = - 13.447

    Price: 0.795 Price: - 0.1867

    Mileage: 8.306 Mileage: 0.0413

    Top speed: -0.0185 Top speed:0.2208


    Equation: predicted sales(Y)= 50.723 – 0.795
    7+8.306 x 22 Equation: predicted sales(Y)= -13.447- 0.1867
    Predicted Sales(in units):227,897 x 41 + 0.2208 x 210
    Predicted Sales(in units): 25,26485
    Q-5) Based on sales prediction, what is the overall predicted profit for
    Rocinante36 model and Marengo32 model ?

    Overall predicted profit

    Rocinante36 Model: Rs. 227,897

    Marengo32 Model: Rs. 202119


    Q-6) As a CEO, you wish to invest only in the model which is predicted to be
    more profitable. Which model among Rocinante36 and Marengo32 will you
    invest in?

    Which model you will invest in?

    Invest in Rocinante36 model since predicted profit of Rocinante36 is more


    than Marengo32 and will be more profitable.
    Q-7) Now you must have derived the regression equation for both models, Rocinante and
    Marengo. Now if you increase the price of Rocinante36 and Marengo32 by 1 lac rupees
    each, which car will have a higher impact on the sales due to increase in price? Give proper
    logic for your answer. You can consider that all other specifications such as mileage and top
    speed remain the same for both models.
    Which car is most affected by a price increase? Why?
    Rocinante36 Marengo32

    Previous sales 227,897 25265

    New sales 227,102 25078

    Difference in sale -795 -186


    Profit 227 x 2 =454L 25.2 x 9 =227L

    With an increase on the price Rocinante36 will have a higher impact on the sales,
    negatively effecting the sales count compared to Marengo32.
    Q-8) After developing the regression equation for both models (Rocinante and Marengo), if you
    analyse the p values for coefficients in the regression results, you will notice that some of the
    regression variables (top speed, mileage and price) are insignificant. Remove the insignificant
    regression variables from your selection and rebuild the regression model using only significant
    variables. Compare the Adjusted R square value for the new and old regression model. Do you
    notice any change in Adjusted R square value? If yes, explain the reason for the change.

    Is there a change on Adjusted R square Value? If so, Why?

    Rocinante36: Adjusted R-square value(regression model)


    Old model: 0.99535
    New model: -0.00715

    Marengo32: Adjusted R-square value(regression model)


    Old model: 0.84787
    New model:-0.03171
    Adjusted R-square value has decreased since the variable value is not
    improving the model.

    You might also like