Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / COMM 291 Application of Statistics in Business Fall 2014 ASSIGNMENT 2 Hard Copy Solution...

COMM 291 Application of Statistics in Business Fall 2014 ASSIGNMENT 2 Hard Copy Solutions to be handed in 2:30 pm Wednesday October 1 2014 Instructions This assignment comprises a total of

1 COMM 291 Application of Statistics in Business (Fall 2014) ASSIGNMENT 2 Hard Copy Solutions to be handed in 2:30 pm, Wednesday, October 1, 2014 Instructions: This assignment comprises a total of four questions: question 1, 2 and 3 use data compiled in the file Asst2_2014_Data.xls. Present the parts of each question in order. Do not include any original data in your printed submission. Use the posted cover page. This is mandatory. Assignments without properly completed cover pages will be penalized by reducing one mark. When formatting numbers in Excel, display only as many decimal places as needed to provide decision-making value to the reader (usually fewer than you would think), make sure the numbers are aligned by their decimal point, and include commas in the formatting of large numbers. All text must be typed, preferably all charts and tables as well, except where noted. 2 Question 1 – Canadian Transport Accidents Statistics Canada records the number of transport accidents involving dangerous goods that occur in Canada every year. Transport accidents in Canada involving dangerous goods must be reported to the government. Moreover, Statistics Canada collects data on transport accidents involving dangerous goods across Canada and for each of the provinces. The spreadsheet Transport_Accidents has data on transport accidents nationally and by province for the period from 1987 to 2011. Data are provided for all transport modes and separately for road, rail and air. There is also a category “Facility”, but we will not use it in this assignment. a) Using data in the spreadsheet, construct a contingency table of Transport Mode (columns) by Province/Territories (rows), which will show how accidents are distributed across the three modes of transport and across different provinces for the year of 2010 (Hint: include only three modes of transport (road, rail and air) and don’t forget to include row and column totals.) b) Create another contingency table of Transport...

Aug 04 2020 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions