Summary Tables
BrainMass Categories within Summary Tables
Frequency Distribution
A frequency distribution Is commonly represented in tabular format and can summarize data for either categorical or numerical variables.
Contingency Table
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
Differences of relative and cumulative frequency distribution
Illustrate, with a numerical example, the difference between the relative and cumulative frequency distributions.
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
Probability Distribution - Using 100 pennies, complete the following activities: 1. Spread 100 pennies across a table ... [See the attached Question File.]
Can you help me specifically with Part B - especially #3 & #4? Part A Directions: Using 100 pennies, complete the following activities: 1. Spread 100 pennies across a table 2. Separate into two groups based on heads and tails 3. Total the number of heads and number of tails 4. Compute the percentage of heads and the perce
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
Frequency Distributions in the Business World
Why is it important to be familiar with frequency distributions in the business world? Give examples by using a distribution chart from a set of data.
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,