Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

  1. 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:
    1. bar chart of the population by region over the years using "YEAR" as the slicer;
    2. line graph of houses built over the years using "category" as a slicer and;
    3. cluster column chart showing year-on-year changes in the number of houses built. The slicer at (ii) above should work with this.
  2. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Physics For Scientists And Engineers With Modern Physics

Authors: Raymond A Serway, John W Jewett

10th Edition

133767172X, 9781337671729

More Books

Students also viewed these Mathematics questions

Question

8. What values do you want others to associate you with?

Answered: 1 week ago