2 tables  one quartile boxlot and 2 pie charts 

Maths for Business
INU0111
Semester 2
Project

Deadline:

Tuesday March 24th – 12:00 noon

2 | P a g e

Aims of the Project

The aim of this project is to explore the price of properties for sale in two areas

of Newcastle upon Tyne. You are to write a report comparing the properties

available and their prices for two specific areas of Newcastle upon Tyne. You

are expected to use the statistical methods that you are learning on your

course.

Background

Newcastle upon Tyne, like many major cities, grew up from separate, small

villages. Centuries ago, the River Tyne had a town called Newcastle around

the “new castle” built by the Normans and there were settlements outside this

now known as Walker, Byker, Wallsend (where Hadrian’s Wall ended),

3 | P a g e

Gosforth, Jesmond and many others. When the Industrial Revolution came to

the North-East, Newcastle became a centre for coal exports, shipbuilding (on

the River Tyne from Wallsend to Walker and up the river at Scotswood and

Elswick) and other “heavy” industry. Indeed, the river became the most

important resource the area had. Even today, Geordies are very attached to

“their” river.

With all the heavy industry came a workforce. In a time when public transport

was limited, workers lived near their place of work. In very simple terms,

properties near the river were built to house the workers and areas away from

the river grew up to house those who were better off. Most of the heavy

industry has gone now but many of the properties remain. The sometimes-

narrow cramped streets and often small terraced properties of Walker,

Wallsend and Byker are a reminder of those days.

Jesmond (about 2km north of the river) and Gosforth (a little further north)

grew up away from the heavy industry. This was where the people with wealth

lived. Some streets (such as Mitchell Avenue in Jesmond or Elmfield Road in

Gosforth) still contain very expensive properties dating from the late 1890’s

and early 1900’s. Elsewhere in Jesmond and Gosforth, prices never quite reach

these levels but are much higher than the sites where heavy industry once

housed its workforce.

4 | P a g e

Types of Properties

Properties in the UK come in many shapes and sizes. There are detached

properties in their own grounds and semi-detached, which share a central wall

with another house. There are also terraced houses (a row of properties).

Then there are bungalows (just a ground floor, no upstairs) and apartments

(part of a block). There are also properties called Tyneside flats. These are

(usually) a terraced house divided so that someone lives upstairs and someone

lives downstairs (and they have separate front doors). There are other types

too, so be very careful in your categorisation.

Terraced
Houses

Tyneside Flat

Detached
House

Semi-detached
House

Block of flats Bungalow

Apartment Block

5 | P a g e

How to tackle this project…?

You need to write a report. You must choose ONE location from each area and

collect data on prices of houses, number of bedrooms in each house and type

of each house. You will need to create a table of data with column headings

that look like this:

Area A

Street Number of Bedrooms Type of House Price

Repeat for Area B

The first thing you are going to have to do is to collect some data.

Have a look at the map on the page 2.

The areas outlined in blue dashes (Area A: Jesmond and Gosforth) and red

dots (Area B: Wallsend, Walker and Byker) are the places you are looking for

data. There are newspapers that contain information about properties for

sale. HOWEVER, the simplest way to find data is to use ESTATE AGENTS’

websites.

Make a note of where you obtained your data because you will need to

reference it.

You need at least 30 properties from each area (at least 60 in total) for this

project. However, between 50 and 100 properties from each area would be

better. Try to make the sample REPRESENTATIVE of the population of all the

properties available in the two areas that you have chosen. Do not just choose

many 3-bedroom semi-detached properties (even though there are a lot of

these about). Also, do not just choose the first few properties on a website, as

they may be the most expensive or least expensive properties available.

6 | P a g e

The best way to create your table of data is to use Microsoft Excel. When you

have collected all your data, print off a full list sorted so the most expensive

properties are at the top of the list and the cheapest is at the bottom.

Explaining what you are doing and why is important.

Break your data up now into the two areas, A and B.

What types of properties are available in these two areas or how many

properties are there with 1, 2, 3, etc. bedrooms? You will need to make a

comparison between the two areas. Consider using tables, graphs and

comments.

Considering all the data for each area calculate some statistics. Find the

measures for the centre and for the spread of the prices. Display your two sets

of data graphically. Now make some comment about what you have found.

Do not just “do statistics”; analyse them.

You could now break your data up into smaller categories. For example, draw

graphs to show the prices of 2-bedroom properties in the 2 areas, then for the

3-bedroom properties (or detached properties, or semi-detached properties).

