Assignment:
Discuss the below:
Q1: 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.
Q2: Use Excel & Put all related data in a single coloumn
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.
Q3: 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.