Question
Peter and Lois have decided to expand the business because they are convinced that there will be a house building explosion in the next few
Peter and Lois have decided to expand the business because they are convinced that there will be a house building explosion in the next few years and kitchen sales will skyrocket. Stewie is not convinced and has obtained data from the Office of National Statistics (ONS) that likely correlates with kitchen sales: UK population growth and houses built in the past ten years statistics. Stewie is convinced that this data should have been used in his parents' decision to expand the business, as such, the data should be appropriately collated and presented.
Your are required to:
- Using spreadsheets: "Data-Population" and "Data-Houses Built" in the assignment workbook; create an interactive dashboard on the partially completed "Dashboard" worksheet to include a:
- bar chart of the population by region over the years using "YEAR" as the slicer;
- line graph of houses built over the years using "category" as a slicer and;
- cluster column chart showing year-on-year changes in the number of houses built. The slicer at (ii) above should work with this.
- In your report, explain ways in which the directors could have used the data to make the decision to expand a more scientific/empirical approach. Using the data and other pertinent social, economic, technical and political events to critically assess whether the directors are correct in their assertion that kitchen sales will grow in the next few years.
Table 1.1: Data-Population
Population estimates for Government Office Regions (GOR), by single year of and sex, 2010 to mid-2020 | ||||||
Year | Regions | All Persons | All Males | All Females | ||
2010 | North East | 2,586,868 | 1,263,696 | 1,323,172 | ||
2010 | North West | 7,019,921 | 3,446,551 | 3,573,370 | ||
2010 | Yorkshire and The Humber | 5,254,788 | 2,582,634 | 2,672,154 | ||
2010 | East Midlands | 4,507,071 | 2,221,698 | 2,285,373 | ||
2010 | West Midlands | 5,565,866 | 2,743,229 | 2,822,637 | ||
2010 | East | 5,807,402 | 2,855,503 | 2,951,899 | ||
2010 | London | 8,061,495 | 3,975,939 | 4,085,556 | ||
2010 | South East | 8,577,771 | 4,210,659 | 4,367,112 | ||
2010 | South West | 5,261,270 | 2,577,335 | 2,683,935 | ||
2011 | North East | 2,596,441 | 1,269,598 | 1,326,843 | ||
2011 | North West | 7,055,961 | 3,467,727 | 3,588,234 | ||
2011 | Yorkshire and The Humber | 5,288,212 | 2,601,969 | 2,686,243 | ||
2011 | East Midlands | 4,537,448 | 2,236,979 | 2,300,469 | ||
2011 | West Midlands | 5,608,667 | 2,767,260 | 2,841,407 | ||
2011 | East | 5,862,418 | 2,885,001 | 2,977,417 | ||
2011 | London | 8,204,407 | 4,053,962 | 4,150,445 | ||
2011 | South East | 8,652,784 | 4,251,422 | 4,401,362 | ||
2011 | South West | 5,300,831 | 2,599,244 | 2,701,587 | ||
2012 | North East | 2,602,387 | 1,273,228 | 1,329,159 | ||
2012 | North West | 7,084,470 | 3,483,782 | 3,600,688 | ||
2012 | Yorkshire and The Humber | 5,316,897 | 2,618,110 | 2,698,787 | ||
2012 | East Midlands | 4,567,798 | 2,251,991 | 2,315,807 | ||
2012 | West Midlands | 5,642,763 | 2,786,076 | 2,856,687 | ||
2012 | East | 5,905,914 | 2,905,789 | 3,000,125 | ||
2012 | London | 8,308,833 | 4,106,055 | 4,202,778 | ||
2012 | South East | 8,724,928 | 4,288,336 | 4,436,592 | ||
2012 | South West | 5,339,739 | 2,620,081 | 2,719,658 | ||
2013 | North East | 2,610,563 | 1,278,374 | 1,332,189 | ||
2013 | North West | 7,103,488 | 3,495,012 | 3,608,476 | ||
2013 | Yorkshire and The Humber | 5,337,940 | 2,630,036 | 2,707,904 | ||
2013 | East Midlands | 4,598,548 | 2,267,917 | 2,330,631 | ||
2013 | West Midlands | 5,675,030 | 2,803,779 | 2,871,251 | ||
2013 | East | 5,951,934 | 2,928,639 | 3,023,295 | ||
2013 | London | 8,417,458 | 4,165,752 | 4,251,706 | ||
2013 | South East | 8,793,154 | 4,323,843 | 4,469,311 | ||
2013 | South West | 5,377,702 | 2,640,617 | 2,737,085 | ||
2014 | North East | 2,618,736 | 1,283,116 | 1,335,620 | ||
2014 | North West | 7,133,026 | 3,511,220 | 3,621,806 | ||
2014 | Yorkshire and The Humber | 5,360,117 | 2,641,368 | 2,718,749 | ||
2014 | East Midlands | 4,637,369 | 2,288,061 | 2,349,308 | ||
2014 | West Midlands | 5,713,439 | 2,824,444 | 2,888,995 | ||
2014 | East | 6,017,250 | 2,962,149 | 3,055,101 | ||
2014 | London | 8,539,398 | 4,234,346 | 4,305,052 | ||
2014 | South East | 8,874,005 | 4,364,820 | 4,509,185 | ||
2014 | South West | 5,423,278 | 2,663,672 | 2,759,606 | ||
2015 | North East | 2,624,579 | 1,287,124 | 1,337,455 | ||
2015 | North West | 7,175,178 | 3,535,054 | 3,640,124 | ||
2015 | Yorkshire and The Humber | 5,390,211 | 2,658,196 | 2,732,015 | ||
2015 | East Midlands | 4,677,425 | 2,309,324 | 2,368,101 | ||
2015 | West Midlands | 5,755,032 | 2,846,808 | 2,908,224 | ||
2015 | East | 6,075,970 | 2,993,400 | 3,082,570 | ||
2015 | London | 8,666,930 | 4,305,606 | 4,361,324 | ||
2015 | South East | 8,949,392 | 4,405,125 | 4,544,267 | ||
2015 | South West | 5,471,610 | 2,688,649 | 2,782,961 | ||
2016 | North East | 2,636,589 | 1,293,982 | 1,342,607 | ||
2016 | North West | 7,223,961 | 3,563,196 | 3,660,765 | ||
2016 | Yorkshire and The Humber | 5,425,370 | 2,678,166 | 2,747,204 | ||
2016 | East Midlands | 4,725,390 | 2,335,322 | 2,390,068 | ||
2016 | West Midlands | 5,810,773 | 2,878,130 | 2,932,643 | ||
2016 | East | 6,129,005 | 3,021,335 | 3,107,670 | ||
2016 | London | 8,769,659 | 4,369,201 | 4,400,458 | ||
2016 | South East | 9,030,347 | 4,449,245 | 4,581,102 | ||
2016 | South West | 5,516,973 | 2,712,343 | 2,804,630 | ||
2017 | North East | 2,644,727 | 1,297,924 | 1,346,803 | ||
2017 | North West | 7,258,627 | 3,581,219 | 3,677,408 | ||
2017 | Yorkshire and The Humber | 5,450,130 | 2,690,510 | 2,759,620 | ||
2017 | East Midlands | 4,771,666 | 2,359,406 | 2,412,260 | ||
2017 | West Midlands | 5,860,706 | 2,904,272 | 2,956,434 | ||
2017 | East | 6,168,432 | 3,040,283 | 3,128,149 | ||
2017 | London | 8,825,001 | 4,398,848 | 4,426,153 | ||
2017 | South East | 9,080,825 | 4,474,409 | 4,606,416 | ||
2017 | South West | 5,559,316 | 2,734,182 | 2,825,134 | ||
2018 | North East | 2,657,909 | 1,305,486 | 1,352,423 | ||
2018 | North West | 7,292,093 | 3,598,698 | 3,693,395 | ||
2018 | Yorkshire and The Humber | 5,479,615 | 2,704,526 | 2,775,089 | ||
2018 | East Midlands | 4,804,149 | 2,375,362 | 2,428,787 | ||
2018 | West Midlands | 5,900,757 | 2,924,175 | 2,976,582 | ||
2018 | East | 6,201,214 | 3,055,520 | 3,145,694 | ||
2018 | London | 8,908,081 | 4,448,930 | 4,459,151 | ||
2018 | South East | 9,133,625 | 4,500,331 | 4,633,294 | ||
2018 | South West | 5,599,735 | 2,754,914 | 2,844,821 | ||
2019 | North East | 2,669,941 | 1,312,124 | 1,357,817 | ||
2019 | North West | 7,341,196 | 3,625,650 | 3,715,546 | ||
2019 | Yorkshire and The Humber | 5,502,967 | 2,717,432 | 2,785,535 | ||
2019 | East Midlands | 4,835,928 | 2,391,957 | 2,443,971 | ||
2019 | West Midlands | 5,934,037 | 2,941,291 | 2,992,746 | ||
2019 | East | 6,236,072 | 3,072,499 | 3,163,573 | ||
2019 | London | 8,961,989 | 4,475,817 | 4,486,172 | ||
2019 | South East | 9,180,135 | 4,523,939 | 4,656,196 | ||
2019 | South West | 5,624,696 | 2,767,122 | 2,857,574 | ||
2020 | North East | 2,680,763 | 1,317,749 | 1,363,014 | ||
2020 | North West | 7,367,456 | 3,640,348 | 3,727,108 | ||
2020 | Yorkshire and The Humber | 5,526,350 | 2,728,685 | 2,797,665 | ||
2020 | East Midlands | 4,865,583 | 2,407,678 | 2,457,905 | ||
2020 | West Midlands | 5,961,929 | 2,956,945 | 3,004,984 | ||
2020 | East | 6,269,161 | 3,089,445 | 3,179,716 | ||
2020 | London | 9,002,488 | 4,514,378 | 4,488,110 | ||
2020 | South East | 9,217,265 | 4,542,648 | 4,674,617 | ||
2020 | South West | 5,659,143 | 2,784,942 | 2,874,201 |
Table 1.2: -Data-Housing Built
Source: Office of National Statistics (ONS) | ||
HOUSE BUILDINGS COMPLETED IN ENGLAND 2010-2020 | ||
YEAR | CATEGORY | Completed Houses |
2010 | Private Enterprise | 83,280 |
2010 | Housing Association | 22,660 |
2010 | Local Authorities | 790 |
2010 | All Dwellings | 106,730 |
2011 | Private Enterprise | 85,890 |
2011 | Housing Association | 25,950 |
2011 | Local Authorities | 2,230 |
2011 | All Dwellings | 114,030 |
2012 | Private Enterprise | 88,750 |
2012 | Housing Association | 25,440 |
2012 | Local Authorities | 1,410 |
2012 | All Dwellings | 115,590 |
2013 | Private Enterprise | 87,010 |
2013 | Housing Association | 21,600 |
2013 | Local Authorities | 840 |
2013 | All Dwellings | 109,450 |
2014 | Private Enterprise | 92,850 |
2014 | Housing Association | 23,790 |
2014 | Local Authorities | 1,180 |
2014 | All Dwellings | 117,820 |
2015 | Private Enterprise | 110,700 |
2015 | Housing Association | 30,130 |
2015 | Local Authorities | 1,660 |
2015 | All Dwellings | 142,480 |
2016 | Private Enterprise | 115,350 |
2016 | Housing Association | 24,430 |
2016 | Local Authorities | 2,110 |
2016 | All Dwellings | 141,880 |
2017 | Private Enterprise | 133,460 |
2017 | Housing Association | 27,290 |
2017 | Local Authorities | 1,750 |
2017 | All Dwellings | 162,470 |
2018 | Private Enterprise | 135,190 |
2018 | Housing Association | 27,550 |
2018 | Local Authorities | 2,680 |
2018 | All Dwellings | 165,420 |
2019 | Private Enterprise | 144,080 |
2019 | Housing Association | 32,040 |
2019 | Local Authorities | 2,190 |
2019 | All Dwellings | 178,300 |
2020 | Private Enterprise | 114,542 |
2020 | Housing Association | 27,248 |
2020 | Local Authorities | 1,040 |
2020 | All Dwellings | 142,830 |
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