Question

A manager wishes to determine the relationship between the number of miles (in hundreds of miles)...

A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the manager's sales representatives travel per month and the amount of sales (in thousands of dollars) per month. Find the standard error of estimate, se, given that y=3.53x + 37.92

Miles traveled, x= 2, 3, 10, 7, 8, 15, 3, 1, 11
Sales, y= 31, 33, 78, 62, 65, 61, 48, 55, 120

Group of answer choices

5.122

10.569

22.062

15.951

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

y=3.53x + 37.92

From given Data, Using Regression analysis using Excel ,

Standard error = 22.062

Answer:

22.062

SUMMARY OUTPUT Miles Traveled x Sales y 2 31 3 33 10 78 7 62 Regression Statistics Multiple R 0.632079 R Square 0.399524 Adju

Add a comment
Know the answer?
Add Answer to:
A manager wishes to determine the relationship between the number of miles (in hundreds of miles)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A manager wishes to determine the relationship between the number of miles (in hundreds of miles)...

    A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the manager's sales representatives travel per month and the amount of sales (in thousands of dollars) per month. Find the test statistic. Miles traveled, x= 2, 3, 10, 7, 8, 15, 3, 1, 11 Sales, y= 31, 33, 78, 62, 65, 61, 48, 55, 120 Group of answer choices 1.89 22.062 2.16 .632

  • A manager wishes to determine the relationship between the number of miles (in hundreds of miles)...

    A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the sales representative travels per month and the amount of sales (in thousands of dollars) per month. The Z-scores for both variables are shown below. Miles: -0.98 -0.77 0.70 0.07 0.28 1.75 -0.77 -1.19 0.91 Sales: -1.14 -1.07 0.62 0.02 0.13 -0.02 -0.50 -0.24 2.20 What is the correlation coefficient? 0.632 0.561 0.717 0.791

  • A manager wishes to determine whether there is a relationship between the number of years her...

    A manager wishes to determine whether there is a relationship between the number of years her sales representatives have been with the company and their average monthly sales. The table shows the years of service for each of her sales representatives and their average monthly sales (in thousands of dollars). Compute the linear correlation coefficient between the two variables and determine whether a linear relation exists. A manager wishes to determine whether there is a relationship between the number of...

  • Part A A marketing manager wishes to determine whether a relationship exists between the number of...

    Part A A marketing manager wishes to determine whether a relationship exists between the number of cereal boxes (Y) sold at the company's retail store and the number of clerks on duty (X) per day. The sample data below will be used to examine this empirical problem. Calculate the slope of the regression line. X Y 3 4 2 4 2 2 1 2 a. 0 b. 1 c. 2 d. None of the above Part 2 Calculate the Y-intercept...

  • An individual wanted to determine the relation that might exist between speed and miles per gallon...

    An individual wanted to determine the relation that might exist between speed and miles per gallon of an automobile. Let X be the average speed of a car on the highway measured in miles per hour and let Y represent the miles per gallon of the automobile. The following data is collected: X 50 55 55 60 60 62 65 65 Y 28 26 25 22 20 20 17 15 a. In the space below, draw a scatterplot of the...

  • Mr. James McWhinney, president of Daniel James Financial Services, believes there is a relationship between the...

    Mr. James McWhinney, president of Daniel James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indicates the number of client contacts last month and the Y column shows the value of sales ($ thousands) last month for each client sampled. Number of Contacts, x 14 12 20 16 46 Sales ($ thousands) 24 14 28...

  • a. Use t and F to test for a significant relationship between HRS1 and age. Use...

    a. Use t and F to test for a significant relationship between HRS1 and age. Use α = 0.05 and make sure you know what hypotheses you are using to conduct the significance tests.[3.5 points] b. Calculate and interpret the coefficient of determination R2. Based on this R2, did the estimated regression equation provide a good fit? Briefly justify your answer. Hint: If you used Excel Regression Tool to answer part c, R2was reported with your output.  [2.5 points] Use the...

  • Mr. James McWhinney, president of Daniel James Financial Services, believes there is a relationship between the...

    Mr. James McWhinney, president of Daniel James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample Information. The X column indicates the number of client contacts last month, and the Y column shows the value of sales ($ thousands) last month for each client sampled Number of Sales Number of Sales Contacts, (5 thousands), Contacts, (5 thousands) х 22 76...

  • Problem 4: Variables that may affect Grades The data set contains a random sample of STAT 250 Final Exam Scores out of 80 points. For each individual sampled, the time (in hours per week) that the stu...

    Problem 4: Variables that may affect Grades The data set contains a random sample of STAT 250 Final Exam Scores out of 80 points. For each individual sampled, the time (in hours per week) that the student spent participating in a GMU club or sport and working for pay outside of GMU was recorded. Values of 0 indicate the students either does not participate in a club or sport or does not work a job for pay. The goal of...

  • a. Using the Excel’s Regression Tool, develop the estimated regression equation to show how income (y...

    a. Using the Excel’s Regression Tool, develop the estimated regression equation to show how income (y annual income in $1000s) is related to the independent variables education(level of education attained in number of years), age ( Develop the dummy variable for the gender variable first. [ 6 points] Use the t test to test whether each of the coefficients obtained in part (a) are significant at .05 level of significance. What are your conclusions? [3 points] Use the F test...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT