Big Data Analytics In Business

develop your own research question and answer that using data from the attached work safety data. You will perform all of the data processing and analysis steps performed using excel or any other software of your choice. Steps you will complete include:  Open the attached work safety dataset.  Combine and clean data, recode and prepare excel spreadsheets with the variables of interest  Change variable names and labels  Check for missing data types and variables  Code categorical variables in letters or symbols (age group, gender, incident cost, shift) into numerical variables.  Compute descriptive statistics (mean, standard deviation, median, minimum, maximum) for incident cost and day lost.  Compute frequencies for age group, gender, incident type and shift.  Perform histograms of incident cost and day lost.  Perform bar graphs and pie chart of age group, gender, incident type and shift.  Perform a scatterplot of incident cost (dependent variables) versus day lost (independent variable).  Compute a correlation between incident cost and day lost.  Perform a simple linear regression analysis between incident cost and day lost.  Perform a multiple linear regression between incident cost and day lost, age group, gender, incident type and shift.  Interpret the analyses  Write-up your findings Components of your analysis Your analysis must include the following and you must interpret the findings. Statistics that exist on their own with no interpretation will not count. 1. Descriptive statistics: 1.1 Show output for and describe descriptive statistics for at least 4 variables 1.2 Show and describe histograms and scatterplots (total of 7 graphics). Histograms with “frequency” on the y-axis are often the most straightforward to interpret. 3. Correlation: Show output for and describe correlations for at the two continuous variables. 4. Regression: 4.1