Tuesday, 22 January 2013

IT and Business Application lab : Assignment 3


Problem 1: Using Mileage-Groove data, fit 'lm' and 'comment on the applicability of 'lm'.
Solution:
Commands:
>test1<-read.csv(file.choose(),header=T)


> a<-test1$mileage
> b<-test1$groove
> reg1<- lm(a~b)
> reg1


> res_var<-resid(reg1)
> res_var


> plot(b,res_var)

> qqnorm(res_var)

>qqline(res_var)

Linear Regression is not applicable as can be seen from the graph

Problem 2:
a) Plot residual and standard residual of independent variable
Solution: 
Commands:
 > test2<-read.csv(file.choose(),header=T)

> a<-test2$Pluto
> b<-test2$alpha
> reg1<- lm(a~b)
> reg1


> res_var<-resid(reg1)
> sres<-rstandard(reg1)



B) Plot qqplot and add a qqline
Solution:
Commands:
> plot(b,res_var)
> qqnorm(res_var)


> qqline(res_var)

Problem 3: Justify null hypothesis using Anova
Solution:
Commands:
> anova1<-read.csv(file.choose(),header=T)
> anova2<-aov(anova1$Comfort_level~anova1$Chair)     

p value=0.687
Since p-value is greater than 5%, we can't reject the null hypothesis.
 











Tuesday, 15 January 2013

IT and Business Application lab : Assignment 2


Problem 1
a) Create two matrices
Solution:            
Command
> a<- c(1,2,3,4,5,6,7,8,9)
> b<- c(32,48,1,5,10,12,15,18,23)
> dim(a)<- c(3,3)
> dim(b)<- c(3,3)
> a
     [,1] [,2] [,3]
[1,]    1    4    7
[2,]    2    5    8
[3,]    3    6    9
> b
     [,1] [,2] [,3]
[1,]   32    5   15
[2,]   48   10   18
[3,]    1   12   23  
b) Select 3rd column from first matrix {a} and 1st column from second matrix {b}
Solution:
Command
> a1<-a[ ,3]
> a1
[1] 7 8 9
> b1<-b[ ,1]
> b1
[1] 32  48 1
c) Combine the two matrices
Solution:
Command
> combine<-cbind(a1,b1)
> combine
     a1 b1
[1,]  7 32
[2,]  8 48
[3,]  9 1

Problem 2: Find the product of two matrices
Solution:
Command
> multiple<- a%*%b
> multiple
     [,1] [,2] [,3]
[1,]  231  129  248
[2,]  312  156  304
[3,]  393  183  360

Problem 3: Find the regression using nifty data from 01 Dec 2012 to 31 Dec 2012 ?
Solution:
Command
> nifty<-read.csv(file.choose(),header=T)

> open<- nifty[ ,2]
> high<- nifty[ ,3]
> data<- cbind(open,high)
> reg1<-lm(high~open,data=nifty)
> reg1

Call:
lm(formula = high ~ open, data = nifty)

Coefficients:
(Intercept)        open
  1578.3358       0.7355


Problem 4: Generate and plot a normal distribution curve
Solution:
Command
> x<-seq(0,100)
> y<-dnorm(x,mean=50,sd=5)
> plot(x,y,type="l")

Tuesday, 8 January 2013

IT and Business Application lab : Assignment 1


Problem 1:
a) Create line plot of x, where x is a variable.
Solution:            
Command:          
> x<-c(1,2,3)
> plot(x,type="l")

b) Create histogram of NSE data extracted from 1st October 2012 to 4th January 2013.
Solution:            
Command:       
>z<-read.csv(file.choose(),header=T)
>zcol1<-z[ ,3]
> plot(zcol1,type="h")


Problem 2:
Plot both lines and points. Also name the plot, x axis and y axis
Command:
>plot(zcol1,type="b",main="NSEGraph",xlab="Time",ylab="nifty")


Problem 3:
Create scatter plot by selecting the low values.
Command:
> zcol4<- z[,4]
> plot(zcol1,zcol4)


Problem 4:
Find the volatility of data?






Thursday, 29 November 2012

Tata Steel Ideation

Tata Steel is looking for an original idea that will use any aspect of digital technology (cloud, mobile, Android etc ) to create an application or platform that can be integrated with the strategic management requirements of the company.

View the solution:-


Friday, 19 October 2012

Internal Customer Complaint System

Costra Company Ltd.

Costra Company Ltd. a cable manufacturing company in Gujarat implements a new technology on ExoPHPDESK for managing complaints of there internal customers. I was given the reaponsiblity to implement a Internal Customer Complaint System for which I evaluated a number of other technologies which are listed below:

1. phpOnline

2. HESK

3. osTicket

I chose ExoPHPDESK over others as it is easily customisable and user friendly. It has the unique feature of online chat with the customer. I found this technology best and well suited for my application.

I required to do the following customisation in order fullfil my requirements:

1. I have defined one more admin apart from the default one. Both of them have the rights to modify the response and the tickets


2. Then i have defined three department namely IT Support, HR and Facilities


3. I have alloted 6 number of staffs, two for each department.




Helpdesk Login : admin       Password : pass

Any employee can register a complaint at helpdesk.

The admin will be able to view the complaint and the details of the employee.


Thursday, 20 September 2012

e-Medical-store

Online Form powered by


If finding difficulty in viewing this application, please click here : e-Medical Store

Task  : Develop an application of Online Medical Store using the Zoho Creater.

Customer : Manas Ghose (12BM60100)

Vendor :     Kamya Sharma (12BM60101)

The application is created by me on request of my customer.

User Manual :   User Manual
Certificate of Compliance :  Acceptance Certificate




 

User Manual


e-Medical Store                                          

Introduction

e-Medical Store is the registered online chemist in India. e-Medical Store is a chain of Medical stores present all over India. You can buy entire range of medicines Online at competitive Prices and door delivery at your place.

 User Manual for the Customer

Following is the main page of the website:
 
The user needs to register first to buy any medicine. After registration the page will automatically move to login page for the user. Following is the screenshot for registration page and login page.



 A mail regarding the successful registration will be sent to the customer. After registration the customer needs to login using the same login id and password. After successful login it will automatically lead to medicine page, wherein customer can select the medicines they want.

 Medicine page will by default take the User ID and all the information which the customer had put it during registration. But the customer can change these fields as required. Now the customer will be selecting the medicine from the dropdown. It will automatically take the information like company name, per unit price and units. Now the customer needs to enter the quantity of medicines required. It will automatically calculate the total amount. After selecting everything the customer needs to place an order. It will automatically send a copy of invoice to the registered e-mail id of the customer.

 
Information of placing the order will be sent to the e-Medical store and delivery person will deliver the medicines ordered.

 
 
Admin User Manual

Admin is the owner of e-Medical store. Admin will get the information of registered customers in Registration view.

 The admin will also get the information every time the customer logins into the login page.


 The admin will also get an invoice copy after the customer place an order.

The admin will check if that medicine is available or not in the "Medicine Database". Admin can also check how much quantity is available in the database.

 The admin can also add the quantity of new medicines bought by the store. Also admin can add new medicines in the database.