Question

In: Statistics and Probability

The following data gives the monthly sales (in thousands of dollars) for different advertising expenditures (also...

The following data gives the monthly sales (in thousands of dollars) for different advertising expenditures (also in thousands of dollars) and sales commission percentages.

Sales 245 138 352 322 228 275 560 366

Advertising 16.5 18.0 22.3 18.4 19.0 19.5 30.0 18.6

Commission 10.5 2.0 4.0 3.5 4.5 1.8 9.0 8.5

What amount of sales would this model predict for advertising expenditures of 25,000 and sales commission of 8%? [Show your code in “R Code” section. Show the answer in “Answer” section. Leave “Comments” section blank.]
Find the correlation coefficients for advertising expenditure and commission compared to sales. Explain the results of these findings. [Show your code in “R Code” section. Show the answer in “Answer” section. Leave “Comments” section blank.]
At the 5% level of significance, are advertising expenditure or sales commission percentage significant? Why? [Show your code in “R Code” section. Show the answer in “Answer” section. Include the mathematical notations of two sets of null and alternate hypotheses and the phrase “advertising expenditure” or “sales commission percentage” or “both” along with a justification in a few sentences in “Comments” section.]

Expert Solution

Answer 1.

Predicted Sales = 447.9571

Answer 2.

Correlation between Advertising Expenditure and Sales is 0.851564 :- There exist very strong positive correlation between Advertising Expenditure and Monthly Sales. That is, as Advertising Expenditure increases the sales will also increase and the statistical probability that the relationship between the two occurred by chance is very low

Correlation between Commisiion and Sales is 0.4902884 :- There exist low positive correlation between Commission and Monthly Sales. That is, as Commission increases the sales will also increase but the statistical probability that the relationship between the two occurred by chance is high.

Answer 3.

Significance of Advertising Expenses

Null Hypothesis, Ho: The Advertising Expense coefficient is not significant i.e

Alternative Hypothesis, Ha: The Advertising Expense coefficient is significant i.e

In the t-test performed (given in R Code), t -value is 3.973 and p-value is 0.0106.

Decision: SInce p-value = 0.0106 < so we reject Ho at 5% level of significance and conclude that Advertising Expense is significant

Significance of Commission

Null Hypothesis, Ho: The Commission coefficient is not significant i.e

Alternative Hypothesis, Ha: The Commission coefficient is significant i.e

In the t-test performed (given in R Code), t -value is 1.587 and p-value is 0.1734.

Decision: SInce p-value = 0.1734 > so we fai to reject Ho at 5% level of significance and conclude that Advertising Expense is not significant

R-code:

orchestra answered 2 years ago

Data on advertising expenditures and revenue (in thousands of dollars) for the Four Seasons Restaurant follow....

Data on advertising expenditures and revenue (in thousands of dollars) for the Four Seasons Restaurant follow. Advertising Expenditures Revenue 1 20 2 33 4 44 6 40 10 52 14 53 20 54 a. Let X equal advertising expenditures and Y equal revenue. Complete the estimated regression equation below (to 2 decimals). y =( )+( )x b. Compute the following (to 1 decimal). SSE ( ) SST ( ) SSR ( )MSR ( ) MSE ( ) c. Test whether...

the following are the monthly sales (in thousands of dollars) for a company in four regions...

the following are the monthly sales (in thousands of dollars) for a company in four regions of the country. North East South West 34 28 18 24 47 36 30 38 44 40 30 41 29 21 30 24 37 23 Does the data suggest that there is a difference in the mean monthly sales among the different regions?

The data shown below contains the monthly sales (in thousands of dollars) at a local department...

The data shown below contains the monthly sales (in thousands of dollars) at a local department store for each of the past 24 months. Copy the data to Excel, perform a runs test, and compute a few autocorrelations to determine whether this time series is random. Give your conclusion by referring to the results of your runs test and autocorrelations (no need to try to attach the Excel output in this text box, just mention the specific values you refer...

The chart below lists the sales in thousands of dollars based on the advertising budget for...

The chart below lists the sales in thousands of dollars based on the advertising budget for that quarter. The regression equation is Y' = 4.073 + 0.8351X. What is the correlation coefficient? Advertising ($hunderds) Sales ($thousands) 0 5 3 5.5 4 7 5 7.8 6 9 7 11 Multiple Choice 0.775 0.844 0.926 1.00

Advertising expenditures and sales for the last 5 quarters have been as follows: Quarter Advertising expenditures...

Advertising expenditures and sales for the last 5 quarters have been as follows: Quarter Advertising expenditures Sales 1 1 4 2 1 5 3 2 6 4 2 7 5 4 8 In quarter 3, a new product was introduced that would influence sales in quarter 3. 4 and 5. The following model is established: y=β1x1+β2x2+ ε where y=sales, x1=advertising expenditures, x2 is a variable that is 1 when the new product is available and 0 otherwise, and ε is...

A regression analysis of 32 months’ data relating a company's monthly advertising expenses (x, in thousands...

A regression analysis of 32 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...

The table below shows monthly sales (in thousands) of different kinds of chocolate at a confectionary...

The table below shows monthly sales (in thousands) of different kinds of chocolate at a confectionary store. Assume monthly sales are normally distributed and share the same variance. Month Milk Chocolate White Chocolate Dark Chocolate January 9 7 9 February 8 6 9 March 8 7 10 April 10 9 6 Without using excel or any other technological tool, use ANOVA to test, at the 5% significance level, the hypothesis that all three chocolates sell equally on average.

The data below show sales of daily ice cream in thousands of dollars and the temperature...

The data below show sales of daily ice cream in thousands of dollars and the temperature in Fahrenheit for 21 consecutive days in an ice cream shop. Assuming there is a linear relationship between the two, find the regression coefficients using the formulae for αhat and βhat (not the Excel regression tool). Daily High Sales Per Store Temperature (Thousands of Day (Degrees F) Dollars) 1 63 1.52 2 70 1.68 3 73 1.80 4 75 2.05 5 80 ...

The following data give the annual incomes (in thousands of dollars) and amounts (in thousands of dollars) of life insurance policies for eight persons.

The following data give the annual incomes (in thousands of dollars) and amounts (in thousands of dollars) of life insurance policies for eight persons.(a) At the 98% confidence level, test whether annual income and the amount of life insurance policies are independent.(b) Find the attained significance level.(c) State any assumptions you have made in solving the problem.

David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands...

David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Data for 14 households may be found in the file Landscape. Home Value ($1,000) Landscaping Expenditures ($1,000) 242 8.1 321 10.8 198 12.2 340 16.2 300 15.6 400 18.9 800 23.5 200 9.5 521 17.5 547 22.0 437 12.1 464 13.5 635 17.9 356 13.9...