Descent, Inc., produces a variety of climbing and mountaineering equipment. One of its products is a traditional three-strand climbing rope. An important characteristic of any
Descent, Inc., produces a variety of climbing and mountaineering equipment. One of its products is a traditional three-strand climbing rope. An important characteristic of any climbing rope is its tensile strength. Descent produces the three-strand rope on two separate production lines: one in Bozeman and the other in Challis. The Bozeman line has recently installed new production equipment. Descent regularly tests the tensile strength of its ropes by randomly selecting ropes from production and subjecting them to various tests. The most recent random sample of ropes was taken after the new equipment was installed at the Bozeman plant. The data collected for the two samples are given in the Excel file.
Test the hypothesis that the mean strength for Bozeman ropes is different from that of Challis, at the 90% confidence level. Show all parts of the hypothesis test, including your hypotheses, identification/calculation of the necessary values, your test-statistic calculation, your p-value calculation, and your conclusion. For this question, you may use the appropriate Analysis Toolpak tool.
Excel file
Bozeman | Challis |
7382 | 6823 |
7210 | 6987 |
7248 | 6976 |
7070 | 6836 |
7092 | 6867 |
7145 | 6859 |
7129 | 6984 |
7154 | 6863 |
7162 | 6803 |
7172 | 6854 |
7244 | 6860 |
7301 | 7045 |
7174 | 6927 |
7190 | 6909 |
7147 | 6994 |
7061 | 6965 |
7182 | 6952 |
7173 | 6985 |
7341 | 7052 |
7326 | 6849 |
7069 | 6885 |
7117 | 7045 |
7325 | 6980 |
7289 | 6802 |
7183 | 6984 |
7389 | 6951 |
7224 | 6868 |
7179 | 6834 |
7005 | 6994 |
7135 | 7009 |
7182 | 6908 |
7244 | 7032 |
7367 | 6955 |
7282 | 6826 |
7252 | 6849 |
7161 | 6846 |
7017 | 6860 |
7147 | 6830 |
7033 | 6905 |
7063 | 7056 |
7231 | 6817 |
7312 | 6832 |
7159 | 6967 |
7289 | 7056 |
7219 | 6836 |
7059 | 6865 |
7249 | 7050 |
7233 | 6920 |
7161 | 6827 |
7018 | 6910 |
7272 | 6914 |
7142 | 6998 |
7318 | 6842 |
7068 | 6904 |
7156 | 7016 |
7137 | 6978 |
7326 | 6825 |
7171 | 6844 |
7036 | 7088 |
7218 | 7250 |
7267 | 6872 |
7210 | 7062 |
7056 | 6988 |
7349 | 7043 |
7338 | 6939 |
7280 | 6984 |
7260 | 7098 |
7328 | 6933 |
7238 | 6942 |
7384 | 6858 |
7334 | 6927 |
7196 | 7032 |
7169 | 6840 |
7166 | 6957 |
7239 | 7041 |
7032 | |
7052 | |
6832 | |
6938 | |
7053 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Summ...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started