26 Sep Produce a frequency distribution table and histogram Generate descriptive statistics table, including measures of central tendency (mean, median, and mode), kurtosis, and skewnes
Reference – Uploaded – Sun Coast.pdf
Describe the Sun Coast data (SunCoastDataFiles_StudentGuide.xlsx) using the descriptive statistics tools . Establish whether assumptions are met to use parametric statistical procedures. Repeat the tasks below for each tab in the (Uploaded – SunCoastDataFiles_StudentGuide.xlsx). Utilize the template (Uploaded – Unit IV – Template.pdf)
You will conduct the data analysis using Microsoft Excel Toolpak. View these links for information: https://support.office.com/en-us/article/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4 and https://www.excel-easy.com/data-analysis/analysis-toolpak.html
Here are some of the items you will cover.
- Produce a frequency distribution table and histogram.
- Generate descriptive statistics table, including measures of central tendency (mean, median, and mode), kurtosis, and skewness.
- Describe the dependent variable measurement scale as nominal, ordinal, interval, or ratio.
- Analyze, evaluate, and discuss the above descriptive statistics in relation to assumptions required for parametric testing. Confirm whether the assumptions are met or are not met.
The title and reference pages do not count toward the page requirement for this assignment. This assignment should be no less than five pages in length, follow APA-style formatting and guidelines, and use references and citations as necessary.
1
Insert Title Here
Insert Your Name Here
Insert University Here
2
Sun Coast Remediation Course Project Guidance
Background
To help make a connection between business research and its use in the real world, this course
will use an iterative course project. Throughout the term, you will serve as the health and safety
director for Sun Coast Remediation (Sun Coast).
Sun Coast provides remediation services to business and governmental organizations. Most of
their contracts involve working within contamination sites where they remove toxic substances
from soil and water. In addition to the toxicity of the air, water, and soil their employees come
into contact with, the work environment is physically demanding and potentially contributory to
injuries involving musculoskeletal systems, vision, and hearing. Sun Coast genuinely cares about
the health, safety, and well-being of their 5,500 employees, but they are also concerned about
worker compensation costs and potential long-term litigation from injuries and illness related to
employment.
Health and Safety Director Task
Sun Coast hired you last month to replace the previous health and safety director, who left to
pursue other opportunities. This is a critical position within the company because there are many
health and safety-related issues due to the nature of the work. The former health and safety
director was in the midst of analyzing these issues through the implementation of a research
project when she left the organization.
3
Sun Coast Remediation Course Project
Introduction
Senior leadership at Sun Coast has identified several areas for concern that they believe
could be solved using business research methods. The previous director was tasked with
conducting research to help provide information to make decisions about these issues. Although
data were collected, the project was never completed. Senior leadership is interested in seeing the
project through to fruition. The following is the completion of that project and includes the
statement of the problems, literature review, research objectives, research questions and
hypotheses, research methodology, design, and methods, data analysis, findings, and
recommendations.
Statement of the Problems
Six business problems were identified:
Particulate Matter (PM)
There is a concern that job-site particle pollution is adversely impacting employee health.
Although respirators are required in certain environments, PM varies in size depending on the
project and job site. PM that is between 10 and 2.5 microns can float in the air for minutes to
hours (e.g., asbestos, mold spores, pollen, cement dust, fly ash), while PM that is less than 2.5
microns can float in the air for hours to weeks (e.g. bacteria, viruses, oil smoke, smog, soot). Due
to the smaller size of PM that is less than 2.5 microns, it is potentially more harmful than PM
that is between 10 and 2.5 since the conditions are more suitable for inhalation. PM that is less
than 2.5 is also able to be inhaled into the deeper regions of the lungs, potentially causing more
deleterious health effects. It would be helpful to understand if there is a relationship between PM
size and employee health. PM air quality data have been collected from 103 job sites, which is
4
recorded in microns. Data are also available for average annual sick days per employee per job-
site.
Safety Training Effectiveness
Health and safety training is conducted for each new contract that is awarded to Sun
Coast. Data for training expenditures and lost-time hours were collected from 223 contracts. It
would be valuable to know if training has been successful in reducing lost-time hours and, if so,
how to predict lost-time hours from training expenditures.
Sound-Level Exposure
Sun Coast’s contracts generally involve work in noisy environments due to a variety of
heavy equipment being used for both remediation and the clients’ ongoing operations on the job
sites. Standard ear-plugs are adequate to protect employee hearing if the decibel levels are less
than 120 decibels (dB). For environments with noise levels exceeding 120 dB, more advanced
and expensive hearing protection is required, such as earmuffs. Historical data have been
collected from 1,503 contracts for several variables that are believed to contribute to excessive
dB levels. It would be important if these data could be used to predict the dB levels of work
environments before placing employees on-site for future contracts. This would help the safety
department plan for procurement of appropriate ear protection for employees.
New Employee Training
All new Sun Coast employees participate in general health and safety training. The
training program was revamped and implemented six months ago. Upon completion of the
training programs, the employees are tested on their knowledge. Test data are available for two
groups: Group A employees who participated in the prior training program and Group B
5
employees who participated in the revised training program. It is necessary to know if the revised
training program is more effective than the prior training program.
Lead Exposure
Employees working on job sites to remediate lead must be monitored. Lead levels in
blood are measured as micrograms of lead per deciliter of blood (μg/dL). A baseline blood test is
taken pre-exposure and postexposure at the conclusion of the remediation. Data are available for
49 employees who recently concluded a 2-year lead remediation project. It is necessary to
determine if blood lead levels have increased.
Return on Investment
Sun Coast offers four lines of service to their customers, including air monitoring, soil
remediation, water reclamation, and health and safety training. Sun Coast would like to know if
each line of service offers the same return on investment. Return on investment data are available
for air monitoring, soil remediation, water reclamation, and health and safety training projects. If
return on investment is not the same for all lines of service, it would be helpful to know where
differences exist.
,
Correlation Data
| job site | microns | mean annual sick days per employee |
| 1 | 4 | 11 |
| 2 | 6.5 | 7 |
| 3 | 8 | 5 |
| 4 | 8 | 5 |
| 5 | 4 | 10 |
| 6 | 7 | 7 |
| 7 | 2 | 11 |
| 8 | 5.5 | 9 |
| 9 | 5 | 7 |
| 10 | 4 | 10 |
| 11 | 4.5 | 8 |
| 12 | 8.5 | 4 |
| 13 | 7 | 7 |
| 14 | 5 | 8 |
| 15 | 9.5 | 3 |
| 16 | 7 | 7 |
| 17 | 9.5 | 5 |
| 18 | 9.5 | 7 |
| 19 | 5 | 10 |
| 20 | 6 | 6 |
| 21 | 8 | 5 |
| 22 | 7.5 | 6 |
| 23 | 8.5 | 5 |
| 24 | 9 | 4 |
| 25 | 3 | 7 |
| 26 | 6 | 7 |
| 27 | 7.5 | 7 |
| 28 | 7.5 | 5 |
| 29 | 2.7 | 7 |
| 30 | 2 | 9 |
| 31 | 7.5 | 6 |
| 32 | 9 | 4 |
| 33 | 6 | 6 |
| 34 | 3 | 8 |
| 35 | 8 | 5 |
| 36 | 1 | 8 |
| 37 | 8.5 | 5 |
| 38 | 0.7 | 8 |
| 39 | 0.5 | 8 |
| 40 | 8.5 | 4 |
| 41 | 2 | 8 |
| 42 | 4.5 | 9 |
| 43 | 6 | 7 |
| 44 | 7 | 7 |
| 45 | 5 | 10 |
| 46 | 2.5 | 12 |
| 47 | 5 | 9 |
| 48 | 4 | 7 |
| 49 | 8 | 5 |
| 50 | 5 | 7 |
| 51 | 3.5 | 9 |
| 52 | 8 | 6 |
| 53 | 5 | 5 |
| 54 | 4.9 | 10 |
| 55 | 7.5 | 9 |
| 56 | 2.5 | 7 |
| 57 | 6.5 | 7 |
| 58 | 8 | 6 |
| 59 | 5 | 6 |
| 60 | 7 | 6 |
| 61 | 4 | 9 |
| 62 | 8 | 5 |
| 63 | 1 | 8 |
| 64 | 2 | 8 |
| 65 | 4 | 10 |
| 66 | 4 | 9 |
| 67 | 7 | 7 |
| 68 | 5.2 | 10 |
| 69 | 5 | 7 |
| 70 | 6 | 6 |
| 71 | 8 | 6 |
| 72 | 6 | 7 |
| 73 | 6.5 | 6 |
| 74 | 1.5 | 8 |
| 75 | 8.5 | 6 |
| 76 | 2 | 8 |
| 77 | 8 | 5 |
| 78 | 10 | 4 |
| 79 | 10 | 5 |
| 80 | 8 | 8 |
| 81 | 1 | 8 |
| 82 | 7 | 6 |
| 83 | 10 | 2 |
| 84 | 7 | 8 |
| 85 | 7 | 6 |
| 86 | 6.5 | 7 |
| 87 | 7.5 | 6 |
| 88 | 8.5 | 6 |
| 89 | 3 | 8 |
| 90 | 0.5 | 9 |
| 91 | 1 | 8 |
| 92 | 9 | 6 |
| 93 | 7 | 7 |
| 94 | 2 | 9 |
| 95 | 8.5 | 7 |
| 96 | 3.5 | 9 |
| 97 | 3 | 8 |
| 98 | 7 | 6 |
| 99 | 5.5 | 7 |
| 100 | 7.5 | 7 |
| 101 | 0.2 | 12 |
| 102 | 4 | 8 |
| 103 | 5 | 9 |
Simple Regression Data
| contract # | safety training expenditure | lost time hours |
| 1116 | 1985.12 | 10 |
| 205 | 1500.00 | 30 |
| 2146 | 1126.46 | 40 |
| 1603 | 1294.10 | 40 |
| 914 | 1445.56 | 40 |
| 437 | 1112.47 | 50 |
| 598 | 1720.81 | 60 |
| 2801 | 1789.66 | 60 |
| 1420 | 1837.52 | 60 |
| 682 | 2000.00 | 60 |
| 714 | 2271.86 | 60 |
| 2336 | 1507.97 | 70 |
| 2216 | 1542.33 | 70 |
| 1327 | 1544.90 | 70 |
| 1025 | 1547.16 | 70 |
| 920 | 1567.55 | 70 |
| 465 | 1600.00 | 70 |
| 138 | 1452.69 | 80 |
| 1411 | 1500.00 | 80 |
| 1439 | 1500.00 | 80 |
| 2388 | 1326.60 | 90 |
| 1849 | 1351.25 | 90 |
| 1740 | 1380.69 | 90 |
| 1666 | 1423.57 | 90 |
| 1672 | 1095.58 | 100 |
| 2455 | 1132.88 | 100 |
| 403 | 1134.58 | 100 |
| 856 | 1163.44 | 100 |
| 2050 | 1170.92 | 100 |
| 1271 | 1177.05 | 100 |
| 2429 | 1188.19 | 100 |
| 812 | 1323.29 | 100 |
| 405 | 1051.17 | 110 |
| 1630 | 1054.03 | 110 |
| 2376 | 1071.75 | 110 |
| 861 | 1077.86 | 110 |
| 2436 | 1080.34 | 110 |
| 36 | 923.37 | 120 |
| 30 | 957.17 |