iii 1 of 2 - Q + 2. IL Page view | A Read aloud T Add text T Draw Highlight Erase @ A (c) Copy and complete the following table using the datasets given above to work out the missing values. Number of minutes to complete the test Industry standard In-house Minimum (Min) Lower quartile (Q1) Median 346.5 326.5 372 336 389 347.5 Upper quartile (23) Maximum (Max) 377.55 69.88 12.69 Question 2 30 marks This question is based on your work on MU 123 up to and including Unit 4- An IT company develops software for the banking sector. It tests its code using an industry standard software package. Aiming to expand its business and be more competitive in the sector, the company has decided to pilot an in-house software package to test its code. A company researcher wishes to compare the times taken for each package to complete tests. Both software packages were run on 20 occasions testing the same code. The researcher records the times taken on each occasion, and these are shown in Table 1. Table 1 Comparison of test times in minutes for the industry standard and in-house software testing packages Test number Industry standard software package In-house software package 1 357 325 2 337 335 3 344 310 4 402 354 5 376 318 6 398 337 7 304 328 8 368 335 9 656 337 10 382 355 11 310 318 12 354 339 13 387 347 14 391 351 15 366 335 16 376 348 17 316 325 18 349 332 19 392 354 20 386 344 Mean Standard deviation (SD) Interquartile range (IQR) Range Size of dataset (ne) 20 20 14 2) (d) (i) Identify the two measures of location from the table in part (e). Use both of these measures to determine which of the two datasets has the higher location. (ii) Identify the three measures of spread from the table in part (e). Which of the two datasets has the wider spread, as measured by each of these three measures? le) (1) The researcher concludes that the in-house software package runs quicker than the industry standard software package. Is this a reasonable conclusion? Explain your answer briefly. (11) Which stage of the statistical investigation is used in part (e) (i)? Briefly justify your answer. (1) The researcher notices that the industry standard software package entry for the ninth test was a typing error. The correct value should have been 356. The revised mean and median for the industry standard software package data with the correct value for the ninth test are given in the following table. Industry standard software package With typing error With correct value (2) 12 (2) (a) (1) Which of the three types of investigation discussed on pages 210-214 of Unit 4 is this? Explain your answer briefly. (11) Are these primary or secondary data, from the researcher's point of view? Explain your answer briefly. (b) Spend a few minutes scanning these datasets by eye. (1) List any three features that you should be looking for when scanning datasets by eye. (ii) Comment on whether or not you think there might be a problem with any of the most extreme values in each column. . [3] [3] Mean Median 377.55 372 362.55 367 2) What is the effect on the mean and on the median of including the typing error instead of the correct value? Explain why this happens. (g) Would having the correct value affect the researcher's conclusion in part (e) (i)? Explain your answer briefly. 2) ( page 4 of 7 page 5 of 7 y iii 1 of 2 - Q + 2. IL Page view | A Read aloud T Add text T Draw Highlight Erase @ A (c) Copy and complete the following table using the datasets given above to work out the missing values. Number of minutes to complete the test Industry standard In-house Minimum (Min) Lower quartile (Q1) Median 346.5 326.5 372 336 389 347.5 Upper quartile (23) Maximum (Max) 377.55 69.88 12.69 Question 2 30 marks This question is based on your work on MU 123 up to and including Unit 4- An IT company develops software for the banking sector. It tests its code using an industry standard software package. Aiming to expand its business and be more competitive in the sector, the company has decided to pilot an in-house software package to test its code. A company researcher wishes to compare the times taken for each package to complete tests. Both software packages were run on 20 occasions testing the same code. The researcher records the times taken on each occasion, and these are shown in Table 1. Table 1 Comparison of test times in minutes for the industry standard and in-house software testing packages Test number Industry standard software package In-house software package 1 357 325 2 337 335 3 344 310 4 402 354 5 376 318 6 398 337 7 304 328 8 368 335 9 656 337 10 382 355 11 310 318 12 354 339 13 387 347 14 391 351 15 366 335 16 376 348 17 316 325 18 349 332 19 392 354 20 386 344 Mean Standard deviation (SD) Interquartile range (IQR) Range Size of dataset (ne) 20 20 14 2) (d) (i) Identify the two measures of location from the table in part (e). Use both of these measures to determine which of the two datasets has the higher location. (ii) Identify the three measures of spread from the table in part (e). Which of the two datasets has the wider spread, as measured by each of these three measures? le) (1) The researcher concludes that the in-house software package runs quicker than the industry standard software package. Is this a reasonable conclusion? Explain your answer briefly. (11) Which stage of the statistical investigation is used in part (e) (i)? Briefly justify your answer. (1) The researcher notices that the industry standard software package entry for the ninth test was a typing error. The correct value should have been 356. The revised mean and median for the industry standard software package data with the correct value for the ninth test are given in the following table. Industry standard software package With typing error With correct value (2) 12 (2) (a) (1) Which of the three types of investigation discussed on pages 210-214 of Unit 4 is this? Explain your answer briefly. (11) Are these primary or secondary data, from the researcher's point of view? Explain your answer briefly. (b) Spend a few minutes scanning these datasets by eye. (1) List any three features that you should be looking for when scanning datasets by eye. (ii) Comment on whether or not you think there might be a problem with any of the most extreme values in each column. . [3] [3] Mean Median 377.55 372 362.55 367 2) What is the effect on the mean and on the median of including the typing error instead of the correct value? Explain why this happens. (g) Would having the correct value affect the researcher's conclusion in part (e) (i)? Explain your answer briefly. 2) ( page 4 of 7 page 5 of 7 y