+1443 776-2705 panelessays@gmail.com

 Big Data Analytics   Overview

 For this assignment, you will come up with a research question and explore it using the techniques of data analysis that we have described in class and explored in the labs. You will 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. Complete the bivariate regressions, show output for and describe (coefficients, t- stat, p-value, r-squared) 4.2. Complete the multiple linear regression, show output for and describe (coefficients, t-stat, p-value, r-squared) Note: We do not want to read about all of the intermediary steps that you did, see all of the output you created, hear about syntax errors, things you fixed, etc. Do not include all of your work – only the relevant parts.  Requirements: Your assignment includes the following: 1. A narrative of the analysis you conducted, complete with an introduction, Stata output inserted in the body of the text, your interpretations of the output, and a conclusion. Be sure to:  Explain your reasoning for including each independent variable, along with your hypothesis for how you thought it would affect the dependent variable (again, you could help to illustrate your reasoning using scatter plots, histograms, or descriptive statistics)  Be sure to explain any regression outputs you include clearly, interpreting the r-squared, the coefficients on the independent variables, and the related p- values in plain language.  What can you conclude based on your results? Provide a clear conclusion 

Instructions

Downloaded From
Sample Data for Excel
Related tutorials
Named Excel Tables
Data Entry Tips
More Excel Sample Files
Notes
Fake data to use for Excel testing
Grey columns have formulas

https://www.contextures.com/xlSampleData01.html https://www.contextures.com/xlExcelTable01.html https://www.contextures.com/xlDataEntry01.html https://www.contextures.com/excelfiles.html

SafetyData

Date Injury Location Gender Age Group Incident Type Days Lost Plant Report Type Shift Department Incident Cost
1-Jan-20 Multiple Male 25-34 Burn 0 Iowa Near Miss Afternoon Painting $0
3-Jan-20 N/A Male 35-49 Vehicle 0.5 Alabama Lost Time Day Fabrication $3,367
3-Jan-20 Eye Male 18-24 Cut 0 Georgia Near Miss Day Administration $0
4-Jan-20 Legs Female 50+ Falling object 0 Iowa Near Miss Day Painting $0
7-Jan-20 Legs Male 25-34 Lifting 0 Ohio Near Miss Day Painting $0
11-Jan-20 N/A Female 50+ Crush & Pinch 0 Georgia First Aid Afternoon Security $132
11-Jan-20 Neck Male 25-34 Crush & Pinch 3.5 Iowa Lost Time Day Purchasing $4,872
12-Jan-20 Feet Male 35-49 Burn 1.5 California Lost Time Night Administration $1,248
15-Jan-20 N/A Male 18-24 Fall 0 Florida First Aid Afternoon Maintenance $29
16-Jan-20 Arms Male 50+ Crush & Pinch 4.5 Florida Lost Time Afternoon Administration $2,525
18-Jan-20 N/A Female 35-49 Falling object 0 Iowa First Aid Night Shipping $59
23-Jan-20 Neck Male 35-49 Crush & Pinch 0 Alabama Medical Claim Afternoon Shipping $1,947
26-Jan-20 Eye Male 35-49 Vehicle 0 Florida Medical Claim Day Finishing $2,268
27-Jan-20 Eye Male 50+ Burn 0 Texas Medical Claim Day Maintenance $628
27-Jan-20 Eye Male 35-49 Burn 0 Georgia First Aid Night Finishing $77
27-Jan-20 Back Male 50+ Cut 0 Ohio First Aid Day Shipping $341
30-Jan-20 Arms Male 18-24 Burn 0 Montana Near Miss Afternoon Maintenance $0
30-Jan-20 Hands Male 35-49 Fall 0 California Medical Claim Day Melting $2,007
1-Feb-20 Multiple Male 50+ Crush & Pinch 0 Illinois First Aid Night Painting $338
3-Feb-20 Arms Male 35-49 Fall 4 Ohio Lost Time Night Maintenance $1,196
4-Feb-20 Head Male 18-24 Lifting 0 Montana Near Miss Night Shipping $0
9-Feb-20 Feet Male 35-49 Crush & Pinch 0 Montana First Aid Afternoon Melting $180
9-Feb-20 Head Male 25-34 Equipment 4.5 Florida Lost Time Afternoon Shipping $3,784
10-Feb-20 Feet Male 35-49 Burn 1.5 Texas Lost Time Day Melting $4,414
10-Feb-20 Head Male 35-49 Slip/trip 2.5 Ohio Lost Time Afternoon Security $2,790
11-Feb-20 N/A Male 25-34 Slip/trip 0 Illinois First Aid Afternoon Administration $394
12-Feb-20 Hands Male 50+ Fall 4 Montana Lost Time Afternoon Finishing $4,743
13-Feb-20 N/A Male 50+ Burn 4.5 Illinois Lost Time Night Finishing $3,417
13-Feb-20 Legs Male 25-34 Crush & Pinch 0 Alabama Medical Claim Night Painting $2,337
14-Feb-20 Abdomen Male 25-34 Equipment 0 Georgia Near Miss Night Shipping $0
16-Feb-20 Abdomen Male 50+ Slip/trip 0 California First Aid Day Fabrication $207
17-Feb-20 Multiple Female 35-49 Fall 2 Ohio Lost Time Night Maintenance $2,544
19-Feb-20 Multiple Female 35-49 Equipment 0 Montana Medical Claim Day Administration $3,411
20-Feb-20 Back Male 25-34 Slip/trip 0 California Near Miss Afternoon Fabrication $0
22-Feb-20 N/A Male 25-34 Equipment 0 Georgia Medical Claim Afternoon Fabrication $4,800
27-Feb-20 Neck Male 50+ Equipment 0 Texas Medical Claim Night Maintenance $3,339
28-Feb-20 Back Male 50+ Lifting 5 Montana Lost Time Night Fabrication $4,969
1-Mar-20 Trunk Male 18-24 Fall 0 Montana First Aid Afternoon Shipping $360
3-Mar-20 Eye Male 35-49 Burn 0 Iowa Near Miss Afternoon Shipping $0
3-Mar-20 N/A Male 50+ Crush & Pinch 2.5 Florida Lost Time Day Maintenance $4,718
6-Mar-20 Eye Male 25-34 Burn 0 Ohio Near Miss Night Shipping $0
6-Mar-20 Head Male 18-24 Cut 0 Montana First Aid Day Shipping $456
7-Mar-20 Feet Male 18-24 Fall 0 Alabama First Aid Night Administration $307
11-Mar-20 Arms Male 35-49 Cut 0 Ohio Near Miss Day Maintenance $0
12-Mar-20 Neck Female 18-24 Fall 0 Florida Medical Claim Day Administration $4,933
17-Mar-20 Abdomen Male 25-34 Slip/trip 4.5 Iowa Lost Time Day Fabrication $3,146
20-Mar-20 Eye Male 35-49 Lifting 0 Montana Near Miss Day Security $0
21-Mar-20 Back Male 35-49 Falling object 0 Ohio Medical Claim Night Melting $3,084
23-Mar-20 Multiple Male 35-49 Falling object 0 Florida Near Miss Afternoon Finishing $0
3-Apr-20 Legs Male 18-24 Burn 0 California First Aid Night Painting $260
4-Apr-20 Trunk Male 25-34 Equipment 0 Illinois First Aid Afternoon Melting $40
4-Apr-20 Back Male 25-34 Vehicle 0 Montana Medical Claim Day Finishing $2,615
4-Apr-20 Arms Male 35-49 Falling object 4.5 Montana Lost Time Day Administration $450
6-Apr-20 N/A Male 18-24 Slip/trip 0 Illinois Medical Claim Night Finishing $4,462
7-Apr-20 Legs Male 25-34 Lifting 0 Ohio First Aid Night Purchasing $76
12-Apr-20 N/A Male 25-34 Fall 0 Ohio First Aid Night Maintenance $297
13-Apr-20 Eye Female 50+ Vehicle 4.5 Alabama Lost Time Night Fabrication $1,152
13-Apr-20 Legs Male 18-24 Slip/trip 0 Illinois Near Miss Day Finishing $0
14-Apr-20 Back Male 50+ Burn 0 Texas First Aid Night Purchasing $173
14-Apr-20 Arms Male 50+ Fall 0 Montana Near Miss Night Finishing $0
15-Apr-20 Back Male 35-49 Falling object 1.5 Illinois Lost Time Afternoon Shipping $4,731
16-Apr-20 Eye Male 50+ Burn 0 Iowa First Aid Afternoon Painting $155
17-Apr-20 Abdomen Male 25-34 Crush & Pinch 3 Georgia Lost Time Night Administration $3,425
18-Apr-20 Neck Male 25-34 Burn 0 Alabama Near Miss Night Administration $0
21-Apr-20 Arms Male 18-24 Cut 3 California Lost Time Night Fabrication $2,627
21-Apr-20 Head Female 18-24 Vehicle 4 Texas Lost Time Afternoon Shipping $3,680
22-Apr-20 Legs Male 35-49 Vehicle 0 Iowa First Aid Day Administration $281
22-Apr-20 Legs Male 18-24 Equipment 0 Iowa Near Miss Afternoon Security $0
24-Apr-20 Back Male 18-24 Lifting 1 Montana Lost Time Day Maintenance $3,954
25-Apr-20 Eye Female 50+ Equipment 0 Montana Near Miss Day Purchasing $0
27-Apr-20 Trunk Female 18-24 Slip/trip 0 California Near Miss Day Purchasing $0
2-May-20 Legs Male 25-34 Lifting 0 Illinois Medical Claim Day Maintenance $2,461
4-May-20 Head Male 25-34 Cut 0 Illinois Medical Claim Day Administration $3,851
5-May-20 Feet Male 50+ Burn 0 Florida First Aid Night Finishing $224
7-May-20 Neck Male 18-24 Lifting 4 Florida Lost Time Night Finishing $3,969
8-May-20 Arms Male 18-24 Burn 0 Alabama First Aid Night Administration $434
8-May-20 Neck Male 50+ Crush & Pinch 1 Ohio Lost Time Night Melting $1,173
9-May-20 Eye Male 35-49 Fall 0 Alabama First Aid Afternoon Maintenance $236
10-May-20 Trunk Male 35-49 Lifting 0 Iowa Near Miss Day Administration $0
10-May-20 Feet Male 35-49 Crush & Pinch 1.5 Montana Lost Time Night Maintenance $1,592
11-May-20 Abdomen Male 50+ Slip/trip 0 Georgia Near Miss Night Shipping $0
13-May-20 Feet Male 50+ Fall 0 Montana Near Miss Afternoon Melting $0
13-May-20 Neck Male 35-49 Cut 0 Illinois First Aid Night Maintenance $457
17-May-20 N/A Male 35-49 Cut 0 Ohio Near Miss Day Security $0
17-May-20 Head Male 18-24 Fall 0 Ohio First Aid Afternoon Security $247
19-May-20 Hands Male 25-34 Crush & Pinch 0 Georgia First Aid Night Administration $457
21-May-20 Back Male 35-49 Falling object 0 Illinois Near Miss Afternoon Security $0
22-May-20 Trunk Male 35-49 Falling object 0 Ohio First Aid Day Melting $305
23-May-20 Neck Male 50+ Lifting 0 Montana Near Miss Afternoon Administration $0
25-May-20 Head Male 25-34 Crush & Pinch 0.5 Florida Lost Time Afternoon Purchasing $2,468
26-May-20 Arms Male 35-49 Burn 0.5 California Lost Time Afternoon Finishing $786
26-May-20 Eye Male 18-24 Lifting 0 Alabama Medical Claim Day Administration $2,481
29-May-20 Arms Male 25-34 Burn 0.5 California Lost Time Day Shipping $674
31-May-20 Head Male 50+ Crush & Pinch 0 Alabama Near Miss Night Purchasing $0
31-May-20 Legs Male 35-49 Lifting 0 Alabama Near Miss Afternoon Shipping $0
2-Jun-20 Feet Male 50+ Slip/trip 0 Georgia Near Miss Afternoon Shipping $0
7-Jun-20 Legs Male 25-34 Equipment 0 Georgia Near Miss Night Shipping $0
10-Jun-20 Back Male 18-24 Equipment 2.5 Ohio Lost Time Night Shipping $2,370
11-Jun-20 Hands Male 35-49 Falling object 0 California Medical Claim Night Purchasing $1,121
12-Jun-20 Eye Male 18-24 Slip/trip 0 California Medical Claim Day Maintenance $3,269
15-Jun-20 Legs Male 18-24 Lifting 0 Illinois First Aid Day Painting $249
15-Jun-20 Multiple Male 18-24 Burn 0 Illinois First Aid Night Shipping $423
16-Jun-20 Feet Male 18-24 Falling object 0 Georgia Medical Claim Day Maintenance $3,397
19-Jun-20 Head Female 25-34 Falling object 0 California Medical Claim Day Fabrication $4,016
23-Jun-20 Hands Male 25-34 Slip/trip 0 Montana Medical Claim Afternoon Maintenance $2,387
26-Jun-20 Legs Male 50+ Crush & Pinch 0 Iowa Near Miss Afternoon Administration $0
27-Jun-20 Back Male 35-49 Slip/trip 0 Montana Medical Claim Afternoon Shipping $4,292
28-Jun-20 Feet Female 25-34 Equipment 2 Alabama Lost Time Day Melting $1,635
30-Jun-20 Trunk Male 18-24 Crush & Pinch 0 Florida Near Miss Night Security $0
30-Jun-20 Neck Male 18-24 Slip/trip 5 Alabama Lost Time Day Security $603
1-Jul-20 Neck Male 50+ Lifting 0 Alabama Medical Claim Afternoon Finishing $1,335
6-Jul-20 N/A Female 50+ Equipment 0 Ohio First Aid Day Melting $250
6-Jul-20 Neck Male 18-24 Burn 2 Illinois Lost Time Day Security $3,203
7-Jul-20 Back Male 25-34 Slip/trip 0 Illinois Medical Claim Day Maintenance $4,246
10-Jul-20 Abdomen Male 25-34 Crush & Pinch 0 Florida Medical Claim Afternoon Melting $4,229
11-Jul-20 Arms Male 18-24 Falling object 1 Alabama Lost Time Night Administration $3,256
12-Jul-20 Trunk Male 25-34 Cut 4 Iowa Lost Time Night Finishing $2,861
12-Jul-20 Eye Male 18-24 Slip/trip 0 Montana First Aid Night Melting $118
13-Jul-20 N/A Male 50+ Equipment 3.5 Ohio Lost Time Day Maintenance $3,716
14-Jul-20 Abdomen Male 18-24 Crush & Pinch 0 Montana Near Miss Day Finishing $0
16-Jul-20 Head Male 35-49 Lifting 0 Alabama Near Miss Night Maintenance $0
18-Jul-20 Feet Male 35-49 Cut 0 Iowa Medical Claim Night Maintenance $532
19-Jul-20 Back Male 18-24 Equipment 0 Alabama Near Miss Night Painting $0
22-Jul-20 Trunk Male 18-24 Lifting 0 Alabama Near Miss Day Fabrication $0
26-Jul-20 N/A Male 25-34 Equipment 5 Texas Lost Time Night Melting $4,281
27-Jul-20 Head Male 25-34 Burn 0 Montana Medical Claim Day Melting $4,455
28-Jul-20 Head Male 18-24 Equipment 0 California Medical Claim Night Purchasing $4,444
28-Jul-20 N/A Male 50+ Equipment 2 California Lost Time Night Security $2,777
30-Jul-20 Abdomen Male 35-49 Lifting 3 Illinois Lost Time Night Shipping $4,940
30-Jul-20 N/A Female 35-49 Falling object 0 Ohio Near Miss Night Shipping $0
1-Aug-20 Neck Male 25-34 Crush & Pinch 0 Florida Near Miss Afternoon Administration $0
3-Aug-20 Multiple Male 35-49 Slip/trip 0 Illinois Medical Claim Day Painting $2,521
4-Aug-20 Back Male 35-49 Falling object 0 Georgia Medical Claim Day Maintenance $1,430
7-Aug-20 Trunk Male 35-49 Equipment 5 Iowa Lost Time Afternoon Fabrication $1,505
9-Aug-20 Feet Male 35-49 Burn 0 Alabama Medical Claim Night Maintenance $921
9-Aug-20 Legs Male 25-34 Equipment 0 Georgia First Aid Afternoon Administration $206
10-Aug-20 Trunk Female 25-34 Slip/trip 0 Texas Near Miss Day Melting $0
11-Aug-20 Legs Male 50+ Vehicle 0 Florida Near Miss Afternoon Finishing $0
12-Aug-20 Arms Male 50+ Burn 0 California Medical Claim Afternoon Fabrication $1,835
13-Aug-20 Feet Male 35-49 Slip/trip 1 California Lost Time Afternoon Administration $2,333
13-Aug-20 Trunk Female 35-49 Cut 0 Montana Near Miss Afternoon Maintenance $0
13-Aug-20 Hands Male 35-49 Fall 0 Georgia Medical Claim Afternoon Fabrication $1,890
15-Aug-20 Back Male 35-49 Lifting 0 Georgia Medical Claim Night Security $1,951
21-Aug-20 Arms Male 35-49 Falling object 5 Montana Lost Time Night Administration $3,692
21-Aug-20 Trunk Male 50+ Slip/trip 0 Iowa First Aid Night Administration $242
23-Aug-20 Hands Female 35-49 Cut 0 Illinois Near Miss Night Painting $0
25-Aug-20 Legs Male 25-34 Slip/trip 0 Montana Near Miss Day Administration $0
26-Aug-20 Abdomen Male 35-49 Slip/trip 0 Florida Medical Claim Day Shipping $845
27-Aug-20 Eye Male 18-24 Fall 0 Illinois First Aid Day Administration $395
27-Aug-20 Hands Female 35-49 Lifting 0 California First Aid Afternoon Maintenance $88
30-Aug-20 Legs Male 35-49 Cut 0 Alabama Near Miss Afternoon Painting $0
31-Aug-20 Hands Female 18-24 Slip/trip 2.5 Ohio Lost Time Night Finishing $3,488
5-Sep-20 N/A Female 25-34 Cut 0 Texas First Aid Day Administration $351
6-Sep-20 Arms Male 50+ Fall 0 Alabama First Aid Night Fabrication $430
7-Sep-20 Abdomen Male 35-49 Falling object 0 Illinois Medical Claim Day Maintenance $4,871
11-Sep-20 Neck Male 18-24 Fall 1.5 Illinois Lost Time Night Security $1,230
13-Sep-20 Head Male 50+ Fall 0 Ohio Near Miss Night Melting $0
14-Sep-20 Eye Male 35-49 Cut 0 Montana Medical Claim Night Fabrication $1,136
16-Sep-20 Feet Female 35-49 Lifting 0 Texas Medical Claim Day Fabrication $1,819
22-Sep-20 Feet Male 25-34 Lifting 2.5 Georgia Lost Time Night Finishing $709
23-Sep-20 Legs Male 18-24 Fall 0 Florida First Aid Afternoon Finishing $366
25-Sep-20 Feet Male 35-49 Vehicle 0 Iowa First Aid Night Administration $133
27-Sep-20 Back Male 50+ Lifting 0 Ohio First Aid Afternoon Fabrication $470
30-Sep-20 N/A Male 35-49 Cut 0 Georgia Near Miss Night Shipping $0
4-Oct-20 Feet Male 35-49 Lifting 1 Montana Lost Time Day Security $2,237
9-Oct-20 Arms Male 50+ Burn 0 Florida First Aid Day Maintenance $58
11-Oct-20 Multiple Male 35-49