Description
As a data scientist of a company, you want to analyze the following data collected by your company which relates the advertising expenditure A in thousands of dollars to total sales S in thousands of dollars. The following table shows this relationship:
Advertising Expenditure (A)
Total Sales (S)
36
335
37.5
341
38
342
38
342
41
345
42
350.2
43
360
- Determine if the above relation (A, S) defines a function or not.
- Using Excel, draw a scatter diagram of data. Click here (Links to an external site.)Links to an external site. for a video explanation on how to create a scatter plot and linear regression.
- Using Excel, find the line of the best fit the models.
- Add this line to the scatter diagram.
- Interpret the slope and y-intercept of this equation.
- Express this equation as a function S of A and find its domain.
- Predict the sales if the advertising expenditure is $48000.
Explanation & Answer
Hi, please find the solution attached
Running head: ANALYZING ADVERTISING EXPENDITURE
Analyzing Advertising Expenditure
Your name
Subject
Institution
Name of the Professor
Date
1
ANALYZING ADVERTISING EXPENDITURE
2
Analyzing Advertising Expenditure
Introduction
There is a need for advertising analysis because of the increase in promotional costs. The
analysis is carried out at each and every step of advertising process: during developing of the
message, preparing the copy and even after rolling out the advertisement because any mistake
can amount to a big ...