Each sheet contains a yellow cell for each answer. You may use blank areas in the spreadsheet for intermediate steps. Put your final answer in the yellow cell. For numeric answers, do no Enter the formula that yields the answer rather than typing the num What is What is 3 3 times times 4 4 12 No 12 Yes Enter your name(s) below, but do not make any changes to this shee 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 0.00 0.00 0 0 0 0.0000 0.0% 0.0% 0.0% 0.0% 0 0 0 ediate steps. nswers, do not "hard code" your answers. yping the numeric answer. es to this sheet. Road Section 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 # Repairs 0 0 0 0 0 0 4 0 0 0 0 5 0 0 3 0 0 0 0 1 0 0 0 0 2 0 3 0 1 4 0 0 2 0 0 1 1 0 2 0 1 0 0 2 0 1 0 0 3 0 Your company contracts with the county to do roadwork. Your contract stat If a section of road deteriorates within 1 year of being paved, the county wi the county will pay half of the repair costs and your company will pay the ot Repairs cost your company $200,000 per section of roadway. (Road sectio The data show sections of roadway your company has paved in the past a The county has offered your company a contract (call it, contract A) to pave What is the probability that the section you have been asked to pave will re How many repairs do you expect the section of road to require over the 5 y How much do you expect the section of road to cost your company in repa The county is offering you an alternate contract (contract B) that pays your to bear any cost for deterioration repairs. Instead, the county will pay the fu Which contract do you expect to be worth more to your company, A or B? By how much is this contract worth more than the other one? work. Your contract states the county will pay you to pave the roads. You and the county expect each section of road to last ng paved, the county will pay for the repairs. If the same section of road deteriorates a second time within 5 years of the orig company will pay the other half. Your company must pay the full cost for any additional repairs during the 5 year window. f roadway. (Road sections are defined to be roughly identical with respect to the paving cost.) has paved in the past and the number of times each section has required repairs during the 5 years following the paving. call it, contract A) to pave a section of road. Use the data to answer the following questions. een asked to pave will require more than 1 repair within 5 years? d to require over the 5 year window? st your company in repairs during the 5 year window? ntract B) that pays your company $50,000 less than contract A but which does not require your company he county will pay the full cost of all repairs during the 5 year window. your company, A or B? xpect each section of road to last for 5 years before deteriorating. ond time within 5 years of the original paving, pairs during the 5 year window. e 5 years following the paving. your company Year Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Pittsburgh Philadelphia 1.2% 2.8% 1.8% 1.4% 1.4% 2.8% 2.9% 2.5% 1.2% 2.9% 1.2% 1.8% 1.7% 1.2% 1.1% 2.7% 2.1% 2.9% 2.0% 2.3% 1.7% 1.6% 1.6% 2.8% 2.4% 1.4% 2.0% 1.9% 2.2% 2.5% 2.0% 1.9% 1.5% 1.4% 2.2% 1.1% 2.2% 1.8% 2.7% 1.1% 2.7% 1.1% 1.1% 1.5% 1.1% 1.7% 1.9% 2.8% 1.0% 2.8% 2.3% 2.1% 2.6% 1.0% 2.3% 1.0% 2.3% 2.9% 1.3% 2.2% 1.5% 2.8% 1.0% 1.4% 1.4% 2.2% 1.4% 2.6% 1.0% 1.6% 1.3% 2.2% 2.0% 2.2% 1.3% 2.8% 1.2% 2.8% 1.1% 1.3% 1.1% 2.1% 1.3% 2.3% 2.0% 2.8% 2.1% 1.9% 2.2% 1.9% 2.1% 1.3% 1.7% 1.4% 1.1% 2.8% 1.1% 1.5% 1.1% 1.2% 2.3% 2.5% 2.9% 2.9% 1.9% 1.5% 2.1% 2.7% You will be graduating soon and are deciding whether to look for job with bachelors degrees in your field in each of the cities over time. Over this period, the average unemployment rate in your field in Pitt apparent difference is due to random chance? There is a 95% chance that, in the month you graduate, Pittsburgh's There is a 95% chance that, over the sixth months following your gra When employed, you can expect to earn $47,000 working in Pittsbu Accounting for the difference in the expected unemployment rates a per year in Philadelphia versus Pittsburgh? Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 2.8% 1.8% 1.3% 1.4% 2.6% 2.5% 2.0% 1.1% 2.4% 1.7% 2.8% 2.8% 2.4% 2.8% 2.1% 2.4% 2.8% 2.3% 2.8% 1.2% whether to look for jobs in Pittsburgh or in Philadelphia. The data show unemployment rates for people of the cities over time. rate in your field in Pittsburgh was 1.8%. In Philadelphia, it was 2.1%. What is the probability that this u graduate, Pittsburgh's unemployment rate in your field will be between what two extremes? onths following your graduation, Pittsburgh's unemployment rate in your field will average between what two extremes? ,000 working in Pittsburgh but $54,000 working in Philadelphia. The cost of living is $6,000 per year higher in Philadelphia. unemployment rates and the difference in the costs of living, how much more spending money can you expect to have what two extremes? ar higher in Philadelphia. n you expect to have Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 Rides per Day Number of Drivers 178 7 52 29 154 22 223 14 262 16 204 17 220 12 200 12 154 8 146 6 215 17 230 19 155 24 101 25 95 28 199 12 159 23 209 8 8 30 35 28 111 5 246 12 156 24 133 6 185 22 135 6 185 10 186 10 200 13 143 6 185 22 248 18 180 7 158 7 224 11 113 26 195 13 234 20 183 23 47 29 162 24 225 20 212 21 229 18 199 11 240 17 212 12 199 16 204 15 65 27 136 24 208 20 197 19 125 23 You are analyzing data for Uber. Over 75 days, you ha number of rides those drivers provided. Use this data Rides per Day = a + b (Number of Drivers) + c (Numb According to the estimated regression model, how ma the number of rides (round to the nearest whole numb According to the estimated regression model, if Uber provide (round to the nearest whole number)? 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 18 120 106 116 160 106 230 200 218 160 205 134 95 205 203 122 186 128 165 220 209 30 5 26 24 6 5 18 10 11 7 21 24 26 20 11 6 21 24 7 10 20 er. Over 75 days, you have recorded the number of drivers who were registered as "available" and the total provided. Use this data to estimate the following regression model. er of Drivers) + c (Number of Drivers)2 + u gression model, how many drivers would Uber need to have available on a given day to maximize the nearest whole number)? gression model, if Uber had this many drivers available, how many rides would it whole number)