Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the data in the attachment, Analyze the data using any the following tools: time series charts basic plots of 2 variables scatter plots Base
Using the data in the attachment, Analyze the data using any the following tools:
- time series charts
- basic plots of 2 variables
- scatter plots
Base on tools above, What is the data saying in terms of rebate? What is the data saying in terms of idle time and cost?
Sample | MPH | Field Ops Cost $ | Idle Minutes | Idle Cost $ | Re | Rebate $ | Margin $ | USL | LSL | IN/OUT | Sample | Idle Cost $ | Idle Minutes | Revenue $ | Rebate $ | Margin $ | |
1 | 20.3 | 10.2 | 0 | 0 | 8.55 | 0 | -1.65 | 45 | 30 | IN | 1 | 0 | 0 | 8.55 | 0 | -1.65 | |
2 | 15 | 27.05 | 0 | 0 | 9.23 | 9.23 | -27.05 | 45 | 30 | OUT | 2 | 0 | 0 | 9.23 | 9.23 | -27.05 | |
3 | 24.5 | 16.36 | 0 | 0 | 9.6 | 0 | -6.76 | 45 | 30 | IN | 3 | 0 | 0 | 9.6 | 0 | -6.76 | |
4 | 15.9 | 14.65 | 1.4 | 0.35 | 25.34 | 0 | 10.69 | 45 | 30 | OUT | 4 | 0.35 | 1.4 | 25.34 | 0 | 10.69 | |
5 | 15 | 11.22 | 0 | 0 | 26.57 | 0 | 15.35 | 45 | 30 | IN | 5 | 0 | 0 | 26.57 | 0 | 15.35 | |
6 | 19.4 | 6.41 | 8.7 | 1.09 | 9.74 | 0 | 3.33 | 45 | 30 | OUT | 6 | 1.09 | 8.7 | 9.74 | 0 | 3.33 | |
7 | 15.8 | 6.6 | 7.2 | 0.9 | 24.18 | 0 | 17.57 | 45 | 30 | OUT | 7 | 0.9 | 7.2 | 24.18 | 0 | 17.57 | |
8 | 17.9 | 6.83 | 5.4 | 0.67 | 21.61 | 0 | 14.78 | 45 | 30 | OUT | 8 | 0.67 | 5.4 | 21.61 | 0 | 14.78 | |
9 | 20.3 | 21.73 | 0 | 0 | 14.15 | 0 | -7.58 | 45 | 30 | IN | 9 | 0 | 0 | 14.15 | 0 | -7.58 | |
10 | 14.7 | 13.78 | 4.9 | 1.22 | 39.91 | 0 | 26.13 | 45 | 30 | OUT | 10 | 1.22 | 4.9 | 39.91 | 0 | 26.13 | |
11 | 12 | 3.99 | 28.1 | 3.51 | 47.58 | 0 | 43.59 | 45 | 30 | OUT | 11 | 3.51 | 28.1 | 47.58 | 0 | 43.59 | |
12 | 30.6 | 14.61 | 1.5 | 0.39 | 44.7 | 0 | 30.09 | 45 | 30 | OUT | 12 | 0.39 | 1.5 | 44.7 | 0 | 30.09 | |
13 | 10.4 | 3.93 | 28.6 | 3.57 | 53.83 | 0 | 49.9 | 45 | 30 | OUT | 13 | 3.57 | 28.6 | 53.83 | 0 | 49.9 | |
14 | 30.8 | 14.04 | 3.8 | 0.96 | 50.7 | 0 | 36.66 | 45 | 30 | OUT | 14 | 0.96 | 3.8 | 50.7 | 0 | 36.66 | |
15 | 16.5 | 13.1 | 0 | 0 | 24.09 | 24.09 | -13.1 | 45 | 30 | OUT | 15 | 0 | 0 | 24.09 | 24.09 | -13.1 | |
16 | 17.9 | 7.88 | 0 | 0 | 15.86 | 0 | 7.97 | 45 | 30 | IN | 16 | 0 | 0 | 15.86 | 0 | 7.97 | |
17 | 20.1 | 10.36 | 18.6 | 4.64 | 25.22 | 0 | 14.86 | 45 | 30 | OUT | 17 | 4.64 | 18.6 | 25.22 | 0 | 14.86 | |
18 | 25.5 | 10.47 | 18.1 | 4.53 | 51.54 | 0 | 41.07 | 45 | 30 | OUT | 18 | 4.53 | 18.1 | 51.54 | 0 | 41.07 | |
19 | 25.1 | 12.24 | 11 | 2.76 | 33.01 | 0 | 20.77 | 45 | 30 | OUT | 19 | 2.76 | 11 | 33.01 | 0 | 20.77 | |
20 | 29.8 | 12.61 | 9.6 | 2.39 | 7.15 | 0 | -5.46 | 45 | 30 | OUT | 20 | 2.39 | 9.6 | 7.15 | 0 | -5.46 | |
21 | 12.5 | 7.04 | 3.7 | 0.46 | 45.36 | 0 | 38.32 | 45 | 30 | OUT | 21 | 0.46 | 3.7 | 45.36 | 0 | 38.32 | |
22 | 12.8 | 13.18 | 0 | 0 | 42.07 | 42.07 | -13.18 | 45 | 30 | OUT | 22 | 0 | 0 | 42.07 | 42.07 | -13.18 | |
23 | 14.7 | 10.71 | 17.2 | 4.29 | 42.3 | 0 | 31.6 | 45 | 30 | OUT | 23 | 4.29 | 17.2 | 42.3 | 0 | 31.6 | |
24 | 14.7 | 9.61 | 21.6 | 5.39 | 15.78 | 0 | 6.17 | 45 | 30 | OUT | 24 | 5.39 | 21.6 | 15.78 | 0 | 6.17 | |
25 | 15.6 | 4.76 | 21.9 | 2.74 | 31.4 | 0 | 26.63 | 45 | 30 | OUT | 25 | 2.74 | 21.9 | 31.4 | 0 | 26.63 | |
26 | 19.2 | 8.7 | 0 | 0 | 7.44 | 0 | -1.26 | 45 | 30 | IN | 26 | 0 | 0 | 7.44 | 0 | -1.26 | |
27 | 9.5 | 19.94 | 0 | 0 | 52.05 | 52.05 | -19.94 | 45 | 30 | OUT | 27 | 0 | 0 | 52.05 | 52.05 | -19.94 | |
28 | 15.8 | 11.28 | 0 | 0 | 24.29 | 24.29 | -11.28 | 45 | 30 | OUT | 28 | 0 | 0 | 24.29 | 24.29 | -11.28 | |
29 | 17.8 | 7.64 | 0 | 0 | 13.03 | 0 | 5.39 | 45 | 30 | IN | 29 | 0 | 0 | 13.03 | 0 | 5.39 | |
30 | 15.3 | 4.29 | 25.6 | 3.21 | 33.86 | 0 | 29.56 | 45 | 30 | OUT | 30 | 3.21 | 25.6 | 33.86 | 0 | 29.56 | |
31 | 30.8 | 9.64 | 21.4 | 5.36 | 19.91 | 0 | 10.27 | 45 | 30 | OUT | 31 | 5.36 | 21.4 | 19.91 | 0 | 10.27 | |
32 | 15.4 | 11.59 | 0 | 0 | 30.14 | 30.14 | -11.59 | 45 | 30 | OUT | 32 | 0 | 0 | 30.14 | 30.14 | -11.59 | |
33 | 25.3 | 14.37 | 2.5 | 0.63 | 10.62 | 0 | -3.75 | 45 | 30 | OUT | 33 | 0.63 | 2.5 | 10.62 | 0 | -3.75 | |
34 | 23.8 | 13.89 | 4.4 | 1.11 | 36.86 | 0 | 22.97 | 45 | 30 | OUT | 34 | 1.11 | 4.4 | 36.86 | 0 | 22.97 | |
35 | 25.4 | 9.44 | 22.2 | 5.56 | 25.95 | 0 | 16.51 | 45 | 30 | OUT | 35 | 5.56 | 22.2 | 25.95 | 0 | 16.51 | |
36 | 14.1 | 8.72 | 0 | 0 | 35.5 | 0 | 26.78 | 45 | 30 | IN | 36 | 0 | 0 | 35.5 | 0 | 26.78 | |
37 | 29.2 | 12.18 | 11.3 | 2.82 | 6.13 | 0 | -6.05 | 45 | 30 | OUT | 37 | 2.82 | 11.3 | 6.13 | 0 | -6.05 | |
38 | 12.8 | 4.91 | 20.7 | 2.59 | 50.58 | 0 | 45.66 | 45 | 30 | OUT | 38 | 2.59 | 20.7 | 50.58 | 0 | 45.66 | |
39 | 15 | 4.95 | 20.4 | 2.55 | 33.63 | 0 | 28.68 | 45 | 30 | OUT | 39 | 2.55 | 20.4 | 33.63 | 0 | 28.68 | |
40 | 31 | 8.39 | 26.4 | 6.61 | 39.77 | 0 | 31.38 | 45 | 30 | OUT | 40 | 6.61 | 26.4 | 39.77 | 0 | 31.38 | |
41 | 14.1 | 14.84 | 0 | 0 | 35.85 | 35.85 | -14.84 | 45 | 30 | OUT | 41 | 0 | 0 | 35.85 | 35.85 | -14.84 | |
42 | 16.1 | 11.46 | 14.2 | 3.54 | 41.82 | 0 | 30.36 | 45 | 30 | OUT | 42 | 3.54 | 14.2 | 41.82 | 0 | 30.36 | |
43 | 12.6 | 4.03 | 27.8 | 3.47 | 42.74 | 0 | 38.71 | 45 | 30 | OUT | 43 | 3.47 | 27.8 | 42.74 | 0 | 38.71 | |
44 | 29.8 | 14.64 | 1.4 | 0.36 | 47.75 | 0 | 33.11 | 45 | 30 | OUT | 44 | 0.36 | 1.4 | 47.75 | 0 | 33.11 | |
45 | 17.4 | 8.83 | 0 | 0 | 22.53 | 0 | 13.7 | 45 | 30 | IN | 45 | 0 | 0 | 22.53 | 0 | 13.7 | |
46 | 14.4 | 19.89 | 0 | 0 | 53.14 | 0 | 33.25 | 45 | 30 | IN | 46 | 0 | 0 | 53.14 | 0 | 33.25 | |
47 | 15.1 | 29.35 | 0 | 0 | 16.34 | 16.34 | -29.35 | 45 | 30 | OUT | 47 | 0 | 0 | 16.34 | 16.34 | -29.35 | |
48 | 29.4 | 8.33 | 26.7 | 6.67 | 26.24 | 0 | 17.9 | 45 | 30 | OUT | 48 | 6.67 | 26.7 | 26.24 | 0 | 17.9 | |
49 | 19.2 | 12.18 | 11.3 | 2.82 | 15.91 | 0 | 3.73 | 45 | 30 | OUT | 49 | 2.82 | 11.3 | 15.91 | 0 | 3.73 | |
50 | 16.1 | 5.49 | 16 | 2.01 | 21.65 | 0 | 16.16 | 45 | 30 | OUT | 50 | 2.01 | 16 | 21.65 | 0 | 16.16 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started