{"id":6714,"date":"2024-04-04T10:30:52","date_gmt":"2024-04-04T10:30:52","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/3258-basic-statistical-analysis-lab-syllabus-for-computer-application-business-management-3rd-sem-2021-revision-sitttr\/"},"modified":"2024-04-04T10:30:52","modified_gmt":"2024-04-04T10:30:52","slug":"3258-basic-statistical-analysis-lab-syllabus-for-computer-application-business-management-3rd-sem-2021-revision-sitttr","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/3258-basic-statistical-analysis-lab-syllabus-for-computer-application-business-management-3rd-sem-2021-revision-sitttr\/","title":{"rendered":"3258: Basic Statistical Analysis Lab Syllabus for Computer Application &amp; Business Management 3rd Sem 2021 Revision SITTTR"},"content":{"rendered":"<p align=\"justify\">Basic Statistical Analysis Lab detailed syllabus for Computer Application &amp; Business Management (CB) for 2021 revision curriculum has been taken from the <a class=\"rank-math-link\" href=\"http:\/\/www.sitttrkerala.ac.in\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">SITTTRs<\/a> official website and presented for the Computer Application &amp; 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. <\/p>\n<p align=\"justify\">For Computer Application &amp; Business Management 3rd Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/sitttr-diploma-computer-application-business-management-cb-syllabus-for-3rd-sem-2021-revision\">Computer Application &amp; Business Management (CB) 3rd Sem 2021 revision scheme<\/a>. The detailed syllabus of basic statistical analysis lab is as follows. <\/p>\n<p><h4>Course Objectives:<\/h4>\n<ul>\n<li>To acquire knowledge on data analysis with the help of MS Excel.<\/li>\n<li>To provide students with the practical skills necessary for the analysis of economic and financial data.<\/li>\n<\/ul>\n<p><h4>Course Outcomes:<\/h4>\n<p>On completion of the course, students will be able to:<\/p>\n<ol>\n<li>Apply data collection methods<\/li>\n<li>Create Tables, Charts and Descriptive Statistics using Excel Functions<\/li>\n<li>Implement the measures of central tendency &amp; dispersion, and correlation using Analysis Toolpak in Excel<\/li>\n<li>Implement linear regression using Analysis Toolpak in Excel<\/li>\n<\/ol>\n<p><h4>Module 1:<\/h4>\n<ol>\n<li>List the stages of statistical enquiry in Descriptive Statistics<\/li>\n<li>Perform primary data collection by preparing a questionnaire<\/li>\n<li>Perform secondary data collection from publications and historical documents<\/li>\n<\/ol>\n<p><h4>Module 2:<\/h4>\n<ol>\n<li>Create frequency distribution table and histogram<\/li>\n<li>Summarize a table using PivotTable<\/li>\n<li>Perform questionnaire analysis using Excel<\/li>\n<li>Find the measures of central tendency and measures of dispersion a. Traditional formula b. Excel function<\/li>\n<li>Find the Karl Pearson Correlation coefficient using a. Traditional formula b. Excel function and display the scatter diagram<\/li>\n<li>Find the Spearman Rank Correlation coefficient using a. Traditional formula b. Excel function and display the scatter diagram<\/li>\n<\/ol>\n<p><h4>Module 3:<\/h4>\n<ol>\n<li>Install the Analysis Toolpak in Excel and use it to create frequency distribution table and histogram<\/li>\n<li>Find the measures of central tendency and measures of dispersion<\/li>\n<li>Find the Karl Pearson Correlation coefficient, Spearman Rank Correlation coefficient and display the scatter diagram<\/li>\n<\/ol>\n<p><h4>Module 4:<\/h4>\n<ol>\n<li>Perform linear regression and display the scatter diagram<\/li>\n<li>Evaluate the result of linear regression<\/li>\n<li>Open ended experiments<\/li>\n<\/ol>\n<p><h4>Reference Books:<\/h4>\n<ol>\n<li>Lisa M. Sullivan, Essentials of Biostatistics Workbook Statistical Computing Using Excel, Second Edition<\/li>\n<li>Dan Remenyi, George Onofrei, Joe English, An Introduction to Statistics Using Microsoft Excel<\/li>\n<li>T N Srivastava, Shailaja Rego , Statistics for Management<\/li>\n<li>David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Modern Business Statistics with MicrosoftR ExcelR,<\/li>\n<li>Kiran Pandya and Smriti Bulsari, SPSS in simple steps, Dreamtech, 2011<\/li>\n<\/ol>\n<p><h4>Online Resources<\/h4>\n<ol>\n<li>http:\/\/www.textbooksfree.org\/Statistics%20Book.htm<\/li>\n<li>https:\/\/www.cengage.com\/resource_uploads\/downloads\/0538733500_301118.pdf<\/li>\n<li>https:\/\/www.wisdomjobs.com\/e-university\/excel-data-analysis-tutorial-1750.html<\/li>\n<li>http:\/\/www.businessbookmall.com\/Excel-Statistics-Book.htm<\/li>\n<li>https:\/\/www.spss-tutorials.com\/basics\/<\/li>\n<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all other subjects of Computer Application &amp; Business Management (CB), 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/sitttr\/cb\">Computer Application &amp; Business Management 3rd Sem subject syllabuses for 2021 revision<\/a>. <\/p>\n<p align=\"justify\">To see the syllabus of all other branches of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-syllabus\/\"> SITTTR diploma all branches syllabus.<\/a>. <\/p>\n<p align=\"justify\">To see the results of Computer Application &amp; Business Management (CB) of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-results\/\"> SITTTR diploma Computer Application &amp; Business Management (CB) results.<\/a>. <\/p>\n<p align=\"justify\">For all Computer Application &amp; Business Management academic calendars, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-academic-calendar\/\"> Computer Application &amp; Business Management all semesters academic calendar<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Basic Statistical Analysis Lab detailed syllabus for Computer Application &amp; Business Management (CB) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Computer [&hellip;]<\/p>\n","protected":false},"author":2462,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[34,76],"tags":[],"class_list":["post-6714","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-cb"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/6714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/users\/2462"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/comments?post=6714"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/6714\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=6714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=6714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=6714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}