Excel: Charts

Intuitively describing data patterns. When conducting statistical studies it is as important to present the results in an intuitive manner so users may understand and act on it as it is to conduct the study itself. In this article I will briefly describe the recommended uses for each method. Purpose Chart Type Displaying Trends Over…

Excel: Cumulative Frequency

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…

Statistics: Cumulative Frequency

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…

Statistics: Charts

Intuitively describing data patterns. When conducting statistical studies it is as important to present the results in an intuitive manner so users may understand and act on it as it is to conduct the study itself. In this article I will briefly describe the recommended uses for each method. Purpose Chart Type Displaying Trends Over…

MVC 4 ADO.NET Entity Data Model

Leveraging Visual Studio’s ORM Tool to Create a Data Layer Any application which interacts with a data source utilizes a data layer to perform Create, Read, Update, and Delete (CRUD) operations. Usually, this is quite an arduous tasks requiring endless maintenance to reflect changes in the data source as they occur. However, Visual Studio provides…

MVC 4: Accessing Form Values

Leveraging the FormCollection object to retrieve user input. Collecting user input is one of the most common deliverables in Internet applications for which MVC provides a robust mechanism called the FormCollection. Beginning where my MVC 4 ADO.NET Entity Data Model article ended, I will demonstrate how to leverage FormCollection to collect user input. First, I’ll…

MVC 4: Displaying Data Source Records

Leveraging the Data Model to Retrieve Records for Display. As illustrated in MVC 4 ADO.NET Entity Data Model, Visual Studio now provides an extremely efficient ORM tool to quickly generate the data layer for CRUD operations. In this article, I will illustrate how to query and display data from the database into an Html form’s…