R Dataset / Package HistData / Wheat.monarchs

How To Create a Barplot

Webform
The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

How To Create a Stacked Barplot

Webform
The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

How To Create a Pie Chart

Webform
The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

How To Compute the Mean

Webform
The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

How To Create a Plot

Webform
The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

How to Compute the Median

Webform
The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Boxplot

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Correlation Coefficient

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Cumulative Frequency Histogram

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Dotplot

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Hollow Histogram

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Numerical Summaries

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Pie Chart

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Plot

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Regression

Stem and Leaf Plots

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.

Visual Summaries

The Drupal File ID of the selected dataset. The user may load another using the search bar on the operation's page.
Embed
<iframe src="https://embed.picostat.com/r-dataset-package-histdata-wheatmonarchs.html" frameBorder="0" width="100%" height="307px" />
Attachment Size
dataset-77745.csv 310 bytes
Dataset License
GNU General Public License v2.0
Documentation License
GNU General Public License v2.0
Documentation

On this Picostat.com statistics page, you will find information about the Wheat.monarchs data set which pertains to Playfair's Data on Wages and the Price of Wheat. The Wheat.monarchs data set is found in the HistData R package. You can load the Wheat.monarchs data set in R by issuing the following command at the console data("Wheat.monarchs"). This will load the data into a variable called Wheat.monarchs. If R says the Wheat.monarchs data set is not found, you can try installing the package by issuing this command install.packages("HistData") and then attempt to reload the data. If you need to download R, you can go to the R project website. You can download a CSV (comma separated values) version of the Wheat.monarchs R data set. The size of this file is about 310 bytes.


Playfair's Data on Wages and the Price of Wheat

Description

Playfair (1821) used a graph, showing parallel time-series of the price of wheat and the typical weekly wage for a "good mechanic" from 1565 to 1821 to argue that working men had never been as well-off in terms of purchasing power as they had become toward the end of this period.

His graph is a classic in the history of data visualization, but commits the sin of showing two non-commensurable Y variables on different axes. Scatterplots of wages vs. price or plots of ratios (e.g., wages/price) are in some ways better, but both of these ideas were unknown in 1821.

In this version, information on the reigns of British monarchs is provided in a separate data.frame, Wheat.monarch.

Usage

data(Wheat)
data(Wheat.monarchs)

Format

WheatA data frame with 53 observations on the following 3 variables.

Year

Year, in intervals of 5 from 1565 to 1821: a numeric vector

Wheat

Price of Wheat (Shillings/Quarter bushel): a numeric vector

Wages

Weekly wage (Shillings): a numeric vector

Wheat.monarchs A data frame with 12 observations on the following 4 variables.

name

Reigning monarch, a factor with levels Anne Charles I Charles II Cromwell Elizabeth George I George II George III George IV James I James II W&M

start

Starting year of reign, a numeric vector

end

Starting year of reign, a numeric vector

commonwealth

A binary variable indicating the period of the Commonwealth under Cromwell

Source

Playfair, W. (1821). Letter on our Agricultural Distresses, Their Causes and Remedies. London: W. Sams, 1821

Data values: originally digitized from http://www.math.yorku.ca/SCS/Gallery/images/playfair-wheat1.gif now taken from http://mbostock.github.com/protovis/ex/wheat.js

References

Friendly, M. & Denis, D. (2005). The early origins and development of the scatterplot Journal of the History of the Behavioral Sciences, 41, 103-130.

Examples

data(Wheat)data(Wheat)# ------------------------------------
# Playfair's graph, largely reproduced
# ------------------------------------# convenience function to fill area under a curve down to a minimum value
fillpoly <- function(x,y, low=min(y),  ...) {
    n <- length(x)
    polygon( c(x, x[n], x[1]), c(y, low, low), ...)
}# For best results, this graph should be viewed with width ~ 2 * height
# Note use of type='s' to plot a step function for Wheat
#   and panel.first to provide a background grid()
#     The curve for Wages is plotted after the polygon below it is filled
with(Wheat, {
    plot(Year, Wheat, type="s", ylim=c(0,105), 
        ylab="Price of the Quarter of Wheat (shillings)", 
        panel.first=grid(col=gray(.9), lty=1))
    fillpoly(Year, Wages, low=0, col="lightskyblue", border=NA)
    lines(Year, Wages, lwd=3, col="red")
    })
