Share
Explore BrainMass

Summary Tables

Summary tables are a tool used in descriptive statistics to summarize either categorical or numerical variables in a tabular format. Collected data can be organized in these tables and this data is usually either characteristic of frequencies or counted values. Utilizing a summary table is practical in statistics because different tests, such as a Chi-square test, and various measures can be assessed and interpreted to gather meaningful results. A frequency distribution is a regularly used type of summary table in statistics. Basically, a frequency distribution organizes data by splitting it up into different categories and indicating the value associated with each individual category. Additionally, a frequency distribution only looks at the tabulated frequencies for the different categories of one variable at a time. For example, if a teacher was calculating the different hair colours of all her students, the variable in this case would be hair colour and the categories would be all the different colours recorded from the students. When working with more than one variable, a frequency distribution cannot be used, and instead a contingency table is required. A contingency table is another kind of summary table which looks at the relationship between multiple categorical variables. Using different tests, statistical significance between the different variables can be tested. Essentially, a contingency table is just a more complex version of a frequency distribution. The use of summary tables is integral to the practice of statistics. For example, when conducting hypothesis tests, a summary table is a common starting point which assists in understanding what relationships are being tested in the null hypothesis. Thus, maintaining a basic understanding of summary tables is necessary to properly analyze data and conduct measures of significance.

Categories within Summary Tables

Frequency Distribution

Postings: 275

A frequency distribution Is commonly represented in tabular format and can summarize data for either categorical or numerical variables.

Contingency Table

Postings: 31

This type of table presents data for more than one categorical variable over usually five or less levels.

Basic Statistics Test 1

Basic Statistics Name: Test 1 1) A test worth 100 points was given to a class with the following results: Midpoint Interval Freq. Rel. Freq. 89.5 - 99.5 5 79.5 - 89.5 8 69.5 - 79.5 17 59.5 - 69.5 7 49.5 - 59.5 3 A) Fill in the Midpoint column and the Relative Frequency column in the above table. B) Draw t

Forecasting Models for Decision Making

Two airlines that are merging and the new president, who has to quickly get a handle on the maintenance costs for their entire fleet of planes. The president must act quickly, but accurately, to make the decisions necessary to create a financially sound company. 1. Prepare Peg Young's response to Stephen Ruth. 2. Give suppor

Frequency Distribution Analysis and Calculations

** Please see the attached file for the complete problem description ** 1. Prepare a frequency distribution of ungrouped data including cumulative frequency (tally) for the table of approved 2. Calculate the mean, mode and median of the table of approved 3. Calculate the range, variance and standard deviation table Approval

Frequency Distribution Analysis

A frequency distribution is shown below. Complete parts (a) through (e). The number of dogs per household in a small town. Dogs 0 1 2 3 4 5 Households 1185 425 163 45 28 15 x P(x) 0 1 2 3 4 5 (a) Use the frequency distribution to construct a probability distribution. (round to the nearest thousandth as

Frequency Distribution and Sampling: Sampling Plan Analysis

1. 49, 34, and 48 students are selected from the Sophomore, Junior, and Senior classes with 496, 348, and 481 students respectively. Identify which type of sampling is used and why 2. The name of each contestant is written on a separate card, the cards are placed in a bag, and three names are picked from the bag. Identify whi

Statistics: Graphs and Frequency Distributions in EXCEL

Using Excel, please set these problems up in order to create the proper graphs. Enter the following data into Microsoft Excel, and answer the questions. 1. Twenty employees of Bright Idea Lightbulb Company were asked if they approved or disapproved of the new floor manager. Below are their responses. Let A represent appro

Generate a Frequency Distribution and a Z-scores using Microsoft Excel

How to Generate a Frequency Distribution and a Z-scores using Microsoft Excel? Using the following data: Month Year 1 Year 2 Year 3 Year 4 1 18,000 45,100 59,800 35,500 2 19,800 46,530 30,740 51,250 3 15,700 22,100 47,800 34,400 4 53,600 41,350 73,890 68,000 5 83,200 46,000 60,200 68,100 6 72,900 41,800 55,200 61,1

Confidence Intervals and Graphing: Hours Spent Training Per Year

A study of hours spent in training (per year) at a company was conducted with 49 participants. The mean number of hours spent in training was reported to be 89.25 hours. The standard deviation was 13.44 hours. 1. Calculate a 95% confidence interval for the average time spent in training per year at this firm. 2. Create a g

Form a frequency, Display the information as a histogram, calculate an estimate of the mean and sample standard deviation if this data, Determine a 95% confidence interval for the population mean (i) what is the probability that one person has an allergic reaction ? (ii) Using the Poisson approximation to the binomial, what is the probability that no one in a group of 120 patients has an allergic reaction ?

Question (1): The data in the table below relate to cadence. Form a frequency distribution using the classes 70 - 79.9 , 80 - 89.9 ...., 130 - 139.9 Display the information as a histogram. Use your frequency table to calculate an estimate of the mean and sample standard deviation if this data. Determine a 95% confidence int

Statistics Questions

See attached file for full problem description. 1. If the scores in a sample have been organized into a frequency distribution table, the number of scores (n) can be obtained by adding the values in the f column. True False 2. To find â?'X for the scores in a frequency distribution table, you simply

Place the following scores in a frequency distribution table. Describe the difference in appearance between a bar graph and a histogram, and describe the circumstances under which each type of graph should be used. What is the shape of the distribution. Find each of the percentiles and percentile ranks requested.

1. Place the following scores in a frequency distribution table. Include columns for proportion (p) and percentage (%) in your table. The scores are: 4, 6, 2, 9, 8, 8, 5, 7, 7, 3, 6, 6, 7, 4, 5, 8, 6, 5 2. Under what circumstances should you use a grouped frequency distribution instead of a regular frequency distribution?

Chart types - Ogive, Histogram and Pie chart

Question 1 Multiple Choice In a stem and leaf plot of numbers with five digits, the stem has two digits. In the number, 42096, the leaf is: 420 209 096 426 Question 2 Multiple Choice An advantage that a histogram has over a pie chart is that: When two categories are close in size,