quant excel homework

Font size of 11 pt or higher.  DO NOT SUBMIT YOUR EXCEL DATASET.  PDF format only.1) ANOVA analysisOpen the Data for ANOVA analysis Excel workbookChoose to perform a 1-way ANOVA analysis for either the variable demographic age or race. You may need to reorganize the dataset in order to conduct the analysis is Excel.  Report  which variable you have selected to work withPerform a descriptive numerical and histogram analysis for each subgroup (or levels) for the variable you’ve selected.  Report all tables and histograms , along with interpretations, in your Final Report documentCheck that the subsets for your variable have the same number of row entries. If not, use the Sampling Tool in Excel to randomly select the largest number of row entries, for each subset, that works for all of them.  For example,  if there are  subsets with 7, 4, 9, and 10 row entries,  use the sampling tool to select a random sample of 4 row entries for each subset. Report the Sampling tool screen shot as part of your Final ReportUse Excel to run a 1-way ANOVA analysis.  Report all Excel output tables and interpret the results.  Report this as part of your Final ReportIf significant differences between subgroups is detected,  perform a Tukey multiple comparison test (see ANOVA note files from course) to determine where the significant differences exist.  Report the test, and your interpretation, evidence in your Final Report document2) Please attach your presentation.  Save in PDF format only. Your presentation, should contain the following  slides (please title the slides):Your Choice of analysisA description of its use (What is a  1-way ANOVA, What is an example real-life application (provide hyperlink to real-life application source))List of Variables in the times series dataset or list the ANOVA subsets groupsReport all tables and charts (on separate slides) , formatted to class expectations, that were used in the analysis.  Be sure to number all tables and charts and include brief description with each.  Axes titles for all charts