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 1 year ago

Next > < Previous

Related Solutions

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...

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) ≤...

Year Promisedcash flows Expectedcash flows 1 6 5 2 6 5 3 6 5 4 6...

Year Promisedcash flows Expectedcash flows 1 6 5 2 6 5 3 6 5 4 6 5 5 6 5 6 6 5 7 6 5 8 6 5 9 6 5 10 106 95 What is the present value today of promised cash flows at 6%? If the price of the bond is 80, what is the yield to maturity of the bond using the promised cash flows? What is the present value today of the expected cash flows...

Problem 6-01 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6...

Problem 6-01 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 18 12 16 10 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. Mean absolute error. If required, round your answer to one decimal place. Mean squared error. If required, round your answer to one decimal place. Mean absolute percentage error. If required, round your intermediate calculations and final...

Subjects