1 answer

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

Question:

Questions should be answered using the Answer Sheet Template with your name at the top. All relevant R codes, numeric answers

The following data gives the monthly sales (in thousands of dollars) for different advertising expenditures (also in thousands of dollars) and sales commission percentages. Help me solve this R code, thanks

Questions should be answered using the Answer Sheet Template with your name at the top. All relevant R codes, numeric answers and conclusions should be provided. No screenshots are required. Note, only R should be used to answer the questions, as needed. Answers should be written in the appropriate row of the Answer Sheet (ie., corresponding to the question number). The report should be individually uploaded in BB by the due date. Question A: 3*26 points 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 Advertising Commission 245 138 352 322 228 275 560 366 16.5 18.0 22.3 17.4 19.0 20.0 32.0 18.6 10.5 2.0 4.0 3.5 4.5 1.8 9.0 8.5 1. What amount of sales would this model predict for advertising expenditures of 25,000 and sales commission of 8%? [Write in R Code & Answer of Question 1] At the 5% level of significance, is either advertising expenditure or sales commission percentage or both significant? Why? [Write in R Code, Answer & Conclusion of Question 2] 2.

Answers

1.)

Sales=c(245,138,352,322,228,275,560,366)
Advertising=c(16.5,18,22.3,17.4,19,20,32,18.6)
Commission=c(10.5,2,4,3.5,4.5,1.8,9,8.5)
data=as.data.frame(cbind(Sales,Advertising,Commission))
model1=lm(Sales~Advertising+Commission, data = data)
dat2=data.frame(Advertising=25,Commission=8)
predict(model1,dat2)

Answer: 424.6849

2.)

summary(model1)

Estimate Std. Error t value Pr(>|t|)
(Intercept) -139.633 111.792 -1.249 0.2669
Advertising 19.069 5.456 3.495 0.0174 *
Commission 10.950 8.062 1.358 0.2325

So advertising is significant at 5% level of significance as p-value for it is less than 5%

.

Similar Solved Questions

