You work for an organization that is concerned about automotive technologies. Your supervisor has asked that you examine and report significant conclusions for the following data set: https://lib.stat.cmu.edu/DASL/Datafiles/carmpgdat.html (the data set has also been attached as an excel document above) so that he can easily understand the state of automobiles in 1991. This will be used in comparison to similar data for more recent car models. Analyze the data set and provide important findings (e.g. mean, standard deviation, scatterplot, histogram, bar chart, etc.).
• Discuss the average size and deviation for the top 5 and bottom 5
• Average Wt and deviation for Top 5
• Average Wt and deviation for Bottom 5
• Average SP and deviation for Top 5
• Average SP and deviation for Bottom 5
• Average MPG and deviation for Top 5
• Average MPG and deviation for Bottom 5
• Average HP and deviation for Top 5
• Average HP and deviation for Bottom 5
• Average Vol and deviation for Top 5
• Average Vol and deviation for Bottom 5
• Provide overview of the automobile industry base on your finding here. Make sure you are focused on the state of the Automobile Industry.
• Use any Other information that helps you make your case on the State of the Automobile Industry in 1991.