
Explore primary data via surveys and questionnaires, or use secondary data from publications; evaluate accuracy and the cost-benefit tradeoff with sources like Census Bureau and Bureau of Labor Statistics.
Explore how frequency distribution clarifies data by counting frequencies and building a distribution table for qualitative data. Analyze a shoe-brand survey of 50 responses to reveal Nike leading in popularity.
Create a bar graph for qualitative data in Microsoft Excel by inserting a column chart, adding x-axis and chart titles, and formatting the axis.
Convert inclusive intervals to exclusive boundaries by filling gap between limits; compute lower boundary as lower limit minus D/2 and upper boundary as upper limit plus D/2 to construct histogram.
Learn to build a grouped frequency distribution for continuous data and create a histogram in Excel, using two methods with exclusive class boundaries and an example of 25 salesmen.
Assess how pie charts can be limited for comparing product sales and contrast them with a horizontal bar graph, and identify when pie charts effectively emphasize large or small shares.
Explore numerical measures of central tendency for quantitative data, and learn how mean, median, and mode summarize data by a single value to identify the center.
Learn how to compute the mean in Excel from raw, ungrouped, and grouped data, and how to calculate weighted mean using the sum and average functions.
This Statistics course is your first step to learn how to make sense of piles of data using the graphical and numerical measures. It has students (from over 130 countries), including absolute beginners in Statistics and professionals from other fields. Here is what some of them have to say:
"Simple to understand and follow; graphics are clean and easy to read" ~ Linda Chisholm
"The instructor explained three different ways to calculate frequency in Excel." ~ Diane Dye
Course Description:
This Statistics course is designed for students and businesses who want to learn how to summarize data and communicate the results effectively. In this course, I will take you through the tabular, graphical and numerical methods that one can use to turn data into information using Microsoft Excel.
There are no prerequisites required to take this course as I will start all the concepts from scratch.
A glimpse of what you are going to learn in 3 hours:
Still wondering if this course is useful?
Well, here is our take - Its better to spend a couple of hours learning how to summarize and present your data than spending days to try and make sense of the data without knowing these methods.
All that said, lets get started..!