Calculate the compound Interest using the values in cells D4, D5 & D6 in part b) above

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

a) Decrease the value of cell C30 by 15%. (1.5 marks)

b) Calculate the simple interest if T, P and R% are given in cells D4, D5 and D6 respectively. (2.5 marks)

c) Calculate the compound Interest using the values in cells D4, D5 & D6 in part b)

above. (3.5 marks)

d) Subtract the sum of the values in cells j2:k9 from the average of the same set of values. (2.5 marks)

e) Add the mode score of cells A5:A6 to the median of scores in cells L9:L12. (2 marks)

f) Divide the total of the scores in cells N4:P16 by the numbers of scores that are there in the cell range. (2.5 marks)

g) Find the statistical range of the set of scores in cells G3:37. (2 marks)

h) Increase D10 by 3% then take the square root of the result. (2.5 marks)

i) Divide the variance of the set of scores in cells A1:A6, by the number of score in th

set. (2.5 marks)

j) Find the standard deviation of the values in cells B3:B9 (2.5 marks)

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme