Math app question

 Application Assignment #1

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: http://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.).

Additional information

 All analysis will be on 10 cars:

· Top 5 with highest MPG

· Bottom 5 with lowest MPG

2. Use Application 1 APA Template  (click template name) to format your paper with the following sections:

Title (See APA Template): State of Automobile Industry in 1991  

· In this sections, provide a general automobile industry in 1991 (1 or 2 paragraphs with APA in-text citations and Reference Page)

Level 1 Header (See APA Template): Descriptive Statistics 

· Provide overview of what descriptive statistics are (1 to 2 paragraphs with in-text citation and reference on Reference Page). 

Level 2 Header (See APA Template): Mean and Standard Deviation

·  Discuss the average size and deviation for the top 5 and bottom 5

· Average Wt and deviation for Top 5 (APA formated table)

· Average Wt and deviation for Bottom 5 (APA formated table) 

· Average SP and deviation for Top 5 (APA formated table)

· Average SP and deviation for Bottom 5 (APA formated table) 

· Average MPG and deviation for Top 5 (APA formated table)

· Average MPG and deviation for Bottom 5 (APA formated table) 

· Average HP and deviation for Top 5 (APA formated table)

· Average HP and deviation for Bottom 5 (APA formated table) 

· Average Vol and deviation for Top 5 (APA formated table)

· Average Vol and deviation for Bottom 5 (APA formated table)  

· Summarize your findings for the industry.

Level 2 Header (See APA Template): Histograms

· Create Histogram for Top 5 and Bottom 5

· Summarize findings

Level 2 Header (See APA Template): Scatterplot and Correlation

· Create 2 Scatterplots one for Top 5 and one for  Bottom 5

· MPG (y-axis) VS Horsepower (x-axis)

· MPG (y-axis) VS Weight (x-axis)

· Correlation Table 

· MPG VS Horsepower 

· MPG  VS Weight

· Summarize findings

Level 1 Header (See APA Template): Conclusion

· 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.

3. Mechanics of the paper: 

·

· Make sure that the vertical & horizontal axes are labeled appropriately on any graphs, figures, and plots. 

· All Tables/Figures are in APA Format as shown in the APA Template

· Spelling is correct

· Correct grammar

· Basic writing skills are present in the assignment

· No MS Excel submissions 

· All Assignments are in the APA Template provide.

Basically I think what it is asking is for the work to be in apa format with the above requirements.