Drawing conclusions and using the statistics that you have calculated is an

important skill. Top marks can be obtained by writing between 1000 and

1500 words.

The Project will be marked out of 100 according to the

following criteria:

 Introduction and methodology to the project (20 Marks) 

 Data Collection (10 Marks) 

 Presenting data in an appropriate form (15 Marks) 

 Statistical analysis (15 Marks) 

7 | P a g e

 Discussion (20 Marks)

 Conclusions (10 Marks) 

 Report Layout (10 Marks)

For further details, please see Blackboard.

Additional Advice.

 Write this in the style of a report.

 You covered this in Study Skills!

 Include a front cover with a suitable title and your name.

 Write a brief introduction saying what you are doing and what you hope

to find.

 Discuss where you got your data. Together with this, you need to say

how you chose your sample of properties.

 Provide data in tables.

 Calculation of and comments on relevant statistics are expected.

 Graphs should be used to compare the data sets.

 The conclusion should be factual and fully supported by the evidence

that you have collected.

 Include an accurate and comprehensive list of your sources.

Submitting the project

You must submit your project by 12:00 noon on Monday March 23rd. You must

upload your project to Turnitin using Blackboard. You do NOT need to hand

in a paper copy of your project. Late submissions are liable to be penalised. If

you have any problems, you must contact either Adrian or Yvonne by email

before the submission time:

adrian.shepherd@newcastle.ac.uk yvonne.wancke@newcastle.ac.uk

mailto:adrian.shepherd@newcastle.ac.uk

mailto:yvonne.wancke@newcastle.ac.uk

2

>

Jesmond

Jesmond

2

Street

Type

No. of bedrooms

Price (£)

Detached

Number of Bedrooms

Frequency

Semi-detached

1

Terraced

Flat

3

Bungalow

4

5

Mean

Median

Mode

Standard deviation

Byker

Byker

Street Type No. of bedrooms Price (£)
Detached Number of Bedrooms Frequency
Semi-detached 1
Terraced 2
Flat 3
Bungalow 4
5

Mean
Median
Mode
Standard deviation

Sheet3

04/03/2020

1

Maths for Business – INU0111/0511

Project

Maths for Business – INU0111/0511

Deadline

12:00 noon

Tuesday

March 24th 2020

Maths for Business – INU0111/0511
Project

• The project looks at the price of houses in Newcastle.
– i.e. How much it would cost to BUY a property

• Because there are many areas of the city, you must
concentrate on only 2 areas.

• You are to compare and comment on the similarities
and differences in the prices of houses in the two
locations.

Maths for Business – INU0111/0511

In this Project you will. . .

1. . . . collect appropriate data that can be used to . . .

2. . . . carry out a statistical analysis of house prices in
two areas of Newcastle upon Tyne and to . . .

3. . . . write a report that presents the analysis in words
and graphs and to . . .

4. . . . draw conclusions.

Maths for Business – INU0111/0511

History
• Newcastle upon Tyne grew up from separate, small settlements

• Centuries ago, the River Tyne had a town called Newcastle around the
“new castle” built by the Normans

– there were communities outside now known as Walker, Byker, Wallsend (where
Hadrian’s Wall ended), Gosforth, Jesmond and many others

• The Industrial Revolution came to the North-East, Newcastle became a
centre for coal exports, shipbuilding and other “heavy” industry on the
River Tyne from Wallsend and Walker to Scotswood and Elswick.

Maths for Business – INU0111/0511

History – continued

• With the heavy industry came a workforce

• Public transport was limited
– workers lived near their place of work

• In very simple terms
– houses near the river were built to house the workers

• Areas away from the river grew up to house those who were better off
– Often those who owned the businesses

• Most of the heavy industry has gone now
– but some of the houses remain – often small terraced houses of Walker,

Wallsend and Byker are a reminder of those days

04/03/2020

2

Maths for Business – INU0111/0511

 Jesmond (about 2km north of the river) and Gosforth (a
little further north) grew up away from the heavy industry

 People with wealth lived here.
 Some streets (such as Mitchell Avenue in Jesmond or Elmfield Road

in Gosforth) still contain very expensive houses dating from the late
1890’s and early 1900’s

 Elsewhere in Jesmond and Gosforth, prices never quite
reach these levels
 but are much higher than the sites where heavy industry once

housed its workforce.

History – continued
Maths for Business – INU0111/0511

The Areas to look at…

Maths for Business – INU0111/0511

House Prices

