Question

In: Statistics and Probability

Situation: Fidelity Investment has collected data polling online investors on their experiences. As a part of...

Situation:

Fidelity Investment has collected data polling online investors on their experiences. As a part of the survey, the investors were asked to rate the quality of the speed of execution with their brokers and an overall satisfaction rating for online trades. Possible responses were Unsatisfied (score = 1), Somewhat satisfied (score = 2), Satisfied (score = 3), and Very satisfied (score = 4). An average score for each broker was computed and average execution speed in seconds for each investor was recorded as shown in the following table.

Broker

Speed

Satisfaction

1 3.4 3.5
2 3.3 3.4
3 3.4 3.9
4 3.6 3.7
5 3.2 2.9
6 3.8 2.8
7 3.8 3.6
8 2.6 2.6
9 2.7 2.3
10 4.0 4.0
11 2.5 2.5

Action

Perform a correlation and regression analysis to predict satisfaction score using execution speed. Discuss the following:

  1. Scatter Diagram
  2. R, R2 and 1-R2
  3. Show the regression equation. Comment on the interpretation of the slope of regression equation.
  4. What is the standard error of estimate value? What is the interpretation of this value?
  5. Conduct the appropriate test of hypothesis for the regression model. Use a .05 level of significance. Does trade execution speed appear to be good predictor of the satisfaction rating? Why or why not?

Solutions

Expert Solution

a. Scatter plot

Put the data in excel, select the data and go to insert -> scatterplot as shown in the diagram.


b. Regression equation

Step to run regression in excel.

step 1 : Put the data in excel as shown.


Step 2 : Go to data -> Data Analysis -> Regression


Step 3 : Input the values as shown


Step 4 : Output will be generated as given below.

From the regression output highlighted in blue we get the regression equation give below

y = 0.2046 + 0.9077 Speed(x)


R2 = 0.5983
R = sqrt(0.5983) = 0.7735


Show the regression equation. Comment on the interpretation of the slope of regression equation.
y = 0.2046 + 0.9077 Speed(x)

One unit increase in the speed increase the satisfaction by 0.9077 units.

What is the standard error of estimate value? What is the interpretation of this value?
0.399700743

On an average the actual values are 0.3997 units away from the regression line.

Conduct the appropriate test of hypothesis for the regression model. Use a .05 level of significance. Does trade execution speed appear to be good predictor of the satisfaction rating? Why or why not?

For the beta coefficient, we test the following hypothesis.

Next we check the pvalue for the variable in the regression output and check if the pvalue is less than 0.05, if it is less than 0.05 then we reject the null hypothesis and conclude that the variable is significant.

In this case we find the pvalue is 0.005221191
which is less than 0.05, hence we reject the null hypothesis and conclude that the variable speed is a significant predictor of y.


Related Solutions

A polling organization collected data on a sample of 60 registered voters regarding a tax on...
A polling organization collected data on a sample of 60 registered voters regarding a tax on the market value of equity transactions as one remedy for the budget deficit. Opinion about Market Tax Education High School College Grad. MBA Favorable 15 5 0 Undecided 10 8 2 Unfavorable 0 2 18 a. Compute gamma for the table. b. Compute tau b or tau c for the same data. c. What accounts for the differences? d. Decide which is more suitable...
The data on a loan has been collected in the Microsoft Excel Online file below. Open...
The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Amortization schedule Loan amount to be repaid (PV) $39,000.00 Interest rate (r) 11.00% Length of loan (in years) 3 a. Setting up amortization table Formula Calculation of loan payment #N/A Year Beginning Balance Payment Interest 1 2 3 b. Calculating % of Payment Representing Interest and Principal for Each Year Year Payment...
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the...
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Complete an amortization schedule for a $18,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance...
The data on a loan has been collected in the Microsoft Excel Online file below. Open...
The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. a. Complete an amortization schedule for a $22,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $   $  ...
Data was collected to study the background of the people who participate in online gambling. Data...
Data was collected to study the background of the people who participate in online gambling. Data was collected to study the background of the people who participate in online gambling. Data was collected to study the background of the people who participate in online gambling. Data was collected to study the background of the people who participate in online gambling. Data was collected to study the background of the people who participate in online gambling. Data was collected to study...
Data was collected to study the background of the people who participate in online gambling. 64...
Data was collected to study the background of the people who participate in online gambling. 64 people were selected at random and asked about their annual salary and whether they went to college. After the survey, sample mean and sample standard deviation were calculated. They were $90K and $30K respectively. A. Calculate 95% confidence limits for the population mean annual salary. B. What is the interpretation of the limits in part A? C. If you calculate 99% confidence limits for...
The results below are based on data collected as part of a student project for an...
The results below are based on data collected as part of a student project for an introductory statistics class at UF. If there is more than one group/treatment, the first group mentioned is group 1. Data was collected to determine if the price of food items at Graham Oasis (a convenience store inside UF campus) is higher, on average, than at a Publix Supermarket located 2 miles away. The p-value was 0.000, and the confidence interval was ( 0.85, 1.62)....
Chase Bank account division has collected data on the age of credit accounts. The data collected...
Chase Bank account division has collected data on the age of credit accounts. The data collected indicate that the age of the accounts follows a normal distribution with mean 18 years and standard deviation 6 years. a. What proportion of the accounts are between 20 and 32 years old? b. What is the number of years in which 75% of all accounts are above?
As part of a study on transportation safety, the U.S. Department of Transportation collected data on...
As part of a study on transportation safety, the U.S. Department of Transportation collected data on the number of fatal accidents per 1000 licenses and the percentage of licensed drivers under the age of 21 in a sample of 42 cities. Data collected over a one-year period follow. These data are contained in the file named “Safety.csv”. 1- Find the sample mean and standard deviation for each variable. Round your answers to the nearest thousandth. 2- Use the function lm()...
As part of a study on transportation safety, the U.S. Department of Transportation collected data on...
As part of a study on transportation safety, the U.S. Department of Transportation collected data on the number of fatal accidents per 1000 licenses and the percentage of licensed drivers under the age of 21 in a sample of 42 cities. Data collected over a one-year period follow. These data are contained in the file named “Safety.csv”. 1- Find the sample mean and standard deviation for each variable. Round your answers to the nearest thousandth. 2- Use the function lm()...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT