Background

The new Electronic Road Pricing (ERP) System implemented by the Land Transportation Authority (LTA) charges road usage by tracking vehicle movements. A location sensor in the In-vehicle unit (IU) communicating with the global positioning satellite (GPS) receiver enables the ERP System to determine the vehicle's location and distance travelled. The system depends on the accuracy of the location sensor which is how close the measured location is to the actual sensor location.

Precision Locator Device (PLD) Pte Ltd designs and sells location sensors. It wishes to supply sensors to LTA for the ERP System. To focus on its core design competency and lower operation costs, PLD outsources its production to a manufacturing contractor: Sunny Electronic Manufacturing (SEM). Another contractor Total Production Services (TPS) recently approached PLD and claimed its manufacturing capability produces higher quality products than SEM. PLD has begun to outsource some productions to TPS.

PLD has designed a location sensor based on a standard industrial model which is known to have location accuracy's population mean of 2.46 meters and standard deviation of 0.30 meters. PLD management wants to know its location sensor's performance compared to the industry standard. It also wants to verify TPS's claim.

Assuming you are a Data Analyst in PLD's Operations Department. The CEO has assigned you to conduct an analysis for decision-making. You collected data for a sample of sensors produced by SEM and TPS. The data are in the Location Sensor Accuracy Excel file.

Question 1 (a)

Using relevant Excel reports, provide a descriptive summary of the PLD sensor location accuracy. You are expected to describe and state relevant descriptive statistics, and use relevant charts to provide visualisations of the distribution of the data. You are also expected to make a preliminary conclusion on the sensor performance.

The PLD location sensor is designed with the industry standard model in mind. Explain whether the probability of receiving the same sample mean in the industry standard model is plausible.

Justify the use of your analysis method. Hence, comment on the PLD sensor's performance compared to the industry standard model.

(b) Use relevant descriptive statistics and a chart to conduct a preliminary comparison of the sensors produced by the two contractors.

(c) The CEO has requested you to make a short presentation to the management regarding your findings. In particular, the management wants to know the PLD sensor's performance. They are also interested to know the relative performance of the contractors. Develop a written script for the short presentation. You are expected to provide insightful interpretations of the findings that would be useful to the management. You also hope to use this opportunity to demonstrate to management how quantitative information helps in decision-making. Please indicate the word count at the end of your answer.

SN	Contractor	PLD Sensor Accuracy (in meters)
1	SEM	1.95
2	TPS	1.79
3	SEM	3.23
4	TPS	3.58
5	SEM	3.22
6	TPS	1.98
7	TPS	2.02
8	SEM	3.22
9	TPS	2.05
10	TPS	3.14
11	SEM	2.07
12	TPS	3.01
13	TPS	2.08
14	SEM	2.92
15	TPS	2.09
16	TPS	2.91
17	SEM	2.1
18	SEM	2.88
19	TPS	2.1
20	TPS	2.86
21	TPS	2.18
22	SEM	2.86
23	TPS	2.18
24	SEM	2.84
25	TPS	2.18
26	SEM	2.83
27	TPS	2.23
28	SEM	2.8
29	SEM	2.25
30	SEM	2.8
31	TPS	2.32
32	TPS	2.7
33	SEM	2.37
34	SEM	2.69
35	TPS	2.37
36	TPS	2.68
37	SEM	2.38
38	SEM	2.64
39	SEM	2.39
40	SEM	2.62
41	TPS	2.4
42	TPS	2.6
43	SEM	2.41
44	TPS	2.59
45	TPS	2.45
46	SEM	2.57
47	SEM	2.47
48	TPS	2.51
49	SEM	2.47
50	SEM	2.51
51	TPS	2.48
52	TPS	2.49

Background The new Electronic Road Pricing (ERP) System implemented by the Land Transportation Authority (LTA) charges road usage by tracking vehicle movements. A location sensor in the In-vehicle unit (IU) communicating with the global positioning satellite (GPS) receiver enables the ERP System to determine the vehicle's location and distance travelled. The system depends on the accuracy of the location sensor which is how close the measured location is to the actual sensor location, Precision Locator Device (PLD) Pte Ltd designs and sells location sensors. It wishes to supply sensors to LTA for the ERP System. To focus on its core design competency and lower operation costs, PLD outsources its production to a manufacturing contractor: Sunny Electronic Manufacturing (SEM). Another contractor Total Production Services (TPS) recently approached PLD and claimed its manufacturing capability produces higher quality products than SEM. PLD has begun to outsource some productions to TPS. PLD has designed a location sensor based on a standard industrial model which is known to have location accuracy's population mean of 2.46 meters and standard deviation of 0.30 meters. PLD management wants to know its location sensor's performance compared to the industry standard. It also wants to verify TPS's claim. Assuming you are a Data Analyst in PLD's Operations Department. The CEO has assigned you to conduct an analysis for decision-making. You collected data for a sample of sensors produced by SEM and TPS. The data are in the Location Sensor Accuracy Excel file. Question 1 (a) (k) (c) Using relevant Excel reports, provide a descriptive summary of the PLD sensor location accuracy. You are expected to describe and state relevant descriptive statistics, and use relevant charts to provide visualisations of the distribution of the data. You are also expected to make a preliminary conclusion on the sensor performance. The PLD location sensor is designed with the industry standard model in mind. Explain whether the probability of receiving the same sample mean in the industry standard model is plausible. Justify the use of your analysis method. Hence, comment on the PLD sensor's performance compared to the industry standard model. (40 marks) Use relevant descriptive statistics and a chart to conduct a preliminary comparison of the sensors produced by the two contractors. (20 marks) The CEOQ has requested you to make a short presentation to the management regarding your findings. In particular, the management wants to know the PLD sensor's performance. They are also interested to know the relative performance of the contractors. Develop a written script for the short presentation. You are expected to provide insightful interpretations of the findings that would be useful to the management. You also hope to use this opportunity to demonstrate to management how quantitative information helps in decision-making. Your script should be less than 300 words. Please indicate the word count at the end of your answer. (40 marks)