Hotel Guest Day # Guest Bins 1 2 3 4 5 6 7 8 9 10 11 32 45 19 17 42 22 32 45 92 66 32 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 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 11 16 18 38 18 41 63 72 43 45 44 48 48 67 72 41 52 75 40 34 40 88 63 38 48 45 50 150 84 28 37 52 44 49 70 75 58 23 62 10 71 80 70 41 47 99 38 29 83 60 54 35 46 51 58 72 86 48 48 51 62 62 85 150 0 20 40 60 80 100 120 140 160 180 Bin 0 20 40 60 80 100 120 140 160 180 More Frequency 0 7 15 28 16 7 0 0 2 0 0 Q-1a. You're the manager of a hotel and you want to know how many guest visit on a daily basis. You collect data over a 75 day period. Use appropriate descriptive statistics to make sense of this data. Use an appropriate graph also. (Note, Key statistics to consider: Mean, Median, Mode) Income $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 26,748.51 53,063.79 36,090.14 32,058.07 47,843.42 50,180.97 30,710.08 29,141.70 55,980.15 28,730.88 31,109.23 55,614.12 23,038.43 34,531.72 30,350.36 38,964.94 49,392.77 25,595.69 29,622.61 31,586.10 49,674.56 28,878.98 24,287.08 46,711.24 43,449.81 31,694.45 45,459.22 47,047.34 26,433.24 33,396.66 26,179.36 33,454.64 42,271.50 Sales $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,695,712.62 3,403,862.05 2,710,352.91 529,215.46 663,686.65 2,546,324.34 2,787,046.20 612,696.05 891,822.03 1,124,967.97 909,500.98 2,631,166.88 882,972.65 1,078,573.12 844,320.19 1,849,119.03 3,860,007.32 826,573.88 604,682.87 1,903,611.60 2,356,808.39 2,788,571.96 1,634,878.29 2,371,627.37 2,627,837.96 1,868,116.33 2,236,796.86 1,318,876.23 1,868,097.84 1,695,218.57 2,700,194.42 1,156,049.77 643,858.44 Age Growth 33.16 32.67 35.66 33.07 35.76 33.81 30.98 30.78 32.32 32.53 31.44 33.16 31.87 33.41 34.05 28.89 36.11 32.81 33.05 33.50 32.68 28.52 32.89 30.50 30.29 31.29 33.05 32.93 31.84 31.08 32.18 31.69 34.03 0.8299 0.6619 0.9688 0.0821 0.4646 2.1796 1.8048 -0.0569 -0.1577 0.3664 2.2256 1.5158 0.1413 -1.0400 1.6836 2.3596 0.7840 0.1164 1.1498 0.0606 1.6338 1.1256 1.4884 4.7937 1.8922 1.8667 1.7896 0.2707 3.0129 3.4630 0.7041 -0.1569 0.7084 HS 73.5949 88.4557 73.5362 79.1780 84.1838 93.4996 78.0234 70.2949 70.6674 63.7395 76.9059 82.9452 65.2127 73.4944 80.2201 87.5973 85.3041 65.5884 80.6176 80.3790 79.8526 81.2371 70.2244 87.1046 80.2057 75.2914 77.6162 85.1753 74.1792 81.6991 73.4140 73.7161 78.6493 College 17.8350 31.9439 18.6198 20.6284 35.2032 41.7057 28.0250 15.0882 10.9829 13.2458 19.5500 20.8135 16.9796 32.9920 22.3185 24.5670 30.8790 17.4545 18.6356 38.3249 23.7780 16.9300 19.1429 30.8843 26.5570 28.3600 19.2490 35.4994 18.6375 41.1130 17.8566 26.5426 29.8734 Can demographic information be helpful in predicting sales at sporting goods stores? The data at left are monthly sales totals from a random sample of 33 stores in a large chain of nationwide sporting goods stores. All stores in the franchise, and thus within the sample, are approximately the same size and carry the same merchandise. The county, or in some cases counties, in which the store draws the majority of its customers is referred to here as the customer base. For each of the 33 set are: Sales ------Latest one month sales total (dollars) Income ---Median family income of customer base (dollars) Age --------Median age of customer base (years) HS ----------Percentage of customer base with a high school diploma College ---Percentage of customer base with a college diploma Growth ---Annual population growth rate of customer base over the past 10 years. __________________________________________________________________________________________ Q-2a. Interpret the meaning of the Y-intercept, b0, and the slope, b1, in this problem. (5 pts.) __________________________________________________________________________________________ Q-2b. Compute the coefficient of determination r2, and interpret its meaning. (5 pts.) __________________________________________________________________________________________ Q-2c. Construct a 95% confidence interval estimate of the population slope and interpret its meaning. ( 5 pts.) Model Honda Civic Hyundai Elantra XE Mazda 3 Honda Civic Ex Kia Rio LX Hyundai Accent Kia Spectra EX Mitsubishi Lancer Nissan Sentra Kia Spectra EX Toyota Yaris Chevrolet Cobalt Suzuki Forenza MPG 31 27 27 28 28 28 25 25 26 25 33 23 24 The data at left come from a sample of the overall miles per gallon (MPG) of 2008 sedans priced under $20,000. Q-4a: Construct a 95% confidence interval estimate for the population mean MPG of 2008 sedans under $20,000. (Round to one decimal place.) Use the calculator below to help calculate your answer Sample Size: n >= 30 Input Area n x-bar s confidence level Output Area Center of Interval t*s/sqrt(n) Lower end of int'l Upper end of int'l #DIV/0! #DIV/0! #DIV/0! Other Calculations Interval width 1-conf t #DIV/0! 1.00 Err:502 sqrt(n) s/sqrt(n) #DIV/0! Late payment of medical claims can add to the cost of health care. The auditing firm of Dewey, Cheatham, and Howe has discovered that for one insurance company, 85.1% of the claims were paid in full when first submitted based on a sample of 200 claims. Suppose that the insurance company developed a new payment system in an effort to increase this percentage. A sample of 200 claims processed under this new system revealed that 180 of the claims were paid in full when first submitted. At the 5% level of significance, is there evidence that the population proportion of claims paid in full under this new system is higher than the proportion of claims paid in full under the old system? Q-2a: State the null hypothesis Q-2b: State the alternative hypothesis. Q-2c: Perform the hypothesis test and state your conclusions and evidence. Use the calculator below to calcualte your answer. Type of Estimate: Proportion Input Area Sample 1: Sample 1 proportion, p1-bar Sample 1 Size, n1 0.980 120 Sample 2: Sample 2 Proportion, p2-bar Sample 2 Size, n2 0.820 150 Confidence level Test Result 99% p is less than significance level Reject Null Hypothesis p-value Significance Level Other Calculations p1-bar - p2-bar s1^2/n1 s2^2/n2 standard error z statistic 0.000 0.010 0.1600 0.000163 0.0010 0.0339 4.724 (p1-bar)(1 - p1-bar) 0.02 (p2-bar)(1 - p2-bar) 0.15