Using Excel to create a script to batch-rename images. First, I’ll begin with a simple set of images I intend to rename. Then, I’ll create a new Excel spreadsheet from which I’ll delete the last two worksheets, leaving only one. In my new spreadsheet, I’ll enter those image names into an Excel spreadsheet (or use…
Using excel to query the database to produce reports. Using the ubiquitous Office application Excel, users may easily perform queries against your database to display reports within the worksheet and then utilize Excel’s robust tools to customize their reports. For this example, I’ll begin with a simple customers tables from AdventureWorks db. First, I’ll open…
Understanding event outcomes by their frequency. One of the most important patterns studied within statistical research are frequency distributions and their cumulativeness to understand events. In this example we’ll begin with a dataset illustrating adult student ages with the goal of understanding how often certain-aged students participate in school. Next, I’ll add to my spreadsheet…
Presenting column headers as rows. If you have ever worked with a long list of column headers – too long so it displays off the screen to the right, you know how arduous such a list can be to work with – use Transpose. I’ll begin with a list of columns which goes up to…
Combine data from worksheets into a new worksheet. Beginning with two worksheets containing fictitious data where both share a column – you need at least one “key” between the two, I will use Excel to combine both sheet’s data into one worksheet. First, save the spreadsheet somewhere easily accessible. Define Dataset Ranges In Excel, name…
Using the Chi-Squared Test to Validate Results When analyzing data it is important to demonstrate confidence the results found using the sample reflects would be found throughout the population, and not random phenomenon. In this article, I will begin with a simple A/B Test determining between two age groups (1-50, 51-100) which constitute the larger…
Use a Bar Chart to Communicate Important Trends In my Charts article, I briefly described how to create the most common types of Excel charts. In this article I will highlight important considerations when designing a bar chart to ensure its ability to intuitively illustrate patterns within data. First, I’ll begin with a simple dataset…
Please see my other Statistics articles. Choosing the Correct Method to Intuitively Communicate Data Patterns. Many options exist to intuitively communicate patterns in data for enable strategic decision-making. The following table recommends charts depending on your goals. Chart Purpose Example Bar Chart Simplest method for summarizing data, especially for a smaller number of categories and…
Describing Central Tendency of Data Descriptive statistics is concerned with describing important aspects of set of measurements, organizing and summarizing data. Here’s an example of descriptive statistics using the following dataset: There are 20 statistics classes at a university for which all the ages of the students in one class have been collected – a…
Please see my other Business Intelligence articles. Leveraging descriptiven and inferential statistics to deliver a competitive, data-drive strategy. Leveraging Free Tools in Statistics I’ve found the following free tools to be very useful when analyzing data. Mockaroo: Easily create large test data sets. https://mockaroo.com/ Meta-Chart: Easily create diagrams and charts. https://www.meta-chart.com/ Descriptive Statistics Descriptive statistics…
TechMbaBi 