Explore BrainMass

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. © BrainMass Inc. brainmass.com September 28, 2023, 7:49 am ad1c9bdddf

    BrainMass Categories within Summary Tables

    Frequency Distribution

    Solutions: 285

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

    Contingency Table

    Solutions: 33

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

    BrainMass Solutions Available for Instant Download

    Descriptive Statistics Calculations

    Use the template below and calculate: Sum Average Median Mode Sample Standard Deviation Sample Variance Replace the 0 below with your calculated answers in the highlighted area in yellow. Student Height Weight Age Shoe Size Waist Size Pocket Change 1 64 180 39 7 36 18 2 66 140 31 9 30 125 3 69 130 31 9 25 151 4 6

    Range Rule of Thumb

    The Range Rule of Thumb is based on the insight that the range is often approximately 4 times as large as the standard deviation. This insight enables you to quickly estimate the standard deviation of a data set by finding the maximum and minimum data values, using them to compute the range, and then dividing this value by 4.

    MGMT 650 Q2 Descriptive Statistics Excel

    Here is sample data showing the weight of coffee beans in bags labeled 5 pounds. The data is in pounds. 1) Compute the mean. Compute the median. Compute the mode. 2) Compute the first quartile Compute the third quartile. Compute the interquartile range. 3) Find the largest number. Find the smallest number. What is the

    Bus Excel Project

    The attached MS-Excel file contains data on the bus fleet of the Buena School district. Download the file and analyze the characteristics of the Buena Bus fleet.a. Sort the data by type of Bus Manufacturer and calculate the Average Cost of Maintenance for each Manufacturer      b. Sort the data by Fuel Type and calculate the

    Two-way ANOVA Example

    Given the aggression scores below for Outcome A of the sleep deprivation experiment, verify that, as suggested earlier, these mean differences shouldn't be taken seriously by testing the null hypothesis at the .05 level of significance. Use the computation formul2as for the various sums of squares and summarize results with an A

    Birth Weights: Mean, median, mode, and more

    You will be using data to calculate various statistical values such as: mean, median, mode, maximum, minimum, standard deviation, and z-scores. You will also create tables and graphs to help analyze the data. 1. Convert all the given data to total ounces. 2. Use Excel to find the following statistics for the given data:

    Data Presentation,Model Specification, Interpret Results of Data

    I am seeking help with my statistics final. My assignments is required to be 9 pages in length, double-spaced, and in APA formatting. I am utilizing Introduction to Business Statistics (7th Edition) by Ronald M. Weiers. I am offering 17 custom credits for this assignment. I need it completed by Saturday October 22, 2016 (3:30 pm

    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

    Z-score method probability with different n values

    Would like the review of the formula step by step. I have to solve questions by using the z-score method with n being 1 and 100 to determine if an event is usual or unusual. Hunter Chemical Company claims that its major product contains on the average 4.0 fluid ounces of caustic materials per gallon. It further states that 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 Approvals 4.

    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 for watching TV

    Create a frequency distribution from the following. Average hours per week spent watching TV in the following countries is: USA 10 Argentina 22 UK 9 Philippines 9 Sweden 11 Spain 9 Thailand 12 South Africa 13 Poland 15 Russia 9 Mexico 11

    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

    Frequency Distribution graph and Histogram

    I need assistance with the following: I need a frequency distribution graph and histogram created with the data attached. a. Data analysis using descriptive statistics 1) Calculate the measures of central tendency, dispersion, and skew for your data 2) Display your descriptive statistical data using graphic and tabular tec

    Statistics - Computing Price Index

    See attached file. 1. Suppose the following data are prices of market goods involved in household transportation for the years 1994 through 2002. Using 1998 as a base year, compute aggregate transportation price indexes for this data. Year Items 1994 1995 1996 1997 1998 1999 2

    Grouped Frequency Distribution With Real Limits

    For the set of data below construct a grouped frequency distribution that also contains the real limits of each interval, the midpoint of each interval, the cumulative frequency, the mean, median, mode, standard deviation, variance and relative frequency. 45,48,49,52,53,54,58,59,60,61,61,61,64,69,70,70,71,72,74,78

    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

    Frequency distribution calculated

    How long does it take to travel to work Monday through Friday for 10 days? Monday = 30 + 35 /2 = 65/2 = 32.5 or 32 ½ or 0.10485 Tuesday = 35 + 25 /2 = 60/2 = 30 or 0.09675 Wednesday = 30 + 30 = 60/2 = 30 or 0.09675 Thursday = 25 + 30 /2 = 55/2 = 27.5 or 27 ½ or 0.0887 Friday = 35 + 35 = 70 /2 = 35 or 0.1129 Using

    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?

    AIU Job Satisfaction Database.

    Be sure to include information about how you would use the concept of probabilities to apply to profiles for hiring more satisfied individuals. (Job Satisfaction is an attitude about one's job. It may be measured globally or via facets (e.g. intrinsic/extrinsic). However, job satisfaction is a post hoc phenomenon. Using "prof

    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,