Explore BrainMass
Share

# Descriptive Statistics

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

Question 1
Use Excel & Put all related data in a single column.
A. A headline in a newspaper reported that crime was on the decline. Listed below are the numbers of homicides from 1989-2005

Year Homicides Year Homicides
1989 21 1998 35
1990 34 1999 30
1991 26 2000 28
1992 42 2001 25
1993 37 2002 21
1994 37 2003 19
1995 44 2004 23
1996 45 2005 27
1997 40
Draw a line chart to summarize the data

B. One of the most popular candies in the us is M & M's, which are produced by the Mars Company. In the beginning M & M's were all brown; more recently they produced in red, green, blue, orange, brown and yellow. Recently the purchase of a 14 ounce bag of M & M's plain had 444 candies with the foll. Breakdown in color. Brown 130, yellow 98, red 96, orange 35, blue 52, and 33 green.
Develop a bar chart depicting this information.

Question 2
Use Excel & Put all related data in a single column.

A. The accounting firm of Crawford and Associates has 5 senior Partners. Yesterday the senior partners saw 6, 4, 3, 7, and 5 clients respectively. Compute the mean number and median number of clients seen by a partner.

B. Owens Orchards sells apples in a large bag by weight. A sample of seven bags contained the following number of apples: 23, 19, 26, 17, 21, 24, and 22. Compute the mean, number and median number of apples in a bag.

Question 3
Use Excel & Put all related data in a single column.
A. The Thomas Supply Company Inc. Is a distributor of gas powered generators. As with any Business, the length of time customers take to pay their invoices is important. Listed below, arranged from smallest to largest, is the time in days for a sample of the Thomas Supply Company, Inc. Invoices

13, 13, 13, 20, 26, 27, 31, 34, 34, 34, 34, 35, 35, 36, 37, 38
41, 41, 41, 45, 47, 47, 47, 50, 51, 53, 54, 54, 56, 62, 37, 82

Use Excel's Descriptive statistics output table to find the mean, standard error, median, mode, standard deviation, sample variance, kurtosis, skewness, range, minimum, maximum, sum count, largest(2), smallest(2), and estimate quartile one, quartile two, the first decile, and the ninth decile and the 67th percentile.

https://brainmass.com/statistics/quantative-analysis-of-data/descriptive-statistics-143144

#### Solution Summary

The solution does a great job of explaining the problem below. Step by step instructions are provided to arrive to the final answer. The solution can be easily understood by a student with a basic understanding of Statistics. A word document has also been provided to assist the student. Overall, a great response.

\$2.19

## Statistics - Descriptive Statistics (Analysis of Variance)

Car Fuel Consumption:

The following table lists highway fuel consumption amounts (in mi/gal) from data Set 22 in Appendix C. Assume that fuel consumption amounts are not affected by an interaction between the type of transmission (manual or automatic) and the number of cylinders. Are fuel consumption amounts affected by the type of transmission? Are fuel consumption amounts affected by the number of cylinders? (Please see the attached file)

Age
under 20 20-40yrs Over 40
Male 96 64 68 60 64 88 72 64 68 72 60 88
Female 76 64 76 68 72 88 72 68 60 68 72 64

Cylinders
4 Cyliners 6 Cylinders 8 Cylinders
Manual 33 30 28
Automatic 31 27 24

View Full Posting Details