XLSTAT and Excel to analyze the data.

Open your data in Excel and answer the following in complete sentences.In class this week we’ve learned about chi-squared tests, which allow us to answer more complicated problems with categorical data.1. In this project, you will try to see if two categorical variables of your choosing are dependent using a chi-squared test.What two categorical variables do you intend to use? What makes them categorical?If you are working with the Pokemon, Amazon Bestsellers, IBM, or FIFA data, pretend the entire dataset is a sample.If you are working with the KickStarter or Youtube data, take a sample of 1500 rows. Go ahead and sample from all columns rather than the two you think you’ll be interested in. This may be the one time I don’t ask you to attach your sample to the end of the project. Enjoy!Run your chi-squared test of Independence and then answer the following questions using the relevant output.2. Create a contingency table using two categorical variables (from one of the six given datasets) as your columns and rows, respectively.3. What is the null hypothesis for a test of independence based on this table?4. Using your XLSTAT output, show all five steps of the Chi-squared Test of Independence Hypothesis Test.Remember: These are five steps to a hypothesis test. I would like to see all five steps.5. What does this p-value tell you about your two categorical variables, in everyday language? In other words, what is your conclusion in context?6. Did your data satisfy the “rule of 5” meaning did each of your expected cell counts exceed 5?Assuming it didn’t, how could you adjust your data so that you could satisfy the “rule of 5”?7. Did the results of your hypothesis test surprise you? Discuss.