Trident DOC670 Module 3 SLP Latest 2020 January

DOC670 Applied Statistics for Research

Module 3 SLP

OBTAINING THE DATA FOR THE RESEARCH CONTEXT

Descriptive statistics are used to learn about the characteristics of a measure that is collected over time or may be a measure of an item from a survey administered to many people. Typically, descriptive statistics are the average score (mean), the maximum, the minimum in the scores along with the variation. Descriptive statistics is used to describe the measures rather than to make inference centered around the same item or conceptual construct being measured. Thus, descriptive statistics is not inferential statistics and does not use probability to infer behaviors of a population from which the measures were drawn.

Descriptive statistics fits the background analysis for your firm selected for your dissertation. Here you have financial and performance measures of the firm with respect to others in the same competitive space. In most cases descriptive measures can be used to generate trend lines to try and forecast based on past measures.

Here is a descriptive spreadsheet for the United Way of Orange County that shows the average and standard deviation for revenues and expenses from the 990 Report we looked at in SLP 2. Here in this spreadsheet Figure 4 (click the image to open the file) you see by clicking the various tabs on the lower part of the spreadsheet graphs that can be generated from this 990 data. Columns F and G have the average and standard deviation of the revenue and expense measures, but they are rather static. To use the years of revenue and expense measures, you can click the Forecast Sheet tab on your tool bar. This is how the graphs for Revenues, Expenses, and Net were produced where a technique called exponential smoothly is used that factors in the four years of data to produce the trend lines in the forecast.

Figure 4

Chapter 18 in:

Carlberg, C. (2016). Excel sales forecasting for dummies, 2nd edition. John Wiley & Sons. Available in the Trident Online Library: Follow these instructions for Finding Skillsoft Books. Enter 132620 in the search bar.