Question

In: Statistics and Probability

Shipment Time to Deliver (Days) 1 7.0 2 12.0 3 4.0 4 2.0 5 6.0 6...

Shipment Time to Deliver (Days)
1 7.0
2 12.0
3 4.0
4 2.0
5 6.0
6 4.0
7 2.0
8 4.0
9 4.0
10 5.0
11 11.0
12 9.0
13 7.0
14 2.0
15 2.0
16 4.0
17 9.0
18 5.0
19 9.0
20 3.0
21 6.0
22 2.0
23 6.0
24 5.0
25 6.0
26 4.0
27 5.0
28 3.0
29 4.0
30 6.0
31 9.0
32 2.0
33 5.0
34 6.0
35 7.0
36 2.0
37 6.0
38 9.0
39 5.0
40 10.0
41 5.0
42 6.0
43 10.0
44 3.0
45 12.0
46 9.0
47 6.0
48 4.0
49 3.0
50 7.0
51 2.0
52 7.0
53 3.0
54 2.0
55 7.0
56 3.0
57 5.0
58 7.0
59 4.0
60 6.0
61 4.0
62 4.0
63 7.0
64 8.0
65 4.0
66 7.0
67 9.0
68 6.0
69 7.0
70 11.0
71 9.0
72 4.0
73 8.0
74 10.0
75 6.0
76 7.0
77 4.0
78 5.0
79 8.0
80 8.0
81 5.0
82 9.0
83 7.0
84 6.0
85 14.0
86 9.0
87 3.0
88 4.0

A) Find the average delivery time for the sample of shipments from the data sheet

B) Find the standard deviation of the delivery times for the sample of shipments from the data sheet.

C) Find the size of the sample of shipments from the data sheet.

D) Find the score from the appropriate probability table (standard normal distribution, t distribution, chi-square) to construct a 90% confidence interval .

E) Find the margon of error at 90% confidence level.

If you use Excel, please list what Excel functions would allow me to get this answers for future reference

Solutions

Expert Solution

A) Find the average delivery time for the sample of shipments from the data sheet

Average delivery time = 5.943181818

(by using excel function =average().)

B) Find the standard deviation of the delivery times for the sample of shipments from the data sheet.

Standard deviation = 2.688237275

(Use excel =stdev() function)

C) Find the size of the sample of shipments from the data sheet.

Sample size = n = 88

D) Find the score from the appropriate probability table (standard normal distribution, t distribution, chi-square) to construct a 90% confidence interval .

n = 88

confidence level = 90%

df = n – 1 = 88 – 1 = 87

so, by using t-table or excel, we have

Critical t value = 1.6626

(Use excel =tinv() function)

E) Find the margon of error at 90% confidence level.

Margin of error = t*S/sqrt(n)

Margin of error = 1.6626*2.688237275/sqrt(88)

Margin of error = 1.6626* 0.286567056

Margin of error = 0.4764

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Shipment Time to Deliver (Days) 1 7.0 2 12.0 3 4.0 4 2.0 5 6.0 6...
Shipment Time to Deliver (Days) 1 7.0 2 12.0 3 4.0 4 2.0 5 6.0 6 4.0 7 2.0 8 4.0 9 4.0 10 5.0 11 11.0 12 9.0 13 7.0 14 2.0 15 2.0 16 4.0 17 9.0 18 5.0 19 9.0 20 3.0 21 6.0 22 2.0 23 6.0 24 5.0 25 6.0 26 4.0 27 5.0 28 3.0 29 4.0 30 6.0 31 9.0 32 2.0 33 5.0 34 6.0 35 7.0 36 2.0 37 6.0 38...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5 8 7 6 5 7 7 6 7 8 8 8 9 7 8 10 12 11 Test the significance of the correlation coefficient. Then use math test scores (X) to predict physics test scores (Y).  Do the following: Create a scatterplot of X and Y. Write the regression equation and interpret the regression coefficients (i.e., intercept and slope). Predict the physics score for each....
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Find mean, median, mode, variance, standard deviation, coefficient of variation, range, 70th percentile, 3rdquartile of the data and skewness and define what each of these statistics measure. For example, mean is a measure of the central tendency, what about the rest? Use Chebyshev’s rule to find...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Split the dataset in two equal parts. You have 30 datavalues. If you split the data in two equal parts each part will contain 15 data values.  Call the first part Y and second part X.Draw scatter plot of the 2 datasets, X being on the horizontal...
1.Determine the linearization of f(x)= −2.0 x^2.0−4.0 x - 4 at x=2. 2.Determine the linearization of...
1.Determine the linearization of f(x)= −2.0 x^2.0−4.0 x - 4 at x=2. 2.Determine the linearization of f(x)= (−x^2)−4/x^3 at x=−1.
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3...
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3 5 4 7 9 7 0 0 4 5 6 9 9 8 1 3 5 6 8 9 9 0 1 2 3 5 9 The table represent a random sample of 31 test scores taken from a large lecture class. Find the following [round to 2 decimal points X. XX] a) [2 pts] Find the 5 number summary [L, Q1, Q2, Q3,...
Time (hours) spent on social media per day 2 5 4 6 3 2 4 1...
Time (hours) spent on social media per day 2 5 4 6 3 2 4 1 0 1 3 2 5 4 2 6 3 7 4 3 5 2 4 1 3 4 2 4 3 5 3 6 3 2 4 1. For the above data set, give the minimum and maximum score and calculate the range. 2. Calculate the standard deviation (show your work). 3. Choosing the appropriate format, draw a bar chart or histogram of the...
Matrix A2= [1 2 3; 4 5 6; 7 8 9; 3 2 4; 6 5...
Matrix A2= [1 2 3; 4 5 6; 7 8 9; 3 2 4; 6 5 4; 9 8 7] Note: TA2 is defined to be a linear transformation that maps any vector x to A2* x. That is TA2 = A2*x. Also the range of the Linear transformation represented by A2 is the same as the column space of A2. l) Find a basis for the null(TA2). m) Find nullity of A2, TA2 and A2tA2. n) Find rank(A2), rank(A2t),...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot the date B: find the line of best fit C: determine ŷ AT x=3 D: Find r and r^2 E: explain r and r^2
2. Consider functions f : {1, 2, 3, 4, 5, 6} → {1, 2, 3, 4,...
2. Consider functions f : {1, 2, 3, 4, 5, 6} → {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}. (a) How many of these functions are strictly increasing (i.e. f(1) < f(2) < f(3) < f(4) < f(5) < f(6))? Hint: How many different possibilities are there for the range of f? For each range of f, how many strictly increasing functions are there? (b) How many of these functions are non-decreasing (i.e. f(1) ≤ f(2) ≤...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT