Answered: On Excel spreadsheet, find the results…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

On Excel spreadsheet, find the results of the hypothesis test for the equality of the mean production levels between the two locations Tampa, Florida, and Columbus, Ohio.

The current production goals for the monthly production level of the cases are a mean of at least 1,000 units per month and a standard deviation of less than 100 units per month.

Are the company goals being met for the cases produced at the Tampa, Florida location?

Are the company goals being met for the cases produced at the Columbus, Ohio location?

Are the mean production levels the same between the Tampa, Florida and Columbus, Ohio locations?

Number of cases
Number of cases
Month
produced (Columbus,
produced (Tampa, Florida)
Ohio)
1
684
819
1,080
836
3
720
888
773
897
5
1,016
903
831
907
7
835
912
8.
848
918
9
1,005
942
10
852
943
11
859
952
12
860
959
13
868
962
14
870
986
15
876
992
16
893
994
17
899
1,004
18
905
1,005
19
909
1,007
20
911
1,015
21
922
1,016
22
924
1,018
23
926
1,020
24
926
1,022
25
938
1,034
26
939
1,038
27
943
1,072
28
946
1,077
29
954
1,077
30
971
1,082
31
972
1,096
32
977
1,100
33
984
1,113
34
852
1,113
35
1,014
1,116
36
821
1,153
37
1,041
1,154
38
1,052
1,174
39
697
1,188
40
1,093
1,230

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution