Wednesday, 28 October 2015

Business Analytic Lab Experiments

WEEK 1:
a)      To open MS Excel and identify the Components of the Screen.
b)      To create a Workbook in Microsoft Excel and to save it.

WEEK 2:
To practice some MS Excel Basics.
a)      To insert Rows and Columns
b)      To delete Rows and Columns
c)      Row height Changing
d)      Column width Changing
e)      To print Worksheet

WEEK 3:
To practice the features of the MS Excel like Gridlines, VLookup, Index, Summation, and Auto fill.

WEEK 4:
To practice how to format the cells, text and conditional formatting for the given data in Workbook of MS Excel.

WEEK 5:
To practice the built in Functions in MS Excel.

WEEK 6:
To practice Tables, pivot table, Ranges, Array formulae, charts and Advanced chart Techniques.

WEEK 7:
To practice the Filters, Sorting, Totals & Sub-Totals, Goal seek.

WEEK 8:
To practice how to create Multiple Windows, to Manage Windows, to Splitting Windows, to freezing panes.

WEEK 9:
To practice how to Linking the data with the MS Access, to import Multiple relation model, to record and access Macros.

WEEK 10:
To practice how to create Objects and Accessing Objects in R Programming Language.

WEEK 11:
Write an R Program to perform the Arithmetic and Matrix operations.

WEEK 12:
Write an R Program to manipulate the functions in R Programming Language.

WEEK 13:
a)      Write an R Program to Read and Write the data.
b)      Write an R program to find the Fibonacci series with the help of ‘if’ and ‘while’ statements.

WEEK 14:
Plot the data by using the following functions
a)      pairs(): scatter plot matrix
b)      bar plot(): bar plots
c)      box plot()’: box-and-whisker plots
d)      curve(): function plots

WEEK 15:
Write an R programs by using the Standard statistical models.

WEEK 16:
Write an R program to perform the Linear Regression and Logistic Regression.