Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me solve and not just answer. I know the Excel functions, but I don't understand it. (a) Develop an estimated linear regression equation

image text in transcribed

image text in transcribed

image text in transcribed

Please help me solve and not just answer. I know the Excel functions, but I don't understand it.

(a) Develop an estimated linear regression equation using trade price and speed of execution to predict overall satisfaction with the broker. Let x1 represent satisfaction with Trade Price. Let x2 represent satisfaction with speed of execution. If required, round your answer to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300 ) y^= What is the coefficient of determination? If required, round your answer to four decimal places. Interpret the coefficient of determination. If required, round your answer to one decimal places. The regression model explains approximately % of the variation in the values of overall satisfaction in the sample. (b) Use the t test to determine the significance of each independent variable. What are your conclusions at the 0.05 level of significance? We conclude that 1=0. That is, there a relationship between satisfaction with trade price and overall satisfaction with the electronic trade. We conclude that 2=0. That is, there a relationship between satisfaction with speed of execution and overall satisfaction with the electronic made. c) Interpret the estimated parameters. Are the relationships indicated by these estimates what you would expect? execution. execution. trade price. trade price. Investments if they can achleve these performance levels. If required, round your answer to one decimal place. Do not round intermediate calculations. The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences with electronic trades handled by discount brokers. As part of the survey, members were asked to rate their satisfaction with the trade price and the speed of execution, as well as provide an overall satisfaction rating. 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 computing a weighted average of the scores provided by each respondent. A portion of the survey results follow (AAII website). (a) Develop an estimated linear regression equation using trade price and speed of execution to predict overall satisfaction with the broker. Let x1 represent satisfaction with Trade Price. Let x2 represent satisfaction with speed of execution. If required, round your answer to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300 ) y^= What is the coefficient of determination? If required, round your answer to four decimal places. Interpret the coefficient of determination. If required, round your answer to one decimal places. The regression model explains approximately % of the variation in the values of overall satisfaction in the sample. (b) Use the t test to determine the significance of each independent variable. What are your conclusions at the 0.05 level of significance? We conclude that 1=0. That is, there a relationship between satisfaction with trade price and overall satisfaction with the electronic trade. We conclude that 2=0. That is, there a relationship between satisfaction with speed of execution and overall satisfaction with the electronic made. c) Interpret the estimated parameters. Are the relationships indicated by these estimates what you would expect? execution. execution. trade price. trade price. Investments if they can achleve these performance levels. If required, round your answer to one decimal place. Do not round intermediate calculations. The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences with electronic trades handled by discount brokers. As part of the survey, members were asked to rate their satisfaction with the trade price and the speed of execution, as well as provide an overall satisfaction rating. 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 computing a weighted average of the scores provided by each respondent. A portion of the survey results follow (AAII website)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Grade Energy Audit Making Smart Energy Choices

Authors: Shirley J. Hansen, James W. Brown

1st Edition

0824709284, 978-0824709280

More Books

Students also viewed these Accounting questions

Question

14. State the all-or-none law.

Answered: 1 week ago