Question: AB E 1 Month 56 > N. Sales (Millic Advertisement (Million $) 40l 66 7.25 71.5 90 13.5 100 13.25 84 22.25 106 18.5 127

AB E 1 Month 56 > N. Sales (Millic Advertisement

AB E 1 Month 56 > N. Sales (Millic Advertisement (Million $) 40l 66 7.25 71.5 90 13.5 100 13.25 84 22.25 106 18.5 127 23.25 198.5 30 10 192. 5 28.25 236| 36.75 198.5 31.5 238 34.5 349.5 36.25 272.5 40 418.5 371.5 45 361 49.25 367.5 50.75 419 55.75 528.5 61.75 465 60.5 542.5 58.5 24 545 63.5 25 60967,75 49 s Linear Regression: The amount of sales for company A is constantly increasing over time. The monthly value of sales for 25 past months are known. In addition, the marketing department found that there is a high correlation between the value of sales and advertisement spendings. Knowing that the time and advertisement impact sales values, marketing managers want to forecast the sales value for the 26th month. Use simple linear regression to find the linear equation for the sale and time. Use simple linear regression to find the linear equation for the sale and advertisement. What is the 26th-month sale value using the trend in time? What is the 26th-month sale value if the company is expecting to spend $70m on advertising for this period? Submit your answers in an excel file with your name on the file. Instructions: Step 1: Run a simple linear regression for Sale (dependent variable) and time (independent variable). Step 2: Run a simple linear regression for Sale (dependent variable) and Advertisement (independent variable). Step 3: Using the regression table from step 1, find the coefficients and write the regression equation for Sale and Time. Simply plug in 26 for the time in the equation and find the sale's value. Step 4: Using the regression table from step 2, find the coefficients and write the regression equation for Sale and Advertisement. Simply plug in the advertising expenditure of $70m and find the value for sales

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The term churn is very important to managers in the cellular phone business.Churning occurs when a customer stops using one company's service and switches to another company's service.Obviously,...

SpendRat Age 11.83 16.83 11.38 31.33 1.9 84.13 2.15 38 136.28 61.46 2.73 5.86 113 8.4 31.67 19 70.85 20.17 0.59 19.48 86.2 25.46 76.82 0.77 335.94 18.78 205.07 216.57 77.21 0.26 92.53 46.55 6.86...

Share Comments SB LIX V ) m Insert Format Delete Y Sart Filter v Find & Select Analyze Date V AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout...

The amount of sales for company A is constantly increasing over time. The monthly value of sales for 25 past months are known. In addition, the marketing department found that there is a high...

Done using R studio and please share the r script. Predict the number of applications received Apps using all other variables in the College data set using LASSO model for variable selection: a....

Question 1 (10 marks) Read section 1.1 of the textbook. Use the provided spreadsheet (presenting the data used to create Figure 1.2 from the textbook). Consider Australia, China, USA and another two...

Question 1 (10 marks) Use the provided spreadsheet. Consider Australia, China, USA and another two countries of your choice. 1. For each country calculate the 90/10 ratio in 1980, 1990 and 2014. (3...

Use the provided spreadsheet (presenting the data used to create Figure 1.2 from the textbook). Consider Australia, China, USA and another two countries of your choice. 1. For each country calculate...

The datasetEducation - Post 12th Standard.csvis a dataset that contains the names of various colleges. This particular case study is based on various parameters of various institutions. You are...

Nokia (www.Nokia.com) is a leading manufacturer of mobile devices and services, and it competes to some extent with both Research In Motion and Apple. Key financial figures for Nokia follow. Required...

The snowmobile moves along a straight course according to the v-t graph. Construct the s-t and a-t graphs for the same 50-s time interval.When t=2,s=0. %3D v (m/s) 12 30 50 Prob. 12-42

2. If a car breaks down on the freeway, a passing mechanic is not obligated to render emergency road service. For similar reasons, if a person suff ers a heart attack on the street, a passing...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...