Windsong Training
Share
At Windsong we focus on helping people to use their computers effectively. At Windsong Training we focus on helping people to use their technology effectively.
In this article we are going to look at Excel’s Goal Seek command. This command is actually quite easy to use, and it is very popular because of its ability to look backwards from a given result. A common example used to illustrate this command is finding the amount a person can borrow, at a given interest rate, based on a monthly payment; basically, pairing Goal Seek with the PMT function. ...
We have a steady supply of Covid-19 statistics and graphs on sites like Worldometers with their corona virus page, and Our World in Data, and their corona virus page. Some of the available graphs have an option to show "Moving Averages" with averages of 3 days or 7 days. These averages smooth the data to hide rabid fluctuations....
12/30/2020
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 ( and . The data is the daily closing price for the last 6 months of 2019. Here is a sample of the first few and the last few lines of the example file, and a graph of the data for the last 6 months of 2019:...
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 D…
12/16/2020
In previous articles we discussed adding fixed error bars and Standard Deviation error bars to Excel charts. The last option available on the Format Error Bars dialog is the standard error, short for "standard error of the mean". Using the same data set that we used for the post Standard Deviation Error Bars in Excel, we can choose the Standard Error option from either the Chart Elements button in the upper right corner of the chart, or from the Format Error Bars dialog....
“Standard Error” Error Bars in Excel In previous articles we discussed adding fixed error bars and Standard Deviation error bars to Excel charts. The last option available on the Format Error Bars dialog is the standard error, short …
Click here to claim your Sponsored Listing.
Category
Contact the business
Telephone
Website
Address
Edmonton, AB
