A special project from AutosRUs’ is working on a new prototype called the MechaCar. The prototype is suffering from production troubles and the manufacturing team has called on the data analytics team to review the production data for the prototype that may help the team.
- As per our Coefficients the vehicle length and ground clearance greatly affect the significance over the vehicle weight and spoiler angle in which provides a non-random amount of variance to the mpg values within our dataset.
- Within our linear model, the slope is not considered to be zero. As the p-value states a 5.35e-11 result which further concludes that the null hypothesis will be rejected moving forward given our current dataset.
- This linear model will predict that the mpg of a MechaCar prototype will be 71% accurate. The regression model has a R-value of 0.71 which strongly suggests a connection between the data’s variables of the vehicle’s length, weight, spoiler angle, ground clearance and AWD to tie-up with the MPG of the MechaCar prototype.
The design specifications for the MechaCar suspension coils dictate that the variance of the suspension coils must not exceed 100 pounds per square inch.
The design specification does meet the current manufacturing data. The variance across all three lots meet at a 62.29. However, when examining the PSI of the suspension coils in the three lots, the variance between Lot 1 & does meet the requirement of the suspension coil under 100 pounds per square inch. At this time, Lot 3 showed a variance above 100 pounds per square inch. The Lot 3 data showed a variance of 170.29 which does not meet the MechaCar specifications per the PSI.
An overview of the One Sample t-test of the suspension coils across all of the manufacturing lots returns a p-value result of .06 which concludes that we are unable to reject the null hypothesis.
The t-test for Lot 1 returned a p-value of 1, which is also above the significance level of .05 percent.
The t-test for Lot 2 returned a p-value of .60, which is also above the significance level of .05 percent.
The t-test for Lot 3 returned a p-value of .04, which is below the significance level of .05 percent leaving us to reject the null hypothesis.
Today’s consumer timely considers many factors when deciding on purchasing a vehicle. The consumer measures brand, cost, reliability, fuel efficiency, safety, horse power, as well as their own personal environment. As MechaCars hoping to achieve all above average aspects within their new prototype against their competition. The following all must considered for the consumer.
One metric to test would be the fuel efficiency compared to the competitors as many consumers wish their vehicle always take them further or as competitors are also switching to sustainable energy with electric cars.
The Null Hypothesis would be that MechaCars have no difference in price on their fuel efficiency compared to their competitors. The Alternative Hypothesis is that MechaCars have different, if not better price on their fuel efficiency compared to other competitors.
In order to test our hypothesis, we would use a One-Sample t-Test as we would like to see if there is a statistical difference between the mean of the sample and the mean of a population distribution.
To conduct this study, we will need the MechaCars fuel efficiency data as well as the mean data from its competitors.