The questions for the assignment are indicated below. The datasets are in the assignment folder. Q1. QUESTION XR03-27, Page 66: A number of businesses and economics courses require the use of computers. As a result many students buy their own computer. A survey asks students to identify which computer brand they have purchased. The responses are recorded with the following codes. 1 IBM 2 Compaq 3 Dell 4 Other Based on the data, answer the following: a. Use a graphical technique that depicts the data frequencies [2 points] b. Graphically depict the proportions [2 points] c. What do the charts tell you about the brands of computers used by the students? [1 point] Q2. A sample of 400 visitors to an exhibition was timed to determine how long each took to view the exhibit. Three samples were taken: one in the morning, the second in the afternoon and the third in the evening. These data are stored in column 1, 2 and 3 respectively of the file provided (exhi8bition.xls). Using the data, answer the following questions: a. Determine the mean and standard deviation of each sample [3 points] b. Calculate the best measure of spread that can be used to compare the three samples [3 points] c. Based on the measure calculated in part b, interpret your findings. [1 points] Q3. One of the critical factors that determine the success of a catalogue store chain is the availability of products that customers want to buy. If a store is sold out, future sales to that customer are less likely. Because of this, stores are regularly resupplied by delivery trucks operating from a central warehouse. In an analysis of a chain's operations, the general manager wanted to determine the factors that affected how long it took to unload delivery trucks. A random sample of 50 deliveries to one store was observed. The time (in minutes) to unload the truck, the total number of boxes and the total weight (in hundreds of kilograms) of the boxes were recorded. Analyze the sample data to answer the following questions: a. Determine the multiple regression equation. [2 points] b. How well does the model fit the data? Explain using any two statistics from your regression results. [2 points] c. Which of the variables is linearly related to the time to unload? What statistics do you use to draw this conclusion [2 points] d. Calculate to predict the amount of time needed to unload a truck with 100 boxes of total weight 5000kg. [2 points] Computer 3 1 1 1 4 3 1 2 4 3 3 3 3 1 4 3 1 4 4 1 3 4 3 3 4 4 1 3 1 2 3 4 1 3 2 1 3 2 1 3 1 3 4 1 3 1 2 2 3 3 4 4 3 3 4 3 1 3 4 1 3 4 4 3 3 2 3 3 4 4 3 3 4 3 3 4 3 3 2 3 2 1 4 1 4 1 4 2 4 3 2 1 3 3 2 3 4 2 Times in minutes Morning Afternoon Evening 113 46 107 36 40 40 45 50 39 47 65 63 51 34 41 42 25 77 31 28 29 89 78 32 52 53 54 40 78 90 45 53 52 65 92 48 52 42 54 32 60 88 28 71 39 28 50 43 34 33 40 82 49 70 29 28 65 47 43 82 49 54 45 43 70 91 38 27 71 64 44 45 58 66 40 31 33 67 47 78 51 39 48 44 53 41 41 64 50 63 88 90 57 73 50 66 41 41 47 51 41 58 98 42 38 29 82 35 63 52 50 60 125 60 85 70 49 41 81 32 62 98 50 30 55 49 70 38 42 34 54 63 48 50 67 41 29 38 26 74 49 60 37 41 151 70 56 47 35 39 66 28 42 45 43 54 31 27 58 41 33 59 27 31 106 40 53 30 42 104 90 50 57 34 51 42 31 35 45 42 44 64 72 54 70 56 62 55 30 107 62 57 33 45 48 98 66 28 53 42 60 44 55 38 43 72 46 38 28 44 53 41 46 58 70 59 63 44 45 56 134 43 102 46 49 35 33 59 88 68 50 28 93 32 42 45 32 62 43 43 42 34 75 47 44 39 48 51 109 70 74 64 36 44 70 40 39 63 40 52 47 36 44 45 112 32 45 32 39 27 57 74 69 48 33 94 44 46 61 38 71 63 68 58 42 78 73 33 32 38 57 30 52 48 23 57 44 49 46 62 57 80 44 64 36 42 44 40 43 55 84 61 29 42 79 47 39 33 61 60 50 54 55 54 48 32 64 68 61 29 62 41 47 30 53 54 71 54 31 29 64 33 67 85 85 52 38 58 60 40 34 30 41 47 46 59 63 41 53 33 36 35 45 37 35 83 43 30 35 66 91 40 45 63 36 28 46 70 64 61 33 46 41 45 48 37 57 54 24 41 91 71 48 62 43 70 36 121 79 35 Time Boxes 62 77 39 52 79 34 51 70 71 53 58 58 61 72 84 67 58 81 70 42 67 73 83 73 68 61 55 83 58 51 83 37 52 86 46 87 50 22 68 23 61 55 68 66 61 36 77 63 50 59 126 154 96 127 151 103 125 138 139 140 114 117 141 130 156 136 128 137 131 103 129 129 154 144 127 127 126 153 126 136 182 91 131 156 115 156 127 73 127 102 149 130 126 132 135 101 150 146 137 140 Weight 36.05 22.94 24.86 30.54 35.57 11.49 15.45 33.71 33.88 25.72 20.78 19.54 5.80 37.26 59.53 24.25 34.91 25.51 40.89 19.72 25.83 33.41 51.99 35.59 31.38 27.21 36.06 17.84 34.35 2.38 18.62 19.28 23.08 53.22 18.17 33.71 8.83 21.55 45.41 14.77 41.40 32.52 45.32 25.54 19.07 14.86 50.02 40.83 7.50 17.30