Explore BrainMass
Share

# Statistical Analysis in Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The file DarkChocolate contains the cost per ounce (\$) for a sample of 14 dark chocolate bars.
(See attached file for data)
a.) Compute the mean, median, and mode.
b.) Compute the variance, standard deviation, range, coefficient of variation, and Z score. Are the any outliers? Explain.
c.) Are the data skewed? If so, how?
d.) Based off the results of (a) and (c), what conclusions can be reached concerning the cost of dark chocolate bars?

One of the major measures of the quality of service provided by an organization is the speed with which it responds to customer complaints. A large family-held department store selling furniture and flooring, including carpet, had undergone a major expansion in the past several years. In particular, the flooring department had expanded from 2 in stallion crews to an in stallion supervisor, a measurer, and 15 installation crews. The business objective of the company was to reduce the time between when the complaint is received and when it is resolved. During a recent year, the company got 50 complaints concerning carpet installions. The data of the 50 complaints organized in Furniture represent the number of days between the receipt of a complaint and the resolution of the complaint (see attached file for data).
a.) Compute the mean, median, first quartile, and third quartile.
b.) Compute the range, interquartile range, variance, standard deviation, and coefficient of variation.
c.) Construct a boxplot. Are the data skewed? If so, how?
d.)On the basis of the results of (a) through (c), if you had to tell the president of the company how long a customer should expect to wait to have a complaint resolved, what would you say? Explain.

The quality manager control manager of Marilyn's Cookies is inspecting a batch of chocolate-chip cookies that has been baked. If the production process is in control, the mean number of chip parts per cookie is 6.0. What is the probability that in any particular cookie being inspected
a.) Fewer than five chip parts will be found?
b.) Exactly five chips parts will be found?
c.) Five or more chip parts will found?
d.) Either four or five chip parts will found?
The owner of a fish market determined that the mean weight for salmon is 12.3 pounds, with a standard deviation of 2 pounds. Assuming that the weights of salmon are normally distributed, what is the probability that randomly selected salmon will weigh
a.) Between 12 and 15 pounds?
b.) Less than 10 pounds
c.) Between what two values will 95% of the salmon weights fall?

https://brainmass.com/statistics/quantative-analysis-of-data/statistical-analysis-excel-536877

#### Solution Summary

The expert computes the mean, median and mode. The variance, standard deviation, range and coefficients are examined.

\$2.19

## Statistical Data Analysis using Excel

See attached file.

Assume you are researching about housing in a neighborhood encompassed by 5 townships in the attached Real Estate Data Set (Excel). Evaluate if the distance from center of town the homes are located creates a positive, negative or neutral change in the price of the home.

Data analysis using descriptive statistics (Excel)

1) Calculate the measures of central tendency, dispersion, and skew for data

2) Display your descriptive statistical data using graphic and tabular techniques
a) Line graph
b) Bar graph

3) Based on your measures of central tendency and graphs, discuss the best measures of central tendency and dispersion of your data. Justify selection

4) Is there a relationship between sales price and how far the distance of the home is from the center of the town?

b. Conclusions
Prepare a paper examining the data collected, and drawing conclusions based on findings.

View Full Posting Details