Your Section of BU203:

Exercise 1:

Data for a sample of checks from the Metro Diner from this past week can be found in the Excel worksheet titled Exercise1 and is shown below:

$57

$99

$59

$58

$77

$55

$85

$74

$71

$60

$85

$62

$70

$77

$91

$71

$66

$66

$67

$77

$94

$68

$97

$85

$99

$78

$73

$73

$74

$85

$55

$99

$57

$56

$75

$53

$50

$72

$69

$103

Model your answers on the examples shown in Clear-Sighted Statistics.

A. How many classes would you recommend? Use the 2 to the k rule.

B. What class interval would you suggest?

C. Construct a frequency distribution, relative frequency distribution, a cumulative frequency distribution, and cumulative relative frequency distribution.

D.What do the Frequency Distributions tell us?

E. Draw a histogram, frequency polygon, and cumulative frequency polygon (ogive) using Microsoft Excel. A proper ogive has two Y-Axes. The left Y-Axis shows the cumulate relative frequencies. The second Y-Axis on the right shows the cumulative relative frequencies. The scale of the second Y-Axis must not exceed 100%. Do not draw a Pareto Chart. Remember: With the histogram, there are no gaps between columns. Do not use 3-D effects.

Histogram:

Frequency Polygon:

Ogive:

Exercise 2:

There are approximately 13,500 taxicab medallions in NYC. The medallion is fixed to a taxicabs' hood. The Sheet titled Exercise2 shows a sample of 50 taxicabs listing the car model and his shown below.

Toyota Sienna

Dodge Caravan

Toyota RAV4

Nissan NV

Ford Transit

Nissan NV

Ford Transit

Toyota Sienna

Dodge Caravan

Nissan NV

Toyota Sienna

Toyota Prius

Toyota Sienna

Toyota Prius

Ford Transit

Toyota RAV4

Ford Transit

Ford Transit

Toyota Sienna

Toyota Sienna

Dodge Caravan

Toyota RAV4

Dodge Caravan

Ford Transit

Nissan NV

Ford Transit

Toyota RAV4

Toyota Sienna

Toyota Prius

Ford Transit

Ford Transit

Toyota Sienna

Dodge Caravan

Toyota RAV4

Toyota RAV4

Toyota Prius

Nissan NV

Ford Transit

Ford Transit

Toyota Sienna

Nissan NV

Dodge Caravan

Ford Transit

Nissan NV

Dodge Caravan

Toyota Prius

Toyota Sienna

Toyota Sienna

Toyota Prius

Toyota Sienna

Model your answers on the examples shown in Clear-Sighted Statistics.

A. Construct a frequency table of the approved taxicab models in the sample. Show the Frequencies and Relative Frequencies. Use Excel's COUNTIF and SUM functions.

B. Present the frequency table as a chart. Draw your chart using Microsoft Excel. DO NOT USE A PIE CHART!

C. Comment on your findings.

Exercise 3

According to the College Board, college students spend $1,240 on books and supplies a year. The Sheet titled Exercise3 shows results of a survey of students' expenditures:

Model your answers on the examples shown in Clear-Sighted Statistics.

A. How many classes would you recommend? Use the 2 to the k rule.

B. What class interval would you suggest?

C. Construct a frequency distribution, relative frequency distribution, cumulative frequency distribution, and relative cumulative frequency distribution.

D.What do the Frequency Distributions tell us?

E. Draw a histogram, frequency polygon, and cumulative frequency polygon (ogive) using Microsoft Excel. A proper ogive has two Y-Axes. The left Y-Axis shows the cumulate relative frequencies. The second Y-Axis on the right shows the cumulative relative frequencies. The scale of the second Y-Axis must not exceed 100%. Do not draw a Pareto Chart. Remember: With the histogram, there are no gaps between columns. Do not use 3-D effects.

Histogram:

Frequency Polygon:

Ogive:

Exercise 4: Measures of Location and Dispersion

Calculate the:

A. Mode:

B. Median:

C. Mean:

D. Range:

E. Mean Absolute Deviation:

F. Population Variance:

G. Sample Variance:

H. Population Standard Deviation:

I. Sample Standard Deviation

Show your work. Paste the Excel cells using the method described above.

NOTE: You must treat the data in the five columns are one data set, not five. Save time: Perform these calculations using Excel. Show your work: Follow my instructions on pasting the Excel cells into the Word template.

Exercise 5: Weighted Mean

A first-year freshman received the following grades.

What is her Grade point average for the semester?

Show your work.

Exercise 6: Index Numbers

Here are data for heavy urban rapid rail systems in the U.S. Create index numbers for the system length in miles and number of stations. Use the arithmetic means for your bases.

s

A. What are the index numbers for each of the 15 systems? Round your index numbers to the nearest whole number.

B. Comment on your findings.

Exercise 7: Combinations and Permutations

You select three items out of nine.

A. How many permutations are there?

B. How many combinations are there?

Solve this problem using Excel's PERMIT and COMBIN functions. Show your work.

Exercise 8: Probability

A company has accepted a shipment of 90 new desks: 60 maples and 30 oak. The company will deliver three of these desks to the human resources department. The new desks will be selected at random.

A. What is the probability that all three desks are maple? P(Maple and Maple and Maple).

B. What is the probability that all three desks are oak? P(Oak and Oak and Oak).

C. What rule of probability did you use to solve this problem?

Show your work.

Exercise 9: Probability

In a group of 100 students, 60 are freshman, 55 are female, and 22 are female freshmen.

A. What is the probability that a student picked from this group at random is either a freshman or female?

B. What rule of probability did you use to solve this problem?

Show your work.

Exercise 10: Probability

In New York City, the New York Times is read by 52% of the households, the New York Post is read by 18% of the households, and 14% of the city's households read both newspapers.

A. What is the probability of a particular household reading at least one of these newspapers?

B. What rule of probability did you use to solve this problem?

Show your work.

***