The data below relate to the sales of car parts and the amount spent on marketing...

 

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.

Answer rating: 100% (QA)

Solution 6 R 8737 7 Pred... View the full answer