Mean, Median and Mode

4. Statistics Examples

Statistical analysis in R is performed by using many in-built functions. Most of these functions are part of the R base package. These functions take R vector as an input along with the arguments and give the result. The functions we are discussing in this chapter are mean, median and mode. Mean It is calculated by taking the sum of the values and dividing with the number of values in a data series. The function mean() is used to calculate this in R. Syntax The basic syntax for calculating mean in R is − Following is the description of the parameters used − Example When we execute the above code, it produces the following result − Applying Trim Option When trim parameter is supplied, the values in the vector get sorted and then the required numbers of observations are dropped from calculating the mean. When trim = 0.3, 3 values from each end will be dropped from the calculations to find mean. In this case the sorted vector is (−21, −5, 2, 3, 4.2, 7, 8, 12, 18, 54) and the values removed from the vector for calculating mean are (−21,−5,2) from left and (12,18,54) from right. When we execute the above code, it produces the following result − Explore our latest online courses and learn new skills at your own pace. Enroll and become a certified expert to boost your career. Applying NA Option If there are missing values, then the mean function returns NA. To drop the missing values from the calculation use na.rm = TRUE. which means remove the NA values. When we execute the above code, it produces the following result − Median The middle most value in a data series is called the median. The median() function is used in R to calculate this value. Syntax The basic syntax for calculating median in R is − Following is the description of the parameters used − Example When we execute the above code, it produces the following result − Mode The mode is the value that has highest number of occurrences in a set of data. Unike mean and median, mode can have both numeric and character data. R does not have a standard in-built function to calculate mode. So we create a user function to calculate mode of a data set in R. This function takes the vector as input and gives the mode value as output. Example When we execute the above code, it produces the following result −

October 29, 2024 / 0 Comments
read more

Scatterplots

3. Charts & Graphs

Scatterplots show many points plotted in the Cartesian plane. Each point represents the values of two variables. One variable is chosen in the horizontal axis and another in the vertical axis. The simple scatterplot is created using the plot() function. Syntax The basic syntax for creating scatterplot in R is − Following is the description of the parameters used − Example We use the data set “mtcars” available in the R environment to create a basic scatterplot. Let’s use the columns “wt” and “mpg” in mtcars. When we execute the above code, it produces the following result − Creating the Scatterplot The below script will create a scatterplot graph for the relation between wt(weight) and mpg(miles per gallon). When we execute the above code, it produces the following result − Scatterplot Matrices When we have more than two variables and we want to find the correlation between one variable versus the remaining ones we use scatterplot matrix. We use pairs() function to create matrices of scatterplots. Syntax The basic syntax for creating scatterplot matrices in R is − Following is the description of the parameters used − Example Each variable is paired up with each of the remaining variable. A scatterplot is plotted for each pair. When the above code is executed we get the following output.

October 29, 2024 / 0 Comments
read more

Line Graphs

3. Charts & Graphs

A line chart is a graph that connects a series of points by drawing line segments between them. These points are ordered in one of their coordinate (usually the x-coordinate) value. Line charts are usually used in identifying the trends in data. The plot() function in R is used to create the line graph. Syntax The basic syntax to create a line chart in R is − Following is the description of the parameters used − Example A simple line chart is created using the input vector and the type parameter as “O”. The below script will create and save a line chart in the current R working directory. When we execute the above code, it produces the following result − Line Chart Title, Color and Labels The features of the line chart can be expanded by using additional parameters. We add color to the points and lines, give a title to the chart and add labels to the axes. Example When we execute the above code, it produces the following result − Multiple Lines in a Line Chart More than one line can be drawn on the same chart by using the lines()function. After the first line is plotted, the lines() function can use an additional vector as input to draw the second line in the chart, When we execute the above code, it produces the following result −

October 29, 2024 / 0 Comments
read more

Histograms

3. Charts & Graphs

