Question

Create two frequency tables based on two separate questions from your survey. Create a bar graph and a pie chart based on the data in the frequency tables. Determine the class intervals and create frequency distribution for each of the frequency tables. Create one frequency polygon of the data from the frequency distribution.

please data collected (time stamp with 3 multiple choice questions)

Timestamp   If given the opportunity would you work from home?   Do you consider working from home more of a employee convenience or employer benefit?   Who benefits more from the "Work from Home" opportunity?
8/11/2019 11:24:03   Maybe   Employee Convenience   Employee
8/11/2019 11:26:37   Maybe   Employee Convenience   Employee
8/11/2019 12:14:33   Maybe   Employee Convenience   Employee
8/11/2019 14:07:45   Maybe   Employee Convenience   Employer
8/11/2019 20:01:33   Maybe   Employee Convenience   Employee
8/12/2019 23:30:00   Maybe   Employee Convenience   Employee
8/14/2019 15:21:15   Maybe   Employee Convenience   Employee
8/14/2019 21:13:15   Maybe   Employee Convenience   Employee
8/14/2019 13:50:32   No   Employer Benefit   Employer
8/11/2019 11:21:21   Yes   Employee Convenience   Employee
8/11/2019 11:22:28   Yes   Employer Benefit   Employer
8/11/2019 11:29:04   Yes   Employee Convenience   Employee
8/11/2019 11:36:23   Yes   Employer Benefit   Employee
8/11/2019 11:36:55   Yes   Employee Convenience   Employee
8/11/2019 11:43:05   Yes   Employee Convenience   Employee
8/11/2019 11:59:13   Yes   Employer Benefit   Employee
8/11/2019 12:22:02   Yes   Employer Benefit   Employer
8/11/2019 12:39:02   Yes   Employee Convenience   Employee
8/11/2019 12:47:51   Yes   Employee Convenience   Employee
8/11/2019 13:12:20   Yes   Employee Convenience   Employer
8/11/2019 13:49:33   Yes   Employer Benefit   Employer
8/11/2019 15:16:18   Yes   Employer Benefit   Employer
8/11/2019 18:55:11   Yes   Employer Benefit   Employer
8/11/2019 19:07:52   Yes   Employer Benefit   Employer
8/11/2019 20:03:24   Yes   Employer Benefit   Employer
8/11/2019 21:38:25   Yes   Employer Benefit   Employer
8/12/2019 5:52:13   Yes   Employer Benefit   Employer
8/12/2019 6:56:04   Yes   Employee Convenience   Employee
8/12/2019 12:16:08   Yes   Employer Benefit   Employer

Answer 1

procedure:
select data -> pivot table ->
drag variable under row
drag variable under values

select table -> insert -> chart -> bar chart/pie chart

analysis

1)

Row Labels	Count of If given the opportunity would you work from home?
Maybe	8
No	1
Yes	20
Grand Total	29

2)

Row Labels	Count of Do you consider working from home more of a employee convenience or employer benefit?
Employee Convenience	16
Employer Benefit	13
Grand Total	29