IFSM 201
Excel
Import the japan.txt file into an Excel worksheet:
Download japan.txt from the class web site.
Open it in Excel (the Text Import Wizard will do the importing,
use the defaults).
Save it as an Excel Workbook.
Add a new column that is the product of the third C and fourth D columns.
Format the fourth D column and this new seventh G column in accounting style.
Add a header row naming the columns. Use whatever names you think make sense.
Make a tabular summary of the statistics of the numeric columns (B,C,D,G) of this data.
For each of the four numeric columns, show the sum, average, min, max and count of the values.
Put this tabular summary on a sheet by itself.
Format it some.
Print this summary statistics page.
Make a scatter chart of the third C column.
Adjust the axes, legend, title, marker sizes so that the page is
mostly usable information, so there's no wasted space.
This is a uniform distribution.
Print it.
Make a scatter chart of the new seventh G column.
Adjust the axes, legend, title, marker sizes so that the page is
mostly usable information, so there's no wasted space.
This is a non-uniform distribution.
Print it.
Make a scatter chart of the third C and seventh G column.
Put it on a sheet by itself.
Make it look good by fiddling with the axes, title, markers etc.
so there's no wasted space, minimize overlapping markers, labeled.
Add a linear trend/regression line.
Include the R-squared (correlation) value.
Format the line and the value for visibility.
Print this chart.
Turn the japan data into a table.
Apply some sort(s) on some column(s) and some filters on at least three columns,
one being a label column, to reduce the number of rows to less a printed page of rows.
Write in a cell what sorting and filtering has been done. Print this one page.
Print the sorted and filtered table, the summary statistics sheet, and the 3 charts.
Make sure that the filtering of the table did not change the data of
the chart or the summary statistics.