# MN4063: To gain insights into the typical price consumers are willing to pay for a bag: Managing Data Coursework, LMU, UK

 University London Metropolitan University (LMU) Subject Managing Data

To gain insights into the typical price consumers are willing to pay for a bag, a bag designer randomly selected 42 designs from its summer collection. The data have been made available in the Excel file named “MN4063 Autumn CWK 1 Data” under the tab labelled Task 1.

1. Using the ungrouped data for Task 1 and the pivot table function in Excel, create an appropriately grouped frequency table (with six intervals) to summarise the price data. Both absolute and percentage frequencies should be presented on the same frequency table. Percentage frequencies should be rounded appropriately. Copy the table into your Word document.
2. Using the ungrouped data for Task 1, calculate relevant descriptive statistics to summarise the price data. Values should be rounded to a correct number of decimal places. At a minimum, you should calculate the mean, standard deviation, range, median and interquartile range. Present your statistics in a table. Copy the table into your Word document. The Excel formulae used should also be shown, where applicable.

A project consists of 9 activities, each with a specific duration stated in weeks. For example, Activity E takes 3 weeks to complete and can only be started after Activity C has been completed. Information on the 9 activities is outlined in the precedence table (Table 1) below.

1. With reference to Table 1, construct a network diagram by going through the forward and backward passes. You may draw your network diagram in Excel or Word. NB: An image of a handdrawn network diagram will not be accepted and will not receive marks. The network diagram needs to be copied into your Word file.
2. With reference to the network diagram created under (1) above, identify the critical path and state the duration of the project.

Do You Need Assignment of This Question

In a recent survey, 70% of respondents were male and 30% of all male respondents did not own a car. In total, 25% of respondents did not own a car.

1. Construct a contingency table by using the information above. All values in the contingency table should be shown as proportions and not percentages.
2. With reference to the contingency table prepared under (1) above, what is the chance that a respondent chosen at random is female and owns a car? Use the correct notation and state the problem in full. The probability should be shown as a proportion.