Explore BrainMass

Frequency Distribution

Basic Statistics using Excel and Eviews

See attached files for assignments. TASK1 You are required to prepare a dataset consisting of the Income (X) in £ per week and Years of Education (Y) of 40 randomly chosen adults and then perform the following exercises. (You may enter numbers representing these characteristics of fictitious individuals, provided these are

Drying rate

1. The drying rate in an industrial process is dependent on many factors and varies according to the following distribution. Minutes Relative Frequency 3 0.22 4 0.36 5 0.28 6 0.10 7 0.04 Using these random numbers 0.53; 0.65; 0.98; 0.94; 0.07; and 0.99 , sim

Statistics problem

1. An insecticide company exposes 10,000 cockroaches to its newest product, and exposes another 10,000 to their previous formula. The researchers use videotape to count how many cockroaches are still alive, and how many appear to be in distress, at 10 second intervals. When the test is completed, the researchers determine the

Statistic problems

1. Find the mean, median, and mode for the set of scores in the following frequency distribution table: X 10 9 8 7 6 5 f 2 3 5 6 3 1 2. A sample of n= 20 scores has a mean of M=6. If one person with a score of X= 2 is added to the sample, what will be the value of the new mean? 3. A sample of n =

Histogram & Frequency Polygon

The following frequency distribution reports the number of frequent flier miles, reported in thousands, for employees of Brumley Statistical Consulting, Inc. during the first quarter of 2004. Frequent Flier Miles Number of Employees 0 up to 3 5 3 up to 6 12

Grouped frequency distribution table

I managed to do all my other questions but I can't figure these two out. They are not fully explained in the book and I can't figure it out by searching for help online. I need this within the next 3 hours because it is due tonight. I've worked ALL day on this and just can't get these two problems! If you could explain how to do

Question about Mathematics - Modelling and Simulation

The dying rate in an industrial process is department of many factors and varies according to the following distribution. Minutes Relative Frequency 3 .14 4 .30 5 .27 6 .18 7 .11 a. Compute the mean drying time. b. U

Statistics: Grouped Data

See the attached file. Question 1: (please help me in question 1.2 to 1.5.3 and please do check 1.1, if it is correct or not) (i) A production manager at a firm recorded the outputs of the all workers in the production division during a certain shift and obtained the following results. 1496 1377 1336 1103 1284 1459 14

Frequency curves and Histogram

For normal distribution with mean = 60 and standard deviation = 6, determine the probability content of the interval [62 to 67] Question 2 The table below gives the deviation of a hypothetical portfolio's annual total return (gross of fees) from its benchmark's annual returns, for a 12-year period ending in 2003. Portf

Difference in Frequency Distribution and Relative Frequency

From a practical point of view, what is the difference between a frequency distribution and a relative frequency distribution? Why is a cumulative relative frequency distribution so much more informative that just the relative frequency distribution? Use examples to describe these differences.

Frequency and Probability

Use the frequency distribution, which shows the response of a survey of college students when asked, "How often do you wear a seat belt when riding in a car driven by someone else?" Find the following probabilities of responses of college students from the survey chosen at random. RESPONSE FREQUENCY Never

Statistics: Class Midpoints and Boundaries

Identify the class width, class midpoints and class boundaries for the given frequency distributions. Daily Low Temp Frequency Daily Low Temp Frequency 50-52 1 62-64 7 53-55 3 65-67 7 56-58 5

Statistical Charts

A manufacturing company produces electric insulators. If the insulators break when in use, a short circuit will likely occur. To test the strength of the insulators, destructive testing in high powered labs is carried out to determine how much force is required to break the insulators. Force is measured by observing how much

Frequency Distribution Chart

You are the production manager for an operation that produces circuit boards. Each board is tested at the end of the manufacturing process. Rejected boards are discarded and have no future value. For product B-17, you have kept data on the number of rejects for the past 38 weeks. These data are: Number of rejected boards.


Please show all work so I can better understand the problem ----------------------------------------- The drying rate in an industrial process is dependent on many factors and varies according to the following distribution. Minutes Relative Frequency 3 .14 4 .30 5

Frequency Distribution in Excel

Attached is a small data set. This is information that comes from a Mfg line at which I am an intern. I have calculated the mean, std dev, min, and max for the 2 data sets. but I do not understand statistics well enough or the "Data Analysis" add-in in Excel. I am being asked to put the 2 sets of data into "normal distribu

Mid-Values and Borders of Class

See the attached file. In exercises 5 to 6, it identifies the width of class, the mid-values of class and the borders of the class for the given frequency allocations. 5) Daily minimal temperature (F) Frequency 35-40 1 40-44

Statistics for Managers Using Microsoft Excel

The data in the file protein.xls indicate fat and cholesterol information concerning popular protein foods (fresh red meats, poultry, and fish). For the data relating to the number of calories and the amount of cholestrol for the popular protein foods: a. Consruct a frequency distribution and a percentage distribution.

Appropriate statistical summary

Your customers have been divided into 3 groups. The first group represents 15% of customers, and these customers spent an average of $29.76 last year. The second group represents 29% of customers who spent $58.03 on average. Within the third group, average spending was $75.10. You are interested in finding the average spendi

Frequency distribution a) Use the probability distribution to find the mean of the probability distribution. b) Use the probability distribution to find the variance of the probability distribution. c) Use the probability distribution to find the standard deviation of the probability distribution. d) Use the probability distribution to find the expected value of the probability distribution.

5. 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 1261 438 169 46 27 11 (a) Use the frequency distribution to construct a probability distribution. (b) Find the mean of the probability distribution. (c) Find the variance

Statistical data from a pharmaceutical company

1. A pharmaceutical company conducted a study to evaluate the effectiveness and safety of a new inhaled form of insulin for the treatment of diabetes. A group of 650 diabetics was given the drug twice a day, while another group of 650 diabetics was given an inhaled placebo twice a day. Insulin levels were checked periodically

Frequency distribution, histogram and stem-and-leaf

For following set of scores, prepare a frequency distribution, a histogram, and a stem-and-leaf display for each variable. Also calculate the mean, the median and the standard deviation of each score. Are there any outliers in the distribution? If so,what is the result if these scores are removed fro the data set? Draw a scat

Statistics of One Variable

I have attached several problems that I need solved. Questions - u4 The questions are to be answered with full solutions. Be sure to focus on proper mathematical form, including: 1. One equal sign per line, 2. Equal signs in each question lined up vertically with each other, 3. No self-developed short form notations.

Frequency Distribution and Descriptive Statistics

Temperature Frequency 96.5 - 96.8 1 96.9 - 97.2 8 97.3 - 97.6 14 97.7 - 98.0 22 98.1 - 98.4 19 98.5 - 98.8 32 98.9 - 99.2 6 99.3 - 99.6 4 Find the mean, standard deviation, and variance for this frequency distribution.

Cumulative Frequency and Cumulative Percent Frequency

See the attached file. Sales Price (Thousands) Frequency Percent Frequency Cumulative Frequency Cumulative Percent Frequency 20 - 39 1 40 - 59 2 60 - 79 4 80 - 99 2 100 - 119 1 Sales records for a real estate company for the month of May show the fo

Frequency Distribution Charts

The following frequency distribution reports electricity cost for a sample of 50 two-bedroom apartments in Albuquerque, New Mexico during the month of May last year. Electricity Cost Frequency $ 80 up to $100 3 100 up to 120 8 120 up to 140

The answer to Histogram and frequency distribution

The following frequency distribution reports the number of frequent flier miles, reported in thousands, for employees of Brumley Statistical Consulting, Inc. during the first quarter of 2004. Frequent Flier Miles Number of Employees 0 up to 3 5 3 up to 6 12 6 up to 9

Grouped Frequency Distribution Question

Q2) The owner of a small business wants to analyze profits over the past 30 years. Profits (in thousands of dollars) were obtained for the 30-year period. The ranked data values are: 15 17 18 19 20 20 20 21 23 23 24 24 24 24 24 25 25 25 25 25 26 26 27 27 28 29 30 30 31 32 a. Complete the following grouped frequency d

Construct Frequency Distribution Problem

A podiatrist recorded the recovery times, measured in days, for 36 patients. He was trying out a new procedure and hoped that the recovery time would be less than the usual 6 days. The recorded time were: 8 7 6 9 4 5 3 7 8 10 7 7 6 4 10 3 6 8 2 5 4 5 3 8 7 4 6 3 7 12 4 3 6 6 9 4 a) Construct the frequency distribution

Finding Class Interval

The largest value in a set of data is 160, and the smallest value is 70. If the resulting frequency distribution is to have six classes of equal width, what will be the class interval? The options are 15, 6, 12, and 5.