Question
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
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. Start at 0 and use a bin of 6, with equal ranges, starting from 154000. 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.
Rubric
Item | Points |
All named ranges created | 1 |
Descriptive statistics for 2010 | 1 |
Named ranges used for all formulas | 5 |
Histogram bin and output are created | 2 |
Rank and percentile done | 1 |
Total | 10 |
ZOOM + Civilian workforce Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Jan 153484 153263 154381 155703 155352 157030 158342 159847 161068 103142 164608 Feb 153694 153214 154871 155312 155483 156844 158653 150767 161783 163047 164546 Mar 153954 153378 154740 155005 156028 156843 150103 160066 161684 162935 162913 Apr 154822 153543 154545 155304 155360 157060 158981 160309 161742 162546 156481 May 154091 153470 154866 155536 155684 157851 158787 160060 161874 162782 158227 Jun 153616 153346 155083 155749 155707 157002 158973 160232 162269 163133 159932 Jul 153691 153288 154948 155500 156007 156997 150123 160330 162173 163373 159870 Aug 154086 153780 154783 155605 158130 157172 150570 160600 161768 163894 160838 Sep 153975 154131 155100 155687 158040 156733 159817 161212 162078 184051 160143 Oct 153635 153981 155554 154673 156417 157167 159734 160378 162005 164401 160887 Nov 154125 154128 155338 155285 158494 157463 150551 160510 162862 184347 160467 Dec 153650 153095 155628 155182 158332 158035 159710 160538 163111 164558 163029 ZOOM + Civilian workforce Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Jan 153484 153263 154381 155703 155352 157030 158342 159847 161068 103142 164608 Feb 153694 153214 154871 155312 155483 156844 158653 150767 161783 163047 164546 Mar 153954 153378 154740 155005 156028 156843 150103 160066 161684 162935 162913 Apr 154822 153543 154545 155304 155360 157060 158981 160309 161742 162546 156481 May 154091 153470 154866 155536 155684 157851 158787 160060 161874 162782 158227 Jun 153616 153346 155083 155749 155707 157002 158973 160232 162269 163133 159932 Jul 153691 153288 154948 155500 156007 156997 150123 160330 162173 163373 159870 Aug 154086 153780 154783 155605 158130 157172 150570 160600 161768 163894 160838 Sep 153975 154131 155100 155687 158040 156733 159817 161212 162078 184051 160143 Oct 153635 153981 155554 154673 156417 157167 159734 160378 162005 164401 160887 Nov 154125 154128 155338 155285 158494 157463 150551 160510 162862 184347 160467 Dec 153650 153095 155628 155182 158332 158035 159710 160538 163111 164558 163029
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started