A histogram represents the frequencies of values of a variable bucketed into ranges. Histogram is similar to bar chat but the difference is it groups the values into continuous ranges. Each bar in histogram represents the height of the number of values present in that range. R creates histogram using hist() function. This function takes a vector as an input and uses some more parameters to plot histograms. Syntax The basic syntax for creating a histogram using R is − Following is the description of the parameters used − Example A simple histogram is created using input vector, label, col and border parameters. The script given below will create and save the histogram in the current R working directory. When we execute the above code, it produces the following result − Range of X and Y values To specify the range of values allowed in X axis and Y axis, we can use the xlim and ylim parameters. The width of each of the bar can be decided by using breaks. When we execute the above code, it produces the following result −

October 29, 2024 / 0 Comments
read more

Boxplots

3. Charts & Graphs

Boxplots are a measure of how well distributed is the data in a data set. It divides the data set into three quartiles. This graph represents the minimum, maximum, median, first quartile and third quartile in the data set. It is also useful in comparing the distribution of data across data sets by drawing boxplots for each of them. Boxplots are created in R by using the boxplot() function. Syntax The basic syntax to create a boxplot in R is − Following is the description of the parameters used − Example We use the data set “mtcars” available in the R environment to create a basic boxplot. Let’s look at the columns “mpg” and “cyl” in mtcars. When we execute above code, it produces following result − Creating the Boxplot The below script will create a boxplot graph for the relation between mpg (miles per gallon) and cyl (number of cylinders). When we execute the above code, it produces the following result − Boxplot with Notch We can draw boxplot with notch to find out how the medians of different data groups match with each other. The below script will create a boxplot graph with notch for each of the data group. When we execute the above code, it produces the following result −

October 29, 2024 / 0 Comments
read more

Bar Charts

3. Charts & Graphs

A bar chart represents data in rectangular bars with length of the bar proportional to the value of the variable. R uses the function barplot() to create bar charts. R can draw both vertical and Horizontal bars in the bar chart. In bar chart each of the bars can be given different colors. Syntax The basic syntax to create a bar-chart in R is − Following is the description of the parameters used − Example A simple bar chart is created using just the input vector and the name of each bar. The below script will create and save the bar chart in the current R working directory. When we execute above code, it produces following result − Bar Chart Labels, Title and Colors The features of the bar chart can be expanded by adding more parameters. The main parameter is used to add title. The col parameter is used to add colors to the bars. The args.name is a vector having same number of values as the input vector to describe the meaning of each bar. Example The below script will create and save the bar chart in the current R working directory. When we execute above code, it produces following result − Group Bar Chart and Stacked Bar Chart We can create bar chart with groups of bars and stacks in each bar by using a matrix as input values. More than two variables are represented as a matrix which is used to create the group bar chart and stacked bar chart.

October 29, 2024 / 0 Comments
read more

Pie Charts

3. Charts & Graphs

R Programming language has numerous libraries to create charts and graphs. A pie-chart is a representation of values as slices of a circle with different colors. The slices are labeled and the numbers corresponding to each slice is also represented in the chart. In R the pie chart is created using the pie() function which takes positive numbers as a vector input. The additional parameters are used to control labels, color, title etc. Syntax The basic syntax for creating a pie-chart using the R is − Following is the description of the parameters used − Example A very simple pie-chart is created using just the input vector and labels. The below script will create and save the pie chart in the current R working directory. When we execute the above code, it produces the following result − Pie Chart Title and Colors We can expand the features of the chart by adding more parameters to the function. We will use parameter main to add a title to the chart and another parameter is col which will make use of rainbow colour pallet while drawing the chart. The length of the pallet should be same as the number of values we have for the chart. Hence we use length(x). Example The below script will create and save the pie chart in the current R working directory. When we execute the above code, it produces the following result − Slice Percentages and Chart Legend We can add slice percentage and a chart legend by creating additional chart variables. When we execute the above code, it produces the following result − Explore our latest online courses and learn new skills at your own pace. Enroll and become a certified expert to boost your career. 3D Pie Chart A pie chart with 3 dimensions can be drawn using additional packages. The package plotrix has a function called pie3D() that is used for this. When we execute the above code, it produces the following result −

