Comm 291 Statistics Populations Parameters 2014 Assignment 2 Berkowitz

Notes 1 the spreadsheet is already sorted by segment

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ross the three market segments? Summarize your conclusion in one or two sentences. The three market segments seem to idealize similar values. Although contemporary’s column percentages are higher that is due to the fact that contemporary has more people in each column than the other segments. Notes: 1) The spreadsheet is already sorted by Segment and by Work within each Segment group. But you will want to re-sort to do the Segment by Value crosstab. 2) Use the Excel functions COUNT and COUNTIF to help you figure out the entries in each cell. 3) It is not needed in this assignment, but, in a full market segmentation research project you would also be interested in comparing Work by Value to answer the question of whether different work status groups report different values as being most important. 4 Question 2 – Canadian Exports (adapted from Mini Case Study, p. 133) Statistics on Canadian exports are used for a variety of purposes, from projecting Canada’s foreign exchange earning to planning capacity in Canadian ports. The spreadsheet <Canadian_Exports> has monthly export data (reported in tens of thousands of dollars) from Statistics Canada for four selected products: wheat, zinc, fertilizer and industrial machinery. Statistics Canada calculates exports on a “Customs” basis and also on a “Balance of Payments” basis, and the file contains footnotes describing the difference. a) Draw time series graphs of these export data and identify any major differences between the “Customs” and “Balance of Payments” series. For each series, put all four products on the same graph. 20000 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 Wheat Zinc FerIlizer Industrial Machinery 1999- 01 1999- 08 2000- 03 2000- 10 2001- 05 2001- 12 2002- 07 2003- 02 2003- 09 2004- 04 2004- 11 2005- 06 2006- 01 2006- 08 2007- 03 2007- 10 2008- 05 2008- 12 In 0,000's of $ Customs 20000 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 Wheat Zinc FerIlizer Industrial Machinery 1999- 01 1999- 08 2000- 03 2000- 10 2001- 05 2001- 12 2002- 07 2003- 02 2003- 09 2004- 04 2004- 11 2005- 06 2006- 01 2006- 08 2007- 03 2007- 10 2008- 05 2008- 12 In 0,000's of $ Balance of Payments 5...
View Full Document

Ask a homework question - tutors are online