ID Cost of Airfares in the US (domestic) 1 146 2 620 3 79 4 299 5 576 6 89 7 589 8 165 9 509 10 23 11 376 12 226 13 462 14 634 15 36 16 226 17 263 18 456 19 390 20 541 21 19 22 329 23 537 24 512 25 423 26 515 27 358 28 110 29 319 30 671 31 561 32 96 33 574 34 385 35 263 36 240 37 449 38 592 39 404 40 119 41 173 42 419 43 495 44 224 45 228 46 616 47 168 48 396 49 524                 Airfares (as shown in the Excel file for this week’s seminar) were based on the total ticket value, which consisted of the price charged by the airlines plus any additional taxes and fees.   The prices follow normal distribution. Use Excel to plot the density of the prices;   You can either use pen and paper or Excel for question 2-5. Please use the z score formula to calculate the question 2-5.   What is the probability that a domestic airfare is $550 or more? What is the probability that a domestic airfare is $250 or less

B Salaries for 39 Engineers Employed by the Solnar Company B 9 0 1 12 83 34 35 36 37 Salary ($1000) 48 50 52 54 56 59 59 59 59 60 65 65 67 70 78 86 88 89 90 95 95 96 97 100 102 110 115 118 120 124 125 125 128 130 130 38 39 40 41 42 43 44 130 131 134 134 Years 1 1 1 1 2 5 2 2 4 7 3 4344 10 10 7 14 10 15 15 10 14 13 13 25 34 30 25 19 18 32 19 20 18 20 32 35 YearsSq 1 1 1 1 4 25 4 4 16 49 9 16 9 16 16 100 100 49 196 100 225 225 100 196 169 169 625 1156 900 625 361 324 1024 361 400 324 400 1024 1225 Male 0 0 1 1 0 0 1 1 1 0 0 0 1 1 0 1 1 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Years x Male 0 0 1 1 0 0 2 2 4 0 0 0 3 4 4 0 10 7 0 10 0 15 10 14 13 13 25 34 30 25 19 18 32 19 20 18 20 32 35 Leaming Copyright 2019 by The McGraw-Hill Companies This spreadsheet is intended solely for educational purposes by licensed users of Connect Note: The binary variable Male is 1 if the engineer is male, 0 otherwise

ID Cost of Airfares in the US (domestic) 1 146 2 620 3 79 4 299 5 576 6 89 7 589 8 165 9 509 10 23 11 376 12 226 13 462 14 634 15 36 16 226 17 263 18 456 19 390 20 541 21 19 22 329 23 537 24 512 25 423 26 515 27 358 28 110 29 319 30 671 31 561 32 96 33 574 34 385 35 263 36 240 37 449 38 592 39 404 40 119 41 173 42 419 43 495 44 224 45 228 46 616 47 168 48 396 49 524 What if the probability that a domestic airfare is between $300 and $400? What is the cost for the 3% highest domestic airfares?     Use Excel functions Dist and Norm.INV to check your answers in Question 2-5.

Years <50 50-54 55-59 60-64 65-69 70+ Africans Population 8,236,458 834,541 757,364 661,428 485,851 1,185,358 No. of deaths from Covid 19 4,265 2,007 2,026 1,258 2,191 8,265 Europeans Population 6,235,145 311,774 272,111 223,112 143,872 288,056 No. of deaths from Covid 19 3,254 715 456 776 618 2,569 Calculate the crude death rates for Covid 19 for both Africans and Europeans per 100,000 population.

Number of ChildrenTable 1 shows the number of women (per 1000) between 15 and 50 years of age who have been married grouped by the number of children they have had. Table 2 gives the same information for women who have never been married.1 Number of Children     Women per 1000 0   162 1   213 2   344 3   182 4   69 5+      32 Table 1 Women who have been married Number of Children     Women per 1000 0   752 1   117 2   72 3   35 4   15 5+      10 Table 2 Women who have never been married 1http://www.census.gov/hhes/fertility/data/cps/2014.html, Table 1, June 2014.   Condition gt requires numbers instead of "null" and "0" (a) Without doing any calculations, which of the two samples appears to have the highest mean number of children?  Women who have been marriedWomen who have never been married Which of the distributions appears to have the mean most different from the median?  Women who have been marriedWomen who have never been married…

ID  Old Score New Score  1 81 82 2 72 72 3 77 74 4 74 72 5 78 78 6 77 72 7 83 84 8 90 86 9 70 69 10 70 72 11 72 69 12 71 69 13 71 67 14 71 64 15 71 68 16 71 69 17 71 71 18 71 69 19 71 72 20 71 70 21 71 71 22 71 71 23 72 70 24 72 69 25 72 72 26 72 73 27 72 74 28 72 69 29 72 73 30 72 69 31 73 71 32 73 74 33 73 72 34 73 75 35 73 73 36 73 69 37 73 72 38 74 67 39 74 68 40 74 75 41 74 74 42 74 75 43 74 74 44 74 68 45 74 70 46 75 70 47 75 72 48 75 70 49 75 69 50 75 74 51 75 71 52 75 71 53 75 71 54 75 71 55 75 69 56 76 75 57 76 70 58 76 70 59 76 78 60 76 72 61 77 78 62 77 73 63 77 74 64 77 78 65 78 78 66 78 71 67 78 72 68 79 72 69 79 76 70 79 77 71 79 77 72 80 82 73 80 74 74 81 81 75 82 82 Question 13 with the data set above.

need help on these

How long does it take to finish the 1161-mile Iditarod Dog Sled Race from Anchorage to Nome, Alaska? Finish times (to the nearest hour) for 57 dogsled teams are shown below. 261 271 236 244 279 296 284 299 288 288 247 256 338 360 341 333 261 266 287 296 313 311 307 307 299 303 277 283 304 305 288 290 288 289 297 299 332 330 309 328 307 328 285 291 295 298 306 315 310 318 318 320 333 321 323 324 327             For this problem, use five classes. (a) Find the class width. (b) Make a frequency table showing class limits, class boundaries, midpoints, frequencies, relative frequencies, and cumulative frequencies. (Give relative frequencies to 2 decimal places.)

Male Female27,329 22,49814,596 24,5893,890 5,06827,315 16,72525,067 10,3808,480 16,57219,490 10,75516,334 19,12228,183 11,82721,356 18,61212,674 15,73210,066 11,42311,288 17,79220,679 24,76719,722 6,359369 19,57118,284 21,81211,653 19,68618,981 18,29415,412 13,48515,839 31,24320,391 9,4316,069 16,1216,072 4,22624,527 12,6649,492 20,22511,618 14,59813,916 22,04613,081 20,08517,460 11,13913,491 35,7097,630 8,54121,263 9,82216,455 12,38511,590 28,05515,409 19,22816,827 16,21710,596 17,72618,005 20,00612,428 16,58313,727 19,8574,706 14,49917,168 17,97412,641 17,22015,661 28,75616,855 38,40718,490 25,78537,993 33,38319,196 25,06447,688 30,26225,062 18,14310,357 7,59515,653 23,8969,962 16,4425,377 16,53619,537 26,129

chix