• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Exploring Business Data.

Extracts from this document...


Exploring Business Data Assignment

Task 1        - (i)

A Table showing the Total number of passengers using UK airports over the period from 1989 to 1999

Figure 1:


























Figure 2:

Figure 3        (Source of information: Annual abstract of statistics record, 2001)image01.png


As we can see from the table above the total number of passengers using UK airports in 1989 was 91.4 million and ten years on in 1999 the figure has increased almost 70% to 153.9 million. Figure 1 shows the total number of passengers that have used UK airports over the period from 1989 to 1999. Figures 2 and 3 shows the steady increase in the total numbers very clearly. As time goes on the totals are clearly increasing. There is only one year where the total decreased which is the year 1991. This could be due to many reasons.

...read more.


Figure 4:


Figure 4 above is a line graph, which shows the total number of passengers using UK airports over the period from 1989 to 1999, it also includes a trend line which identifies the increasing trend of the total number of passengers over the specified period. It also shows a forecast for the years 2000 and 2001. The forecast predicts the total number of passengers that would use the airports if the upward trend continues. The forecast shows that in the year 2000 there should be about 158,000,000 passengers using UK airports and in the year 2001, there should be about 164,000,000 passengers. The forecast is only based on past trends. The forecast cannot be 100% accurate. Certain unexpected events would certainly affect the total number passengers using UK airports. We cannot forecast any unexpected events, which could happen in the future, and for this reason we cannot totally rely on the forecast.

...read more.


There are a couple of unusual values. These are the values, which lie further than the regression line than the other observations. The unusual values are for the films, The Lost World and Men in Black.


Figure 7:


Figure 8:


Movies released in the summer have a larger range than those not released in the summer.

From figure 8 we can clearly see that the majority of the movies released in the summer have higher gross receipts than those released in other seasons, with a few exceptions.

The movies released in the summer do tend to do better than those in other seasons, but there are some movies which have done well which were released in the other seasons.

Overall we can say that the summer releases would do better than releases in the other seasons.


Sources of task 1: Annual abstract of statistics website

Sources of task 2: “movies.mdf” on the public drive in the sub-directory “MADDOCK”.

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE T-Total essays

  1. I am going to investigate how changing the number of tiles at the centre ...

    You notice you add 4 each time so that 4 is the multiplier, so you have 4 ??N which equals 4N. To get the +4 you subtract the difference of 4 from the original number of tiles you started with, 8.

  2. ICT Coursework: Data Management Systems

    The software I require is Microsoft Excel, a spreadsheet package. I am going to use this as it can be used to do many calculations automatically, and I am familiar with the package. The sources of input data for this product are as follows: * The price the customer buys

  1. Maths Statistics on premiership football.

    2nd with a mean score of 73.85, a difference of 6.29 pts behind. As you can see in Fig 1 some teams don't have any points next to them. This is simply because they didn't finish in the top ten.

  2. For this task we were required to create a model that can be used ...

    This total should give a bill amount. Economy 7 is another variation to a bill model. Economy 7 works differently to the models mentioned above. It calculates a total for day and night costs separately and then totals them for a price.

  1. The T-Total Mathematics Coursework Task.

    17 T = 2t - 9 + 3t - 54 T = 5t - 63 Therefore, we can conclude that: On a 9 x 9 grid any T-Total can be found using T = 5t - 63 were t is the T-Number.

  2. ICT system analysis and modelling.

    �0.07 V.A.T 17.50% Rental Cost 0 Total Days Taken 14 Mileage Cost 70 Total Insurance Costs 140 Total Rental Costs 70 Sub Total 70 Total VAT 12.25 Total inc. VAT 82.25 This was used to find out the total rental costs.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work