Statistical Analysis for an Automobile Research Firm
Your organization, a consumer automobile research firm, wishes to analyze data from a study of fuel economy among the major automobile models to determine how the variables in the data set correlate with fuel economy. You are tasked with developing a better understanding of the variables in the CARS data set. Management wants you to explore this data set to determine if the data is suitable for use in the next phase of their upcoming analytics project.
You are required to conduct two analyses for this assignment.
1. Statistical Analysis
• Use SAS University Edition to conduct these statistical tasks:
• Summary statistics:
• Use MSRP, Invoice, MPG-City, and MPG-Highway as your analysis variables.
• Use Make as your classification variable.
• Distribution analysis:
• Use MSRP, Invoice, MPG-City, and MPG-Highway as your analysis variables.
• Note:
• Statistical tasks are located under Tasks and Utilities > Tasks > Statistics.
• The data set can be found in Libraries > SASHELP > CARS. 2. Cluster Analysis
• Conduct the following cluster analysis task:
• Cluster variables:
• Determine which variables, if any, appropriately cluster the variables to account for variability.
• Limit your analysis to 10 clusters. Submit an analysis of each of the variables used (MSRP, Invoice, MPG-City, and MPG-Highway). Include any tables, histograms, or scatterplot graphs necessary to support your analysis. Also, based on the cluster variables analysis, which variables, if any, can function as cluster variables? Provide tables, histograms, and other graphs to support your conclusion.