• 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

Middle

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

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.

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