# add some annotations
text(1625,10, "Weekly wages of a good mechanic", cex=0.8, srt=3, col="red")# cartouche
text(1650, 85, "Chart", cex=2, font=2)
text(1650, 70, 
	paste("Shewing at One View", 
        "The Price of the Quarter of Wheat", 
        "& Wages of Labor by the Week", 
        "from the Year 1565 to 1821",
        "by William Playfair",
        sep="\n"), font=3)# add the time series bars to show reigning monarchs
# distinguish Cromwell visually, as Playfair did
with(Wheat.monarchs, {
	y <- ifelse( !commonwealth & (!seq_along(start) %% 2), 102, 104)
	segments(start, y, end, y, col="black", lwd=7, lend=1)
	segments(start, y, end, y, col=ifelse(commonwealth, "white", NA), lwd=4, lend=1)
	text((start+end)/2, y-2, name, cex=0.5)
	})# -----------------------------------------
# plot the labor cost of a quarter of wheat
# -----------------------------------------
Wheat1 <- within(na.omit(Wheat), {Labor=Wheat/Wages})
with(Wheat1, {
	plot(Year, Labor, type='b', pch=16, cex=1.5, lwd=1.5, 
	     ylab="Labor cost of a Quarter of Wheat (weeks)",
	     ylim=c(1,12.5));
	lines(lowess(Year, Labor), col="red", lwd=2)
	})
	
# cartouche
text(1740, 10, "Chart", cex=2, font=2)
text(1740, 8.5, 
	paste("Shewing at One View", 
        "The Work Required to Purchase", 
        "One Quarter of Wheat", 
        sep="\n"), cex=1.5, font=3)with(Wheat.monarchs, {
	y <- ifelse( !commonwealth & (!seq_along(start) %% 2), 12.3, 12.5)
	segments(start, y, end, y, col="black", lwd=7, lend=1)
	segments(start, y, end, y, col=ifelse(commonwealth, "white", NA), lwd=4, lend=1)
	text((start+end)/2, y-0.2, name, cex=0.5)
	})
--

Dataset imported from https://www.r-project.org.

Picostat Manual
How To Register With a Username
  1. Go to the user registration page.
  2. Enter a username and email address into the form.
  3. Answer the ReCaptcha (this is used to prevent spam).
  4. Click Submit.
  5. Click the link that was sent to the email address you registered with.
  6. Clicking the link will open another page on Picostat where you can select a password.
  7. Click Save and enter any profile details you wish to enter.
How To Register With Google Single Sign On (SSO)
  1. Go to the user login page.
  2. Click the Google button that says "Sign in with Google". This will redirect you to a page controlled by Google.
  3. Enter your Google username and password if you are not already authenticated.
  4. Review the Picostat Terms of Use and Privacy Policy. Then submit the Google form if you accept the terms.
  5. Google will redirect you back to Picostat with your new account created and you will be logged in.
  6. Enter any profile details you wish to share.
How To Login With a Username and Password
  1. Go to the user login page.
  2. Enter your username and password that you registered with.
  3. Click "Login". You will be redirected to your user homepage authenticated.
How To Login With Google Single Sign On (SSO)
  1. Go to the user login page.
  2. Click the button that says "Sign in with Google".
  3. If you already registered with Picostat via Google SSO, you will be redirected to your user homepage authenticated.
