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. Data are collected for a sample of sensors produced by SEM and TPS. The data are in the Location Sensor Accuracy Excel file as follows:

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

Question 1 (a)

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

The PLD location sensor is designed with the industry standard model in mind. To explain whether the probability of receiving the same sample mean in the industry standard model is plausible. To justify the use of the analysis method. Hence, comment on the PLD sensor's performance compared to the industry standard model.

Question 1 (b)

To use relevant descriptive statistics and a chart to conduct a preliminary comparison of the sensors produced by the two contractors.

Question 1 (c)

The CEO has requested to make a short presentation to the management regarding the 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. To develop a written script for the short presentation and provide insightful interpretations of the findings that would be useful to the management. To also demonstrate to the management how quantitative information helps in decision-making.