
A local car dealership has kept data on its monthly spending on advertising and its sales...
The sample correlation coefficient for the relationship between sales increase and dollars spent on advertising is r = 0.954. WHAT PERCENTAGE OF THE VARIABILITY IN SALES INCREASE CAN BE EXPLAINED BY THE REGRESSION LINE, USING ADVERTISING DOLLARS AS THE PREDICTING VARIABLE? Show work here.
The following estimated regression equation relating sales to inventory investment and advertising expenditures was given. ý = 24 + 14x + 7x2 The data used to develop the model came from a survey of 10 stores; for those data, SST = 18,000 and SSR = 12,780. (a) For the estimated regression equation given, compute RS R2 = (b) Compute R, (Round your answer to two decimal places.) (c) Does the model appear to explain a large amount of variability in...
Last month you assumed the position of manager for a large car dealership. The distinguishing feature of this dealership is its “no hassle” pricing strategy; prices (usually well below the sticker price) are posted on the windows, and your sales staff has a reputation for not negotiating with customers. Last year, your company spent $12 million on advertisements to inform customers about its “no hassle” policy, and had overall sales revenue of $45 million. A recent study from an agency...
13 A company believes that the monthly sales of one of its products are related to the amount spent on advertising during the previous month. It records monthly sales and advertising spend in the preceding month and obtains the data given below. Sales (£m) Advert. prev. month (£000s) 50 51 60 65 45 49 55 1.00 1.02 1.30 1.45 1.20 1.08 1.25 (a) Determine the regression equation for sales upon advertising (b) What value do you predict for next month's...
Last month you assumed the position of manager for a large car dealership. The distinguishing feature of this dealership is its “no hassle” pricing strategy; prices (usually well below sticker) are posted on the windows, and your sales staff has a reputation for not negotiating with customers. Last year, the company spent $2 million on advertisements to inform customers about its “no hassle” policy and had revenues of $40 million. A recent study from an ad agency indicates that for...
1. Calculate the composite dealership profit if 2,900 units are
sold.
3. The regression equation that Jack Snyder developed to project
annual sales of a dealership has an R-squared of 60% and a
standard error of the estimate of $6,300,000. If the projected
annual sales for a dealership total $39,900,000, determine the
approximate 95% confidence interval for Jack’s prediction of sales.
(Hint: The 95% confidence interval uses 2 standard
deviations.).
Range of sales _____ to ______
United States Motors Inc....
Online Store Monthly E-commerce Sales (in 1000 s) Online Advertising Dollars (1000 s) 1330 670 ||950 4.5 Il0.5 1560 |2.0 380 ||1.5 Note: this was a real data, but I changed some of the numbers to make your MANUAL computations easier. 1. Identify the most appropriate/logical Dependent and Independent variables for this study. 2. Is the linear relationship between the Dependent and Independent variables significant at a=0.05? Use both the global and individual tests to answer the questions. Show all...
BBA 403 TEST 3: Name: Score:_ SOLVE AND THOROUGHLY INTERPRET YOUR ANSWER 1. A marketing manager conducted a study to determine whether there is a linear relationship between many spent on advertising and company sales. The data are shown on the table below. Display the data in a scatter plot, calculate the correlation coefficient, state a conclusion, and interpret the result Adverstising Company Expense, (1000s of s) (1000s of ) 2.4 16 2.0 26 14 1.6 2.0 2.2 184 220...
Number 2 A regression analysis of 62 months’ data relating a company's monthly advertising expenses (x, in thousands of dollars) to its sales (y, in thousands of dollars) yields the following output: • ?0=100 • ?1=5.3 • Standard error of the estimate ?=??=56 • Standard error for ?1, ???1=0.3 Furthermore, when ?∗=9, the standard error for a confidence interval for the estimated mean response is given by ???̂=29, while the standard error for a prediction interval is ???̂=63.1. (a) (3...
Question # 3. The following data set records the cost of advertising (in thousands of dollars) and the number of prescriptions written for a new drug (in thousands). Cost (x) 9 2 3 4 2 6 9 10 Number of prescriptions (y) 85 61 64 67 60 75 83 87 Using the above data: (Please use Minitab for parts a, b, d) a) A bivariate (scatter) plot for the data set. (5 points) b) Find the correlation (r) and its...