Excel Work Solution 1 and 2 - 19994

Solution Posted by
studentlance

studentlance

Rating : (5)F
Solution Detail
Price: $5.00
  • From: Business,
  • Posted on: Sat 27 Jul, 2013
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

Excel Work Solution 1 and 2

Excel Work Solution Questions 1 and 2

1 (TCO 3) Use this table to answer the questions.Height (in inches)Frequency

8-11      18

12-15    23

16-19    38

20-23    47

24-27    32

1. Identify the class width.

2. Identify the midpoint of the first class.

3. Identify the class boundaries of the first class.

4. Give the relative frequency for each class.

(Points : 10)

     

     

 

2. (TCO 3) The numbers of homeruns that Sammy Sosa hit in the first 13 years of his major league baseball career are listed as: 4, 15, 10, 8, 33, 25, 36, 66, 63, 50, 64, 49, 40.

1. Display the data in a stem-and-leaf plot.

2. Find the mean.

3. Find the median.

4. Find the mode.

5. Find the range.

6. Find the variance.

7. Find the standard deviation.

 

 

 

Solution Description
Attachments
Excel Work Solution 1 and 2.xls
Excel Work Solu...