Please answer questions, and please write the question # and the question part (ex. 1a, 1b, 2a, 2b, etc...).

1.

The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine 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. The following table shows the average daily hotel room rate (:13) and the average amount spent on entertainment (1]) for a random sample of 9 of the 25 mostvisited U.S. cities. These data lead to the estimated regression equation :17 = 17.49 + 1.033450. For these data SSE = 1541.4. Click on the datafile logo to reference the data. Use Table 1 of Appendix B. DATAF Room Rate Entertainment City ($) ($) Boston 148 161 Denver 96 105 Nashville 91 101 New Orleans 110 142 Phoenix 90 100 San Diego 102 120 San Francisco 136 167 San Jose 90 140 Tampa 82 98 a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals). $ b. Develop a 95% confidence interval for the mean amount spent on entertainment for all cities that have a daily room rate of $89 (to 2 decimals). $ to$ c. The average room rate in Chicago is $128. Develop a 95% prediction interval for the amount spent on entertainment in Chicago (to 2 decimals). $ t0$ \fA regression model relating @, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following regression output. Where ntotal = 30. ANOVA df SS MS F Significance F Regression 7,027.9 Residual Total 9,392.9 Coefficients Standard Error t Stat P-value Intercept 78.0 11.556 Number of 47.0 5.116 Salespersons a. Write the estimated regression equation (to whole number). y = + b. Compute the F statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) F-value p-value is - Select your answer - , we - Select your answer - | Ho c. Compute the t statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) t Stat p-value is - Select your answer - v , we - Select your answer - |Ho : B1 = d. Predict the annual sales at the Memphis branch office. This branch employs 11 salespersons. $ thousand (to whole number)A regression model relating at, number of salespersons at a branch office, to 3/, annual sales at the office (in thousands of dollars) provided the following regression output. Where metal = 30. ANOVA df 55 MS F Signicance F Regression 7,027.9 Residual Total 9,392.9 Coefficients Standard Error t Stat P- value Intercept 78.0 11.556 Number of 47.0 5.116 Salespersons a. Write the estimated regression equation (to whole number). 3:1 = + an b. Compute the F statistic and test the significance of the relationship at a 0.05 level of signicance. (to 2 decimals) F-value p-value i J Select your answer I , we - Select your answer - v H0 less than 0.01 between 0.01 and 0.025 75 Stat between 0.025 and 0.05 gleater than 0.10 d. Predi c. Comp e significance of the relationship at a 0.05 level of significance. (to 2 decimals) -mphis branch office. This branch employs 11 salespersons. $ thousand (to whole number) A regression model relating @, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following regression output. Where ntotal = 30. ANOVA df SS MS F Significance F Regression 7,027.9 Residual Total 9,392.9 Coefficients Standard Error t Stat P-value Intercept 78.0 11.556 Number of 47.0 5.116 Salespersons a. Write the estimated regression equation (to whole number). y = + b. Compute the F statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) F-value p-value is - Select your answer - we V - Select your answer - Ho c. Compute the t statistic and test the sig reject hip at a 0.05 level of significance. (to 2 decimals) do not reject t Stat p-value is - Select your answer - , we - Select your answer - |Ho : B1 = d. Predict the annual sales at the Memphis branch office. This branch employs 11 salespersons. $ thousand (to whole number)A regression model relating at, number of salespersons at a branch office, to 3/, annual sales at the office (in thousands of dollars) provided the following regression output. Where metal = 30. ANOVA df SS MS F Signicance F Regression 7,027.9 Residual Total 9,392.9 Coefficients Standard Error t Stat P- value Intercept 78.0 11.556 Number of 47.0 5.116 Salespersons a. Write the estimated regression equation (to whole number). 3:1 = + an b. Compute the F statistic and test the significance of the relationship at a 0.05 level of signicance. (to 2 decimals) F-value p-value is - Select your answer - V] , we ' - Select your answer - v, H0 c. Compute the t statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) 75 Stat p-value i 4 Select your answer I , we - Select your answer - v H0 2 51 = , less than 0.01 d. Predl -mphis branch office. This branch employs 11 salespersons. between 0.01 and 0.025 $ between 0.025 and 0.05 ber) between 0.05 and 0.10 greater than 0.10 A regression model relating @, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following regression output. Where ntotal = 30. ANOVA df SS MS F Significance F Regression 7,027.9 Residual Total 9,392.9 Coefficients Standard Error t Stat P-value Intercept 78.0 11.556 Number of 47.0 5.116 Salespersons a. Write the estimated regression equation (to whole number). y = + b. Compute the F statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) F-value p-value is - Select your answer - , we - Select your answer - v Ho c. Compute the t statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) t Stat p-value is - Select your answer - We v - Select your answer - Ho : 1 = d. Predict the annual sales at the Memphi reject ch employs 11 salespersons. do not reject $ thousand (to whole number)Given are five observations for two variables, a: and y. Use the estimated regression equation: = 65.9381 2.4948m. a. Compute the mean square error using equation. SSE 112 (to 4 decimals) 52 = MSE = b. Compute the standard error of the estimate using equation. SSE n2 s= MSE: (to 4 decimals) c. Compute the estimated standard deviation of In using equation. 3 Z (5% if (to 4 decimals) 561 = d. Use the t-test to test the following hypotheses (a = 0.10): Hg: 31 = 0 Ha: 51 7E 0 Compute the value of the ttest statistic (Enter negative values as negative numbers). (to 3 decimals) What is the pvalue? Use Table 2 from Appendix B. p-value is - Select your answer - v What is your conclusion? we Ho- e. Use the Ftest to test the hypotheses in part (d) at a 0.10 level of significance. Complete the F table below using Excel. Calculate the Sum of Squares (to 1 decimal), the Mean Squares (to 1 decimal), and the F ratio (to 2 decimals) and the pvalue (to 4 decimals). Source Degrees Sum of Mean of Variation of Freedom Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We - Select your answer - V H0 . (I. Use the t-test to test the following hypotheses (a = 0.10): H0: 31 = 0 Ha: 51 7': 0 Compute the value of the ttest statistic (Enter negative values as negative numbers). (to 3 decimals) What is the pvalue? Use Table 2 from Appendix B. p-value i J Select your answer between 0.01 and 0.02 between 0.02 and 0.05 We between 0.05 and 0.10 between 0.10 and 0.20 between 0.20 and 0.40 heses in part (d) at a 0.10 level of significance. greaterman 0'40 xcel. Calculate the Sum of Squares (to 1 decimal), the Mean Squares (to 1 decimal), and the F ratio (to 2 decimals) and the p'Value ( lower than 0.01 Source Degrees Sum of Mean of Variation of Freedom Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We - Select your answer - v H0. d. Use the t-test to test the following hypotheses (a = 0.10): Ho: 31 = 0 Ha: 51 7,: 0 Compute the value of the ttest statistic (Enter negative values as negative numbers). (to 3 decimals) What is the pvalue? Use Table 2 from Appendix B. p-value is - Select your answer - v What is your conclusion? W J - Select your answer - I H0 . do "m "eet - hypotheses in part (d) at a 0.10 level of significance. reject . . , r u using Excel. Calculate the Sum of Squares (to 1 decimal), the Mean Squares (to 1 decimal), and the F ratio (to 2 decimals) and the pvalue (to 4 decimals). Source Degrees Sum of Mean of Variation of Freedom Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We - Select your answer - v Ho. d. Use the t-test to test the following hypotheses (a = 0.10): Ho: 31 = 0 Ha: 51 7,: 0 Compute the value of the ttest statistic (Enter negative values as negative numbers). (to 3 decimals) What is the pvalue? Use Table 2 from Appendix B. p-value is - Select your answer - v What is your conclusion? we Ho- e. Use the Ftest to test the hypotheses in part (d) at a 0.10 level of significance. Complete the F table below using Excel. Calculate the Sum of Squares (to 1 decimal), the Mean Squares (to 1 decimal), and the F ratio (to 2 decimals) and the pvalue (to 4 decimals). Source Degrees Sum of Mean of Variation of Freedom Squares Square F p-value Regression Error Total What is your conclusion, based on this F test? We- W J - Select your answer - do not reject reject The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed of execution with their broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (scores) were no opinion (0), unsatisfied (1), somewhat satisfied (2), satisfied (3), and very satisfied (4). For each broker summary scores were computed by calculating a weighted average of the scores provided by each respondent. A portion of the survey results follow (AAII website, February 7, 2012). Brokerage Speed Satisfaction Scottracle, Inc. 2.5 2.0 Charles Schwab 3.1 2.6 Fidelity Brokerage Services 2.5 2.2 TD Ameritrade 4.0 3.7 E*Trade Financial 3.6 4.0 Vanguard Brokerage Services 4.0 3.5 USAA Brokerage Services 3.1 3.2 Thinkorswim 3.8 3.6 Wells Fargo Investments 2.4 2.8 Interactive Brokers 2.7 2.6 Zecco.com 3.1 3.4 a. Select a scatter diagram for these data with the speed of execution as the independent variable. A. Satisfaction 4.5 3.5 2.5 2.5 3 3.5 4 Speed of Execution 4.5 B. 4.5 3.5 Satisfaction 2.5 2.5 3 3.5 4 Speed of Execution 4.5 C. D. 4.5 4.5 4 4 Satisfaction 3.5 Satisfaction 3.5- 3+ 3+ 2.5+ 2.5+ 2.5 3.5 4.5 2.5 3.5 4.5 Speed of | Execution Speed of | Execution - Select your answer - v- Select your answer - v b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? The scatter diagram indicates a linear relationship between a: = speed of execution rating and y = overall satisfaction rating for electronic trades. c. Develop the least squares estimated regression equation. Enter negative value as negative number. Satisfaction = + Speed (to 4 decimals) d. Provide an interpretation for the slope of the estimated regression equation. The slope of the estimated regression line is approximately (to 4 decimals). So, a one unit in the speed of execution rating will increase the overall satisfaction rating by approximately points (to 1 decimal). e. Suppose Wells Fargo Investments developed new software to increase their speed of execution rating. If the new software is able to increase their speed of execution rating from the current value of 2.4 to the average speed of execution rating for the other 10 brokerage firms that were surveyed, what value would you predict for the overall satisfaction rating? (to 3 decimals) A 7,...\" 17.... J Select your answer I r diagram developed in part (a) indicate about the relationship between the two variables? icates a - Select your answer - v linear relationship between a: = speed of execution rating and y = overall satisfaction rating for c. Develop the least squares estimated regression equation. Enter negative value as negative number. Satisfaction = + Speed (to 4 decimals) d. Provide an interpretation for the slope of the estimated regression equation. The slope of the estimated regression line is approximately (to 4 decimals). So, a one unit in the speed of execution rating will increase the overall satisfaction rating by approximately points (to 1 decimal). e. Suppose Wells Fargo Investments developed new software to increase their speed of execution rating. If the new software is able to increase their speed of execution rating from the current value of 2.4 to the average speed of execution rating for the other 10 brokerage firms that were surveyed, what value would you predict for the overall satisfaction rating? (to 3 decimals) A 1,"... 1).... - Select your answer - v b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? The scatter diagram indicates . ./ - Select your answer - I linear relationship between a: = speed of execution rating and y = overall satisfaction rating for electronic trades. negative positive c. Develop the least squares e ion. Enter negative value as negative number. Satisfaction = + Speed (to 4 decimals) d. Provide an interpretation for the slope of the estimated regression equation. The slope of the estimated regression line is approximately (to 4 decimals). So, a one unit in the speed of execution rating will increase the overall satisfaction rating by approximately points (to 1 decimal). e. Suppose Wells Fargo Investments developed new software to increase their speed of execution rating. If the new software is able to increase their speed of execution rating from the current value of 2.4 to the average speed of execution rating for the other 10 brokerage firms that were surveyed, what value would you predict for the overall satisfaction rating? (to 3 decimals) A 7,"... 17.... - Select your answer - v b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? The scatter diagram indicates a linear relationship between a: = speed of execution rating and y = overall satisfaction rating for electronic trades. c. Develop the least squares estimated regression equation. Enter negative value as negative number. Satisfaction = + Speed (to 4 decimals) d. Provide an interpretation for the slope of the estimated regression equation. The slope of the estimated regression line is approximately (to 4 decimals). So, a one uni \\/ Select your answer I in the speed of execution rating will increase the overall satisfaction rating by approximately points (to 1 decimal). increase decrease e. Suppose Wells Fargo Investments developed new software to increase their speed of execution rating. .le to increase their speed of execution rating from the current value of 2.4 to the average speed of execution rating for the other 10 brokerage firms that were surveyed, what value would you predict for the overall satisfaction rating? (to 3 decimals) A 7,"... 17