Basic Statistical Analysis Lab detailed syllabus for Computer Application & Business Management (CB) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Computer Application & Business Management students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Computer Application & Business Management 3rd Sem scheme and its subjects, do visit Computer Application & Business Management (CB) 3rd Sem 2021 revision scheme. The detailed syllabus of basic statistical analysis lab is as follows.
Course Objectives:
- To acquire knowledge on data analysis with the help of MS Excel.
- To provide students with the practical skills necessary for the analysis of economic and financial data.
Course Outcomes:
On completion of the course, students will be able to:
- Apply data collection methods
- Create Tables, Charts and Descriptive Statistics using Excel Functions
- Implement the measures of central tendency & dispersion, and correlation using Analysis Toolpak in Excel
- Implement linear regression using Analysis Toolpak in Excel
Module 1:
- List the stages of statistical enquiry in Descriptive Statistics
- Perform primary data collection by preparing a questionnaire
- Perform secondary data collection from publications and historical documents
Module 2:
- Create frequency distribution table and histogram
- Summarize a table using PivotTable
- Perform questionnaire analysis using Excel
- Find the measures of central tendency and measures of dispersion a. Traditional formula b. Excel function
- Find the Karl Pearson Correlation coefficient using a. Traditional formula b. Excel function and display the scatter diagram
- Find the Spearman Rank Correlation coefficient using a. Traditional formula b. Excel function and display the scatter diagram
Module 3:
- Install the Analysis Toolpak in Excel and use it to create frequency distribution table and histogram
- Find the measures of central tendency and measures of dispersion
- Find the Karl Pearson Correlation coefficient, Spearman Rank Correlation coefficient and display the scatter diagram
Module 4:
- Perform linear regression and display the scatter diagram
- Evaluate the result of linear regression
- Open ended experiments
Reference Books:
- Lisa M. Sullivan, Essentials of Biostatistics Workbook Statistical Computing Using Excel, Second Edition
- Dan Remenyi, George Onofrei, Joe English, An Introduction to Statistics Using Microsoft Excel
- T N Srivastava, Shailaja Rego , Statistics for Management
- David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Modern Business Statistics with MicrosoftR ExcelR,
- Kiran Pandya and Smriti Bulsari, SPSS in simple steps, Dreamtech, 2011
Online Resources
- http://www.textbooksfree.org/Statistics%20Book.htm
- https://www.cengage.com/resource_uploads/downloads/0538733500_301118.pdf
- https://www.wisdomjobs.com/e-university/excel-data-analysis-tutorial-1750.html
- http://www.businessbookmall.com/Excel-Statistics-Book.htm
- https://www.spss-tutorials.com/basics/
For detailed syllabus of all other subjects of Computer Application & Business Management (CB), 2021 revision curriculum do visit Computer Application & Business Management 3rd Sem subject syllabuses for 2021 revision.
To see the syllabus of all other branches of diploma 2021 revision curriculum do visit SITTTR diploma all branches syllabus..
To see the results of Computer Application & Business Management (CB) of diploma 2021 revision curriculum do visit SITTTR diploma Computer Application & Business Management (CB) results..
For all Computer Application & Business Management academic calendars, visit Computer Application & Business Management all semesters academic calendar direct link.