5 answers
Suppose 8 out of every 20 students are absent from school less than 5 days a year
Suppose 8 out of every 20 students are absent from school less than 5 days a year. Predict how many students would be absent from school less than 5 days a year out of 40,000 students...
1 answer
Surreal Sound, Inc. manufactures and sells portable mini speakers. Budgeted price and cost data for the...
Surreal Sound, Inc. manufactures and sells portable mini speakers. Budgeted price and cost data for the next year are as follows: $30.00 Selling price per unit Variable Expenses per unit: Direct material $8.20 $4.00 $6.00 $1.60 $19.80 Direct labor Manufacturing overhead Selling expenses Total variab...
2 answers
What is 2xy differentiated implicitly?
What is 2xy differentiated implicitly?...
1 answer
2. Show that if p is differentiable and p(t) > 0, then the Wronskian W(t) of...
2. Show that if p is differentiable and p(t) > 0, then the Wronskian W(t) of two solutions of [p(t)y'l' +q(t)y = 0 is W(t) = po where c is a constant....
1 answer
Mo Meek, Lu Ling, and Barb Beck formed the MLB Partnership by making capital contributions of...
Mo Meek, Lu Ling, and Barb Beck formed the MLB Partnership by making capital contributions of $75,600, $294,000, and $470,400, respectively. They predict annual partnership net income of $498,000 and are considering the following alternative plans of sharing income and loss: (a) equally; (b) in the ...
1 answer
3. (4 pts) Mechansim Show the mechanism of the following process. in the following transformations
3. (4 pts) Mechansim Show the mechanism of the following process. in the following transformations...
1 answer
The flux density distribution over the surface of a two-pole stator of radius r and length l is g...
The flux density distribution over the surface of a two-pole stator of radius r and length l is given by (3-37b) Prove that the total flux under each pole face is The flux density distribution over the surface of a two-pole stator of radius r and length l is given by (3-37b) Prove that the total fl...
1 answer
A very long uniform line of charge has charge per unit length 4.80 μC/m and lies...
A very long uniform line of charge has charge per unit length 4.80 μC/m and lies along the x-axis. A second long uniform line of charge has charge per unit length -2.58 μC/m and is parallel to thex-axis at y1 = 0.406 m . A)What is the magnitude of the net electric field at point y2 = 0.190 m o...
1 answer
An experiment was run to determine whether four specific firing temperatures affect the density of a...
An experiment was run to determine whether four specific firing temperatures affect the density of a certain type of brick. A completely randomized experiment lead to the following data. (Please answer using Sas). Temperature Density 100 21.8 21.9 21.7 21.6 21.7 125 21.7 21.4 21.5 21.4 150 21.9 21.8...
1 answer
When biodegradable organics are discharged into a river, aerobic biodegradation of the organics c...
When biodegradable organics are discharged into a river, aerobic biodegradation of the organics consumes dissolved oxygen. Downriver from DO, DOO A DOmin xe Wastewater site (x0) We write a steady-state ma figure terial balance on dissolved oxygen in a slice of the river, as depicted in we divide bot...
1 answer
2. EXTRA CREDIT OPTION: GREEN'S THEOREM Fix θ > 0, Consider the region A bounded by the straight ...
2. EXTRA CREDIT OPTION: GREEN'S THEOREM Fix θ > 0, Consider the region A bounded by the straight line segment from (0,0) to (1,0), the portion of the hyperbola parametrized by r(t) (cosh(t), sinh(t)) for 0 t 0, and the straight line segment from P-(cosh(9), sinh(9) back to the origin. U...
1 answer
1. Are strategic management and strategic planning synonymous terms? Explain in detail. 2. As cited in...
1. Are strategic management and strategic planning synonymous terms? Explain in detail. 2. As cited in the chapter, famous businessman Edward Deming once said, "in God we trust, all others bring data." what did Deming mean in terms of developing a strategic plan? Explain in detail. 3. List t...
1 answer
Marc, a single taxpayer, earns $261,000 in taxable income and $4,300 in interest from an investment...
Marc, a single taxpayer, earns $261,000 in taxable income and $4,300 in interest from an investment in city of Birmingham bonds. Using the US tax rate schedule for 2019, what is his average tax rate? (Round your final answer to two decimal places.) (Use tax rate schedule) Multiple Choice 25.50 perce...
1 answer
Example: Given 40.5 mA. Find source voltage Vo 4
Example: Given 40.5 mA. Find source voltage Vo 4...
1 answer
P-8.7 Consider two finite-length sequences, x[n] 0 n<0 1 0 <n<3 n> 3 0 and h[n]...
P-8.7 Consider two finite-length sequences, x[n] 0 n<0 1 0 <n<3 n> 3 0 and h[n] = 28[n] - 8[n - 1] - 8[n - 2]. (a) Determine and plot the discrete convolution y[n] = x[n] *h[n] for these two sequences....
1 answer
NO HANDWRITTEN ANSWERS PLEASE Inspired by his trip to Greece, the gentleman farmer decided he needed...
NO HANDWRITTEN ANSWERS PLEASE Inspired by his trip to Greece, the gentleman farmer decided he needed a Mykonos-style windmill pumping a pond for his sheep and orchard. His earned value table for the project appears below. At the end of June, what were the estimated time to completion and the estimat...
1 answer
6. The white gene in Drosophila is on the X chromosome and wº (red) is dominant...
6. The white gene in Drosophila is on the X chromosome and wº (red) is dominant over w (white). A red-eyed female is crossed with a white-eyed male. (A) What must the genotype of the male be? (B) What must the genotype of the female be if the progeny are 25% red male, 25% red female, 25% white ...
1 answer
D | Question 10 cells have O Muscle / squamous layers O Nervous tissue plasmodesmata O...
D | Question 10 cells have O Muscle / squamous layers O Nervous tissue plasmodesmata O Adipose cells/cellulose cell walls O Connective tissue/ voltage dependent ion channels O Epithelial / tight junctions...
1 answer
Question 6 On January 1, 2020, Harlow Company paid $137,000 to purchase a piece of equipment....
Question 6 On January 1, 2020, Harlow Company paid $137,000 to purchase a piece of equipment. Before the equipment could be used, Harlow had to spend $6,000 to put the equipment in working order. The equipment was assigned a useful life of 12 years and a residual value of $11,000. The straight-line ...