Statistics Case Study project. Requires a REPORT, and EXCEL WORKBOOK with all the calculations, tables, plots, etc. used in the report. . Please find attached the dataset to use for the case study (file name is movies29), and two sample projects. Sample projects are too long and include some unnecessary information, so only include whats in the instruction.

A dataset is included in the attachment by the name (movies29). You must use this file for all your work in this case study Section I: Introduction Define your research question or your working hypothesis. Identify your response variable this has to be a continuous variable. Also, identify your explanatory variables. Explain why you think the relationship between your response and the other variables is interesting and elaborate on what you expect to find out form the data. Explain the role of each of these variables in your project. What is the purpose of working with each of these variables? That is, how do these variables connect to your research question? Describe the dataset. Where does it came from? How many observations and how many variables does it have? Also, describe all the variables that you will use. You don’t have to use all the variables in the dataset, but a minimum of 3 explanatory variables is required. You must include both continuous and categorical variables in your analysis and one of your categorical variables must be binary. Section II: Exploratory Data Analysis Generate appropriate summary statistics for all the variables that you will use in the project. You should tabulate categorical data and summarize continuous data. Provide appropriate plots for each variable. Histograms and boxplots for continuous variables and barplots for categorical data. Explore the bivariate relationships between your response variable Y and all the other variables that you will be using in the project. Generate scatterplots for continuous variables and side-by-side boxplots for categorical variables. Calculate covariances and correlations and comment on the nature of the relationship and its strength. Discuss all your findings for this section. Comment on all the summary statistics and plots. Elaborate in your statements. Try to see if you can tell a story from what you see in the data, summaries, and plots. Section III: Hypothesis Testing Do a simple mean t-test to one of your continuous variables and a two-group t-test based on a binary variable. For each one, write your null and alternative hypotheses in mathematical form and in plain English. Provide a conclusion for your test based on a p-value. Also, give a 95% confidence interval for the mean (or difference in means) to support your results. Section IV: Conclusions Write a sound conclusion for all your work. Tie it back to your introduction and your initial thoughts. Comment on anything interesting that you learned about the data. Additionally, describe any challenges you found working with the data and how were you able to overcome them. Remember that your reader will remember your introduction and conclusion the most, and it is always good to close on a strong side.