Question

In: Statistics and Probability

&n

The labor quotation department at Excabar, a large manufacturing company, wants to verify the accuracy of their labor bidding process (estimated cost per unit versus actual cost per unit). They have randomly chosen 35 product quotations that subsequently were successful (meaning the company won the contract for the product). The data is presented to the left of this text.




1. Set up the hypotheses to test whether the Estimated cost/unit is significantly different than the Actual cost/unit.

2. Using the appropriate commands in Excel, find the value of the test statistic. Assume the populations variances are unknown but equal. Compute the 99% Confidence Interval for each variable.


3. Interpret the p- value at α = .01

4. Based on these results, write a statement expressing the results of this study.

Null:   μ      μ
Alternative:   μ      μ

Product   Estimated cost/unit   Actual cost/unit
1   13.90   12.90
2   18.80   15.80
3   14.80   11.80
4   11.80   11.80
5   16.80   12.80
6   14.20   13.20
7   21.80   18.80
8   6.80   10.80
9   19.50   18.50
10   21.00   19.00
11   12.40   11.40
12   15.10   18.10
13   15.80   15.80
14   24.90   23.90
15   13.20   16.20
16   25.90   23.90
17   12.80   10.80
18   12.90   11.90
19   20.50   19.50
20   19.00   18.00
21   10.80   10.80
22   10.80   13.80
23   18.80   17.80
24   12.60   11.60
25   26.80   22.80
26   22.90   24.90
27   22.80   19.80
28   12.50   16.50
29   15.50   15.50
30   14.10   13.10
31   15.10   19.10
32   12.50   10.50
33   21.90   22.90
34   24.20   20.20
35   17.80   14.80

Expert Solution

1) The null and alternative hypotheses are defined as,

There is no difference in estimated cost per unit versus actual cost per unit

There is a significant difference in estimated cost per unit and actual cost per unit

2) The t statistic for the dependent samples t test is obtained using the formula,

Where, the difference is

obtained in excel. The screenshot is shown below,

The average of difference is obtained in Excel. The screenshot is shown below,

The standard deviation of difference is obtained in Excel. The screenshot is shown below,

The t statistic is calculated using the formula described above. The screenshot is shown below,

Confidence Interval

The 99% confidence interval for each variable is obtained in excel using the formula,

The screenshot are shown below,

3)

The p-value for the t test is obtained in excel. The screenshot is shown below,

4)

Since the P-value = 0.1213 is greater than 0.01 at 1% significance level, the null hypothesis is rejected. It can be stated now, there is no difference in estimated cost per unit and actual cost per unit

orchestra answered 1 year ago

Which codes add 1 to integer n? 1) n=n+1; 2) n++; 3)++n; 4) n+=1; 5) n=--n+2

Let f : N → N and g : N → N be the functions defined...

Let f : N → N and g : N → N be the functions defined as ∀k ∈ N f(k) = 2k and g(k) = (k/2 if k is even, (k + 1) /2 if k is odd). (1) Are the functions f and g injective? surjective? bijective? Justify your answers. (2) Give the expressions of the functions g ◦ f and f ◦ g? (3) Are the functions g ◦ f and f ◦ g injective? surjective? bijective?...

Show for the following recurrence that T(n) = T(n/3) + nlog(n) is O(nlog(n)) (not using the...

Show for the following recurrence that T(n) = T(n/3) + n*log(n) is O(n*log(n)) (not using the Master theorem please)

If f(n) = 3n+2 and g(n) = n, then Prove that f(n) = O (g(n))

Suppose f : N→N satisestherecurrencerelation f(n + 1) (f(n) 2 if f(n)iseven 3f(n)+ 1 if f(n)isodd...

Suppose f : N→N satisestherecurrencerelation f(n + 1) (f(n) 2 if f(n)iseven 3f(n)+ 1 if f(n)isodd . Notethatwiththeinitialcondition f(0) 1,thevaluesofthefunction are: f(1) 4, f(2) 2, f(3) 1, f(4) 4, and so on, the images cyclingthroughthosethreenumbers. Thus f isNOTinjective(andalso certainlynotsurjective). Mightitbeunderotherinitialconditions?3 (a) If f satisestheinitialcondition f(0) 5,is f injective? Explain whyorgiveaspecicexampleoftwoelementsfromthedomain withthesameimage. (b) If f satisestheinitialcondition f(0) 3,is f injective? Explain whyorgiveaspecicexampleoftwoelementsfromthedomain withthesameimage. (c) If f satisestheinitialcondition f(0) 27,thenitturnsoutthat f(105) 10 and no two numbers less than 105 have the same...

convergent or divergent infinity sigma n = 1 sqrt(n^5+ n^3 -7) / (n^3-n^2+n)

find zero state response y[n+4]-y[n]=x[n], if x[n]= e^-n u[n]

Find the smallest n ∈ N such that 2(n + 5)^2 < n^3 and call it...

Find the smallest n ∈ N such that 2(n + 5)^2 < n^3 and call it n^0，Show that 2(n + 5)^2 < n^3 for all n ≥ n^0.

def annoying_factorial(n): if n == 0 or n == 1: return 1 if n == 2:...

def annoying_factorial(n): if n == 0 or n == 1: return 1 if n == 2: return 2 if n == 3: return 6 if n == 4: return 4 * annoying_factorial(3) if n == 5: return 5 * annoying_factorial(4) if n == 6: return 6 * annoying_factorial(5) else: return n * annoying_factorial(n-1) def annoying_fibonacci(n): if n==0: return 0 if n==1: return 1 if n==2: return 1 if n==3: return 2 if n==4: return annoying_fibonacci(4-1)+annoying_fibonacci(4-2) if n==5: return annoying_fibonacci(5-1)+annoying_fibonacci(5-2) if...

Prove via induction the following properties of Pascal’s Triangle: •P(n,2)=(n(n-1))/2 • P(n+m+1,n) = P(n+m,n)+P(n+m−1,n−1)+P(n+m−2,n−2)+···+P(m,0) for all...

Prove via induction the following properties of Pascal’s Triangle: •P(n,2)=(n(n-1))/2 • P(n+m+1,n) = P(n+m,n)+P(n+m−1,n−1)+P(n+m−2,n−2)+···+P(m,0) for all m ≥ 0