This data shows national monthly civil employment statistics from January 2010 through December 2020. Numbers are in thousands.

1- Create named ranges for civil employment numbers of each year.

2- Use the Excel descriptive statistics tool. Create output for year 2010. Start the output from cell Q5.

3- Use only named ranges to create the following:

* Cell Q22: Difference between average monthly employment numbers of 2020 and 2019

* Cell Q23: Standard deviation of monthly numbers in year 2015

* Cell Q24: Count the data points of year 2020

* Cell Q25: Maximum employment number of year 2020

* Cell Q26: Minimum employment number of year 2020

4- Use Excel histogram tool. Create a histogram for all observations in this data set. Use a bin of 6, equally incremented. Create the bin numbers in column "O" starting from cell O5. Start the output range from cell A28.

5- Use Excel Rank and Percentile tool to rank the employment numbers of August for all 11 years. Start the output from cell D40.

Civilian workforce Year Jan Feb Mar May Jun Jul Sep Oct Nov Dec 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 153484 153263 154381 155763 155352 157030 158342 159647 161068 163142 164606 153694 153214 154671 155312 155483 156644 158653 159767 161783 163047 164546 153954 153376 154749 155005 156028 156643 159103 160066 161684 162935 162913 Apr 154622 153543 154545 155394 155369 157060 158981 160309 161742 162546 156481 154091 153479 154866 155536 155684 157651 158787 160060 161874 162782 158227 153616 153346 155083 155749 155707 157062 158973 160232 162269 163133 159932 153691 153288 154948 155599 156007 156997 159123 160339 162173 163373 159870 Aug 154086 153760 154763 155605 156130 157172 159579 160690 161768 163894 160838 153975 154131 155160 155687 156040 156733 159817 161212 162078 164051 160143 153635 153961 155554 154673 156417 157167 159734 160378 162605 164401 160867 154125 154128 155338 155265 156494 157463 159551 160510 162662 164347 160467 153650 153995 155628 155182 156332 158035 159710 160538 163111 164556 163029 Civilian workforce Year Jan Feb Mar May Jun Jul Sep Oct Nov Dec 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 153484 153263 154381 155763 155352 157030 158342 159647 161068 163142 164606 153694 153214 154671 155312 155483 156644 158653 159767 161783 163047 164546 153954 153376 154749 155005 156028 156643 159103 160066 161684 162935 162913 Apr 154622 153543 154545 155394 155369 157060 158981 160309 161742 162546 156481 154091 153479 154866 155536 155684 157651 158787 160060 161874 162782 158227 153616 153346 155083 155749 155707 157062 158973 160232 162269 163133 159932 153691 153288 154948 155599 156007 156997 159123 160339 162173 163373 159870 Aug 154086 153760 154763 155605 156130 157172 159579 160690 161768 163894 160838 153975 154131 155160 155687 156040 156733 159817 161212 162078 164051 160143 153635 153961 155554 154673 156417 157167 159734 160378 162605 164401 160867 154125 154128 155338 155265 156494 157463 159551 160510 162662 164347 160467 153650 153995 155628 155182 156332 158035 159710 160538 163111 164556 163029