Part 1–Fearless
It is early 2019, and Fearless Breweries isa household name in the pub industry in England and Wales. Fearless operates a network of pubs, restaurants, off-licenses and other outlets. After a challenging few years, in which the company was largely written off by industry experts, the company was rebranded in 2016, and is now considered one to watch. In an effort to improve the selection of sites for Fearless pubs in the future, the company has been analysing data from its existing pubs in an attempt to understand the main determinants of cost and revenue. The Excel file Fearless.xls contains details of revenues for the past year (Revenue), measured in £millions, for 47 of Fearless’s pubs. The other variables relate to data currently available at head office. This includes information on management (Management) and staff quality (Staff), both on 9 point scales (with 9 being very good and 1 being very poor); a measure of local per capita annual income (Local Income) measured in £000s; and an index of competitor density (Competition) measured in number of pubs within 2 miles of the site. There is also a dummy variable (Modern Type), indicating the type of establishment. A value of 1 for Modern Type indicates that the pub has a modern or unusual theme/ambience, and a value of 0 indicates that the pub is of a conventional type. Lastly, there is a variable (Location) that indicates the approximate location of the pub. For this variable, values of 1, 2, 3, 4 and 5 represent the midlands, north, east, south and west, respectively.
(a) Develop a regression model for revenue using the variables available. In your report, make sure to describe your modelling process, and to interpret your final model. (25marks)
(b) Described below are the details of two sites, which have been offered to Fearless. Which, if either, would you recommend the company should b
