IFSM 201

Excel  "kana" exercise.    *New-to-you technique

*Import the kana.txt file into an Excel worksheet:
  Start Excel, then: Data | Get [External or &Transform] Data | From Text
   click Load
  (the Text Import Wizard will do the importing, use the defaults).
  Save it as an Excel Workbook.
Excel automatically creates a table, in this case with generic column headers
 because the data file does not contain a header row.
Check to make sure you got all 5000 lines of data.
Widen the columns for readability, if necessary.
Center align the single letter column.
Comma style the C column, with no decimal digits.
Insert a column to the left of column E. Make it the product of the third C and fourth D columns.
Format the fourth D column and this new 42 E column in accounting style.
Edit the header row to give meaningful names for the columns, 
 using whatever names you think might make sense.
Rename the sheet 'kana_data'.

On a sheet by itself, make a tabular summary of the statistics of the 
 numeric columns (B,C,D,E,H,I) of this data. 
For each of the six numeric columns, 
 show the sum, average, *standard deviation, *median, min, max, and count of the values.
Hint: fill handle!
Rename the sheet 'stats'.
Format it so it looks good and the values are displayed appropriately for their type.

Make a *scatter chart of the third C column.
Put it on a chart-sheet by itself.
Adjust the axes, legend, title, marker sizes so that the page is 
 mostly usable information, so there's no wasted space.
Note that this is a uniform distribution (every value is equally likely).

Make a scatter chart of the new 42 E column.
Put it on a chart-sheet by itself.
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.

Make a scatter chart of the seventh H and eighth I columns.
Put it on a chart-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:  Trendline   More Options...
  Include the *R-squared (correlation) value. 
  Format the line and the R-squared value for visibility.
See the kanaXYchart.pdf for what this can look like. (A chart can be Exported to a PDF file.)
and the image file below this link.

Back to the kana data table.
Apply some multiway sorts on some columns and some filters on at least three columns, 
one being a label column, to reduce the number of rows to less than one printed page of rows. 
*Make sure that the filtering of the table does not change the data of the charts 
or the summary statistics. If it does, make a copy of the data onto another sheet 
and do the sorting and filtering there.
Write in a cell what sorting and filtering has been done.