ITBA lab Session # 4 - 29 Jan 2013

#this post is created as a solution for assignment for IT & Business Applications Lab, Spring Semester, VGSoM, IIT Kharagpur Class of 2014.

Assignment: EXCEL MACROS
: Read multiple CSV files
: Create multiple charts
: Each chart should show
-multiple company
-different parameters

ITBA lab Session # 3 - 22 Jan 2013

#this post is created as a solution for assignment for IT & Business Applications Lab, Spring Semester, VGSoM, IIT Kharagpur Class of 2014.

Assignment #1:

Using mileage groove data,   fit 'lm' and comment on the applicability of 'lm'

> plot(k1,res)

> qqnorm(res)

> qqline(res)

Linear regression is not applicable as shown in the graph

Assignment #2:
Using alpha pluto data, find the following

Step 1. Initial find the linear regression

a) Residual value

plot(p1,res1)






















b) Standard residual

















>qqnorm(res1)


>qqline(res1) 

Assignment#3

Justify Null Hypothesis using ANOVA

Analysis of the result:-

The P value is 0.687%.

High p value, hence we cannot reject the null hypothesis.

ITBA lab Session # 2 - 15 Jan 2013

#this post is created as a solution for assignment for IT & Business Applications Lab, Spring Semester, VGSoM, IIT Kharagpur Class of 2014.

Assignment # 1

a. Create two matrix.

b. Select highlighted columns.

c. Use cbind to join and create a new matrix.

Assignment # 2
Create two matrices and multiply them

Assignment # 3

Download 30 days Nifty data from 1 Dec 2012 to 31 Dec 2012 and then perform regression on that.

Data downloaded:

Computed Result

Assignment # 4
Generate and plot a Normal distribution

The city that is...

#wrote this long time back  for the love of my favourite Indian city MUMBAI, still feel that this article is incomplete and short of many more details that my mind still has fresh about the magnificence of this ruined metropolis, but isn't Mumbai is about that, celebrating the incompleteness, for whatever short time I have stayed here I've always felt that I have been living here since ages...

Different Moods of Marine Drive

The city of extremes challenges you to rise above your own incompetency into an unseen world full of mysteries and unknown vistas, unimagined richness and unseen dreams.

Some who are able to live up to those dreams for themselves rise above the rest in the ever rising skyscrapers with a majestic view of Arabian sea, the sound of the other mortals get buried somewhere in the honks of the Audis and Mercedes in traffic jams and become just another noise for the city holding millions of cries.

Mumbai holds more treasure than what often meets the eye, city that is hidden in obscure corners of large slums, in the vast expanse of rising skyscrapers and sometimes in the rhythmic movement of local trains that run like blood in the veins of this great metropolis.

It is difficult for an outsider to believe that ‘FAST’ and ‘SLOW’ local trains run at same speeds, by the time one understands it, a vast multitude of people have already pushed him a few yards away on a crowded suburban station.

Mumbai can be a true mirror image of India owing to its economic diversity. To accurately get a picture of Mumbai’s economic unevenness go to the “Bandra” station once on "East" and once on "West", there is a stark difference, thats startling and generates uninspiring awe.

The Magnificent Bandra-Worli Sea Link

From the magnificent Bandra Worli Sea Link to the nearby Dharavi the largest slum in India, Mumbai has it all. Even south Bombay considered elite and the real Bombay has its share of slums and “Koliwadas”. But, somehow this aspect of the city makes it truly great.

Mumbai has some truly breathtaking views to offer to a raring traveler, walk down the entire stretch of Marine Drive anytime during the day or night, you would find a wonderful synthesis of natural and manmade wonders with a beautiful Arabian Sea curving down on right, to the skyscrapers, Wankhede, Brabourne stadiums, Air India Building, Oberoi hotel on the left.

One can experience the beautiful rise and fall in sea waters sitting on the pavements created for visitors. It’s not hard to spot hard stony masses of rocks making their way out in the middle of the Sea on a low tide, whereas on a high tide the stormy waves of ferocious water would well wash your feet with their exhilarating exuberance.

The serenity that one feels on a typical evening at the Haji Ali with sea link appearing at a distance, Imperial towers and  Antilla towering on the other side, as one goes through the slippery pavement into the sea to the holy shrine, one can feel himself entering into a whole new aura of pureness and divinity alike.

Bombay as it was called by the British has retained its soul captured in tiny fragments of life strewn around its entire length. Formed by reclaiming the land from the sea by joining seven islands, the land and the sea though distinct from each come together and become one entity which forms a part of the city’s huge ecosystem. Thus, Mumbai doesn't seem to encompass few hundred miles but stretches its arms as far as the eyes of an avid traveller go out in the vast wild sea, uncontrolled, uninhibited, pulsating with every wave of the sea and dancing with every drop of rain.

Credits: Image credits reserved with original photographers, not mine clicks.

ITBA lab Session # 1 - 8 Jan 2013

#this post is created as a solution for assignment for IT & Business Applications Lab, Spring Semester, VGSoM, IIT Kharagpur Class of 2014.

0) Create line plot of x

1) Plot ZCol1 as histogram from NSE data extracted

2) Plot both lines and points along with labels for X-axis, Y-axis and graph name 

3) Create a scatter plot by selecting low values

4) Draw a graph showing volatility in the data