QBA 1720 Final Exam | with complet solution 2023/24

QBA 1720 Final Exam | with complet solution 2023/24 An analyst wants to determine if there is a relationship between a car's horse power and the car's fuel efficiency (miles per gallon). - Pearson's Correlation What type of relationship did the analyst find? (Use Diagram on Website for Numbers 2-4) - Negative Relationship What is the strength of the relationship between horse power and MPG? - Strong Relationship What is the correct conclusion? - Increases in horse power is associated with decreases in MPG What is the name of the statistical analysis that the researchers conducted? (Use Data On Website for Numbers 5-11) - Multiple Linear Regression . Is the global test significant? - Yes What is the conclusion from the global test? - At least one of the X variables predict Y What X variables are significant? - Cartridge Square root of spread Std. Deviation of square root of spread Interpret the slope for square root of the spread. - Increases in the square root of the spread of pellets predicts increases in the range at which the shotgun was fired Interpret the slope for Cartridge. - Winchester cartridges is associated with a greater range in comparison to Remington Cartridges What is the regression equation? - Predicted Range = 10.56 + (-6.89 * Cartridge) + (1.30 * Square root of spread) + (9.89 * SD of SQRT of spread) What chart would you use to display the average domestic box office for the different genre of movies? (Use Data On Website for Numbers 12-14) - Bar Chart What chart would display to show the percentage of each type of MPAA rating? - Pie Chart What chart would you display to show the relationship between rotten tomatoes score and domestic box office? - Scatterplot What statistical test did the analyst conduct? Use Data On Website for Numbers 15-22) - Simple Linear Regression In this analysis, _____ is the X variable and ______ is the Y variable. - horsepower; MPG Can you use 'Horse power' to significantly predict MPG? - Yes What is the regression equation? - Predicted MPG = 49.22 + (-0.08 * Horse Power) What is the correct interpretation of R-squared? - Differences in horse power account for 58% of the variability in MPG What is the correct interpretation of the Y-intercept? - If a car has 0 horse power, the predicted MPG is 49.22 What is the correct interpretation of the standard error? - The average difference between predicted MPG and actual MPG is 4.83