Chat with us, powered by LiveChat Produce a frequency distribution table and histogram Generate descriptive statistics table, including measures of central tendency (mean, median, and mode), kurtosis, and skewnes - Writeedu

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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Do you need help with this question?

Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Chat with us today! We are always waiting to answer all your questions.

Click here to Place your Order Now



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