• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  • Level: GCSE
  • Subject: ICT
  • Word count: 1414

I am investigating into Price

Extracts from this document...

Introduction

Firstly I have decided to present my data in Tally Charts, I think this is a clear way to get a feel for the data itself. I have chosen these class intervals because the price of my cars range from �1 100 to �41 500, including petrol and diesel cars. I thought these intervals would also be better because this way there is 9 intervals and I need between 7 and 10 intervals. I also looked at the range of prices for both petrol and diesel so that they have the same class intervals, this will make it easier to compare. I will have to sort and resort my data because at this stage I am investigating into Price, but later I will be looking into Age, so a resort of my data will be necessary. Tally Chart for Price - Diesel Band Of Price (�) To the nearest � Tally Frequency Cumulative Frequency 0 ? � < 4 999 | | | | | | | | | | | | | | | | | | | | | 26 26 5 000 ? � < 9 999 | | | | | | | | | | | | | | | | 20 46 10 000 ? ...read more.

Middle

is the median: The median for Petrol = �7 995 The median for Diesel = �6 495 Mode: The modal value is the most common value that appears in the data. I kept my data in the order from lowest to highest and looked down to see which of the numbers appears more often than the others. The modal value for Petrol = �4 999 The modal value for Diesel = �6 374. 50 Range: The range is simple to work out. All I have to do is take the lowest value form the highest value: The range for Petrol is = �36 350 The range for Diesel is = �40 400 Now I will draw tables to present the information clearly: Petrol Diesel Mean �10 970.17 �10 188.17 Median �7 995 �6 374.50 Mode �4 999 �6 374.50 Range �36 350 �40 400 This doesn't really tell me a lot as for the mode and range, diesel is higher and for the mean, petrol is higher. The means are quite close and the ranges and modes are further apart. This could tell me that diesel is slightly more expensive as the diesel range is and it's mode. ...read more.

Conclusion

When looking at these I realised that because the inter quartile ranges, upper quartiles and lower quartile are all very close, this is the reason that these outlier values are only �500 apart as well. I have decided to discard these outliers they are extremes. The reason I have chosen to carry on this way because I do not want these large values distorting the rest of my data and calculations. I am going to redraw my box plots with these changes. After taking out my outliers I have 67 diesel values and 64 petrol values. Standard Deviation: I am going to work out the standard deviation to take my project one step further. Petrol: The spreadsheet on the next page explains how I did the standard deviation calculations. After finding the variance, I did the square root of it to get standard deviation! Variance = 31314359.46 31314359.46 = 5595.92 (2 dp) Standard Deviation = �5595.92 Diesel: The spreadsheet following the petrol workings will explain the diesel standard deviation. Variance = 47647391.3 47647391.3 = 6902.71 (2 dp) Standard Deviation = 7437.95 The analysis of Standard Deviation for Price has been written with the Age Standard Deviation, further on in the project. ?? ?? ?? ?? Victoria Porter 10 B GCSE Statistics Coursework Candidate Number = 6082 Centre Number = 31015 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 ICT Systems and Application essays

  1. ICT PROJECT

    Select parents report macro button To check if macro is working Should go to parents report sheet As expected 17. Select chart summaries macro button To check if macro is working Should go to chart summaries graph Macro button doesn't work Re-test 17 See if macro works correctly Macro button

  2. Database Coursework

    Another form that would have to be used in my system is the printouts of rentals that are overdue. Implementation Hardware Monitor: for the person using this system, it should be visually clear. They should be able to see what's on the monitor and not have any confusion between the different functions.

  1. ICT Coursework (MarcoS)

    Hardware and Software The new system will use Microsoft Office Excel 2007, because it is easy to use, and also one of the best way to manage the profit and loss account. There will be 6 desktop computers, all accessible from all the employee by using their own username and password.

  2. a level ict project

    reach the objective of being able to remain operation for at least three years without any major problems. Backup protocols are a necessity in the event that the master copy is lost or destroyed. Backup up will be provided by an external hard drive, and the system will be backed up periodically, i.e.

  1. Develop a spreadsheet application for the Ibis Hotel.

    Many advantages are available in using a computer. The following points mention some advantages of using a computer instead of using manual systems: * Data can be organised quickly and efficiently. * Errors can easily be traced and also changed. * Information can easily be transferred from one person to another, for example: by e-mail.

  2. Model Price Chart.

    ==> Cool day: hot drinks - 325, cold drinks - 175 ==> Cold day: hot drinks - 375, cold drinks - 100. With this information, I will be able to predict the amount of sales and therefore the amount of profit expected for each different price or weather condition.

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