Facilitating Technology Literacy || Call Us Today! 780-240-6806|contact@WindSongTraining.ca

This author has not yet filled in any details.
So far Joanna Siennicka has created 5 blog entries.

A Few Words About the Pearson’s Correlation Coefficient.

“Politicians use statistics in the same way that a drunk uses lamp-posts for support rather than illumination” -A. Lang Statistics is a very complex subject and because of its complexity statistics and its terms are frequently misunderstood and misused. I came across an excellent article on The datapine Blog about how statistics can be misleading.  [...]

By |2021-03-26T17:45:50-06:00March 26th, 2021|Correlations, Excel, Statistics|0 Comments

How to use the Correlation Command

Once the Data Analysis toolbox has been enabled, the correlation function is ready to use. For this example, we are going to use data from two stock market indexes: NASDAQ Composite Index and the Dow Jones Industrial Average (https://ca.finance.yahoo.com/quote/ONEQ/history?p=ONEQ and https://ca.finance.yahoo.com/quote/DIA/history?p=DIA) . The data is the daily closing price for the last 6 months of [...]

By |2021-02-17T00:05:15-07:00December 30th, 2020|Correlations, Excel, Tutorials and How-Tos|0 Comments

How to Enable Analysis ToolPack in Excel

First: What is the Analysis ToolPak: Excel’s Analysis ToolPak provides a variety of tools and functions which enable sophisticated data analysis to be preformed. It produces output tables, and, in addition, some tools also generate charts. The add in takes the basic Excel functions and combines them into workflows where only the input values and [...]

By |2021-02-18T17:15:05-07:00December 23rd, 2020|Excel, Tutorials and How-Tos|0 Comments

Keyboard Shortcuts for Microsoft Excel 2016

Whether you are technologically savvy or not you can still implement shortcuts when using software applications such as Microsoft Excel. The shortcuts are easy to use and remember. For those people that tend to forget things, keeping a print out of the shortcuts is not a bad idea.

By |2021-02-18T17:23:32-07:00August 26th, 2019|MS Office 2016, Resources|0 Comments

Keyboard Shortcuts for Microsoft Word 2016

Whether you are technologically savvy or not you can still implement shortcuts when using software applications such as Microsoft Word. The shortcuts are easy to use and remember. For those people that tend to forget things, keeping a print out of the shortcuts is not a bad idea.

By |2021-02-18T17:20:49-07:00August 22nd, 2019|MS Office 2016, Resources|0 Comments