• What affects the price of a house?
– Type
– Size

•Number of bedrooms

– Location
•You needs to choose ONE location from each Area

Maths for Business – INU0111/0511

Houses in the UK come in many shapes and sizes.

There are detached houses in their own grounds.

Semi-detached which share a central wall with another house and
terraced (a row of houses).

Then there are bungalows (just a ground floor, no upstairs) and
apartments (part of a block).

There are also houses called Tyneside flats. These are (usually) a
terraced house divided so that someone lives upstairs and someone
lives downstairs (and they have separate front doors).

Types of Houses

Maths for Business – INU0111/0511
Types of Houses

Terraced
Houses

Tyneside
Flat

Detached
House

Semi-detached House

Block of flatsBungalow

Apartment Block

Maths for Business – INU0111/0511

Hypothesis

Houses in Area A are . . . . . . . than houses in

Area B

 A = Gosforth or Jesmond
 B = Wallsend, Walker or Byker

Houses in Gosforth are . . . . . . . . . . . than houses in Byker

. . . for example . . .

http://images.icnetwork.co.uk/upl/icnewcastle/jun2008/4/1/5E1FE988-D657-F110-AB7F71C22E1EFFA1

http://images.google.co.uk/imgres?imgurl=http://img.dailymail.co.uk/i/pix/2008/01_03/DetachedHomeL_468x299 &imgrefurl=http://www.dailymail.co.uk/news/article-508113/Detached-house-prices-plummet-270-day-property-market-enters-slowdown.html&usg=__CW_0yu-eygukb8vfn9MVRFmslEQ=&h=299&w=468&sz=43&hl=en&start=2&tbnid=GkYDa7-SCgqttM:&tbnh=82&tbnw=128&prev=/images?q=Detached+House&gbv=2&hl=en&sa=G

http://images.google.co.uk/imgres?imgurl=http://www.neverpaintagain.co.uk/articleimage.php?id=111&imgrefurl=http://www.neverpaintagain.co.uk/article/The-Rise-of-the-semi-detached-house&usg=__yUcbIqmVm-OIZsYteCY-Gbjo0zg=&h=216&w=288&sz=22&hl=en&start=28&tbnid=oJN_CfqCeVBdSM:&tbnh=86&tbnw=115&prev=/images?q=semi-detached+House&start=20&gbv=2&ndsp=20&hl=en&sa=N

http://static.flickr.com/91/247796015_60db03bf84

http://images.google.co.uk/imgres?imgurl=http://www.littlekings.co.uk/images/bungalow &imgrefurl=http://www.littlekings.co.uk/bungalow.shtml&usg=__3PtBPEFj61Lfj63It_gPto808Kg=&h=329&w=450&sz=19&hl=en&start=4&tbnid=wTH77TgkneueEM:&tbnh=93&tbnw=127&prev=/images?q=Bungalow&gbv=2&hl=en&sa=G

04/03/2020

3

Maths for Business – INU0111/0511

Which Area?

You need to choose:

Either Gosforth or Jesmond from

Area A

And

Either Byker, Walker or Wallsend from Area B

Maths for Business – INU0111/0511

Collecting data…
You could obtain your data:

• From “The Journal” on Saturday

• By asking estate agents for their in-house magazines

– Estate agents specialise in different areas.

But it is much easier

• to visit estate agents’ websites.

– These can give you lots of raw data

• . . . www.rightmove.co.uk

Maths for Business – INU0111/0511

Creating your tables…Organising your data

Street Number of Bedrooms Type of House Price

The Drive 5 Semi-detached £675,000

Area A = Jesmond or Gosforth

Area B = Wallsend, Walker or Byker

For each area a table like this may be helpful as you start to sort out the raw data

Remember that you will need one
table for each area.

At least 30 houses from each area. 50 to 100 houses from each would be better!

Area AArea BGosforth

Maths for Business – INU0111/0511

All your data . . .

You need to compare the whole set of data for the two areas.

Maths for Business – INU0111/0511

Breaking your data up..

• When you are done with the whole of Area A and Area B,
start looking at the categories.

• Look at the prices of houses by number of bedrooms and
create boxplots for 2, 3, 4, more than 4 bedrooms where
appropriate

• You can compare within each area and between each area

Maths for Business – INU0111/0511

Another possible hypothesis?

There is a link between the price of a house and . . .

http://www.rightmove.co.uk/

04/03/2020

4

Maths for Business – INU0111/0511

Analysing your data…

