A novice's solutions corner - Statistics, MS Excel, MS Access, Cognos, and others
Maths made me mad. IT is only for the geeks. You are not alone, and I seek to reach out to those who understand the woes. I am no expert but I just share what I know or how I solve the problems - A novice's solutions to typical maths.IT problems. If statistics and software drive you crazy, I hope this site would put you back to sanity.
Search This Blog
Sunday, September 11, 2011
iphone vs Android: which group do you belong ?
I am waiting for iphone 5. Is it worth waiting for ? @__@
"Sorry, the import failed due to a server error. The error code is bX-izedxv".
You received the above error message when trying to export your Wordpress .xml file into Blogger/Blogspot.
Tuesday, August 30, 2011
Pathetic Page Views
This week's page view :
Only 24 page views in total this week (as at 30 Aug 2011).
How pathetic is that.
Should I continue this blog ? =(
Monday, August 29, 2011
How to link data in 2 excel files and combine them into 1 using macro?
FILE 1
data: Column A, B and C
FILE 2
data: Column A, and D
Use FILE 1 as the primary file.
Final Result: should have A , B C and D together in 1 spreadsheet.
Problem : Look up function but seems like it doesn't work well. the data is jumble up. I still to check using True false function. cos what is avai in A may not be found in B.
Pri file has more information ( in terms of number of names ) than file 2.
name data1 data2 data3
and in file 2:
name data1 data2 data3 data4
data: Column A, B and C
FILE 2
data: Column A, and D
Use FILE 1 as the primary file.
Final Result: should have A , B C and D together in 1 spreadsheet.
Problem : Look up function but seems like it doesn't work well. the data is jumble up. I still to check using True false function. cos what is avai in A may not be found in B.
Pri file has more information ( in terms of number of names ) than file 2.
name data1 data2 data3
and in file 2:
name data1 data2 data3 data4
Sunday, August 28, 2011
Macro - ADD 3 rows & UNDO Macro to undo the addition of 3 rows
To do the following :
a) ADD 3 Rows
(or even more rows) by prompting user to enter the number of rows they wish to insert.
b) UNDO MACRO:
1. Undo the addition/insertion of rows
2. when click, it will also prompt: "Do you want to undo adding 3 rows ?"
> Yes | Cancel
if Yes, macro proceed and if Cancel , macro will not run and remain.
a) ADD 3 Rows
(or even more rows) by prompting user to enter the number of rows they wish to insert.
b) UNDO MACRO:
1. Undo the addition/insertion of rows
2. when click, it will also prompt: "Do you want to undo adding 3 rows ?"
> Yes | Cancel
if Yes, macro proceed and if Cancel , macro will not run and remain.
Saturday, August 27, 2011
Mathematical Expectation
Question 4.53
Suppose that a grocery store purchases 5 cartons of skim milk at the wholesale price of $1.20 per carton and retails the milk at $1.65 per carton After the expiration date, the unsold milk is removed from the shelf and the grocer receives a credit from the distributor equal to 3/4 of the wholesale price. If the probability distribution of the random variable X, the number of cartons that are sold from this lot is:
Find the Expected Profit.
Suppose that a grocery store purchases 5 cartons of skim milk at the wholesale price of $1.20 per carton and retails the milk at $1.65 per carton After the expiration date, the unsold milk is removed from the shelf and the grocer receives a credit from the distributor equal to 3/4 of the wholesale price. If the probability distribution of the random variable X, the number of cartons that are sold from this lot is:
x | 1 | 2 | 3 | 4 | 5 |
f(x) | 1/15 | 2/15 | 3/15 | 4/15 | 5/15 |
Find the Expected Profit.
Enriching Vocabulary 1
Words beginning with au~:
1. audacious - daring; often to a degree that is considered foolish.
It was audacious of the student to talk back to his principal, especially when he was clearly in the wrong.
2. augment - to cause to become bigger, better, more valuable
To augment the income of the family, he took up several part-time jobs.
3. augur - to be a sign of something in the future
The lack of lustre in the stars does not augur well for his fortunes.
4. aura - an effect/feeling that seems to surround / come from a person/place
There was a strangely mysterious aura exuding from the ancient museum.
5. auspices - help, support and favour
This concert was held successfully only because of the auspices of the various organisations.
6. austere - plain, without comfort/enjoyment.
The monks are used to an austere life in the mountains.
7. authentic - genuine
The expert judged this to be an authentic piece of work.
8. auxiliary - providing additonal help/support, especially with lower rank or of less importance.
Auxiliary nurses were called in to cope with the sudden emergencies in the hospital.
9. auburn - reddish-brown
My sister has a nice auburn hair.
10. auspicious - giving, promising or showing signs of future success
The Chinese believe red to be an auspicious colour.
1. audacious - daring; often to a degree that is considered foolish.
It was audacious of the student to talk back to his principal, especially when he was clearly in the wrong.
2. augment - to cause to become bigger, better, more valuable
To augment the income of the family, he took up several part-time jobs.
3. augur - to be a sign of something in the future
The lack of lustre in the stars does not augur well for his fortunes.
4. aura - an effect/feeling that seems to surround / come from a person/place
There was a strangely mysterious aura exuding from the ancient museum.
5. auspices - help, support and favour
This concert was held successfully only because of the auspices of the various organisations.
6. austere - plain, without comfort/enjoyment.
The monks are used to an austere life in the mountains.
7. authentic - genuine
The expert judged this to be an authentic piece of work.
8. auxiliary - providing additonal help/support, especially with lower rank or of less importance.
Auxiliary nurses were called in to cope with the sudden emergencies in the hospital.
9. auburn - reddish-brown
My sister has a nice auburn hair.
10. auspicious - giving, promising or showing signs of future success
The Chinese believe red to be an auspicious colour.
Subscribe to:
Posts (Atom)