writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 79:
Line 79: + + + + + + + + + + + + + + + + + + Line 87:
Line 105: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
Which day was the precipitation the most?
Which day was the precipitation the most?
Find total precipitation for the all months.
Find total precipitation for the all months.
15. A table has the following values.
Name Gender Age Kids
John m 3 5
Mary f 12 4
Sue f 33 2
Kim f 12 1
Sam m 6 2
Extract rows having 2nd column value as f
Find the age of eldest female
Find average number of kids of males
Create a table with data sorted based on age
16. Find Square root of 1/2 + 0.0916 - absolute value of (-7) + natural logarithm of 10. Round this number to 2 decimals.
17. List SIN, COS, TAN values of 0, 30, 60, 90, 120, 150, 180, 210... to 360 degrees
17. List SIN, COS, TAN values of 0, 30, 60, 90, 120, 150, 180, 210... to 360 degrees
===Answer===
===Answer===
|4|.fillwith(LISTPRIMES(1000,100))
|4|.fillwith(LISTPRIMES(1000,100))
19. Convert $321 to British pounds, Indian rupee and Euro
20. Matrix
3 -4 2
4 5 6
2 3 -2
Find the determinant
Find the sum of squares of all numbers
Find inverse
21. Generate random number sequence to simulate 1 hour of windspeed data. Updated every 30 seconds.
Assume wind speed is modeled as uniform distribution, random number varies between upper and lower limits.
Lower limit is 10 mph. Upper limit is 20 mph.
Find the solution.
Plot the values.
22. Population growth formula is P= Po e^rt
Find population if
Population orginal Po = 1billion
e = euler number
r = 1.2%
t = 20 years
If a person's intake is 1.5 kg/day of food and 0.9l of water, how much food and water does the population need?
23. From a group of 7 men and 6 women, five persons are to be selected to form a committee so that at least 3 women are there on the committee. How can it be done?
24. In how many different ways can the letters of the word 'CORPORATION' be arranged so that the vowels always come together?
25. In a shop there are Jeans, Pants, Shirts and Tops of colors black, blue, grey etc and prices $20 to $200. Write a program for selection of Jeans, blue in color, that is priced between $50 and $100. If there are no Jeans, get grey color pants priced less than $50.
26. Out of 7 consonants and 4 vowels, how many words of 3 consonants and 2 vowels can be formed?
26. Out of 7 consonants and 4 vowels, how many words of 3 consonants and 2 vowels can be formed?