data processing and analysis assignment
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
data processing and analysis assignment
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
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow