6/11/24, 8:57 PM upGrad | Learning Platform
Post Graduate 5
Program in Learn Live Discussions SS
General
Management -
Mar 24
Navigate Q&A
Project Questions
You can find the data for your assignment in the Exhibit files provided in the previous
segments. Go through the data in the Exhibit files and answer the questions. You must enter
your response in the Random Motors Project Submission File provided below.
Note: You need to convert the presentation into a PDF file before submission.
Submission requirements:
1. You need to submit the following two Excel files:
1. The first Excel file should contain all the calculations and analyses that you will be
doing for the hypothesis testing for both the models. Create separate sheets
within this Excel file for both the models.
2. The second Excel file should contain the regression analysis for both the car
models. Create separate sheets within this Excel file for both the models.
2. You need to submit the slide deck presentation that is to be presented to the CEO of
your company. Use the slide deck format provided below. Note: You need to convert
the presentation into a PDF file before submission.
3. You need to upload the three files (2 Excel files and One Presentation saved as PDF) in
a single ZIP file. The ZIP file should be named as "Your Name_RandomMotors"
https://learn.upgrad.com/course/5966/segment/51002/301278/915099/4578897 1/4
6/11/24, 8:57 PM upGrad | Learning Platform
Post Graduate 5
Program Presentation
in Format
Learn Live Discussions Download SS
General
Management -
Mar 24
In your presentation, you need to answer the following questions.
Q-1) Formulate the null and alternative hypotheses for mileage and top speed to check
whether the new models are performing as per the desired design specifications. (4 marks)
Q-2) In order to comment on whether or not the design specifications are being matched,
perform relevant hypothesis tests and calculate the p-values for each model. What will you
conclude? Assume that you are performing the tests at a 95% confidence level. (8 marks)
Q-3) You have already learnt about the possible errors that might result from hypothesis
tests. Which type of error is more expensive for Random Motors, and why? Assume that you
need to refund the money to all your customers if your cars do not deliver the promised
specifications. (12 marks)
Q-4) Develop a regression equation for each car brand at a 95% confidence level. Using the
regression equation, predict the sales of the two new car models (Riocante36 and
Marengo32). State the hypothesis assumption for the overall test and individual variables.
(22 marks)
Q-5) Based on the sales prediction, calculate the overall projected profit for the Rocinante36
and Marengo32 models, respectively? (12 marks)
Formula for overall profit for a car model = (price * number of car units sold) - (cost incurred for
producing car * number of car units sold)
https://learn.upgrad.com/course/5966/segment/51002/301278/915099/4578897 2/4
6/11/24, 8:57 PM upGrad | Learning Platform
Q-6)
PostYour company wishes to invest only in the model that can generate high overall profits.
Graduate 5
Program in Learn Live Discussions SS
General
In Management
which of the -
two models, Rocinante36 and Marengo32, should your company invest? (4
Mar 24
marks)
Q-7) You must have developed the regression equation for both the models, Rocinante36
and Marengo32. Suppose you increase the price of Rocinante36 and Marengo32 by ₹1 lakh
each. Which of the two models will have to see a higher impact on sales numbers? Provide
proper logic for your answer. (4 marks)
Note: You can assume that all the other specifications, such as mileage and top speed, are the same
for both models.
Q-8) After developing the regression equation for both the models (Rocinante36 and
Marengo32), if you analyse the p-values for the coefficients in the regression results, you will
notice that some of the regression variables (top speed, mileage and price) are insignificant.
Drop the insignificant regression variables and rebuild the regression model using only
significant variables. Compare the adjusted R-squared value for both the new and the old
regression models. Do you notice any change in the adjusted R-squared value? If yes, explain
the reason for the change. ( 4 marks)
Random Motors Solution
Submission details
Module Deadline
https://learn.upgrad.com/course/5966/segment/51002/301278/915099/4578897 3/4
6/11/24, 8:57 PM upGrad | Learning Platform
Please upload the three files (2 12 Jun '24
Excel files and One Presentation
Post Graduate
saved
Program in as PDF) in a single ZIP file. Live
Learn
11:59 PM (IST)
Discussions
5
SS
General
The ZIP file should be named as
Management -
Mar"Your
24 Name_RandomMotors" Request Extension
8 out of 8 extensions requests
We strongly recommend you to are available.
submit atleast 30 minutes before your
deadline
Upload your file & Save as draft
Upload
Note: If extension isn’t requested before 12 Jun '24, 11:59 PM (IST), submissions
made after 12 Jun '24, 11:59 PM (IST) will incur a penalty as follows: Submitted
between 12 Jun '24, 11:59 PM (IST) - 19 Jun '24, 11:59 PM (IST): 30% penalty,
Submitted after 19 Jun '24, 11:59 PM (IST): 100%.
Report an error
NEXT
PREVIOUS
Peer-Reviewed
Creating the action plan
Publication - I
https://learn.upgrad.com/course/5966/segment/51002/301278/915099/4578897 4/4
