Conduct an analysis and hypothesis test of your choice on the data you collected. Please conduct hypothesis test for the data on stress level and number of sick days used. I want to hypothesize that increasing stress levels leads to more sick days at work being taken. Data, calculations should be placed on attached excel file Hypothesis Test. The data to be used is placed on the excel file hypothesis test.
Write a 250-500 word research summary of the findings generated in the assignments for Topics 2 through 5 ( Attachments for topics 2-5 have been included). The research summary should address the following.
- Explain what type of analysis and hypothesis test was conducted on the data collected.
- Summarize the survey results based on the results of the data you analyzed.
- Include the Excel analysis as part of the document.
APA format is not required, but solid academic writing is expected.
Hulsey 1 Summer Hulsey GCU - SYM506 26 August 2020 Data Collection Topic: Understanding Factors Related to Sick Days at Work The purpose of the study is to better understand reasons behind sick time at work, so that necessary accommodations can be made in future recruitment and benefit packages. The survey will extract data regarding the age group of employees, the number of sick days each one is utilizing annually, if employees require more sick days then company allotment, the type of industry each employee is in, and how stressful respondents rank their jobs. The data collected will serve as a source of future improvement to human resource processes towards improving overall employee satisfaction, and retention. Careful consideration in understanding a combination of variables and how they relate to one another will provide valuable information. For instance, understanding if age contributes to sick days will allow for clarity on the age groups with the highest sick days utilized. In addition to that, understanding the relationship between sick time and job stress, or type of industry will also clarify factors related to employee satisfaction and improvement programs that could be incorporated into business settings. Lastly, gaining awareness on the benefit packages for paid sick time, and if PTO is being utilized will also allow for a better understanding of the use of PTO time and the needs of employees. Taken together the data collection and analysis will serve in better understanding factors contributing to employees taking sick time at work. Link to survey and screenshots below: https://www.surveymonkey.com/r/SDCHQ7Q Frequency Tables Age Group of ParticipantFrequencyType of Industry Frequency Under 180Accounting & Legal1 18-243Business Services3 25-3412Construction, Maintenance, Repair4 35-446Finance0 45-545Healthcare8 55-643Information Technology1 65+1Manufacturing3 Number of Sick DaysFrequencyMedia0 04Restaurants, Bars, Food Service6 11Stress Level (1-100 Scale)FrequencyRetail3 23201 38311 53351 66401 101411 121501 151521 301551 321601 601 621 641 671 751 772 781 802 831 831 851 901 901 941 951 971 1003 1. Create two frequency tables based on two separate questions from your survey. ** Added two additional Frequency tables since Age Group of participant and Type of Industry were already grouped as part of my question in Survey Monkey Bar Graph & Pie Chart Age of Participants Frequency Under 1818-2425-3435-4445-5455-6465+03126531 Age of Participants FrequencyUnder 1818-2425-3435-4445-5455-6465+03126531 Type of Industry Frequency Accounting & LegalBusiness ServicesConstruction, Maintenance, RepairFinanceHealthcareInformation TechnologyManufacturingMediaRestaurants, Bars, Food ServiceRetail1340813063 Type of Industry FrequencyAccounting & LegalBusiness ServicesConstruction, Maintenance, RepairFinanceHealthcareInformation TechnologyManufacturingMediaRestaurants, Bars, Food ServiceRetail1340813063 Number of Sick Days Frequency 0-34-78-1112-1516-1920-2324-2728-32169120002 Number of Sick Days 0-34-78-1112-1516-1920-2324-2728-32169120002 Stress Level 20-2930-3940-4950-5960-6970-7980-8990-10012233457 Stress Level Frequency20-2930-3940-4950-5960-6970-7980-8990-10012233457 2. Create a bar graph and a pie chart based on the data in the frequency tables. *** I created 4 of each based on different questions just in case my ones previously grouped would not count Class Intervals and Distributio Number of Sick DaysFrequencyStress Level (1-100 Scale)Frequency 04201 11311 23351 38401 53411 66501 Number of Sick Days101521 Class IntervalsFrequency121551 0-316151601 4-79301601 8-111321621 12-152641 16-190671 20-230751 24-270772 28-322Number of Sick Days781 802 Mean10.1666666667831 Standard Error3.0940640464831 Median6851 4-Mode6901 Standard Deviation10.7181522605901 Sample Variance114.8787878788941 Kurtosis0.8462864713951 Skewness1.356637651971 Range321003 Minimum0 Maximum32 Sum122Stress Level Count12 Mean67.8461538462 Range32Standard Error4.3949944632 Bins4Median71 Total Groups8Mode60 Standard Deviation22.4101625299 Sample Variance502.2153846154 Stress Level GroupedKurtosis-0.75707015 Class IntervalsFrequencySkewness-0.4438438107 20-291Range80 30-392Minimum20 40-492Maximum100 50-593Sum1764 60-693Count26 70-794Confidence Level(95.0%)9.0516605361 80-895 90-1007Range80 Bins10 Total Groups8 3. Determine the class intervals and create frequency distribution for each of the frequency tables. Frequency Polygon Number of Sick Days Class IntervalsUpper LimitsMidpointsFrequency 0-331.516 4-775.59 8-11119.51 12-151513.52 16-191917.50 20-232321.50 24-272725.50 28-323229.52 4. Create one frequency polygon of the data from the frequency distribution. Frequency Polygon 0-34-78-1112-1516-1920-2324-2728-32169120002Number of Sick Days Frequency Central Tendency Stress Level Number of Sick Days Taken 200 310 35Stress Level 0Number of Sick Days 400 41Mean70.71Mean6.0333333333 50Standard Error4.09798099992Standard Error1.3883615857 52Median772Median3 55Mode1002Mode3 60Standard Deviation22.44556633893Standard Deviation7.6043695848 60Sample Variance503.80344827593Sample Variance57.8264367816 62Kurtosis-0.5793735343Kurtosis6.8107764777 64Skewness-0.56199776733Skewness2.5912438492 67Range803Range32 75Minimum203Minimum0 77Maximum1003Maximum32 77Sum21213Sum181 78Count305Count30 80Confidence Level(95.0%)8.3813122145Confidence Level(95.0%)2.8395182691 805 836 836 856 906 906 946 9510 9712 10015 10030 10032 Determine the mean, median, and mode for each of the variables. ( 2 variables from the data set) Stress Level - Mean is 70.7 Median 77 Mode 100 Number of Sick Days Taken - Mean is 6.03 Median 3 Mode 3 Variance Stress Level Number of Sick Days Taken 200 310 350 400 411 502 522 552 603 603 623 643 Stress Level Number of Sick Days673 753 Mean70.7Mean6.0333333333773 Standard Error4.0979809999Standard Error1.3883615857773 Median77Median3785 Mode100Mode3805 Standard Deviation22.4455663389Standard Deviation7.6043695848805 Sample Variance503.8034482759Sample Variance57.8264367816836 Kurtosis-0.579373534Kurtosis6.8107764777836 Skewness-0.5619977673Skewness2.5912438492856 Range80Range32906 Minimum20Minimum0906 Maximum100Maximum32946 Sum2121Sum1819510 Count30Count309712 Confidence Level(95.0%)8.381312214Confidence Level(95.0%)2.839518269110015 10030 10032 What is the variance for each set of data for each of the variables? Stress Level - variance 503.8 (rounded) Number of Sick Days - Variance 57.82 ( rounded) Standard Deviation Stress Level Number of Sick Days Taken 200 310 350 400 411 502 522 552 603 603 623 643 Stress Level Number of Sick Days673 753 Mean70.7Mean6.0333333333773 Standard Error4.0979809999Standard Error1.3883615857773 Median77Median3785 Mode100Mode3805 Standard Deviation22.4455663389Standard Deviation7.6043695848805 Sample Variance503.8034482759Sample Variance57.8264367816836 Kurtosis-0.579373534Kurtosis6.8107764777836 Skewness-0.5619977673Skewness2.5912438492856 Range80Range32906 Minimum20Minimum0906 Maximum100Maximum32946 Sum2121Sum1819510 Count30Count309712 Confidence Level(95.0%)8.381312214Confidence Level(95.0%)2.839518269110015 10030 10032 What is the standard deviation for each of the variables? Stress Level - Standard Deviation of 22.45 ( rounded) Number of Sick Days - Standard Deviation 7.604 ( rounded) Probability Stress Level Number of Sick Days Taken 200Stress Level Number of Sick Days 310 350Mean70.7Mean6.0333333333 400Standard Error4.0979809999Standard Error1.3883615857 411Median77Median3 502Mode100Mode3 522Standard Deviation22.4455663389Standard Deviation7.6043695848 552Sample Variance503.8034482759Sample Variance57.8264367816 603Kurtosis-0.579373534Kurtosis6.8107764777 603Skewness-0.5619977673Skewness2.5912438492 623Range80Range32 643Minimum20Minimum0 673Maximum100Maximum32 753Sum2121Sum181 773Count30Count30 773Confidence Level(95.0%)8.381312214Confidence Level(95.0%)2.8395182691 785 805 805 836 836 856 906 906 946 9510 9712 10015 10030 10032 What is the probability that each event occurs in each of the two variables. Q1 Stress Level Number of Sick Days TakenStress Level Number of Sick Days 200 310Mean70.7Mean6.0333333333 350Standard Error4.0979809999Standard Error1.3883615857 400Median77Median3 411Mode100Mode3 502Standard Deviation22.4455663389Standard Deviation7.6043695848 522Sample Variance503.8034482759Sample Variance57.8264367816 552Kurtosis-0.579373534Kurtosis6.8107764777 603Skewness-0.5619977673Skewness2.5912438492 603Range80Range32 623Minimum20Minimum0 643Maximum100Maximum32 673Sum2121Sum181 753Count30Count30 773Confidence Level(95.0%)8.381312214Confidence Level(95.0%)2.8395182691 773 785 805 805 836 836 856 906 906 946 9510 9712 10015 10030 10032 What is the best estimate of the population mean Stress Level Mean - 70.7 Number of Sick Days Mean - 6.034 Q2 Stress Level Number of Sick Days TakenStress Level Number of Sick Days 200 310Mean70.7Mean6.0333333333 350Standard Error4.0979809999Standard Error1.3883615857 400Median77Median3 411Mode100Mode3 502Standard Deviation22.4455663389Standard Deviation7.6043695848 522Sample Variance503.8034482759Sample Variance57.8264367816 552Kurtosis-0.579373534Kurtosis6.8107764777 603Skewness-0.5619977673Skewness2.5912438492 603Range80Range32 623Minimum20Minimum0 643Maximum100Maximum32 673Sum2121Sum181 753Count30Count30 773Confidence Level(95.0%)8.381312214Confidence Level(95.0%)2.8395182691 773 785 805 805 836 836 856 906 906 946 9510 9712 10015 10030 10032 Q3 Interpret the confidence interval. Stress level Interpretation - The 95% confidence interval for stress level of participants is between 62.6679559 and 78.7320441 on a scale from 1-100 rating. The 90% confidence interval for stress level of participants is between 59.6107592 and 81.7892408 on a scale from 1-100 rating. The 98% confidence interval for stress level of participants is between 54.9930509 and 86.4069491 on a scale from 1-100 rating. Number of SIck Days Interpretation - The 95% confidence interval for the number of sick days is between 3.31294354 and 8.75505646 The 90% confidence interval for the number of sick days is between 3.75025619 and 8.31774381 The 98% confidence interval for the number of sick days is between 2.79927319 and 9.26872681