Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14.5, Problem 28E
Broker Satisfaction Conclusion. In exercise 8, ratings data on x = the quality of the speed of execution and y = overall satisfaction with electronic trades provided the estimated regression equation
8. Broker Satisfaction. 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 (l), 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).
- a. Develop a
scatter diagram for these data with the speed of execution as the independent variable. - b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
- c. Develop the least squares estimated regression equation.
- d. Provide an interpretation for the slope of the estimated regression equation.
- e. Suppose Zecco.com 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.5 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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
c. At 5% significance level, is there evidence of a linear relationship between shelf space and sales? (use t-test for correlation coefficient)
d. Determine the least square regression equation for this data.
In analyzing the effects of an after-school reading program, you run a regression analysis with program participation as the independent variable (0 = control group; 1 = intervention group) and scores on a reading comprehension exam after the program as the dependent variable.
1. Is the effect of the after-school reading program statistically significant? How can you tell, and what does this mean?
2. What is the slope (or regression coefficient) and what does it tell you exactly? Specifically, interpret it in the context of the evaluation and the program described above.
Multiple regression is sometimes used in litigation. In the case of Cargill, Inc. v. Hardin (1971), the prosecution charged that the cash price of wheat was manipulated in violation of the Commodity Exchange Act. In a statistical study conducted for this case, a multiple regression model was constructed to predict the cash price of wheat using three supply-and-demand explanatory variables: economic growth, population growth, and meat consumption. Data for 24 years were used to construct the regression equation, and a prediction for the suspect period was computed from this equation.
Which of the independent variables is the most significant predictor of the cash price of wheat?
a. Intercept
b. Economic Growth
c. Population Growth
d. Meat Consumption
Chapter 14 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations collected in a...Ch. 14.2 - Retail and Trade: Female Managers. The following...Ch. 14.2 - Production Line Speed and Quality Control. Brawdy...Ch. 14.2 - The National Football League (NFL) records a...Ch. 14.2 - Sales Experience and Performance. A sales manager...Ch. 14.2 - Broker Satisfaction. The American Association of...Ch. 14.2 - Companies in the U.S. car rental market vary...Ch. 14.2 - Age and the Price of Wine. For a particular red...
Ch. 14.2 - Laptop Ratings. To help consumers in purchasing a...Ch. 14.2 - Stock Beta. In June of 2016, Yahoo Finance...Ch. 14.2 - Distance and Absenteeism. A large city hospital...Ch. 14.2 - Using a global-positioning-system (GPS)-based...Ch. 14.3 - 15. The data from exercise 1...Ch. 14.3 - The data from exercise 2 follow.
The estimated...Ch. 14.3 - Prob. 17ECh. 14.3 - Price and Quality of Headphones. The following...Ch. 14.3 - Sales Experience and Sales Performance. In...Ch. 14.3 - Price and Weight of Bicycles. Bicycling, the...Ch. 14.3 - Cost Estimation. An important application of...Ch. 14.3 - 22. Refer to exercise 9, where the following data...Ch. 14.5 - The data from exercise 1 follow.
Compute the mean...Ch. 14.5 - The data from exercise 2 follow.
Compute the mean...Ch. 14.5 - The data from exercise 3 follow.
What is the...Ch. 14.5 - Prob. 26ECh. 14.5 - To identify high-paying jobs for people who do not...Ch. 14.5 - Broker Satisfaction Conclusion. In exercise 8,...Ch. 14.5 - Cost Estimation Conclusion. Refer to exercise 21,...Ch. 14.5 - Significance of Fleet Size on Rental Car Revenue....Ch. 14.5 - Significance of Racing Bike Weight on Price. In...Ch. 14.6 - 32. The data from exercise 1...Ch. 14.6 - 33. The data from exercise 2...Ch. 14.6 - Prob. 34ECh. 14.6 - 35. The following data are the monthly salaries y...Ch. 14.6 - 36. In exercise 7, the data on y = annual sales ($...Ch. 14.6 - In exercise 5, the following data on x = the...Ch. 14.6 - Prob. 38ECh. 14.6 - 39. In exercise 12, the following data on x =...Ch. 14.7 - The commercial division of a real estate firm...Ch. 14.7 - Following is a portion of the regression output...Ch. 14.7 - Prob. 43ECh. 14.7 - Auto Racing Helmet. Automobile racing,...Ch. 14.8 - Prob. 45ECh. 14.8 - Prob. 46ECh. 14.8 - Prob. 47ECh. 14.8 - Prob. 48ECh. 14.8 - Prob. 49ECh. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Prob. 51ECh. 14.9 - Predicting Charity Expenses. Charity Navigator is...Ch. 14.9 - Many countries, especially those in Europe, have...Ch. 14.9 - Valuation of a Major League Baseball Team. The...Ch. 14 - The Dow Jones Industrial Average (DJIA) and the...Ch. 14 - Home Sire and Price. Is the number of square feet...Ch. 14 - Online Education. One of the biggest changes in...Ch. 14 - Machine Maintenance. Jensen Tire & Auto is in the...Ch. 14 - Bus Maintenance. The regional transit authority...Ch. 14 - Studying and Grades. A marketing professor at...Ch. 14 - Used Car Mileage and Price. The Toyota Camry is...Ch. 14 - One measure of the risk or volatility of an...Ch. 14 - As part of a study on transportation safety, the...Ch. 14 - Consumer Reports tested 166 different...Ch. 14 - When trying to decide what car to buy, real value...Ch. 14 - Buckeye Creek Amusement Park is open from the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Life Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forwardMultiple regression is sometimes used in litigation. In the case of Cargill, Inc. v. Hardin (1971), the prosecution charged that the cash price of wheat was manipulated in violation of the Commodity Exchange Act. In a statistical study conducted for this case, a multiple regression model was constructed to predict the cash price of wheat using three supply-and-demand explanatory variables: economic growth, population growth, and meat consumption. Data for 24 years were used to construct the regression equation, and a prediction for the suspect period was computed from this equation Based on a significance level of 5%, which of the following independent variables significantly predict the cash price of wheat? a. Economic Growth b. Population Growth c. Meat Consumption d. All the independent variables significantly predict the cash price of wheat.arrow_forwardMultiple regression is sometimes used in litigation. In the case of Cargill, Inc. v. Hardin (1971), the prosecution charged that the cash price of wheat was manipulated in violation of the Commodity Exchange Act. In a statistical study conducted for this case, a multiple regression model was constructed to predict the cash price of wheat using three supply-and-demand explanatory variables: economic growth, population growth, and meat consumption. Data for 24 years were used to construct the regression equation, and a prediction for the suspect period was computed from this equation. The actual cash price of wheat under investigation in 1963 was $2.13. Based on the comparison of the correct predicted cash price calculated in the previous question and the actual cash price, what does the evidence suggest about Cargill, Inc.? a. Because the predicted price is relatively close to the actual price (within one cent), Cargill, Inc. probably did not artificially manipulate the price of wheat.…arrow_forward
- Multiple regression is sometimes used in litigation. In the case of Cargill, Inc. v. Hardin (1971), the prosecution charged that the cash price of wheat was manipulated in violation of the Commodity Exchange Act. In a statistical study conducted for this case, a multiple regression model was constructed to predict the cash price of wheat using three supply-and-demand explanatory variables: economic growth, population growth, and meat consumption. Data for 24 years were used to construct the regression equation, and a prediction for the suspect period was computed from this equation. The following output represents the regression analysis. . Before the judge and jury consider the results of the regression model, they must ensure that the model is valid. What is the proper hypothesis test for this model, and what is the proper conclusion?arrow_forward18)The regression equation is intended to be the “best fitting” straight line for a set of data. Whatis the criterion for “best fitting”?arrow_forwardOnline clothes II For the online clothing retailer dis-cussed in the previous problem, the scatterplot of Total Yearly Purchases by Income showsThe correlation between Total Yearly Purchases and Incomeis 0.722. Summary statistics for the two variables are: a) What is the linear regression equation for predictingTotal Yearly Purchase from Income? b) Do the assumptions and conditions for regression ap-pear to be met? c) What is the predicted average Total Yearly Purchasefor someone with a yearly Income of $20,000? Forsomeone with an annual Income of $80,000?d) What percent of the variability in Total YearlyPurchases is accounted for by this model?e) Do you think the regression might be a useful one forthe company? Comment.arrow_forward
- On the first day of class, an economics professor administers a test to gauge the math preparedness of her students. She believes that the performance on this math test and the number of hours studied per week on the course are the primary factors that predict a student's score on the final exam. Using data from her class of 60 students, she estimates A portion of the regression results is shown in the following table. a. What is the slope coefficient of Hours? b. What is the sample regression equation? c. What is the predicted final exam score for a student who has a math score of 70 and studies 4 hours per week?arrow_forwardIn exercise 20, data on x = weight (pounds) and y = price ($) for ten road-racing bikes provided the estimated regression equation = 28574 -1439x (Bicycling website, March 8, 2012). For these data SSE = 7,102,922.54 and SST = 52,120,800. Use the F test to determine whether the weight for a bike and the price are related at the .05 level of significance. Click on the datafile logo to reference the data. Calculate the value of the test statistic (to 1 decimal). The p-value is - Select your answer -less than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 2 . Use Table 1 of Appendix B. What is your conclusion?arrow_forwardConsumer Reports tested 19 different brands and models of road, fitness, and comfort bikes. Road bikes are designed for long road trips; fitness bikes are designed for regular workouts or daily commuters; and comfort bikes are designed for leisure rides on typically flat roads. The data file Bikes show the type, weight (lb.), and price ($) for the 20 bicycles tested. In Minitab, Develop an estimated regression equation that can be used to predict Price by using Type and Weight. At the 0.05 level of significance, test for autocorrelation in the data. Bikes: Brand and Model Type Weight Price Klein Rêve v Road 20 1800 Giant OCR Composite 3 Road 22 1800 Giant OCR 1 Road 22 1000 Specialized Roubaix Road 21 1300 Trek Pilot 2.1 Road 21 1320 Cannondale Synapse 4 Road 21 1050 LeMond Poprad Road 22 1350 Raleigh Cadent 1.0 Road 24 650 Giant FCR3 Fitness 23 630 Schwinn Super Sport GS Fitness 23 700 Fuji Absolute 2.0 Fitness 24 700 Jamis Coda Comp Fitness 26 830…arrow_forward
- The Mayor of texas whom is partners with a local agriculturalist wants to know how the amount of fertilizer and the amount of water given to plants affect their growth. The results were inputted into MINITAB so as to fit the model a) Write out the regression equation b) What is the sample size used in this investigation? c) Determine the values of *, ** and ***, **** d) Conduct a hypothesis test, at the 5% level of significance, to determine whether ? is significant. e) What would be the growth of the plant if 4g of fertilizer and 7g of ater was given to it daily? f) Carry out an F -test at the 1% significance level to determine whether the model is significantarrow_forwardDetermine the statistical test that should be conducted before conducting linear regression? a. Normality test b. Variance Homogeneity test c. Correlation d. Data transformationarrow_forwardThe Conde Nast Traveler Gold List for 2012 provided rating for the top 20 small cruise ships. The data from annual Readers’ Choice Survey are the overall scores(Y) each ship received based on several criteria, including Itineraries/Schedule (X1), Shore Excursions(X2), and Food/Dinning(X3). The estimated regression equation to predict the overall scores is Y= 35.6184+0.1105 X1+0.2445 X2+0.2474 X3. Part of the regression results is shown below. Coefficients Standard Error Intercept 35.6184 13.2308 Itineraries/Schedule(X1) 0.1105 0.1297 Shore Excursions(X2) 0.2445 0.0434 Food/Dinning(X3) 0.2474 0.0621 Use the T test to determine whether or not the coefficient of X1 is significant. Use Level of significance=.05? Be sure to state null and alternative hypotheses.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY