(Basic Statistics for Citizen Data Scientist) Excel Charts Excel provides fairly extensive capabilities for creating graphs, what Excel calls charts. You can access Excel’s charting capabilities by selecting Insert > Charts. We will describe how to create bar and line charts here. Other types of charts are created in a similar manner. Once a chart is created …
Month: January 2021
(Basic Statistics for Citizen Data Scientist) Excel User Interface The entire interface is as follows: Figure 1 – Excel User Interface This is the layout used in Excel 2007. The layout in Excel 2010 and Excel 2013 and later versions of Excel are almost identical. The key components are as follows: Title Bar – contains the …
(Basic Statistics for Citizen Data Scientist) Excel Spreadsheets Workbooks and worksheets Excel works with files called workbooks. Each workbook contains one or more spreadsheets, called worksheets. Each worksheet consists of cells organized in a rectangular grid. The rows of a worksheet are labeled with a number and the columns are labeled with a letter or series of letters. The …
(Basic Statistics for Citizen Data Scientist) Basic Statistical Concepts Statistics plays a central role in research in the social sciences, pure sciences and medicine. A simplified view of experimental research is as follows: You make some observations about the world and then create a theory consisting of a hypothesis and possible alternative hypotheses that try …
(Python Tutorials for Citizen Data Scientist) Python Program to Illustrate Different Set Operations In this example, we have defined two set variables and we have performed different set operations: union, intersection, difference and symmetric difference. Python offers a datatype called set whose elements must be unique. It can be used to perform different set operations …
(Python Tutorials for Citizen Data Scientist) Python Code to Sort Words in Alphabetic Order In this program, you’ll learn to sort the words in alphabetic order using for loop and display it. In this example, we illustrate how words can be sorted lexicographically (alphabetic order). Source Code # Program to sort alphabetically the words form …
(Python Tutorials for Citizen Data Scientist) Python Code to Remove Punctuation From a String This program removes all punctuation from a string. We will check each character of the string using for loop. If the character is a punctuation, empty string is assigned to it. Sometimes, we may wish to break a sentence into a …
(Python Tutorials for Citizen Data Scientist) Python Code to Multiply Two Matrices In this example, we will learn to multiply matrices using two different ways: nested loop and, nested list comprehension. In Python, we can implement a matrix as nested list (list inside a list). We can treat each element as a row of the …
(Python Tutorials for Citizen Data Scientist) Python Code to Add Two Matrices In this program, you’ll learn to add two matrices using Nested loop and Next list comprehension, and display it. In Python, we can implement a matrix as a nested list (list inside a list). We can treat each element as a row of …
(Python Tutorials for Citizen Data Scientist) Python Code to Convert Decimal to Binary Using Recursion In this program, you will learn to convert decimal number to binary using recursive function. Decimal number is converted into binary by dividing the number successively by 2 and printing the remainder in reverse order. Source Code # Function to …