How To Import a Dataset
  1. Create a Picostat account or login with your existing picostat account (see above).
  2. Go to the dataset import page.
  3. Select a license for the dataset. The default is "No License" but allows Picostat to host a copy of the dataset as per the privacy policy. You may wish to uncheck the "Public" option if you do not wish to share your dataset with others. R Datasets that come by downloading R have a GNU General Public License v3.0 which may also be selected from the Picostat dropdown.
  4. Enter a title for the dataset
  5. Choose a dataset input methods. Available options include:
    • Random data - this populates your dataset with random numbers between 0 and 100. You can specify the number of rows and columns for the random dataset.
    • CSV, TSV or TXT file - you will have the option upload a file within the current file size limit and also specify the header and whether or not the dataset is a contingency table. With contingency tables, the first column becomes a label for the rows. Currently with Picostat, there is limited support for contingency tables. Choose "Yes" to the Header option if the first line of the data contains titles for the rows. Also choose the Separator for the dataset. A separator is what breaks the data up. In some cases, a comma would separate data values in a row. You will also have the option to add documentation in the form keyboarded text and also uploaded documentation attachments. You can also specify a license for the documentation.
    • Copy and Paste. This selection contains many of the same fields as importing a file with an additional textarea to copy and paste data to.
    • Empty dataset. Start with a blank dataset and manually add data with the Picostat dataset editor.
    • Excel file - Choose this option if you would like to convert your Excel spreadsheet to a Picostat dataset. With this selection, you will have the option to specify whether to use the first row in the Excel file as column names. If you would like to choose a specific sheet to use, you can also specify with entering its name in the text input.
    • sas7bdat file - SAS is a powerful statistical software package that has its own proprietary file format. Choose this option if you are importing a SAS file.
    • SPSS sav file - SPSS is a statistical package owned by IBM. You can import SPSS files by choosing this option.
  6. Choose whether or not the dataset contains a header. Some of the dataset input methods allow you to specify whether or not a Header exists on the file. Sometimes dataset files contain a Header as the first row which names the columns. If you choose "Yes" to this, the first row in the dataset will become column headers.
  7. You can also add documentation and specify a documentation license. This can be used to help explain your dataset to those unfamiliar with it.
  8. Choose whether or not to upload an supporting attachments.
  9. Pass the captcha. To prevent spam submissions, Picostat has a captcha which is used to prevent automated submissions by bots.
  10. Choose a privacy setting for the dataset. You can also specify whether or not the dataset is Public. If you uncheck this setting, only you and the Picostat administrator will be able to view the dataset.
  11. Submit the form. Once the form is validated, you will be redirected to the dataset homepage where you can choose to edit or perform statistical operations on the dataset.
How To Perform Statistical Analysis with Picostat
  1. Go to any dataset homepage. You can get a full list at the dashboard.
  2. Near the top of the page there will be two drop downs. One for analysis and one for education. Here we will choose Analyis. Choose from one of the following:
    • Numerical Summaries - Here you can get the:
      1. Arithmetic mean
      2. Median
      3. Quartiles
      4. Minimum and Maximum
      5. Stem-and-leaf plot
      6. Standard deviation and Variance
      7. IQR
      8. Cumulative frequencies
    • Plot - a plot of two columns on the cartesian coordinate system
    • Boxplot - a Boxplot (box-and-whisker plot) of a column.
    • Correlation Coefficient - Compute the correlation coefficient between two columns.
    • Cumulative Frequency Histogram - Display a cumulative frequency histogram
    • Dotplot
    • Hollow Histogram - Plot two columns on the same histogram with a different color for each column.
    • Pie Chart
    • Regression - Perform a simple linear regression and compute the p-value and regression line. Also plots the data with the regression line.
    • Stem and Leaf Plots - Plot a one or two-sided stem-and-leaf plot from one or two columns respectively.
    • Visual Summaries - plots the following:
      1. Frequency Histogram
      2. Relative Frequency Histogram
      3. Cumulative Frequency Histogram
      4. Boxplot (Box-and-whisker plot)
      5. Dotplot
  3. PDF - Check this box if you want to download a PDF of the output from the statistical analysis application.
  4. HTML - Check this box if you want a link to the HTML page created with the application.
  5. R File - Check this box if you want a link to download the R commands used to generate output from this statistical application. You should be able to copy the commands verbatim into R Studio or R to recreate the analysis.
How To Use Educational Applications with Picostat
  1. Go to any dataset homepage. You can get a full list at the dashboard.
  2. Near the top of the page there will be two drop downs. One for analysis and one for education. Here we will choose Education. Choose from one of the following:
    • How To Create a Barplot - This will show you how to create a bar chart after selecting a column with the mouse.
    • How To Create a Stacked Barplot - This application will show you how to create a stacked bar plot from a column vector.
    • How To Create a Pie Chart - This application will show you how to create a pie chart from a column of data
    • How To Compute the Mean - This application will show you how to compute the mean from a column vector
    • How To Create a Plot - This app will show you how to plot two columns in the cartesian coordinate system.
    • How To Compute the Media - This statisistical app will show you how to compute the median from a column vector.
  3. PDF - Check this box if you want to download a PDF of the output from the education application.
  4. HTML - Check this box if you want a link to the HTML page created with the application.
Recent Queries For This Dataset

No queries made on this dataset yet.

Title Authored on Content type
US Baby Names in 2015 March 25, 2017 - 6:31 PM Dataset
R Dataset / Package DAAG / allbacks March 9, 2018 - 1:06 PM Dataset
R Dataset / Package DAAG / geophones March 9, 2018 - 1:06 PM Dataset
R Dataset / Package Ecdat / Bids March 9, 2018 - 1:06 PM Dataset
R Dataset / Package car / Womenlf March 9, 2018 - 1:06 PM Dataset