| Contents |
|---|
| * R for actuarial students - CS1B and CS2B |
| * Probability Distributions |
In {faraway}: Functions and Datasets for Books by Julian Faraway
In a study of cheddar cheese from the LaTrobe Valley of Victoria, Australia, samples of cheese were analyzed for their chemical composition and were subjected to taste tests. Overall taste scores were obtained by combining the scores from several tasters.
taste - a subjective taste score
Acetic - concentration of acetic acid (log scale)
H2S - concentration of hydrogen sulfice (log scale)
Lactic - concentration of lactic acid
R is an open-source statistical package based on the S language. It is a powerful computing tool that combines the usefulness of a statistical analysis package with that of a publication quality graphics package and a matrix-based programming language. It's easy enough to use for quick and simple tasks, yet powerful enough for the most demanding ones. The goal of this demonstration is to provide a basic introduction to using R. An R session differs from that of other statistical software. You will find it to be an interactive approach where the results from one step lead to the next. This introduction to R is necessarily limited in scope to only a handful of analyses. Once you become familiar with R and browse through some of the online help topics, you will discover tools for practically any type of analysis you need. S-PLUS is a commercial application also based on the S language. Much of R is identical to the command line useage of S-PLUS. There are differences though in some functions and their arguments so existing S-PLUS code may require some modification to run in R.
#Location,X,Y
#UL Pavilion,52.6762442,-8.5738424
#Main Bridge,52.67805256546161, -8.576352949537121
#Living Brige,52.67662148185925, -8.570323343761297
#Main Campus Bus stop,52.67273129954312, -8.570752497200047this R package allows the user to Create an SQL query.
By interpreting a Conventional piece of a rcode. This queryThat would be then passed to the database As standard SQL.
The results of this query can then be collected by our and retrieved into the our environment for further processing.
This is very useful because it allows Data analysis Without downloading the entire contents of the database.
We are mindful that The data can bE Many millions of rows.
I basically not possible to download into the R environment at all.
This approach is very convenient and very cost efficient in terms of memoryAnd computational time.
The overall structure of the package is very simple If you are already familiar with tidy verse,
I recommend a straightforward SQL query - with minimal complications - that contains "enough" information Once the Query is collected into the R environment, further elaborations can be carried out
The most complex part of This approach is actually creating the Database connection.
What is required here is knowledge of the Database permissions
In a corporate setting, It is best to contact. The DBA connection string will have the following sort of formats.
CODE
These permissions are commercially sensitive and must be kept secure and secret for cyber-security purposes.
https://en.wikiversity.org/wiki/Database_Examples/Northwind
About the Northwind sample database The Northwind database is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades. The Northwind database contains the sales data for a fictitious company called “Northwind Traders,” which imports and exports specialty foods from around the world. The Northwind database is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting. The Northwind database has since been ported to a variety of non-Microsoft databases, including PostgreSQL.
The Northwind dataset includes sample data for the following.
Suppliers: Suppliers and vendors of Northwind Customers: Customers who buy products from Northwind Employees: Employee details of Northwind traders Products: Product information Shippers: The details of the shippers who ship the products from the traders to the end-customers Orders and Order_Details: Sales Order transactions taking place between the customers & the company The Northwind sample database includes 14 tables and the table relationships are showcased in the following entity relationship diagram.