Share
Explore BrainMass

Quantative Analysis of Data

Calculate the Mode, Median, and Mean in Excel

I need assistance with one section of this assignment. It asks to calculate the mode, median, and mean in Microsoft Excel using a specific set of data (summer historical data) and to compare the mode, median, and mean of the data. I have included the work from week 5 as well as the complete assignment due to show I'm not asking

Pete's copy center located in Boston, MA has three coin operated copying machines used primarily by Politicians to make copies of their confidential diaries and illegal agreements with foreign governments and corporations. The owner, Pete Salem, is a former Ricoh repairman and can fix a broken machine within 20 minutes on the average. Many times the machines are only jammed and he can get them working again quickly so the exponential will describe his repair time distribution. The time-to-breakdown of a freshly repaired copier averages 60 minutes and is also exponentially distributed. His revenue when all machines are working averages $80/hr per machine. When one machine is broken his revenue drops to $60/hr per working machine because of balking. When two machines are broken his revenue from the remaining machine decreases to $50/hr. When all machines are broken his revenue naturally drops to zero. a) Compute his average hourly revenue? b) If he employs a second, equally competent, repairman, what will be his total expected hourly income? c) What is the largest hourly wage he can pay the employee without decreasing the expected hourly income he earned when working alone?

Pete's copy center located in Boston, MA has three coin operated copying machines used primarily by Politicians to make copies of their confidential diaries and illegal agreements with foreign governments and corporations. The owner, Pete Salem, is a former Ricoh repairman and can fix a broken machine within 20 minutes on the a

A recent study of the life span of portable compact disc players

Portable CD Player Lifetimes A recent study of the life span of portable compact disc players found the average to be 3.7 years with a standard deviation of 0.6 year. If a random sample of 32 people who own CD players is selected, find the probability that the mean lifetime of the sample will be less than 3.4 years. If the m

Comparing the Scores of Two Treatments

A researcher plans to compare two treatment conditions by measuring one sample in treatment 1 and a second sample in treatment 2. The researcher will then compare the scores for the two treatments. If there is a difference between the two groups of scores, a. Briefly explain how the difference may have been caused by the trea

Mean versus Median for Central Tendency

There are good examples of how mean and median is calculated. Both provide us an idea of the data point that is around the center of the dataset. Now the issue is why do we have two different ways of describing the center?

Example of Data Analysis using Descriptive Statistics

Calculate the measures of central tendency, dispersion, and skew for your data. Display your descriptive statistical data using graphic and tabular techniques. * Frequency distribution * Histogram Based on your skew value and histogram, discuss the best measures of central tendency and dispersion of your data. Justify you

Variance & standard deviation of grouped frequency data

The following frequency table summarizes the ages of 100 shoppers at the local grocery store. Calculate the sample variance and standard deviation for this data set. Please show your work in Excel. Age of the shopper Frequency 15-25 15 25-35 3

Clues in Data: Distribution of heights, weights, mean, median of students

See attached file for problem and data. Problem 1: Show the distribution of heights visually. Can you draw any conclusions? What does it mean to "show the distribution...visually?" What specific tool in Chapter 1 gives a picture of the data distribution? Problem 2: Describe the distribution of weights with the Five Numb

Normal distribution: Standard deviation percentiles

Using a standard normal distribution, what percent of scores fall within one standard deviation of the mean? What percent of scores fall two or more standard deviations below the mean? If the mean = 250, what is the median?

Quantitative Analysis

The economists in the Obama administration suggested that the stimulus package that they recommended in early 2008 would keep unemployment under eight percent. Even though they did not show us their analysis, we all know that it was flawed because unemployment reached ten percent in 2010. Were their econometric models improper

Process Capability and SPC

This solution analyzes the process capability and SPC of a process. The solution analyzes the Xbar and R charts for the process.

Statistics: Correlation Coefficient, Probability and Measurement

See the attached file. Q1) The diastolic blood pressure, x, and the systolic blood pressure, y, were recorded for 13 females. x 76 70 82 90 68 60 62 60 62 72 68 80 74 y 122 102 118 126 108 130 104 118 130 116 102 122 120 Find the correlation coefficient (and all related values) for these data: Q2) Suppose a cert

1-2 business statistics

1-2 A national homebuilder builds single family homes and condominiums style townhouses. The excel file shows information on selling price, lot cost, type of home, and region of the country (M-Midwest and S-South) for closings during one month. Use PivotTables to find the average selling price and lot cost for each type of ho

Statistics-Osteoporosis: Women's age & bone density losses

Osteoporosis is a condition in which bone density decreases, often resulting in broken bones. Bone density usually peaks at age 30 and decreases thereafter. To understand more about this condition a random sample of women aged 50 and over were recruited. Each woman's bone density loss and age are recorded in file Xr04-83. a) Co

Finding mean and standard deviation from percentiles

The Globe Fishery packs shrimp that weigh more than 1.91 ounces each in packages marked" large" and shrimp that weigh less than 0.47 ounces each into packages marked "small"; the remainder are packed in "medium" size packages. If a day's catch showed that 19.77 percent of the shrimp were large and 6.06 percent were small, deter

Quantative Analysis of Data: Normal Random Variable

Suppose that a stock is currently selling for $100. The change in the stock's price during the nest year follows a normal random variable with a mean of $10 and a standard deviation of $20. What is the probability (rounded to the nearest hundredth) that the stock will sell for at least $120 in a year's time? a. .31 b. .16

Descriptive statistics for business students

I need the simplest step by step directions for the following word problem. Management of a grocery store recorded the number of coupons redeemed by customers during a recent double coupon sale. The data is presented below. # of coupons f 0-4 15 5-9 9 10-14 6

Sales data for manufacturer of ready to eat cereal, volume differences

Assume you are a marketing analyst working for a manufacturer of ready-to-eat cereal. You are given detailed sales data for the past year and asked to create a report showing the differences between the four sales regions (north, south, east, and west) in terms of sales volume, profitability, and changes in sales volume and prof

Find median height of basketball team

Question 1 Using the data set below, please calculate the: 2 8 6 9 5 - Range - What would be the percentile rank of the number 6? Question 2 Find the median height of a basketball team: 73, 76, 72, 70, and 74 inches

Central Tendency: Nighttime Lighting in Intensive Care Units

Attached is a link of study for the study, "Nighttime Lighting in Intensive Care Units", authored by Heather Dunn, MS, ACNP-BC, Mary Ann Anderson, PhD, RN and Pamela D. Hill, PhD, RN, CBE. http://ccn.aacnjournals.org/content/30/3/31.long Can you help me answer the following questions related to this study: How were meas

Process Improvement: Find UCL and LCL for charts

= - If X =2.0144, R=.0972 and 25 subgroups of size 5, a. Find the UCL and LCL for the X Chart. B. Find the UCL and LCL for the R- chart. = - 2. If X= 5.2, R = .3 and n=4, and if specifications are (4.6, 5.8) is the proce

Density function statements

True or False (1, 2) 1. If a continuous random variable X has zero mean, then its density f(x) has to be strictly positive at zero. 2. If f(x) is a density function on [0,1], then integral 0 to 1 f^2 (x) dx < infinity. 3. A density function is verbally described as follows: it is zero for x < 1, rises linearly between 1 a

Mean, variance, standard deviation and probabilities

The weight of cherries in a pie, X, has the following discrete probability distribution: x 4 5 6 7 P(X=x) 10% 30% 40% 20% a) Find the mean, standard deviation, and variance b) If you took samples of the weight of cherries in 25 cherry pies, what mean and standard deviation would you exp