Chapter 6, Problem 6.17AC

Concur Technologies, Inc., is a large expense-management company located in Redmond, Washington. The Wall Street Journal asked Concur to examine the data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city, with an average daily hotel room rate of $198 and an average amount spent on entertainment, including group meals and tickets for shows, sports, and other events, of $172. In comparison, the U.S. averages for these two categories were $89 for the room rate and $99 for entertainment. The table in the Excel Online file below shows the average daily hotel room rate and the amount spent on entertainment for a random sample of 9 of the 25 most visited U.S. cities (The Wall Street Journal, August 18, 2011). Construct a spreadsheet to answer the following questions. City Hotel Room Rate ($) Entertainment ($) Boston 145 163 Denver 97 105 Nashville 93 101 New Orleans…

Is it possible to predict the annual number of business bankruptcies by the number of firm births (business starts) in the United States? The following data published by the U.S. Small Business Administration, Office of Advocacy, are pairs of the number of business bankruptcies (1,000s) and the number of firm births (10,000s) for a six-year period. Business Bankruptcies (1,000) 34.3 Firm Births (10,000) 58.1 35.0 55.4 38.5 57.0 40.1 58.5 35.5 57.4 37.9 58.0 i) Based on the output given, use these data to develop the equation of the regression model to predict the number of business bankruptcies by the number of firm births. ii) Explain the values of r and r. iii) Predict the number of business bankruptcies if the number of firm births is 54.0 (10,000s). iv) Do the data support the existence of a linear relationship between the number of firm births and the number of business bankruptcies? Test using a = 0.05. OUTPUT Model Summary Std. Error of the Estimate Adusted R Model R R Square…

Suppose researchers at an abdominal transplant clinic are concerned about the rate of graft loss due to diabetes status prior to receiving a donor kidney. Research has shown that gender discordance, or receiving a gender from a donor of an opposite gender may increase the risk of both exposure and outcome after transplant. Assume the following tables represent the stratified analysis of the potential confounding variable. (9 points)   Gender Discordance Graft Failure No Graft Failure Total Diabetes II 23 10 33 No Diabetes II 4 44 48 Total 27 54 81 Gender Concordance Graft Failure No Graft Failure Total Diabetes II 9 34 43 No Diabetes II 12 87 99 Total 21 121 142   A)  Calculate the stratum specific estimates for the odds ratios in each strata. B)  Observe the difference in the odds ratios. Based on observation alone, what are we likely to conclude regarding the relationship between outcome and exposure…