Category: Data Analysis


How to Use Wildcards in Excel?

Wildcard characters such as the asterisk “*”, question mark “?” and the tilde “~” can greatly extend searching, counting, and addition functionality in Excel.  Excel wildcards can be used with functions such as AVERAGEIF,...

Multiple Regression Analysis with Excel 1

Multiple Regression Analysis with Excel

Simple regression analysis is commonly used to estimate the relationship between two variables, for example, the relationship between crop yields and rainfalls or the relationship between the taste of bread and oven temperature.  However,...