Spring 2015
Business Statistics I (Stat 220)
Assignment (mostly excel)
Due on March 31, 2015 (at the beginning of class)
1. Using the Tune up cost data (the Excel File is available on Blackboard),
a. Construct a table for frequency, relative frequency and cumulative relative
frequency.
b. Construct a Histogram and an Ogive.
2. One of the questions in a Financial Times/Harris Poll was, “How much do you favor or
oppose a higher tax on higher carbon emission cars?” Possible responses were strongly
favor, favor more than oppose, oppose more than favor, and strongly oppose. The
following cross tabulation shows the responses obtained for 5372 adults surveyed in four
countries in Europe and the United States (Harris Interactive Website, 27/02/2008)
Country
Level of Support UK Italy Spain Germany U.S Total
Strongly favor 337 334 510 222 214 1617
Favor more that
Oppose
370 408 355 411 327 1871
Oppose more than
favor
250 188 155 267 275 1135
Strongly Oppose 130 115 89 211 204 749
Total 1087 1045 1109 1111 1020 5372
a. Construct a percent frequency distribution for the level of support variable. Do you
think the results show support for a higher tax on higher carbon emission cars?
b. Construct a percent frequency distribution for the country variable.
c. Does the level of support among adults in the European countries appear to be
different than the level of support among adults in the United States? Explain.
2
3. A survey of the business school graduates undertaken by a university’s placement office
asked , among other questions, the area in which each person was employed. The areas of
employment are:
a. Accounting
b. Finance
c. Management
d. Marketing
e. Other
The responses for other questions are given below:
Column variable
1 ID
2 Area
3 Gender (1= Female, 2= male)
4 Job Satisfaction (4= very satisfied, 3= Quite satisfied, 2= little Satisfied, 1= not
satisfied
Using the data “Business Area Survey” (posted on blackboard), answer the following
questions.
a. Using a cross tabulation table and a corresponding graph, determine if female
and male graduates differ in their area of employment. If so, explain how.
b. Are area of employment and job satisfaction related? Explain.
4. Using the grades data (available Excel file on Blackboard) for a calculus and a statistics course,
draw the appropriate diagram and describe the relationship between the grades in calculus and
statistics.
