Enkindle

  Introduction           In Excel, you can perform descriptive and inferential statistics in various ways, and these methods have advantages and disadvantages. In this short article, I will introduce you to a technique you can use when you want to perform quick statistical calculations on a dataset.  Summary Statistics           Summary statistics are a subset of descriptive statistics that summarize and convey the crux of information about a sample data set. Some examples are the mean, standard error, median, mode, standard deviation, sample variance, kurtosis, skewness, range, minimum, maximum, sum, and count.            Most Excel users are accustomed to calculating these data individually. However, Excel offers a menu that delivers all descriptive statistics information at once—on the same page. Let us have a look.  The Data Analysis Command Tool       ...

1. Introduction           A hypothesis is a claim, an assumption, a guess, a prediction, or an allegation. Every day, we form hypotheses. The majority of hypotheses we form daily are educated guesses aimed at explaining why something is happening. For example, if all of the electrical devices in your room suddenly go out, you may come up with a series of hypotheses:  a) There is a widespread power outage.  b) Your prepaid credit on your meter has run out.  c) The meter is broken.            All of these hypotheses can be tested. In the first instance, you might go out to ask your neighbours if they have electricity. In the second scenario, you will step outside to check on your prepaid meter. In any event, any hypothesis must be tested before it is used or accepted. Untested hypotheses are only claims or allegations and cannot be utilized to make decisions.          ...

  Introduction Google forms can be used for a variety of purposes. In a recent blog, I demonstrated how to utilize Google Forms to create simple survey questions. In this article, I'll show you how to utilize Google Forms to create and distribute research questionnaires. The post would also go on to demonstrate how to export the data into Microsoft Excel.  Getting Started To get started, you must first develop and finalize your questionnaire. It is not a good idea to write your questions directly into Google Forms—it increases error.           This tutorial would make use of a PC. It is preferable to perform such exercises on a computer rather than a phone.  1. Go to www.forms.google.com  Your interface should look like this.    2. As seen above, click "start new form." This should take you to the following page:    3. Click on one of the "untitled forms" placeholders, clear the text, and type or copy and paste ...