DJC 200 Excel Statistical Analysis Project Worksheet

Excel Statistical Analysis Project You will collect a data set through one of two options; either a survey or simulated data on Excel. Then, you will analyze the data set using the concepts and tools covered in each of the textbook chapters. There are multiple sheets on the Excel file to complete. Lastly, you will write summary of your project. Please note that if you are using the survey data option you cannot publish, share, present, etc. this data or your findings anywhere other than our classroom. You also cannot collect your survey data from individuals you do not know over social media platforms (Twitter, Reddit, Facebook, etc.). Please download the instructions for your statistical study for use when completing homework assignment 2 and whenever you are working on your statistical project.Topics that will not be approved: Social media, music, movies, video games, food comparisons, shopping, etc… Remember your topic should be a current event in the news.Part 1: Excel File – completed and uploaded to the respective Canvas assignmentComplete the Excel file by following these steps: Import and organize your data set onto Sheet 1.Create the appropriate graphs for your qualitative variables on Sheet 2.Find the appropriate indicators for your quantitative variables by completing the table on Sheet 3.Create a 5-Number Summary and Box-and-Whisker Plots for your quantitative variables on Sheet 4.Create a scatter plot for your continuous quantitative variables on Sheet 5.Prepare and upload your analysis.Results you found.Interesting aspects of the Box-and-Whisker Plots on Sheet 4.Interesting aspects of the scatter plot on Sheet 5 and explanations of correlation if any exists.Interesting aspects of the Two-Way Table on Sheet 6.Concluding thoughts on your findings and suggestions for further research. Explanations of the processes completed throughout this project.