Assignment 1:
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.
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.