Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services A Systematic Approach

Authors: William Messier, Steven Glover, Douglas Prawitt

5th Edition

007333720X, 9780073337203

More Books

Students also viewed these Accounting questions

Question

Is Dan Bane a transformational leader? Why or why not?

Answered: 1 week ago