Question

		Responses to mean number of hours a college student works per week
S/N	Response_id	Age	Gender	Employment Status	Work Hours
1	164405	37	Female	Part Time	10
2	164417	21	Male	Part Time	10
3	164419	19	Female	Part Time	35
4	164430	19	Female	Part Time	30
5	164457	34	Female	Unemployed	0
6	164545	20	Female	Part Time	19
7	164573	23	Female	Full Time	36
8	164609	18	Female	Part Time	13
9	164685	19	Female	Unemployed	0
10	164769	21	Male	Part Time	32
11	164946	20	Female	Part Time	25
12	165016	33	Female	Unemployed	0
13	165056	30	Female	Unemployed	0
14	165345	21	Female	Unemployed	0
15	165417	21	Male	Part Time	20
16	165440	21	Female	Part Time	15
17	165469	33	Female	Full Time	37.5
18	165473	19	Female	Part Time	30
19	165505	19	Female	Part Time	20
20	165638	32	Female	Unemployed	0
21	165793	56	Male	Full Time	40
22	165932	21	Female	Unemployed	0
23	166105	41	Male	Full Time	50
24	166209	19	Female	Part Time	30
25	166216	33	Female	Full Time	37.5
26	166389	38	Female	Part Time	20
27	166391	18	Female	Part Time	25
28	166397	33	Female	Full Time	37.5
29	166415	37	Male	Full Time	40
30	166416	25	Female	Unemployed	0

30 college students were surveyed and the following data was recorded for each respondent: Response_id, Age, Gender, Employment status, Work Hours. This data is listed in an Excel file that is provided. You are required to analyze this data then summarize your findings in a Report. The report will be read by people who may not be familiar with statistical terms. Therefore, it is important that your report be written in a manner that could be understood by people of varying statistical knowledge. The final report is to be submitted to your professor on the due date.

Frequency Distribution (table)

1. Create a frequency distribution for one of the Qualitative variables from (1) above:

   • Create a graph based on your frequency distribution table

   • Summarize your results in 1 -2 sentences.

2. Create a frequency distribution for the variable in excel, Age

   • Use 5 classes, with a class width of 10. The Upper Class limit of the first class should be 16.

   • Draw a histogram and Ogive based on your table. Comment on the shape of the distribution

   • Now add a relative frequency column and a cumulative relative frequency column.

   • Summarize your frequency table with 2-3 sentences.

Answer 1

Summary statistics about the data

Find the statistics using the formulas shown in the introduction of the report.

Finding the distribution of work hours

Put the data as shown and perform the following steps

Highlight the interval and frequency and insert the graph as shown below

From the graph, we see that 1/3 of the students work for less than 10 hours. However an about 8 students work for 30-40 hours per week.

Finding the distribution of age
Using the method described above the required things are shown below along with the formulas.

We were unable to transcribe this image

We were unable to transcribe this image

Review View Get Add-ins Insert Draw Page Layout Formulas Data na Ef Online Pictures 3D Models To Shapes SmartArt mmended Table Pictures otTables Icons @Screenshot bles Illustrations ? Developer Help d ? Recommended Charts a li tn till Maps PivotChart My Add-ins 3D Map Tours Line Column Win/ Loss Sparklines Add-ins Charts x fc 0 - 10 D E F G H I J K L M N O Frequency distribution for work hours We see that the min work hours is O and the max is 50 hence we make 5 classes of interval 10 as follows Next we count the number of observation that fall in each class Frequency Frequency of work hours C Work Hours - Class Inter Interval 1 Interval 1 Interval 4 Interval 3 Interval 1 Interval 2 Interval 4 Interval 2 Interval 1 Interval 4 Interval 3 Interval 1 Interval 1 Interval 1 Interval 2 Interval 2 Interval 4 Interval 3 Interval 2 Interval 1 Interval 4 Interval 1 Interval 2 Interval 3 Interval 4 Interval 5 Dju. Interval 0 - 10 11- 20 21 - 30 31 - 40 41-50 0-10 11-20 21-30 31-40 41-50

L M N O | B CDE Age We see that min age is 18 and max age is 56 hence we make 5 classes of interval 10 as follows Next we count the number of observation that fall in each class | Interval Frequency 0 - 160 17 - 26 18 27 - 36 37 - 46 47 - 56 Total Relative Frequency 0/30 0.00% 18/30 60.00% 7/30 23.33% 4/30 13.33% 1/30 3.33% Cummulative Frequency 0 0+18 18 18+7 25+4 29+1 25 30 30 Age Ogive - Age 0-16 17 - 26 27-36 3 7-46 47-56 0-16 17-26 27 - 36 37-46 47-56