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?
Extracted text: 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