Note that you have quantitative data, which is discrete, (measured in £).

Consider the types of charts and graphs that we have used.

Which is most suitable?

Can you use boxplots? Is this a good way to communicate information?

What others are useful? Histograms?

How do you compare two sets of data, e.g. 3 bedroom houses in Jesmond with
3 bedroom houses in Walker.

Maths for Business – INU0111/0511
Analysing your data…

What types of calculations are you going to do?

• To show the centre of the data? The middle or measure of location?

•To show the spread or the measure of dispersion of the data?

Maths for Business – INU0111/0511

Remember . . . .

Whose data is it?

Use Excel and Geogebra

Maths for Business – INU0111/0511

Using Excel…

Draw your boxplots using Geogebra, Excel 2016 or any
other Statistical software

Choose appropriate scales.

Mean: = AVERAGE(D1:D60)

Median: = MEDIAN(D1:D60)

Standard Deviation: =STDEV.P(D1:D60)

Maths for Business – INU0111/0511

Presenting your data…

Do not just present lots of bar charts, pie charts and boxplots.

You need TABLES with medians, inter-quartile ranges, means and standard
deviations.

Maths for Business – INU0111/0511

Presenting your data…
Find the Median and the Quartile positions for the two areas
using ALL your data. Then present this data as two boxplots….

50000 100000 150000
200000 250000

House Prices
Area A
Area B

04/03/2020

5

Maths for Business – INU0111/0511

What you need to include …
• A front cover with a title and your name.

• An introduction to say what you expect to find from your observations
of the areas and a brief background of the chosen areas.

• A discussion of where you got your data from.

• A discussion about how you chose your data.

• Tables of data.

• Charts or graphs

• A discussion of what you have found.

• Conclusions about the house prices in the two areas.

• A list of raw data as an appendix.
Maths for Business – INU0111/0511

Write a REPORT

Maths for Business – INU0111/0511

Email :
adrian.shepherd@newcastle.ac.uk

yvonne.wancke@newcastle.ac.uk

Maths for Business – INU0111/0511

Now . . .

You need to
. . . Collect
Some Data

How?

From
Where?

mailto:adrian.shepherd@newcastle.ac.uk

mailto:yvonne.wancke@newcastle.ac.uk

Maths Project

By the end of this seminar you will have
Collected a sample of 30 houses from Area A
Considered how to make progress with your maths project

Objectives

Go to www.socrative.com
Type your name
The room is YW
Answer the questions

Quick Quiz
Check what you know
Sampling

You will compare house prices in 2 areas of Newcastle.
You will select a sample of at least 30 houses from each area
Area A : Gosforth or Jesmond
Area B : Walker, Byker or Wallsend
Choose one from each area

Maths Project

You will collect a sample of 30 houses from Jesmond
You will use a website e.g. Rightmove

You will add your sample to an Excel spreadsheet
You should email this to Yvonne for checking

Collecting Data

Take a photo

You need to collect a sample of 30 houses
You may have a population of 300+ houses
How will you choose?
Discuss with your partner

Choosing your Sample

Demonstrate

Types of Houses
Take a photo
Detached
Semi- detached
Terraced
Bungalow
Flat/Apartment

Collect a sample of 30 houses prices from either Jesmond or Gosforth
If you have time today…..
Collect a sample of 30 houses prices from either Byker or Walker
Enter the data onto your spreadsheet (I have emailed a template to you)
Collecting your Data
Support

Independent Work
Your task
Finish collecting your data
Work on the rest of your project

Writing your introduction & methodology

Introduction
Background of the 2 areas
Hypothesis stated

Background : Jesmond
Where is it?
Who lives there?
What types of houses?
Which facilities?
History?

Research :
Make notes
Write a paragraph (200 words max)

Jesmond

Where?

Facilities?

House types?

Who?

History?

Anything else?

Background : Byker
Where is it?
Who lives there?
What types of houses?
Which facilities?
History?

Research :
Make notes
Write a paragraph (200 words max)

Byker

Where?

Facilities?

House types?

Who?

History?

Anything else?

Hypothesis Statement
The hypothesis is that houses in ______ are more expensive than houses in ____________

Describe/explain your method
Describe your sampling technique
Explain how you will approach the project
Methodology

At least 3 different types of graphs
Include calculations – mean. Median. Mode, Standard Deviation
Include comments on all graphs and calculations. What do they show?
Results & Discussion

State whether how hypothesis is supported
Explain how you know. Give examples
No new material
Conclusion