The data below relate to the sales of car parts and the amount spent on marketing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The data below relate to the sales of car parts and the amount spent on marketing by a company. Sales Amount spent on marketing 329999 27916 311304 26046 392609 31521 369226 27322 300678 25453 Question 3 What is the correlation between sales and amount spent on marketing? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. Question 4 For a regression where sales is the dependent (y) variable and amount spent on marketing is the independent (x) variable, what is the intercept of the best fit line obtained by the Least Squares method? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. For a regression where sales is the dependent (y) variable and amount spent on markatina ie the indenendent (vi varinkie what se the clane at hrer fir line Question 5 Sales Amount spent on marketing 329999 27916 311304 26046 392609 31521 369226 27322 300678 25453 What is the correlation between sales and amount spent on marketing? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. 4 For a regression where sales is the dependent (y) variable and amount spent on marketing is the independent (x) variable, what is the intercept of the best fit line obtained by the Least Squares method? (7.5 marks) If you neced to round your answer, please give at least 2 decimal places. For a regression where sales is the dependent (y) variable and amount spent on marketing is the independent (x) variable, what is the slope of the best fit line obtained by the Least Squares method? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. 6 What is the R2 value for the regression in questions 4 and 5? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. From the regression in questions 4 and 5, what is a prediction for sales when 27652 is spent on marketing? (15 marks) If you need to round your answer, please do so to at least the nearest whole number. What is the standard error given by Excel from the regression in questions 4 and 5? (7. 8 If you need to round your answer, please do so to at least the nearest whole number. 9 What is the lower limit for an approximate 95% confidence interval for the prediction in question 7 where the approximation of 2 x standard error is used? (2.5 marks) If you need to round your answer, please do so to at least the nearest whole number. 10 What is the upper limit for an approximate 95% confidence interval for the prediction in question 7 where the approximation of 2 x standard error is used? (2.5 marks) If you need to round your answer, please do so to at least the nearest whole number. The data below relate to the sales of car parts and the amount spent on marketing by a company. Sales Amount spent on marketing 329999 27916 311304 26046 392609 31521 369226 27322 300678 25453 Question 3 What is the correlation between sales and amount spent on marketing? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. Question 4 For a regression where sales is the dependent (y) variable and amount spent on marketing is the independent (x) variable, what is the intercept of the best fit line obtained by the Least Squares method? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. For a regression where sales is the dependent (y) variable and amount spent on markatina ie the indenendent (vi varinkie what se the clane at hrer fir line Question 5 Sales Amount spent on marketing 329999 27916 311304 26046 392609 31521 369226 27322 300678 25453 What is the correlation between sales and amount spent on marketing? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. 4 For a regression where sales is the dependent (y) variable and amount spent on marketing is the independent (x) variable, what is the intercept of the best fit line obtained by the Least Squares method? (7.5 marks) If you neced to round your answer, please give at least 2 decimal places. For a regression where sales is the dependent (y) variable and amount spent on marketing is the independent (x) variable, what is the slope of the best fit line obtained by the Least Squares method? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. 6 What is the R2 value for the regression in questions 4 and 5? (7.5 marks) If you need to round your answer, please give at least 2 decimal places. From the regression in questions 4 and 5, what is a prediction for sales when 27652 is spent on marketing? (15 marks) If you need to round your answer, please do so to at least the nearest whole number. What is the standard error given by Excel from the regression in questions 4 and 5? (7. 8 If you need to round your answer, please do so to at least the nearest whole number. 9 What is the lower limit for an approximate 95% confidence interval for the prediction in question 7 where the approximation of 2 x standard error is used? (2.5 marks) If you need to round your answer, please do so to at least the nearest whole number. 10 What is the upper limit for an approximate 95% confidence interval for the prediction in question 7 where the approximation of 2 x standard error is used? (2.5 marks) If you need to round your answer, please do so to at least the nearest whole number.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
What is the correlation between cooling rate and final properties of a casting?
-
What is the correlation between unemployment and inflation? In your opinion, do you believe that this correlation is true of the current economy? How can you support your position?
-
What is the correlation between unemployment and inflation? In your opinion, do you believe that this correlation is true of the current economy? How can you support your position?
-
The marketing department for an upscale retail catalog company wants to determine if there are differences in the mean customer purchase amounts across the available purchase sources (Internet,...
-
The balance sheet data of Brown Company at the end of 2014 and 2013 follow. Land was acquired for $30,000 in exchange for common stock, par $30,000, during the year; all equipment purchased was for...
-
Match the following statements about process costing with its associated accounting concept: a. Cost measurement b. Cost recognition c. Matching concept 1. Because the processing of a continuous flow...
-
Pension fund data are found in the annual report section entitled "Notes to Consolidated Financial Statements." For example, the 1991 IBM Annual Report indicated a present value of pension benefits...
-
AOZT Volzhskije Motory of St. Petersburg, Russia, makes marine motors for vessels ranging in size from harbor tugs to open-water icebreakers. (The Russian currency is the ruble, which is denoted by...
-
Graph the function. Determine the symmetry, if any, of the function. 6) V= - 1 N 5 - 4+ 3+ 2+ 1+ -5 -4 -3 -2 -1 1 2 3 4 5 x -1+ -2+ -3+ -4 -5
-
The Wallace Stationary Company purchases paper from the Seaboard Paper Company. Wallace produces stationary that require 1,415,000 sq. yards of stationary per year. The cost per order for the company...
-
Hi, Please see question and answer format below: The bank portion of the bank reconciliation for Sheridan Company at October 31, 2017, is as follows. The adjusted cash balance per bank agreed with...
-
A chain of gasoline dispensers recorded sales in 2003 of 15,659 gallons; and in 2011 they had a sale of 11,669. What is the projected sale of gasoline for the year 2017? (Note: Round your answer to...
-
2. (30 marks) You are asked to use the k-means algorithm to cluster the following 8 examples into 3 clusters: P1=(2,10), P2=(2,6), P3=(8,4), P4=(5,8), P5=(7,4), P6=(6,4), P7=(1,2), P8=(4,9). (a)...
-
discuss the concept of ecological niche and niche differentiation, including how environmental gradients, resource availability, and species interactions determine species' ecological requirements...
-
Consider the following graph. g(x) + abc (a) Identify the input value(s) where the slope of the function is zero. X
-
(a) What is the value of the synergic gains from the merger? Your answer should be in millions and accurate to two decimal places (e.g., 10,500,000 should be entered as 10.50). Price #...
-
Rawlss view of the principles of justice is called justice as difference. equality. fairness. liberty
-
Show that the block upper triangular matrix A in Example 5 is invertible if and only if both A 11 and A 22 are invertible. Data from in Example 5 EXAMPLE 5 A matrix of the form A = [ A11 A12 0 A22 is...
-
Refer to the CVS annual report in the Supplement to Chapter 1 and to the following data (in millions) for Walgreens: net sales, $37,508.2 and $32,505.4 for 2004 and 2003, respectively; accounts...
-
Anderson Interiors, a successful retail furniture company, is located in an affluent suburb where a major insurance company has just announced a restructuring that will lay off 4,000 employees....
-
Refer to CVS Corporations annual report in the Supplement to Chapter 1 to answer the following questions: 1. What amount of cash and cash equivalents did CVS Corporation have in 2004? Do you suppose...
Study smarter with the SolutionInn App