The city of North Bay has decided to try out a new Rubber/Asphalt product which
ID: 3326904 • Letter: T
Question
The city of North Bay has decided to try out a new Rubber/Asphalt product which has a guarantee of 20 years before it needs replacing. The City looked all over and decides that Seymour street is the perfect spot to test this new type of road. In order to figure out the thickness for this new road, the city must determine how many semi-trucks and buses travel down this road daily. They step up a counter for 400 days. The data collected is in an excel file marked Assignment #3. 1. Is this data continuous or discrete? 2. Is this data qualitative or quantitative? 3. Construct a labeled frequency table for this data. Include columns for Class width, frequency relative frequency and cumulative relative frequency. 4. Use Microsoft Excel to construct a histogram for this data. Make sure to properly format the histogram using the guidelines from class. Also, make sure to include appropriate titles. Copy it as a picture here. 5. Describe the shape of the distribution. 6. Does the mean or median best represent the center tendency for this data? Justify your answer. 7. What is the preferred measure of variation for this data: the standard deviation or the interquartile range? Justify your answer. 8. Calculate the following. Include the Excel code you used and their answer. the mean, median, and mode. a) MEAN - b) MEDIAN - c) MODE - d) STANDARD DEVIATION - 9. Calculate the interquartile range. Include the Excel code you used and their answer 10. Give an interval that will likely contain about 99.7% of this data. Explain your answer. Include any excel codes you may have used (Hint- think about Unit 1 with standard deviation, not Unit 2 on probability!) *****USE THE INFO FROM QUESTION #8 TO ANSWER THE FOLLOWING QUESTIONS ******* 11. Compute the following probability. Assume the answers to your calculations In Question #8 exactly reflect the population stats. Include probability equation, excel code and the answer. a) P( X 95) = b) P( 60 X 75) = 12. What is the daily number of trucks that only 5% of any sample taken would be greater then? (Show any excel codes and their answers) 13. It has been 10 years since the city has put down the rubber/asphalt road. Although its held up better then regular asphalt, it is starting to crack. The City of North Bay decides to cash in on their 20 year guarantee, but the company says that they will not honour it. They claim that the great success of Canadore College’s Engineering programs at Commerce Court has caused an influx of students, which means many more daily city buses and trucks than originally thought. The matter is brought before the court, and the judge orders your engineering firm to take 40 random samples to see if there was any change. Data collected is included in excel file under QUESTION 13. Assume that your calculations from previous question are correct. At the 0.05 level of significance, would you suggest to the judge that there is significant change? (Show all your work, use the 7 step process for hypothesis testing. Include excel codes and their answers, etc., DATA SET 72 124 70 76 98 70 62 93 91 56 75 74 51 74 82 75 89 58 70 60 63 101 82 80 78 102 62 74 77 89 65 98 59 83 71 98 64 67 56 103 98 59 76 105 67 91 82 76 63 66 82 69 111 74 68 70 80 83 95 79 67 106 79 98 65 94 71 55 64 81 80 67 71 74 92 82 88 66 53 79 63 99 68 95 72 65 77 78 82 97 92 93 86 68 91 90 81 79 78 88 71 74 43 72 95 67 72 83 68 95 80 90 73 108 95 100 75 105 101 88 71 81 54 74 57 98 95 52 75 69 77 85 72 95 52 83 95 101 72 82 58 68 76 84 63 82 93 64 64 45 88 95 114 65 76 74 48 82 90 100 102 94 111 68 68 107 83 105 59 92 50 77 92 67 71 49 109 77 109 71 63 79 61 63 97 97 101 87 84 72 100 104 49 99 90 127 73 79 91 81 103 90 84 57 49 75 70 89 77 114 77 70 51 82 105 77 115 81 104 94 49 96 77 105 70 74 76 95 52 70 81 53 86 79 94 67 75 71 82 67 88 83 86 81 69 62 45 60 93 115 103 72 82 76 91 62 73 78 84 54 97 94 90 75 90 102 68 98 75 52 84 107 57 55 65 62 81 88 74 83 110 77 90 85 78 90 76 86 80 73 71 94 94 67 83 101 51 102 53 75 89 67 68 84 75 52 83 91 65 76 69 106 54 74 83 71 59 113 95 75 63 76 62 90 81 108 54 83 113 97 73 77 56 76 112 65 60 89 74 83 77 83 68 93 83 64 77 64 79 94 71 91 99 77 76 60 72 88 101 78 89 90 80 39 78 72 84 83 80 96 103 98 87 109 74 77 61 63 74 48 96 72 72 113 94 68 78 88 118 81 83 74 59 90 61 84 95 75 38 87 QUESTION #13 125 122 87 150 106 104 112 141 120 133 138 114 102 141 109 150 132 98 105 135 164 121 124 148 151 124 94 126 114 121 102 130 128 131 114 113 124 115 133 124
QUESTION #13 125 122 87 150 106 104 112 141 120 133 138 114 102 141 109 150 132 98 105 135 164 121 124 148 151 124 94 126 114 121 102 130 128 131 114 113 124 115 133 124Explanation / Answer
1)
This data is discrete. It is between 38 and 127, and can take only one value and not a range of values.
2)
It is quantitative, because the data is numeric and doesn't have any labels but numbers.
3)
The 400 values are pasted in a2:a401 range in excel
The formulae for above table is
4)
Histogram
5)
the shape of the distribution is more bell shaped.
6)
Mean is best suited than median for describing the central tendency as the distribution is normal
7)
standard deviation is best suited than interquartile range as the distribution is normal
8)
9)
Inter quartile range
10)
within 3 standard deviations 99.7% of observations lie for a normal distribution
Class width Frequency Relative freqency CumlRel Freq 38-48 7 1.75% 1.75% 49-59 35 8.75% 10.50% 60-70 69 17.25% 27.75% 71-81 115 28.75% 56.50% 82-92 82 20.50% 77.00% 93-103 62 15.50% 92.50% 104-114 25 6.25% 98.75% 115-127 5 1.25% 100.00%Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.