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
Solution:
y=3.53x + 37.92
From given Data, Using Regression analysis using Excel ,
Standard error = 22.062
Answer:
22.062
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) 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 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 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 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 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 α = 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 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 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 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...