• 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
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  • Level: GCSE
  • Subject: ICT
  • Word count: 4509

Excel user guide

Extracts from this document...

Introduction

Contents Bar charts Simple Bar Chart In order to construct a simple bar chart using Excel you will have to follow the following steps. A bar chart would be nothing without data in order to base the bar chart on. Create a table with the following data below. Day Armando's Wages Monday 8,892 Tuesday 5,092 Wednesday 3,072 Thursday 8,972 Friday 13,603 Saturday 15,754 Total 55,371 Once you have inputted data in the spreadsheets highlight the data and click on the bar chart icon Once you have selected the bar chart icon a dialog box will appear with the title chart wizard. This Wizard will take you through 4 stages in order to construct the bar chart. Steps to simple bar chart First step - Select column for the chosen bar type. You will be presented with a chart sub type on the right hand side of the dialog box, select the standard format which has been automatically been chosen. Then select Next. Second step - The second step will illustrate the chart source data within the bar chart. This will allow you to arrange or edit your data. Once you had double-checked your data select Next. Third step - The chart option will now appear in the third step. Here you will be able to name your Y and X-axis. Once you have named your axis select Next. Fourth step - The fourth step will allow you to locate your chart either within the spreadsheet you entered your data in or in a new spreadsheet. Then select finish. Once you have selected finish you should have a simple bar chart like the one shown below. Multiple Bar Chart In order to construct a multiple bar chart using Excel you will have to follow the following steps. A multiple bar chart is very similar to a simple bar chart. The procedures are the same but with the exception of additional data. ...read more.

Middle

Do not delete the bottom cell, which should contain the number 0. This is there for calculation purposes. Steps to construct a Histogram Now that you have found the frequency of the lower and upper class boundaries you will need to create a histogram to go with it. We will be creating a histogram within the format of bars. Before you create your histogram you will need to enter the lower and upper class boundaries in the spreadsheet like shown below. Upper and Lower class boundaries 143 - 144 144 - 145 145 - 146 146 - 147 147 - 148 148 - 149 149 - 150 150 - 151 151 - 152 152 - 153 Highlight the frequency data and once again click on the bar chart icon Steps 1 - Follow the same step as the previous simple bar chart for step 1 Step 2 - click on series, this section will allow you to label the X axis of the histogram bars. In order to do this click here Once you have clicked here you will then have to highlight the lower and upper class boundaries that you just entered in the spreadsheet. Step 3 - The chart option will now appear in the third step. Here you will be able to name your Y and X-axis. Once you have named your axis select Next. Step 4 - The fourth step will allow you to locate your histogram either within the spreadsheet you entered your data in or in a new spreadsheet. Then select finish. Once you have selected finish you should have a histogram like the one shown below. Editing the histogram To emphasise the continuity of the variable axis, the gaps must not be left between the bars in a histogram. 1) As you can see there are gaps in between the bars of the histogram in order to get rid of these gaps you will have to double click the bar. ...read more.

Conclusion

f0 149 f1 10 f2 151 mode 49.49642857 Standard Deviation Standard deviation is a measure of the range of values in a set of numbers. Standard deviation is a statistic used as a measure of the dispersion or variation in a distribution, equal to the square root of the arithmetic mean of the squares of the deviations from the arithmetic mean. The formula for standard deviation is shown below Standard deviation = Efx2/Ef - (Efx /Ef)2 The table below will provide you with data which will enable you to calculate the standard deviation. LCB UCB frequency Mid point (x) fx fx2 143 144 2 143.5 287 41184.5 144 145 1 144.5 144.5 20880.25 145 146 2 145.5 291 42340.5 146 147 3 146.5 439.5 64386.75 147 148 5 147.5 737.5 108781.25 148 149 7 148.5 1039.5 154365.75 149 150 10 149.5 1495 223502.5 150 151 6 150.5 903 135901.5 151 152 3 151.5 454.5 68856.75 152 153 1 152.5 152.5 23256.25 0 5944 ?F 40 5944/40 = 148.6 x*fx=fx2 standard deviation = Efx2/Ef - (Efx /Ef)2 = 882981.2 Simple and compound interest Simple In order to find a simple 5% interest cost of �1000 within the time of 8 years you will have to do the following: The simple formula is A= P (1+ni) In the spreadsheet type in the following data Interest � (p) Percentage (i) Years (n) 1000 0.05 8 Once you have entered the data into the spread sheet select a cell and enter the simple formula which should be like the one below. A = 1000 (1+8*0.05) Now you should have the results for the simple interest Simple A = 1400 Compound Using the same data you will be able to calculate the compound interest of 5% of �1000. The compound formula is A= P (1+i)n Enter the following data into the spreadsheet. Begin End �1000 1050 Once you have entered this data you will have to enter the compound formula in the cell under End 1050. A = 1000(1+0. ...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. GCSE Excel Project ICT

    mean associating customers to a date, which is a shared value, not something individual like their name, which is the standard arbitrary value. Two alternate software solutions considered There are two computerised options within Microsoft both are within the Microsoft Office 2007 Suite.

  2. task2-report-template 3

    For each customer they need to see a list of information about customers: * Title * Name * Address * Home telephone * Mobile telephone * Order date * Laptop ordered 2.2 Use Methods of Collecting Information [4 Marks] 2.2.1 Information Collected [1] This is the letter I sent to

  1. Design Section

    * What you hope to achieve - Microsoft Excel will allow me to achieve all my targets as this as all the stuff I need to achieve all the things. I want to achieve the system to make it easy and I can do that by using easy instructions so the customers can gradually get through my pages.

  2. The new system is required to calculate the costs of a new car as ...

    After conducting an initial interview with Mr. Cruiser, I can deduce that the current system in use would be too slow to meet the demands of the business while it is expanding, as such, it does seem that an automated system would be more appropriate. It also appears that the paper-based method means that the customer base

  1. The end user of my program is for the people applying for the insurance ...

    Doyle: something with a large database and is accurate and can be basically used by beginners Me: so you do not want nothing to complicated Doyle: Because I employ just from over the age of 18 I do not expect all of the future employees to be computer trained Me: what system do you use now?

  2. Statistics Study Guide

    Independent variable is a value determined by the experimenter not subject. Dependent variable is the variable that is measured in a study the idea being it depends on the level /existening of IV. Demand characteristics are cues inadvertently provided by the researcher or research untext concerning the purposes of the study or the behavior expect from the part.

  1. ICT (double award) - Business systems portfolio.

    256mb DDR ram, and 40 GB hard drives. These machines can run all the necessary programs and hardware they are required to. They are all fitted with a 10/100 Ethernet adapter, which enables them to connect to the network at speed. They all also include a keyboard, mouse and a 17-inch TFT monitor's.

  2. Develop a spreadsheet application for the Ibis Hotel.

    Many thanks. Yours sincerely, Mr Singh Manager. The current system At present the hotel is using file-based system. There is 20 staff in the hotel and some of them are part time and the rest are full time. Each day is divided into 3 shifts - day, evening and night.

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