October 29, 2024 / 0 Comments
read more

Databases

2. Data Interfaces

The data is Relational database systems are stored in a normalized format. So, to carry out statistical computing we will need very advanced and complex Sql queries. But R can connect easily to many relational databases like MySql, Oracle, Sql server etc. and fetch records from them as a data frame. Once the data is available in the R environment, it becomes a normal R data set and can be manipulated or analyzed using all the powerful packages and functions. In this tutorial we will be using MySql as our reference database for connecting to R. RMySQL Package R has a built-in package named “RMySQL” which provides native connectivity between with MySql database. You can install this package in the R environment using the following command. Connecting R to MySql Once the package is installed we create a connection object in R to connect to the database. It takes the username, password, database name and host name as input. When we execute the above code, it produces the following result − Explore our latest online courses and learn new skills at your own pace. Enroll and become a certified expert to boost your career. Querying the Tables We can query the database tables in MySql using the function dbSendQuery(). The query gets executed in MySql and the result set is returned using the R fetch() function. Finally it is stored as a data frame in R. When we execute the above code, it produces the following result − Query with Filter Clause We can pass any valid select query to get the result. When we execute the above code, it produces the following result − Updating Rows in the Tables We can update the rows in a Mysql table by passing the update query to the dbSendQuery() function. After executing the above code we can see the table updated in the MySql Environment. Inserting Data into the Tables After executing the above code we can see the row inserted into the table in the MySql Environment. Creating Tables in MySql We can create tables in the MySql using the function dbWriteTable(). It overwrites the table if it already exists and takes a data frame as input. After executing the above code we can see the table created in the MySql Environment. Dropping Tables in MySql We can drop the tables in MySql database passing the drop table statement into the dbSendQuery() in the same way we used it for querying data from tables. After executing the above code we can see the table is dropped in the MySql Environment.

October 29, 2024 / 0 Comments
read more

JSON Files

2. Data Interfaces

JSON file stores data as text in human-readable format. Json stands for JavaScript Object Notation. R can read JSON files using the rjson package. Install rjson Package In the R console, you can issue the following command to install the rjson package. Input Data Create a JSON file by copying the below data into a text editor like notepad. Save the file with a .json extension and choosing the file type as all files(*.*). Explore our latest online courses and learn new skills at your own pace. Enroll and become a certified expert to boost your career. Read the JSON File The JSON file is read by R using the function from JSON(). It is stored as a list in R. When we execute the above code, it produces the following result − Convert JSON to a Data Frame We can convert the extracted data above to a R data frame for further analysis using the as.data.frame() function. When we execute the above code, it produces the following result −

October 29, 2024 / 0 Comments
read more

Web Data

2. Data Interfaces

Many websites provide data for consumption by its users. For example the World Health Organization(WHO) provides reports on health and medical information in the form of CSV, txt and XML files. Using R programs, we can programmatically extract specific data from such websites. Some packages in R which are used to scrap data form the web are − “RCurl”,XML”, and “stringr”. They are used to connect to the URL’s, identify required links for the files and download them to the local environment. Install R Packages The following packages are required for processing the URL’s and links to the files. If they are not available in your R Environment, you can install them using following commands. Input Data We will visit the URL weather data and download the CSV files using R for the year 2015. Explore our latest online courses and learn new skills at your own pace. Enroll and become a certified expert to boost your career. Example We will use the function getHTMLLinks() to gather the URLs of the files. Then we will use the function download.file() to save the files to the local system. As we will be applying the same code again and again for multiple files, we will create a function to be called multiple times. The filenames are passed as parameters in form of a R list object to this function. Verify the File Download After running the above code, you can locate the following files in the current R working directory.

October 29, 2024 / 0 Comments
read more

Posts pagination

Previous 1 … 84 85 86 … 445 Next